topic Re: Oracle. in Operating System - HP-UX

Oracle.

Cleber Zorzi — Mon, 27 Mar 2006 12:51:15 GMT

Hello,

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

Thanks,

Cleber

Re: Oracle.

Sandman! — Mon, 27 Mar 2006 14:51:48 GMT

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!

Re: Oracle.

Steven E. Protter — Mon, 27 Mar 2006 14:55:46 GMT

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

Re: Oracle.

Ninad_1 — Mon, 27 Mar 2006 15:35:05 GMT

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

Re: Oracle.

Julio Yamawaki — Tue, 28 Mar 2006 06:24:34 GMT

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,

Re: Oracle.

Arturo Galbiati — Tue, 28 Mar 2006 06:53:01 GMT

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<

Re: Oracle.

Cleber Zorzi — Tue, 28 Mar 2006 07:00:21 GMT

Thanks!

Cleber