cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle.

SOLVED
Go to solution
Cleber Zorzi
Valued Contributor

Oracle.

Hello,

some command exists that it indicates how much of memory it was placed for the Oracle.

Thanks,

Cleber
6 REPLIES
Sandman!
Honored Contributor
Solution

Re: Oracle.

Hi Cleber,

Run the following command on your system...

# UNIX95= ps -e -o ruser,vsz,args | grep -i "^oracle" | more

2nd column lists actual memory usage of the running Oracle process[es].

hope it helps!

Steven E. Protter
Exalted Contributor

Re: Oracle.

Shalom Cleber,

I like Sandman's command, but would recommend working grep out of it.

UNIX95=1 ps -e -o ruser,vsz,args -C oracle

perhaps, you may need to play with it a bit.

glance is also a good tool for this job and its available on a 60 day trial on the application cd's

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Ninad_1
Honored Contributor

Re: Oracle.

Cleber,

As mentioned in the above replies you can see how much memory is used by processes owned by user oracle. But you may also want to see how much shared memory has been allocated (or rather used) by oracle by
# ipcs -mb
This will give you the figure in bytes - you need to check for your database - basically this shared memory is the memory allocated to your SGA.

Ninad
Julio Yamawaki
Esteemed Contributor

Re: Oracle.

Hi,

Login as oracle:
> sqlplus /nolog
SQL > connect / as sysdba
SQL > show sga

This will show you how much memory oracle allocates for buffers and internal structures.

Regards,

Arturo Galbiati
Esteemed Contributor

Re: Oracle.

Hi Cleber,
you can use this by UNIX user oracle:

/usr/ccs/bin/size $ORACLE_HOME/bin/oracle|awk '{print $1,$3,$5}'|read Mtext Mdata Mbss
#echo $Mtext $Mdata $Mbss
echo "==============================="
echo " $ORACLE_SID"
echo "==============================="
$ORACLE_HOME/bin/sqlplus -s internal<
Cleber Zorzi
Valued Contributor

Re: Oracle.

Thanks!

Cleber