-
Hi,
I ran the utlbstat and utlestat scripts on my database and got the following output for table scans. This shows that I have a lot of Full Table Scans according to the formula
Non Index Lookup ration = Table Scans (Long Tables) / Table Scans (Long Tables) + Table Scans (Short Tables) = 16%.
What is the best approach I should take to tackle this problem.
Thanks
Anurag
Statistic Total
---------------------------------------------------------------- ------------
Per Transaction Per Logon Per Second
--------------- ------------ ------------
table scans (long tables) 3195
19.97 59.17 .16
table scans (short tables) 15666
97.91 290.11 .79
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|