Problem on dropping a tablespace (HELP !)
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