Oracle Table Scans

From: <mdevgan_at_hotmail.com>
Date: Tue, 23 Mar 1999 06:31:12 GMT
Message-ID: <7d7cfg$63q$1@nnrp1.dejanews.com>

Hi,

I have a question. The following query returns various table access methods and their values.

> select name, value from v$sysstat where name like '%table scans%'

           order by name;

  Name                                Value
-----------------------------------------
table scans (cache partitions)        xxx
table scans (direct read)             xxxx
table scans (long tables)             xxxx
table scans (rowid ranges)            xxx
table scans (short tables)            xxxx
------------------------------------------

1.  What does "table scans (cache partitions)"	and "table scans (direct

read)" mean? 2. Do you these account for all possible table access methods?

Thanks,
Manish

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 23 1999 - 00:31:12 CST