Have you monitored what is in v$open_cursor when you see this error?
Printable View
Have you monitored what is in v$open_cursor when you see this error?
Yes, I have only one session as this user (checked 2 nodes) and the result is bellow:Quote:
Originally Posted by pando
Code:SQL> select sid,serial#,machine,program from v$session where username='USER';
SID SERIAL# MACHINE PROGRAM
---------- ---------- ---------------------------------------------------------------- ------------------------------------------------
274 43685 MY MACHINE sqlplus.exe
SQL> select count(*) from v$open_cursor where user_name='USER';
COUNT(*)
----------
617
Thank you, this will be my next step.Quote:
Originally Posted by hrishy
I dont mean count(*)
Look what SQL are being executed in v$open_cursor
Yes, I did look at it, only system queries, I can't say too much about itQuote:
Originally Posted by pando
Hello KGB
Did you find solution to your problem after moving to RAC , as we are having similar issues
Thanks
-Jas
Not yet, today I have contacted Oracle - will see what they say ...Quote:
Originally Posted by jasvinders
I found that tehy released 11.0.1.7, and they fixed somethign related to that error, will update.
5377060 ORA-604 ORA-1000 when selecting from DBA_JAVA_CLASSES
377060 ORA-604 ORA-1000 when selecting from DBA_JAVA_CLASSES
6711477 ORA-1000 from repeated use of a REF CURSOR which is already open