Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Expand SGA but performance slow down?
More is better until you force the operating system into virtual memory
swapping. The SGA is a balance of available memory (real) and the other
requirements of the system. Without knowing the operating system, memory
available and other specifics, it is not possible to be more specific.
James
In article <35dc6b8c.20227570_at_news.twsc.pouchen.com.tw>, violin.hsiao_at_mail.pouchen.com.tw (Violin) wrote:
>Hello,
>2 days ago I changed the init.ora and startup again.
>In init.ora,I changed the:
>db_block_buffers = 200 --> 6400
>shared_pool_size = 3500000 --> 10000000
>log_buffer = 8192 --> 245760
>processes = 50 -->100
>
>After startup database again,the SGA allocated successfully.
>Database Buffers = 400K --> 12800KBytes
>Fixed Size=35K --> 31K
>Redo Buffers=8K --> 240K
>Variable Size=6887K --> 12526K
>
>When I do the same SQL for a large amount of rows(about 37,000) for
>select and insert statement,
>Before changed SGA,the statement takes 5 seconds to complete.
>After changed SGA,it takes 17 seconds to complete.
>Why???
>Isn't the SGA more large more better?
>If you know why,please tell me.
>Please Cc to : violin.hsiao_at_mail.pouchen.com.tw,Thank you :)
--
lorenzen_at_tiny.net | Life is complex; it has | real and imaginary partsReceived on Thu Aug 20 1998 - 10:27:52 CDT
![]() |
![]() |