Re: Failure to extend rollback segment N because of 1000 condition

From: ca111026 <ca111026_at_gmail.com>
Date: Fri, 14 May 2010 22:22:15 -0700 (PDT)
Message-ID: <8221638e-0b73-4a62-8a0f-3537bdd90a0f_at_g39g2000pri.googlegroups.com>

Thanks. Yes, I checked V$SESSTAT for STATISTIC# = 3 ('open cursors current'). In this database parameter open_cursors is set to 2,000.

Most sessions had less than 10 opened cursors, with following exceptions:
- one session with 1,999

• two sessions with 2,000
• one session with 32,430
• one session with 33,877

How a session could have 32,000 opened cursors when limit is 2,000? Received on Sat May 15 2010 - 00:22:15 CDT