Re: X$ksmsp (OSEE 10.2.0.2 on Solaris 8)

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Wed, 28 Jun 2006 07:59:46 -0400
Message-Id: <1151495986l.2737l.0l@medo.noip.com>

On 06/28/2006 05:24:51 AM, eagle fan wrote:
> hi Gogala:
>
> Do you have some meterials or test for this? I mean "selecting from tables
> like that usually means to acquire a latch for
> each row. "

Are you asking me for materials on UNDOCUMENTED table? I'm afraid I don't have any. That, exactly, is the meaning of the word "undocumented". Try doing "select * from x$ksmsp" and see if anything in V$LATCH grows proportionally to the number of rows.

-- 
Mladen Gogala
http://www.mgogala.com

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

Received on Wed Jun 28 2006 - 06:59:46 CDT