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 [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED]
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: [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).
