memory taken by Database in a DB environmnet

[Amit Manna_6]

Hi,

Is there any paramenter which defines how much of the Physical memory will be taken by database in case of Oracle or Sybase is installed in a HP-Ux System

Thanks and Regards,

Amit Manna

[Joseph Loo]

hi,

look under SEGSZ column which shows the SGA use by the database:

# ipcs -mbop

for specified oracle processes, look at SZ column:
# ps -lfu |grep -i oracle

regards.

[David Child_1 · Accepted solution]

shmmax can be used to limit how large of a shared memory segment that Oracle/Sybase can use. Oracle DBAs will usually tell you that if the server has 8GB of memory, they want shmmax set to 8GB. I generally set this lower (much lower if it's a multiple Oracle/Sybase system).

[Tim Howell]

Oracle has several parameters such as SHARED_POOL_SIZE and JAVA_POOL_SIZE that you add together to come up with the total size for the SGA - perhaps this is what you are looking for?

[Abdul Rahiman]

I guess you should take a look at the Oracle paramater file for various memory paramters mentioned in the previous response.(pfile is typically named as initXXXX.ora and can be found under $ORACLE_BASE/admin/????(instance)/pfile direcotry).