Problem on dropping a tablespace (HELP !)

From: Yves Noel <noel_at_citi.citilille.fr>
Date: 22 Mar 1993 13:49:36 GMT
Message-ID: <1okg5gINN6m1_at_netserver.univ-lille1.fr>


I want to drop a 50M tablespace and nothing happens after several minutes wait ! Then I look the contents of /?/rdbms/log/alert_sid.log and I find these errors :

Mon Mar 22 08:52:22 1993
drop tablespace spc_etud_ind
Mon Mar 22 08:52:26 1993
ORA-604 signalled during: drop tablespace spc_etud_ind... Mon Mar 22 08:52:26 1993
Error signalled in file: /usr/oracle/rdbms/log/5_315.trc ORA-00600: internal error code, arguments: [4406], [1342382756], [1342382648], [
], [], []

ORA-00604: error occurred at recursive SQL level 1 ORA-00702: maximum number of row cache enqueues exceeded Mon Mar 22 08:53:17 1993
Error signalled in file: /usr/oracle/rdbms/log/5_315.trc ORA-00600: internal error code, arguments: [4406], [1342382756], [1342382648], [
], [], []

ORA-00600: internal error code, arguments: [4406], [1342382756], [1342382648], [
], [], []

ORA-00604: error occurred at recursive SQL level 1 ORA-00702: maximum number of row cache enqueues exceeded

  • Then I modify the row_cache_enqueues parameter in the init.ora file It was equal 100, now it is equal 200 **************************

Mon Mar 22 11:02:17 1993
drop tablespace spc_etud_ind
Mon Mar 22 11:02:21 1993
ORA-700 signalled during: drop tablespace spc_etud_ind... Mon Mar 22 11:02:21 1993
Error signalled in file: /usr/oracle/rdbms/log/5_308.trc ORA-00600: internal error code, arguments: [4406], [1342382756], [1342382648], [], [], [] ORA-00700: maximum number of row cache objects (parameter 'dc_free_extents') exceeded Mon Mar 22 11:03:02 1993
Error signalled in file: /usr/oracle/rdbms/log/5_308.trc

ORA-00600: internal error code, arguments: [4406], [1342382756], [1342382648], [], [], []
ORA-00600: internal error code, arguments: [4406], [1342382756], [1342382648], [], [], []
ORA-00700: maximum number of row cache objects (parameter 'dc_free_extents') exceeded

**************** I've already modify the dc_free_extents parameters !
                 It was initialy equal 50 and I passed it to 100  ***********************

Can anybody give me good informations about these errors, about the values of the init.ora parameters ? I'm afraid by this error ORA-00600, perhaps the data dictionary is'nt good ? WHAT CAN I DO ??? Thanks ! Received on Mon Mar 22 1993 - 14:49:36 CET

Original text of this message