OraFAQ Forum: Server Administration » SGA Heap / Recursive SQL problems..

Home » RDBMS Server » Server Administration » SGA Heap / Recursive SQL problems..

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SGA Heap / Recursive SQL problems.. [message #55190]

Thu, 09 January 2003 11:37

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

hello all,
every day morning when my (asp ) client tries to connects to database, it gives me an error either SGA Heap .. / Recursive SQL .. .why is that so ? what i will do is change the shared pool size i.e. either increasing or decreasing.. then it works fine.. again next morning i get the same error..

What is the optimal approach .. ?
and One more thing for 128MB ram what is the setting for SGA ?
Please let me know asap..

Thanks and Regards
SAI

Report message to a moderator

Re: SGA Heap / Recursive SQL problems.. [message #55191 is a reply to message #55190]

Thu, 09 January 2003 12:22

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

sai,
can you post the exact error message?
from the logs?
are u getting
ORA-00604 & ORA-04031 or wat?

Report message to a moderator

Re: SGA Heap / Recursive SQL problems.. [message #55196 is a reply to message #55190]

Thu, 09 January 2003 23:28

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

hi mahesh,
yeah i am getting ORA-04031 ..
I am looking at logs evry day , and there were no error messages..
Error pops up when Clients try to access Database from ASP pages.

sai

Report message to a moderator

Re: SGA Heap / Recursive SQL problems.. [message #55198 is a reply to message #55196]

Fri, 10 January 2003 02:53

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

as u told, increase your shared pool size.
are u using any JVM?
try to maintain atleast 8m of java pool size.

----------------------------------------------------------------------

try setting this initsid parameter.
if it is not heping, REMOVE THIS PARAMETER.
_db_handles_cached = 0

Report message to a moderator

Re: SGA Heap / Recursive SQL problems.. [message #55203 is a reply to message #55198]

Fri, 10 January 2003 09:36

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Thanks mahesh,
I will do that, and i will let u know about the outcome as soon as possible..

sai

Report message to a moderator

Previous Topic:	Re: download free ocp dumps,papers,ocp kits...
Next Topic:	connect other database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:41:18 CDT 2024