Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: querying x$ tables can cause DB to hang?

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

From: rjamya <rjamya_at_gmail.com>
Date: Fri, 7 Jul 2006 12:13:14 -0400
Message-ID: <9177895d0607070913yb5afe69g16b40080262784e3@mail.gmail.com>


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
Received on Fri Jul 07 2006 - 11:13:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US