| After updating memory_target, performance is degraded [message #612962] |
Mon, 28 April 2014 05:36  |
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
|
Senior Member |
|
|
Dear All,
Last day, I made memory parameters to automatic by updating memory_target & memory_max_target. But still show sga_max_size values.
While long running sql stmt, performance is degraded. Since long running is executing, pga are taking memories from sga. Is this the issue?
Do i need to revert the changes for long running sql stmt?
Waiting for your valuable response on the same...
Regards,
Ashish Kumar Mahanta
|
|
|
|
|
|
|
|
|
|
| Re: After updating memory_target, performance is degraded [message #612981 is a reply to message #612973] |
Mon, 28 April 2014 07:51  |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
Michel Cadot wrote on Mon, 28 April 2014 17:52
No, in 11g you only have memory_target & memory_max_target, as OP said, if you want to "let Oracle completely take control over the memory management".
Yes, I know. Since OP is facing performance issues after setting the memory parameters, I guess the values might not have been set properly for the parameters. And to set the memory target, sga_target and pga_aggregate_target has to be determined.
@OP, if you want to let Oracle completely take control over the memory management, have a look at this link from documentation about Enabling Automatic Memory Management.
|
|
|
|
| Re: After updating memory_target, performance is degraded [message #613048 is a reply to message #612981] |
Tue, 29 April 2014 02:41 |
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
|
Senior Member |
|
|
Dear All,
I set sga_aggregate & pga_aggregate values to "0". And after getting sum of it, set memory_target values to little higher side.
It was showing "0" on sga_target, sga_aggregate, pga_aggregate values. But also sga_max_size was appearing values as similiar to memory_max_size. I ignored it and proceeded.
Yestarday night, I changed it from Automatic to manual and user are able to execute long update queries. They dont have any problem now. But my worries is, why automatic is not performing well for long running updates query?
Thanks for providing the links. I have gone through it but still, confused.
Regards,
Ashish Kumar Mahanta
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
