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

From: ca111026 <ca111026_at_gmail.com>
Date: Fri, 14 May 2010 23:15:45 -0700 (PDT)
Message-ID: <d16c3eaf-d810-48a8-b85b-2a7df9a4dbf7_at_t34g2000prd.googlegroups.com>

I already checked V$OPEN_CURSOR. It shows than no session has more tha 200 cursors:

SQL> select

  2          sid,
  3          count(*) cnt
  4  from
  5          v$open_cursor
  6  group by
  7          sid
  8  order by
  9          2;

       SID        CNT
---------- ----------
        18          1
        43          1
        87          1
       101          1
       119          1
       157          1
       179          1
       183          1
       206          1
       286          1
       274          1
       260          1
       256          1
       240          1
       210          1
       204          1
       164          1
       412          1
       396          1
       113          1
       144          2
       369          2
       315          2
       417          2
       220          3
       383          4
        84          6
       186          7
        15          8
       394          9
        60         12
        74         13
        88         14
       132         16
       110         17
       182         17
       190         18
       409         18
       127         19
        68         20
       249         20
        36         21
       111         21
        57         24
       147         24
       129         31
       203         31
        12         38
       167         38
       263         39
       308         42
        64         61
       316         61
        75         65
       104         75
       314         77
       259         78
       292         79
       184         80
       415         81
       169         82
       187         83
       271         83
       247         83
        28         84
       268         84
        78         84
        39         84
        96         85
       207         85
       267         85
       294         85
       309         85
       162         86
       337         86
       398         87
        42         88
       126         88
       251         88
       254         88
       141         88
        11         89
       389         89
       339         89
       281         89
       261         89
       153         89
       100         89
        19         90
       105         90
       382         90
       176         90
       229         90
       130         90
       125         90
       117         90
       102         91
       108         91
       166         91
       145         91
        89         92
       224         92
        50         93
       250         93
       295         93
       192         93
        30         94
       152         94
       118         94
       399         95
       307         96
        38         97
        47        100
        82        105
       328        108
       252        112
       154        122
        77        138
       401        138
       194        144
       426        146
       112        151
       244        153
       387        171
       390        175
        85        176
       282        178
       143        179
       368        179
        98        181
       159        187
        24        188
       245        194
       133        195
        17        196
        62        198
        21        200
       395        200
        65        200
       290        200
       333        200
       228        200

142 rows selected. Received on Sat May 15 2010 - 01:15:45 CDT