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

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 08 Sep 2006 06:05:14 -0700
Message-ID: <1157720709.633572@bubbleator.drizzle.com>

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?

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

Received on Fri Sep 08 2006 - 08:05:14 CDT