|
Dear all DBAs,
My Oracle 8.0.5(running on Linux 6.4 kernel 2.2.14)
is getting slower recently.
Every data input output is slow.
And the "Server Stat" in Toad showing:
Library Cache Get Hit Ratio
51.5540 "May need to increase DB_BLOCK_BUFFERS"
Library Cache Pin Hit Ratio
93.6161 "Shared Pool area too small"
Is that means i should increase the size of shared
pool and DB_BLOCK_BUFFERS?
the values in init.ora:
db_block_buffers = 550
shared_pool_size = 19000000
Thanks for helps!
|
- SHARED POOL SIZE Hamid Alavi
- RE: SHARED POOL SIZE DENNIS WILLIAMS
- RE: SHARED POOL SIZE Sherman, Paul R.
- RE: SHARED POOL SIZE Root, Melanie
- Re: SHARED POOL SIZE Jared . Still
- RE: SHARED POOL SIZE raja
- RE: SHARED POOL SIZE Sunil_Nookala
- RE: SHARED POOL SIZE Adams, Matthew (GEA, MABG, 088130)
- RE: SHARED POOL SIZE Sunil_Nookala
- Re: SHARED POOL SIZE Hemant K Chitale
- Re: Shared Pool Size shuan.tay\(PCI鄭祺勛\)
- Re: Shared Pool Size ASHRAF SALAYMEH
- Re: Shared Pool Size shuan.tay\(PCI鄭祺勛\)
- RE: Shared Pool Size DENNIS WILLIAMS
- Re: Shared Pool Size shuan.tay\(PCI鄭祺勛\)
- Re: Shared Pool Size Babu Nagarajan
- RE: Shared Pool Size DENNIS WILLIAMS
- shared pool size bulbultyagi
