Re: ORA-01000: maximum open cursors exceeded

• Post for FREE via your newsreader at post.usenet.com ****

"vinnie washington" <vwas_at_hotmail.com> wrote in message news:fb9e060a.0410181541.2390054_at_posting.google.com...
> I'm wondering if anyone can help me figure out why I'm receiving this
> problem. I am running Oracle 8.1.7 on Win2K server and have been
> receiving this message in my application. When I query 'select
> sql_text from v$open_cursor; ' to see what is holding things up, I
> see:
>
> SELECT NULL AS table_cat, t.owner AS table_schem,
>
> with 300 entries in the table. Any thoughts?

Have a look to the whole sql statement. v$open_cursor only contains the first 60 characters... v$sqlarea the first 1000. Use a query like the following one:

select count(*), sum(s.executions) executions, s.sql_text from v$open_cursor o, v$sqlarea s
where o.address = s.address
and o.hash_value = s.hash_value
group by s.sql_text
order by 1 desc;

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=