From cspence@FuelSpot.com Wed, 03 Oct 2001 06:09:36 -0700 From: Christopher Spence Date: Wed, 03 Oct 2001 06:09:36 -0700 Subject: RE: Please Help Message-ID: MIME-Version: 1.0 Content-Type: text/plain This is covered very well and in detail in the manuals, but in short it means you had a transaction write to a rollback segment, then a long running query requested this information for read consistency before the transaction (cause it was already started before the transactions started) and it doesn't have the rollback information available to rebuild the transaction.  This usually happens when you have long running queries during heavy transactional periods.   In short, increase your rollback segments size or number of extents, but don't increase them so much as that they are huge for your needs.   "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:    (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863   -----Original Message----- From: Riswandi [mailto:riswandi@polyfincanggih.com] Sent: Wednesday, October 03, 2001 7:01 AM To: Multiple recipients of list ORACLE-L Subject: Please Help   Hi lists ...   I got this error when I'm running procedure.   - ORA-01555: snapshot too old (rollback segment too small)   Rollback segments statistics:    CLASS                  COUNT  ------------------ ---------  system undo header         0  system undo block          0  undo header                3  undo block                 0    (db block gets + consistent gets)/100  -------------------------------------                              1041116.1    SUBSTR(NAME,1,40)                EXTENTS    RSSIZE AVEACTIVE   OPTSIZE AVESHRINK   EXTENDS   SHRINKS  ------------------------------ --------- --------- --------- --------- --------- --------- ---------  RB0                                    3   2170880    328140   1572864         0         0         0  RB1                                    3   2170880   1828001   1048576   6291456         7         1  RB2                                    2   1122304    202338   1048576   1048576         2         2  RB3                                    2   1122304    309818   1048576   1048576         1         1  RB4                                    2   1122304    352696   1048576   2097152         2         1  RB5                                    2   1122304    309818   1048576   1048576         1         1  RB6                                    2   1122304    309818   1048576   1048576         1         1  RB7                                    2   1122304    320911   1048576   1048576         1         1  RB8                                    2   1122304    374967   1048576   1048576         1         1  RB9                                    2   1122304    275972   1048576   1048576         1         1  RB10                                   2   1122304    254828   1048576         0         0         0  RB11                                   3   2170880    277233   1048576         0         1         0  RB13                                   2   1572864    275197   1310720         0         0         0    SEGMENT_NAME                   INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS  ------------------------------ -------------- ----------- ----------- -----------  RB0                                     57344     1048576           2         100  RB1                                     57344     1048576           2         100  RB2                                     57344     1048576           2         100  RB3                                     57344     1048576           2         100  RB4                                     57344     1048576           2         100  RB5                                     57344     1048576           2         100  RB6                                     57344     1048576           2         100  RB7                                     57344     1048576           2         100  RB8                                     57344     1048576           2         100  RB9                                     57344     1048576           2         100  RB10                                    57344     1048576           2         100  RB11                                    57344     1048576           2         100  RB13                                   524288     1048576           2         100   Please help. ... ...