Re: Enterprisemanager and Session Details -> Open Cursers: are they really open?

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 11 Sep 2006 22:58:33 -0700
Message-ID: <1158040712.757517@bubbleator.drizzle.com>

Lars Tetzlaff wrote:

> DA Morgan wrote:
>> Lars Tetzlaff wrote:
>>> DA Morgan wrote:

>>>> Lars Tetzlaff wrote:
>>>>> Hi
>>>>>
>>>>> I am not sure if i have a problem with the number of open cursors :(
>>>>>
>>>>> The Open Cursors Tab shows ~40 open cursors, but if the program
>>>>> works correct there shouldn't be any open cursor. Since we are
>>>>> using QT for db access, i don't know if i have to look for a bug in
>>>>> QT or if OEM shows some 'cached' cursors.
>>>>>
>>>>> Any hints?
>>>>>
>>>>> We are using 10.2.0.2.
>>>>>
>>>>> Lars
>>>>
>>>> The following is on a single-user system
>>>>
>>>> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>>>> SQL*Plus: Release 10.2.0.2.0 - Production on Fri Sep 8 06:02:46 2006
>>>>
>>>> Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
>>>>
>>>> Connected to:
>>>> Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
>>>> With the Partitioning, OLAP and Data Mining options
>>>>
>>>> SQL> shutdown immediate;
>>>> Database closed.
>>>> Database dismounted.
>>>> ORACLE instance shut down.
>>>> SQL> startup
>>>> ORACLE instance started.
>>>>
>>>> Total System Global Area 612368384 bytes
>>>> Fixed Size 1290916 bytes
>>>> Variable Size 218107228 bytes
>>>> Database Buffers 390070272 bytes
>>>> Redo Buffers 2899968 bytes
>>>> Database mounted.
>>>> Database opened.
>>>> SQL> SELECT COUNT(*)
>>>> 2 FROM gv$open_cursor;
>>>>
>>>> COUNT(*)
>>>> ----------
>>>> 115
>>>>
>>>> SQL>
>>>> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>>>> What are you counting? The open cursors tab of what with what
>>>> version of Oracle?

>>>
>>> I am using the "Oracle Enterprise Manager 10g Database Control" web 
>>> interface.
>>> There i am looking at the Session Details (Database Instance: db1  > 
>>> Top Activity  >  Session Details ) of one single session. There exits 
>>> a page open cursors. These open cursors belong to the chosen session 
>>> ( as i believe ).
>>> The version is 10.2.0.2.0 (windows XP).
>>>
>>> Does this answer your questions? Don't know how to describe it better.
>>>
>>> Lars
>>
>> Are these cursors opened explicitly by code as in an OPEN CURSOR
>> statement or, as I would guess, implicit cursors opened by Oracle
>> that are available for reuse?
> 
> Since we are using QT i don't know exactly what statements are executed.
> QT uses OCI. To fetch data they use OCIStmtExecute and OCIStmtFetch or 
> OCIStmtFetch2. The statement handle is released witch OCIHandleFree.
> 
> I can see my SQL statement in the list of open cursors after 
> OCIHandleFree is executed. This happens even i a simple test program 
> with "select * from t1".
> 
> Lars

So what is the point of the inquiry? If you can't get to the front-end C++ you've nothing much to do except monitor for problems. As the company that sold it to you if this is normal: Likely it is.

BTW: OCI or whatever you can still trace what it is doing.

-- 
Daniel Morgan
Puget Sound Oracle Users Group

Received on Tue Sep 12 2006 - 00:58:33 CDT