Re: checking for shared pool fragmentation

From: De DBA <dedba_at_tpg.com.au>
Date: Tue, 23 Apr 2013 10:18:48 +1000
Message-ID: <5175D368.20506_at_tpg.com.au>

You don't specify the version, since 11g you can access alertlog information through the database. If you have access to the V$% views, v$diag_problem lists all problems defined by the ADR. The v$diag_info view has the number of active problems. Perhaps the shared pool fragmentation error that you allude to can be traced that way?

Cheers,
Tony

On 23/04/13 06:14, Dba DBA wrote:
> 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-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 23 2013 - 02:18:48 CEST