question about db_file_multiblock_read_count
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: question about db_file_multiblock_read_count

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

    question about db_file_multiblock_read_count

    Could some please tell me if I increase the value of the db_file_multi_block_read from 8 to 64 in "alter session... "scope" while a batch job with many sql statements is executing, whether the remaining sql in the executing batch job will use the new value from memory? Please help. Thx.

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    My feeling is that it wont effect a existing running sql But the next sql in the session might be effected.

    But i am not sure tkprof that session and see

    regards
    Hrishy

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