| v$Open_cursor [message #63964] |
Tue, 30 November 2004 16:00 |
Joan
Messages: 36
Registered: February 2002
|
Member |
|
|
I have database that I am getting alert with our monitoring system that our cursorleft have exceeded 97%. However when I checked the v$open_cursor I only noticed two cursor open.
select sid,user_name,count(*) from v$open_cursor group by user_name,sid;
SID USER_NAME COUNT(*)
---------- ------------------------------ ----------
10 MCHONLINE 1
57 MCHONLINE 2
-- This is the statement the monitoring tools is running to checked for cursorleft
-- The Open_cursor init parameter is set 500
select max(value) from v$sesstat s where s.statistic# =
2 (select statistic# from v$statname where name='opened cursors current');
MAX(VALUE)
----------
808
select SID,value from v$sesstat where value=808;
SID VALUE
---------- ----------
57 808
How can I tell excatly how many cursors are open per sessionId.
seems like the v$sesstat value is different. Some of the application I have experience this problems they are using websphere and connection pooling
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
