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