OraFAQ Forum: Server Administration » how to calculate the sga size

Home » RDBMS Server » Server Administration » how to calculate the sga size

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to calculate the sga size [message #51394]

Tue, 21 May 2002 08:20

ksr
Messages: 112
Registered: January 2002

Senior Member

Hi,
I want to check the total value(bytes or MB) of what is set for my SGA.
From the init.ora,what all parameters i should add to get the overall SGA set for my system.

Any help is appreciated

Report message to a moderator

Re: how to calculate the sga size [message #51400 is a reply to message #51394]

Tue, 21 May 2002 10:04

tommy
Messages: 22
Registered: July 2000

Junior Member

select * from v$sga will show you the size of all the pieces.

tommy

Report message to a moderator

Re: how to calculate the sga size [message #51402 is a reply to message #51394]

Tue, 21 May 2002 10:28

Grant
Messages: 578
Registered: January 2002

Senior Member

Not that easy but here is a start:

(db_block_buffers * DB_BLOCK_SIZE) +
shared_pool_size +
shared_pool_reserved_size +
large_pool_size +
java_pool_size +
sort_area_retained_size = APPROXIATE TOTAL

You should read up on the article "How to determine SGA Size (7.x, 8.0.x, 8i, 9i) in MetaLink. Above is how you might figure it out from the init.ora file. You may need to break down what values you have from the "svrmgrl> show sga" command.

Report message to a moderator

Previous Topic:	OPEN_CURSORS in init.ora file
Next Topic:	Re: ORA-00439: feature not enabled: Objects

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 22:03:39 CST 2025