FULL Scanned Tables' Identification , within a Tablespace

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infy.com>
Date: Mon, 12 Feb 2001 08:39:53 -0800
Message-ID: <F001.002B1BEF.20010212082559@fatcity.com>

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 ?

Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infy.com

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: ListGuru_at_fatcity.com (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). Received on Mon Feb 12 2001 - 10:39:53 CST