Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Shared Pool utilisation

user87124Dec 11 2008 — edited Feb 27 2009

Hello Team:

I ran a metalink script to report the shared pool utilization recently. I took this output when the database was on peak load.

SQL> /
Obj mem: 66435759 bytes (63.36MB)
Shared sql: 324219036 bytes (309.2MB)
Cursors: 341207073 bytes (325.4MB)
Free memory: 67228508 bytes (64.11MB)
Shared pool utilization (total): 468785754 bytes (447.07MB)
Shared pool allocation (actual): 754974720bytes (720MB)
Percentage Utilized: 91%

does this mean I have to add more space to shared pool. If so what is the threshold value?

Regards,

Bala

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 27 2009

Added on Dec 11 2008

#general-database-discussions

2 comments

3,977 views