Home » RDBMS Server » Server Administration » how to calculate the sga size
how to calculate the sga size [message #51394] Tue, 21 May 2002 08:20 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 16 18:13:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.