自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+
  • 博客(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 593

转载 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 295

原创 历史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 2569

原创 使用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 561

best-practices-for-upgrading-11gr2

官方 upgrade best practice,资料例举了升级至11gr2的最佳实践

2018-10-09

1Z0-042题库.pdf

1Z0-042题库.pdf,ocp题库

2012-03-22

DesignPatternsExplained

英文原版书籍 DesignPatternsExplained

2008-09-25

VNC viewer

可以连接别人的电脑,经常用户连接别人电脑排错

2008-09-25

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除