Re: querying x$ tables can cause DB to hang?

From: Mark Strickland <strickland.mark_at_gmail.com>
Date: Fri, 7 Jul 2006 09:22:02 -0700
Message-ID: <90ad14210607070922v408e5204h3a4c4e376cb56cad@mail.gmail.com>

Recently, I attempted a query against x$ksmsp in a non-Production database. The query ran for an hour and held the shared pool latch. Couldn't login to the database from another session. Oracle Support had sent me this query to try to identify shared pool fragmentation and they assured me that there would be no issues with running the query. I knew better. Glad I didn't try it in Production.

Mark Strickland
Next Online Technologies
Seattle, WA

On 7/7/06, rjamya <rjamya_at_gmail.com> wrote:
> Jonathan has warned against frequently accessing x$ksmsp on a system
> that has a large shared_pool and lot of users.
>
> if he says so, I'd take that.
> Raj
>
> On 7/7/06, Powell, Mark D <mark.powell_at_eds.com> wrote:
> >
> >
> > Do you believe everything that Oracle support says?
> >
> --
> ----------------------------------------------
> Got RAC?
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Fri Jul 07 2006 - 11:22:02 CDT