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 Usage 11G: Automated SCript

user627752Mar 14 2012 — edited Mar 16 2012

Team,

We need to monitor the shared pool usage on regular intervals. If it reaches beyond the threshold say 90% then we need to resize the shared pool.

We are using Oracle DB 11G.

Is there is anyway we can accompolish this.

Cheers
Ram

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 13 2012

Added on Mar 14 2012

#general-database-discussions

14 comments

5,751 views