by 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 !