*** orisnoop 1.12.1 *** (c) Oriole Software, 1998
Production version - class 2 license |
ACTIVITY ON DATABASE OMSPAR
Database Version 8.1.5
Database Started on Fri Oct 23 19:48:00 1999
Oldest statement collected first loaded on Fri Oct 23 19:48:56 1999
Collected on Mon Nov 9 18:19:10 1999
Explaining 99 % of costs or a maximum of 25 statements
STATISTICS BY TYPE OF STATEMENT
|
Statement count |
|
Executions |
|
Cumulative cost |
| DML command |
As % of total |
| select |
|
| insert |
|
| update |
|
| delete |
|
| PL/SQL |
|
DISTRIBUTION STATISTICS
Statements are ordered by decreasing total cost.
| Top statement |
46.25 % of costs |
|
| Top 2 statements |
91.37 % of costs |
|
TOP STATEMENTS SUMMARY
Statements are ordered by decreasing total cost.
| RANK |
TOTAL COST |
INDIVIDUAL COST |
TYPE |
TABLES INVOLVED |
| 1 |
164131968 |
312 |
SELECT |
TXTABLE |
| 2 |
160089925 |
305 |
SELECT |
TXTABLE |
DETAILS FOR THE TOP 2 STATEMENTS
Ranking : 1 - Parsing Schema : OMSSG Back to
summary
| Total cost |
164131968 |
| Individual cost |
312 |
| Executions |
526064 |
select distinct SRC_OFFICE
from TXTABLE
where STATE='P';
Execution plan :
SELECT STATEMENT (RULE) Oracle cost estimate: ?
SORT UNIQUE
TABLE ACCESS BY ROWID OMSSG.TXTABLE
INDEX RANGE SCAN OMSSG.TXTABLE_STATE_IDX2 (NON-UNIQUE)
Tables and indexes :
- Table : TXTABLE - Full scan cost : 6399 - Rows ~ 130000
- Index : TXTABLE_PK Avg search cost : 4
1 key value matches exactly 1 row when ALL COLUMNS are specified in the WHERE clause.
- SERIAL_NO
- SUBSEQ_NO
- SRC_OFFICE
- DST_OFFICE
- Index : TXTABLE_STATE_IDX1 Avg search cost : 133
1 key value = 7.14 % of rows on average when ALL COLUMNS are specified in the WHERE
clause.
Distribution of key values :
| key % |
% of rows matched |
|
| 99 % |
|
(2 %) |
- Index : TXTABLE_STATE_IDX2 Avg search cost : 32
1 key value = 12.50 % of rows on average when ALL COLUMNS are specified in the WHERE
clause.
Distribution of key values :
| key % |
% of rows matched |
|
| 102 % |
|
< 1 % |
Ranking : 2 - Parsing Schema : OMSSG Back to
summary
| Total cost |
160089925 |
| Individual cost |
305 |
| Executions |
524885 |
select distinct DST_OFFICE
from TXTABLE
where STATE='T';
Execution plan :
SELECT STATEMENT (RULE) Oracle cost estimate: ?
SORT UNIQUE
INDEX RANGE SCAN OMSSG.TXTABLE_STATE_IDX2 (NON-UNIQUE)
Tables and indexes :
- Table : TXTABLE - Full scan cost : 6399 - Rows ~ 130000
- Index : TXTABLE_PK Avg search cost : 4
1 key value matches exactly 1 row when ALL COLUMNS are specified in the WHERE clause.
- SERIAL_NO
- SUBSEQ_NO
- SRC_OFFICE
- DST_OFFICE
- Index : TXTABLE_STATE_IDX1 Avg search cost : 133
1 key value = 7.14 % of rows on average when ALL COLUMNS are specified in the WHERE
clause.
Distribution of key values :
| key % |
% of rows matched |
|
| 99 % |
|
(2 %) |
- Index : TXTABLE_STATE_IDX2 Avg search cost : 32
1 key value = 12.50 % of rows on average when ALL COLUMNS are specified in the WHERE
clause.
Distribution of key values :
| key % |
% of rows matched |
|
| 102 % |
|
< 1 % |