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

Thread: db_file_multi_block_read_count

  1. #1
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218

    db_file_multi_block_read_count

    Could some please tell me if I increase the value in memory while a batch job with many sql statements is executing, whether the remaining sql in the batch job will use the new value from memory?

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    You could try the following test...

    Trace a session:

    Alter session set events '10046 trace name context forever, level 12';

    Run a long FTS etc.

    In another session

    alter system set db_file_multiblock_read_count =

    Then examine the trace file and see if there is a change to the p3 in scattered reads at the same time as you performed the alter system. i.e.

    WAIT #1: nam='db file scattered read' ela= 21993 p1=24 p2=115529 p3=128
    OCP 8i, 9i DBA
    Brisbane Australia

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