- 博客(11)
- 资源 (6)
- 收藏
- 关注
转载 Fixed Objects Statistics and why they are important
Fixed Objects Statistics and why they are importantBy Maria Colgan-Oracle on Jan 09, 2012Fixed objects are the x$ tables and their indexes. The v$performance views in Oracle are defined in top
2016-07-28 10:57:08 367
转载 Index Monitoring and Index Statistics (The Great Gig In The Sky)
I write this post whilst listening to Pink Floyd’s masterpiece “The Dark Side Of The Moon” while sadly lamenting thepassing away of Richard Wright. RIP and thank you for all the great musical gift
2016-07-27 21:33:03 594
转载 Index Monitoring and Foreign Keys – Caution
Index Monitoring and Foreign Keys – Caution (Kid A) September 12, 2008Posted by Richard Foote in 11g, Constraints, Foreign Keys, Index Monitoring.trackbackOne of the questions asked of i
2016-07-27 21:32:14 296
原创 历史sql plan
历史sql plan可以使用dbms_xplan,display_awr来展示DBMS_XPLAN.DISPLAY_AWR( sql_id IN VARCHAR2, plan_hash_value IN NUMBER DEFAULT NULL, db_id IN NUMBER DEFAULT
2016-07-27 13:14:08 347
转载 Oracle 11g logical standby switchover
11.2.0.4 on Oracle Linux 5.81、检查primary的switchover_statusselect switchover_status from v$database; 如果为sessions active或者to standby 都可以向下进行。2、Prepare primary databaseprimary 上执行:alter data
2016-07-26 14:59:32 406
转载 Using Flashback in a Data Guard Environment
Using Flashback in a Data Guard EnvironmentIf Logical Mistakes happen, we can address them with the Flashback techniques, introduced in Oracle Database 10g already, even if in an Data Guard En
2016-07-15 17:01:00 657
原创 oracle 11.2.0.4 physical standby failover
husical standby failover 11.2.0.4 on Oracle Linux5.81 Primary 还能mount起来的情况 Standby 的mrp程序正常开启,Primary在mount情况下,确定flush redo Alter systemflush redo to ‘standby’;默认是confirmapply Ø 如果该语句正常完成,说
2016-07-14 14:59:06 401
原创 oracle 11g physical standby switchover steps
11.2.0.4 on Oracle Linux 5.8 physical standbyswitchover1 开启追踪Primary 以及Standby的alert日志 2 在主库查看是否日志都已经apply select log.ARCHIVED,log.APPLIED fromv$archived_log log wheredest_id = 2
2016-07-14 11:21:56 359
原创 flush redo时出现ora-00922
11.2.0.4DATAGUARD环境,在primary database mount状态下flush redoSQL> alter system flush redo to sales1 no confirm apply;alter system flush redo to sales1 no confirm apply *
2016-07-13 15:39:00 908
转载 ora-01178及ORA-01511错误
oracle 11.2.0.4参考以下文档:How to Recover from errors ORA-01171 ORA-01122ORA-01251 ORA-01186 (文档 ID 333620.1)OERR: ORA-1178"file %s created before last CREATE CONTROLFILE, cannot recreate"Reference
2016-07-11 16:09:44 2570
原创 使用du统计文件夹大小Tip
当发现某个分区满了时,此时会去看哪个文件夹占用的容量比较大。使用du -hs * 统计当前文件夹下子文件夹大小[root@sdb5-11g ~]# du -hs *8.0K anaconda-ks.cfg44K install.log8.0K install.log.syslog8.0K '\tmp\1.txt'[root@sdb5-11g
2016-07-11 14:42:31 562
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人