checking for shared pool fragmentation
From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Mon, 22 Apr 2013 16:14:58 -0400
Message-ID: <CAE-dsOJte-VhZbutvfdi5_E3gvWG3mipkFw_3XXOyRsCLu0QOQ_at_mail.gmail.com>
Some constraints since another company has the operations contract. No access to alert log. No access to SYS. So no x$tables. I also can't turn get an audit option turned on to audit for errors (not sure if shared pool errors would get caught anyway).
I found a good article here on it, but it hits alot of x$tables. I know how to tell if we have queries that don't use bind variables. Found some, but I am not sure how to tell if the shared pool fragmentation error got thrown with my limited access. I have access to the data dictionary views.
Date: Mon, 22 Apr 2013 16:14:58 -0400
Message-ID: <CAE-dsOJte-VhZbutvfdi5_E3gvWG3mipkFw_3XXOyRsCLu0QOQ_at_mail.gmail.com>
Some constraints since another company has the operations contract. No access to alert log. No access to SYS. So no x$tables. I also can't turn get an audit option turned on to audit for errors (not sure if shared pool errors would get caught anyway).
I found a good article here on it, but it hits alot of x$tables. I know how to tell if we have queries that don't use bind variables. Found some, but I am not sure how to tell if the shared pool fragmentation error got thrown with my limited access. I have access to the data dictionary views.
http://coskan.wordpress.com/2007/09/14/what-i-learned-about-shared-pool-management/
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 22 2013 - 22:14:58 CEST