Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Strange open cursors for "select null from dual" on Oracle 9i and 10g
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 FuzzyReceived on Tue Apr 05 2005 - 17:41:39 CDT
![]() |
![]() |