----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, May 10, 2002 5:03 AM
> Hi ALL, > > 1. > How do I get know memory usage by karnel,application > programs,Filesystem Cache etc in SunOS 5.6 . I do not > have the RMC package installed in my m/c > I think that you can use /usr/proc/bin/pmap pid This will display the memmory map for a process. Detailing shared memory, shared libraries, code, etc. Here you have an example: 25431: ora_lgwr_PRUE73 00010000 8312K read/exec /u01/app/oracle/product/7.3.4/bin/oracle 0083D000 76K read/write/exec /u01/app/oracle/product/7.3.4/bin/oracle 00850000 140K read/write/exec [ heap ] 80000000 6440K read/write/exec/shared [ shmid=0x578 ] 8064A000 4K read/shared [ shmid=0x578 ] 8064B000 160K read/write/exec/shared [ shmid=0x578 ] 80673000 4K read/shared [ shmid=0x578 ] 80674000 40000K read/write/exec/shared [ shmid=0x578 ] EF5A0000 12K read/exec /usr/lib/libmp.so.2 EF5B2000 4K read/write/exec /usr/lib/libmp.so.2 > 2. > How do I know if the ORACLE is using Raw/UFS ? > Check in dba_data_files (dba_temp_files if you're using temporary tablespace Oracle 8i onwards), v$controlfile , v$logfile the locations of the files. After this, go and take a look to these files with the comand "file": oracle:/u01/oradata/RAW81> file raw_data01.dbf raw_data01.dbf: character special (32/39) oracle:/u02/oradata/PRUE73> file data1_01.dbf data1_01.dbf: data > 3. > If I set _filesystemio_options='directIO' instead of > 'async' will that save memory consumption and improve > performance ? It depends on the tipe of datafiles you're using. If your database is on FS, and you mount your FS with forcedirectio option, you can set set _filesystemio_options='directIO' and you'll be using direct io for the FS datafiles. This will save you memory and will boost your performance. If you're on Raw devices you should use Async I/O (KAIO in solaris to be precise) HTH Greetings Diego Cutrone > > Any suggestion ...Thanks in advance > > __________________________________________________ > Do You Yahoo!? > Yahoo! Shopping - Mother's Day is May 12th! > http://shopping.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: S B > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).