Forum OpenACS Q&A: Response to ORA-01000: maximum open cursors exceeded ??

Posted by Brian Fenton on
Hi Andrew, good to hear you've been tracking down the cursors.
Try this query to see the full SQL text:
select user_name, status, osuser, machine, a.sql_text, c.sql_text 
from v$session b, v$open_cursor a,  V$SQLAREA c
where a.sid = b.sid
and c.address = a.address;
I find AOLserver a much better client than SQL*Plus for outputting these long queries! A nice example of this is admin/monitoring/cassandracle/performance/pct-large-table-scans in Cassandracle.
Take care.