Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Strange open cursors for "select null from dual" on Oracle 9i and 10g

Re: Strange open cursors for "select null from dual" on Oracle 9i and 10g

From: Joel Garry <joel-garry_at_home.com>
Date: 5 Apr 2005 15:41:39 -0700
Message-ID: <1112740899.328577.183480@f14g2000cwb.googlegroups.com>


Please state exact versions, cursor handling has been changing through 9.

Please state init.ora parameters with cursor in them for each version, ie select name, value from v$parameter where name like '%cursor%';

Also, if you have OEM, you can drill down from a sesssion to look at cursors. Perhaps your app server is doing many things.

jg

--
@home.com is bogus.
"Thanksgiving turkey, Christmas turkey, Valentines's Day beaver, Easter
rabbit." - Get Fuzzy
Received on Tue Apr 05 2005 - 17:41:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US