Re: How to analyze a session?

> 115 4625 db file sequential
> read file# 59 000000000000003B block# 175664 000000000002AE30 blocks 1 0000000000000001 0 0 WAITING

As you can see from above, the number of blocks being read is '1'. If you want to know which specific block is being read, then that block is part of file number 59, block number 175664. Querying DBA_EXTENTS can tell you which object this block belongs too. Querying V$SESSTAT for the statistics titled 'physical reads' (you'll need the statistic number from V$STATNAME) can give you the total number of physical reads a session requested.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"