OraFAQ Forum: Performance Tuning » how to calculate shared pool size ??

Home » RDBMS Server » Performance Tuning » how to calculate shared pool size ??

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

how to calculate shared pool size ?? [message #190549]

Thu, 31 August 2006 04:37

tridentadm
Messages: 142
Registered: March 2006

Senior Member

is the way of calculating the shared pool as below ??

select sum(250 * users_opening) from v$sqlarea;
+
select sum(sharable_mem) from v$sqlarea;
+
select sum(sharable_mem) from v$db_object_cache;
+
overhead

Report message to a moderator

Re: how to calculate shared pool size ?? [message #190554 is a reply to message #190549]

Thu, 31 August 2006 04:43

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Run this SQL:

SELECT * FROM v$sgastat WHERE pool = 'shared pool';

Report message to a moderator

Previous Topic:	when was COST optimizer introduced ?
Next Topic:	db file scattered and sequential read wait events ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 06:15:19 CDT 2024