FULL Scanned Tables' Identification , within a Tablespace

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infy.com>
Date: Sun, 11 Feb 2001 09:19:55 -0800
Message-ID: <F001.002B13D9.20010211091027@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 ?
--

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 Sun Feb 11 2001 - 11:19:55 CST