Category: oracle - My Notebook

2020-04-23 等待事件: reliable message

2020-04-20 Oracle 12c开启结果集缓存导致大量latch free等待

2019-09-16 优化expdp/impdp思路

2019-09-16 等待事件enq:TM contention

2019-09-07 RAC DG Broker ora-16843 ora-16839错误

2019-09-07 12c PDB级别可修改参数

2019-09-04 如何确认刚刚执行的SQL ID

2019-09-04 利用rman增量备份恢复adg gap

2019-08-27 12c使用dataguard broker配置带farsync的active dataguard

2019-08-16 dbbp bundle patch installed in the cdb but not in the pdb

2019-08-15 Prerequisite Check "CheckActiveFilesAndExecutables" Failed

2019-08-13 远程复制数据库到现有的CDB

2019-08-08 使用SPM固定执行计划

2019-08-08 Fixed Table统计信息

2019-08-08 RMAN Compression And Unused Block Compression

2019-08-07 A Brief Introduction of Oracle Role and Privilege

2019-08-06 Security Hardening of Oracle Database

2019-08-06 Easy Connect with ORA-12504

2019-07-31 A brief introduction of MGMTDB

2019-07-31 OCR Voting disk replacement or movement

2019-07-31 Migrating Oracle ASM storage

2019-06-26 Updating Global Indexes Automatically

2019-03-13 Security Hardening of VPS

2019-03-11 Error for Oracle 12c in AIX rtld: 0712-001

2019-02-21 Rename RAC dbname and GI diskgroup name

2019-01-11 Issues of building RAC ADG

2018-10-27 Understand DB time

2018-10-25 Log file sync wait event

2018-10-15 Adaptive log file sync

2018-10-10 Oracle 12c Proactive Bundle Patch

2018-10-09 Hugepage setting on Linux/AIX

2018-10-09 Correct way to monitor tablespace usages via SQLs

2016-06-30 OGG RMAN Initial Load sample

2016-04-21 Rolling Upgrade RAC from 11g to 12c

2016-04-01 Migrate non-ASM to ASM in 12c

2016-03-31 Part of 12c New Features

2016-03-25 Upgrade single database to 12c

2015-06-24 ASM utilities

2015-06-15 Multipath with udev in RHEL6

2015-06-14 Migrate ASM to different host

2015-06-11 Sysdate Different From Server and Client

2015-04-18 Opatch

2014-12-16 ORA-19511

2014-09-05 BBED Demo

2014-09-01 BBED Structure

2014-09-01 BBED基本命令

2014-09-01 Linux下编译BBED

2014-08-28 Oracle Errorstack

2014-08-26 心跳丢失引起RAC节点不断重启

2014-08-24 重做记录

2014-08-21 DB_FILE_MULTIBLOCK_READ_COUNT

2014-08-20 如何获得SQL的执行计划

2014-08-17 Oracle表连接类型

2014-08-13 12C之PDB管理

2014-08-09 12C静默安装CDB

2014-08-08 12C CDB简介

2014-07-24 Oracle追踪SQL的方法

2014-07-17 管理AWR快照

2014-06-20 RAC Datafile in Local Node

2014-06-16 DataGuard Broker

2014-06-12 DataGuard主备切换及故障切换

2014-06-06 RMAN完全恢复和不完全恢复

2014-06-05 Oracle日志文件损坏的恢复

2014-06-01 RMAN恢复基本概念

2014-05-31 RMAN基础知识

2014-05-30 RAC DataGuard配置

2014-05-23 Duplicate Database With RMAN

2014-05-21 Oracle修改数据库名称

2014-05-20 Oracle Data Pump

2014-04-29 Oracle Enterprise Management failed with locale failed

2014-04-06 Upgrade 10gr2 RAC to 11gr2 RAC

2014-04-01 10g rac管理命令

2014-03-30 oracle TAF

2014-03-30 Deinstall Oracle 11g RAC

2014-03-30 installing 10gr2 rac on linux

2014-03-25 11gr2 RAC SCAN DNS Configuration

2014-03-21 管理redo文件

2013-09-12 Step by step install 11gr2 RAC in silent mode

2013-09-09 11g新特性—FDI简介

2013-09-07 11gr2 RAC删除节点

2013-09-06 11gr2 RAC增加节点

2013-09-04 11gr2 RAC Resource管理

2013-09-04 11gr2 RAC Voting Disk及OCR管理

2013-09-02 ora-12514解决一例

2013-08-30 无备份恢复丢失的数据文件

2013-08-29 数据文件权限导致DataGuard无法同步

2013-08-27 Create database with command line

2013-08-23 Oracle 10g Silent Installation On Redhat Linux

2013-07-03 RMAN RAC异机恢复

2013-06-25 Clustering Factor聚簇因子

2013-06-25 Virtual Index虚拟索引的使用

2013-06-15 Oracle ROWID学习

2013-06-15 Detect And Correct Corruption in Oracle

2013-06-15 使用直方图(Histograms)

2013-06-15 Logminer简单用法