bstat/estat table scans (long tables) breakdown?

From: Dan Bikle <dbikle_at_rahul.net>
Date: 29 Jun 1999 04:40:50 GMT
Message-ID: <7l9ioi$ihn$1@samba.rahul.net>

Oracle DBAs,

I'm working with a file, report.txt, created by the scripts:

$ORACLE_HOME/rdbms/admin/utlbstat.sql
$ORACLE_HOME/rdbms/admin/utlestat.sql

The file reports on a statistic:

table scans (long tables)

For example:

table scans (long tables) 204

which means the rdbms did 204 full table scans on long tables (tables larger than 5 blocks)

Is it possible to get a breakdown on these 204 full table scans?

I'd like to know which tables I should focus my indexing eye upon.

Thanks,

-Dan

---

Daniel B. Bikle/Independent Oracle Consultant bikle_at_bikle.com | 650/941-6276 | P.O. BOX AG LOS ALTOS CA 94023 http://www.bikle.com

---

Received on Mon Jun 28 1999 - 23:40:50 CDT