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

Collapse
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.