why dont u check thro the scattered read which goes on thro the session_event based on that track the table which is getting fully scanned. >From: VIVEK_SHARMA <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: FULL Scanned Tables' Identification , within a Tablespace >Date: Sun, 11 Feb 2001 09:10:26 -0800 > > >The BLKS_READ Value is 15 Times the READS Value Indicating FULL Table Scans > >Qs. Is such a Product Exceedingly High ? What may generally be termed as >acceptable >READS is to BLKSREAD ratios ? > >Qs.Any Advisable ways of locating WHICH Tables of the 50 are going for Full >Scans during >a Single Working Day ? > >NOTE - The Tablespace Contains 50 Tables . > >SVRMGR> Rem Sum IO operations over tablespaces. >SVRMGR> select > 2> table_space||' ' > 3> table_space, > 4> sum(phys_reads) reads, sum(phys_blks_rd) blks_read, > 5> sum(phys_rd_time) read_time, sum(phys_writes) writes, > 6> sum(phys_blks_wr) blks_wrt, sum(phys_wrt_tim) write_time, > 7> sum(megabytes_size) megabytes > 8> from stats$files > 9> group by table_space > 10> order by table_space; >TABLE_SPACE READS BLKS_READ READ_TIME WRITES BLKS_WRT >WRITE_TIME MEGABYTES >-------------- ---------- ---------- ---------- ---------- ---------- >---------- ---------- >CONTROL 240337 3647178 41802 651 651 >1666 105 > >Any Other Misc. Observations ? >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
