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@(protected):
> 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@(protected):
> >
> >
> > Do you believe everything that Oracle support says?
> >
> --
> ----------------------------------------------
> Got RAC?
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
http://www.freelists.org/webpage/oracle-l