| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: FULL Scanned Tables' Identification , within a Tablespace
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 <VIVEK_SHARMA_at_infy.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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: 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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C INET: arun_k_c_at_hotmail.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 - 14:09:38 CST
 |
 |