DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Identify Full Table Scans.

  1. #1
    Join Date
    Feb 2003
    Location
    INDIA
    Posts
    96

    Identify Full Table Scans.

    This is very good place to share the knoledge.

    Can everybody put down their methods to find Full Table Scan on Database.

    How Oracle Decides in v$sysstat between
    "table scans (long tables)" and "table scans (short tables)"
    Dilip Patel
    OCP 8i

    Catch me online at Yahoo: ddpatel256

  2. #2
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116
    Explain plan and tkprof
    The man called Zorro

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    If I remember right, large scan is considered when the size of table is larger than 2% or 4% of db block buffer

Posting Permissions

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


Click Here to Expand Forum to Full Width