old open cursor entries
Date: Thu, 14 Jun 2012 14:16:33 -0300
Message-ID: <CACH2EDLhA1JZaQdq=t1BonZizZCHsan6twaM_+iqV3R_QwCesg_at_mail.gmail.com>
We are seeing in EM11g lists of old cursors for user sessions, some with locks. Some sessions can have over twenty entries in the open cursors page even if their last statement is a simple select statement. As if there is old shadow SQL or zombie cursor locks left in the database server side even though the SQL was run a week or up to a month ago.
Normally for cursors it stores the info in the shared pool, in case someone submits the same SQL again later. It may store the compiled code too I think but whether that's true or not, wouldn't locks be released once the user finishes using the cursor?
These are not the 11g row exclusive locks related to foreign keys, the SQL we see includes select and insert statements, as well as recursive SQL like inserts into the sys.aud$ table.
- Patrice
<http://www.viadeo.com/fr/profile/patrice.boivin>
[image: Facebook]
<http://www.facebook.com/profile.php?id=100000206805521> [image:
LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9> [image:
Twitter] <http://www.twitter.com/PatriceBoivin> [image:
Amazon]<http://www.amazon.com/gp/redirect.html?ie=UTF8&location=http%3A%2F%2Fwww.amazon.com%2Fgp%2Fregistry%2Fregistry.html%3Fie%3DUTF8%26type%3Dwishlist%26id%3D2JU0BBL2AGGSD&tag=casper-20>
[image:
Digg] <http://digg.com/patriceboivin> [image:
Google]<http://https://sites.google.com/site/patriceboivin/>
Get a signature like this.
<http://r1.wisestamp.com/r/landing?promo=19&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_19>
CLICK
HERE.<http://r1.wisestamp.com/r/landing?promo=19&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_19>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 14 2012 - 12:16:33 CDT