| connection failing [message #62947] |
Thu, 26 August 2004 04:20  |
Nirmalendu Dash
Messages: 2
Registered: August 2004
|
Junior Member |
|
|
Hi,
I am facing connection failed with the following error message. Not everytime...
ORA-04031: unable to allocate 26200 bytes of shared memory ("shared
pool","unknown object","sga heap(1,0)","session param values")
So pls suggest me whether I should increase the shared pool size or I will configure the large pool for this purpose or any other better way is there to solve this. And now it is difficult for me to shutdown the database....
Thanks in advance
Nirmal
L&T Infotech LTD.
India
|
|
|
|
| Re: connection failing [message #62948 is a reply to message #62947] |
Thu, 26 August 2004 07:20  |
vadlamani
Messages: 39
Registered: November 2003
|
Member |
|
|
You can try increasing the SAHRED_POOL_SIZE or even setting this parameter is much better
SHARED_POOL_RESERVED_SIZE.
And even try to reduce the shared pool fragmentation
by configuring the large pool if u r using the RMAN,SHARED SERVERS, PARALLEL AUTOMATIC TUNING or u have configured DBWR I/O Slaves, anf JAVA POOL if u r using java.
hope this helps
satish
|
|
|
|
| Re: connection failing [message #63010 is a reply to message #62947] |
Wed, 01 September 2004 09:08 |
easywebtech.com
Messages: 6
Registered: September 2004
|
Junior Member |
|
|
You can run following command and solve this issue without restarting the database.
sqlplus >Alter System Flush shared_pool;
Thanks,
webmaster
www.easywebtech.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
