RE: MEMORY USAGE

• Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 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: bhulubhuli_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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: dcutrone_at_afip.gov.ar

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: ListGuru_at_fatcity.com (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).