Re: Oracle Server performace help needed
From: Dinesh Sharma <dineshsharma_at_adityabirla.com>
Date: 17 Apr 2003 20:22:55 -0700
Message-ID: <9d4671a8.0304171922.7745a630_at_posting.google.com>
Date: 17 Apr 2003 20:22:55 -0700
Message-ID: <9d4671a8.0304171922.7745a630_at_posting.google.com>
> Why did you reduce the db_file_multiblock_read_count from 64 to 32?
> Seems you would want to keep that the same as before.
>
> Roger
db_file_multiblock_read_count was reduced to synchronise read of OS which is 64K with Oracle read which now will be 32*2k(block size).
We had upgraded last week of last month and since then I did not bounce it till yesterday.
Today I have increased the shared_pool_area to 192M.
Let me see the result.
Any suggestion/comment?
Dinesh Received on Fri Apr 18 2003 - 05:22:55 CEST