Results 1 to 1 of 1
  1. #1
    Join Date
    May 2003
    Posts
    12

    Question Unanswered: Full tbl scans as percent of total reads

    I would like to know what percent of the db reads at a point in time are the result of full table scans. My first naive guess is to use the ratio

    physical_reads/table_scan_blocks_gotten

    from v$sysstat. If not, then how would the calc be defined?
    Last edited by BRob; 05-19-03 at 16:46.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •