Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

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

rjamya

2006-07-07

Replies:

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


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.