Re: table scanning

From: Saar <sxmaxoz_at_us.oracle.com>
Date: Wed, 05 Aug 1998 12:11:30 -0700
Message-ID: <35C8AE61.4B848F04@us.oracle.com>

Kevin Everest wrote:

> I am attempting to find out if my database is under indexed by
> determining wether table scanning is taking place.
>
> Can anyone suggest how I go about doing this?
>

SVRMGR> select * from v$sysstat where name like '%table scan%';STATISTIC#
NAME
CLASS VALUE

---

---

• ---------- 139 table scans (short tables) 64 6053 140 table scans (long tables) 64 13 141 table scans (rowid ranges) 64 74 142 table scans (cache partitions) 64 0 143 table scans (direct read) 64 74 144 table scan rows gotten 64 327993 145 table scan blocks gotten 64 160745 7 rows selected.

mostly look at the long tables over time. This is part of using utlbstat & utlestat as statistics collection for a period of time.

--

 __  _    _  __    _ _   _   _ ___  ______________________________
((  /\\  /\\ ||)  |\V/| /\\ /\\ >/  Principal Performance Engineer

_))//-\\//-\\||\ |||||//-\\\\//<_ Oracle Corporation Compaq SBU

////////////////// Drop x's in email (spam) //////////////////////

Received on Wed Aug 05 1998 - 14:11:30 CDT