Home » RDBMS Server » Performance Tuning » how to calculate shared pool size ??
how to calculate shared pool size ?? [message #190549] Thu, 31 August 2006 04:37 Go to next message
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

Re: how to calculate shared pool size ?? [message #190554 is a reply to message #190549] Thu, 31 August 2006 04:43 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Run this SQL:

SELECT * FROM v$sgastat WHERE pool = 'shared pool';
Previous Topic: when was COST optimizer introduced ?
Next Topic: db file scattered and sequential read wait events ?
Goto Forum:
  


Current Time: Sat Dec 10 06:53:43 CST 2016

Total time taken to generate the page: 0.08632 seconds