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

  • From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
  • To: eagle fan <eagle.f@xxxxxxxxx>
  • Date: Wed, 28 Jun 2006 07:59:46 -0400

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

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


Other related posts: