| Error in Pro*C/C++ Application [message #93905] |
Fri, 14 March 2003 21:11  |
Pradeep
Messages: 55
Registered: July 2000
|
Member |
|
|
Hi,
I have developed an application,which is daemon process querying the database every 8 milliseconds.
The configuration i have opted is to connect and disconnect every query. Is this choice right
The problem I am facing is the application works continously fine for nearly 24 hours after,
which it throws an error as following
1. Oracle Error ORA-00604: Error occurred at recursive SQL level2
2. Oracle Error ORA-04031: Unable to allocate 248 bytes of shared memory
Note: Iam exitting the program printing the sql warnings.
The errors are categorized in pro*c as implementation defined.
OS : TRU64 unix
Database : Oracle 8.1.7
Precompiler : Pro*c/C++
The solutions previously proposed was to Increase the sharepool size, but it only helped the
application to execute couple of hours more.
Please give the solution as soon as possible
Thanks,
Pradeep
|
|
|
|
| Re: Error in Pro*C/C++ Application [message #93906 is a reply to message #93905] |
Wed, 19 March 2003 06:02  |
Ritesh Kumar
Messages: 18
Registered: February 2003
|
Junior Member |
|
|
Until and unless there is a business rule or requirement that the user should disconnect after a query, I would say, disconnecting after each query (8 milliseconds) is simply unneccessary.
It is possible that due to the repetitive login/logout, there could be some defunct sessions in the background (Check the v$session view).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
