DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12
  1. #11
    Join Date
    Aug 2002
    Colorado Springs
    That's the default from 10g Release 2 onwards -- prior to that it is "8" regardless of platform or db_block_size. I think from 10gR2 onwards leaving it unset is the best choice.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  2. #12
    Join Date
    Dec 2005
    Thanks Tamil. Perfect answer for my question. I am thanking every one participating on this thread. This site is very useful.

    Quote Originally Posted by tamilselvan
    Max I/O Size depends upon many factors such as volume manager (Veritas or LVM), stripe size , OS limitation etc.
    Today, the effective max I/O size can be set to 1MB.

    If you are using Veritas volume manager, then vol_maxio parameter tells you the size.

    If you donot use LVM, then the best way to determine is from the extended trace data file (using 10046 events) at level 8.

    You change the db_file_multiblock_read_count = 512.
    set events 10046 at level 8.
    full table scan a big table.
    Look for P3 value in the trace file.


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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.