oracle 19004,ORA-00600: [19004]

Log

02/11/2015 11:09 AM / Core / AdvancedGenericEntityMgr / createEntity(String, String, String, String, ArrayList, SqlConditionClause, boolean, String) / Critical(1)

Text: ORA-00600: 内部エラー・コード, 引数: [19004], [], [], [], [], [], [], [], [], [], [], []

Trace:

java.sql.SQLException: ORA-00600: 内部エラー・コード, 引数: [19004], [], [], [], [], [], [], [], [], [], [], []

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)

at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785)

at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1490)

解决办法

以DBA身份执行:1.

execute dbms_stats.delete_schema_stats('username');

or

2.

如果只有个别表在查询时出现错误,可以只对出错表理行处理

execute dbms_stats.delete_table_stats('username','tablename');