ORA-01555 caused by SQL statement below (Query Duration=0 sec, SCN
剛才系統報快照過舊,初看錯誤發現Query Duration=0 sec,比較奇怪。報錯如下
Thu Mar 10 13:16:53 2011
ORA-01555 caused by SQL statement below (Query Duration=0 sec, SCN: 0x0000.13708dcb):
大家也許會奇怪0秒的sql怎麼會出現快照過舊呢?比較疑惑吧!
看看後續的報錯sql就明瞭了
Thu Mar 10 13:16:53 2011
select * from xx_yy_209 as of timestamp(systimestamp - interval '3' day)
呵呵,你懂的……
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/11088128/viewspace-688953/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-01555 caused by SQL statement belowSQL
- Query the duration of log switch
- 【等待事件】standby query scn advance事件
- High Executions Of Statement "delete from smon_scn_time..."delete
- Query sqlSQL
- Statement (操作 SQL 語句)SQL
- Oracle IZ0-053 Q336(Rman Duration)Oracle
- Oracle OCP 1Z0 053 Q342(RMAN BACKUP DURATION)Oracle
- Event 10046 - Enable SQL Statement TraceSQL
- SQL java.sql.SQLException: Parameter metadata not available for the given statementSQLJavaExceptionAI
- IMP-00032: SQL statement exceeded buffer lengthSQL
- In PL/SQL,the statement of "into variable" wasn't appeared in statspackSQLAPP
- Statement Tracer For Oracle 與 SQL Monitor 的比較OracleSQL
- Sphinx 配置sql_query_killlist解析SQL
- Statement
- Oracle9i Flashback Query 閃回查詢總結 --- (通過SCN恢復)Oracle
- Entity Framework Tutorial Basics(39):Raw SQL QueryFrameworkSQL
- SQLite Learning、SQL Query Optimization In Multiple RuleSQLite
- Retrieving the First N Records from a SQL QuerySQL
- CSS3 animation-durationCSSS3
- CSS3 transition-durationCSSS3
- SQLT (SQLTXPLAIN) - Tool that helps to diagnose a SQL statement [ID 215187.1]SQLAI
- How to Run Statement Level/Java trace or a SQL Trace in Self Service ApplicationJavaSQLAPP
- Fastjson SecASTJSON
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQLMySqlJDBCExceptionError
- Caused by: java.sql.SQLException: 索引中丟失 IN 或 OUT 引數:: 1JavaSQLException索引
- FAQ: SQL Query Performance - Frequently Asked Questions_398838.1SQLORM
- Cheap GHD Hair Straighteners Uk below to adjustAI
- Android SQL資料庫查詢方法 query( )AndroidSQL資料庫
- 將 SQL轉換成 Laravel Query Builder 程式碼SQLLaravelUI
- SQL(Structured Query Language)語句分哪幾類SQLStruct
- non-correlated subquery or correlated sub query - [sql語句]SQL
- After mysql installation, we need to change the password of root as belowMySql
- Caused by: android.os.Android
- 【SCN】Oracle SCN 詳細介紹Oracle
- EVENT: 10046 "enable SQL statement tracing (including binds/waits)"SQLAI
- Oracle RDBMS : Flushing a Single SQL Statement out of the Object Library CacheOracleSQLObject
- ORA-01555——理解