Pin Sql query in shared pool [message #462635] |
Fri, 25 June 2010 06:53 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
paradoxkhan
Messages: 92 Registered: April 2008 Location: Pakistan
|
Member |
|
|
Hi,
We are facing performance issues on our production instance 10g(10.2.0.4) 32-bit OELinux 5.3 2GB SGA.
The performance is mainly related to one of the table which is sized about 32Gb. We have rebuild the indexes as well but problem
still persist. We are considering to pin SQL statement in shared pool which is hitting the same table frequently. But as far what we have find, is that we can only pin procedures or function in shared pool. True/false?
If we can, then how to pin SQL statement in shared pool?
If we can not, then is there any other way?
Thanks,
Yasir Aftab
|
|
|
Re: Pin Sql query in shared pool [message #462636 is a reply to message #462635] |
Fri, 25 June 2010 06:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
If the query is being executed regularly then it probably never leaves the shared pool, and if it does your Shared pool is probably too small.
Are you sure that's the root of the problem and not something else?
|
|
|
|
|