发布时间:2012-12-28 09:19:52
Unless and until the database is shutdown, the col_usage$ table will continue to grow. Solution To implement the workaround, please execute the following steps: oracle认证 1. Periodically (eg once a day) run exec DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO; DBMS_STAT......【阅读全文】
发布时间:2012-12-27 11:34:14
unix培训http://www.cuug.com/根据Metalink Note<Database Shutdown Immediate Takes Forever, Can Only Do Shutdown Abort [ID 332177.1]>: Database Shutdown Immediate Takes Forever, Can Only Do Shutdown Abort [ID 332177.1] Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.4.0 ......【阅读全文】
发布时间:2012-12-27 10:52:59
使用dbms_stats的'SIZE AUTO'模式收集表上的统计信息会首先参考col_usage$中的predicate columns记录:SQL> begin23 dbms_stats.gather_table_stats(ownname => 'SYS',4 tabname => 'MACLEAN',5 method_opt => 'FOR ALL COLUMNS SIZE AUTO');6 end;7 /PL......【阅读全文】
发布时间:2012-12-25 18:02:15
linux视频教程下载 注意col_usage$的数据同*_tab_modifications类似, 从查询到数据刷新到col_usage$存在一段时间的延迟, 所以我们立即查询col_usage$将得不到任何记录, 可以手动执行DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO将缓存中的信息刷新到字典上 SQL> select * from col_usage$ where obj#=1323013; no rows selected  ......【阅读全文】
发布时间:2012-12-21 09:21:49
Problem Description: We are receiving the below warning during db startup:WARNING: kqlclo() has detected the following :Non-existent object 37336 NOT deleted because an objectof the same name exists already.Object name: PUBLIC.USER$This is caused by the SMON trying to cleanup the SYS.OJB$.SMON clean......【阅读全文】