-
编辑 删除
ORA-04031 share pool can’t allocate memory
DBA Notes: 2011/12/19Cheng Li(Database: Oracle 9i, OS: AIX) ORA-04031 share pool can’t allocate memoryIssue Case: share pool can’t allocate memory === ODM Proposed Solution ===To try to s...
-
编辑 删除
Oracle Performance Tuning Case Analysis
DBA Notes: 2011/11/15Cheng Li Oracle Performance Tuning Case Analysis Instance Efficiency Percentages (Target 100%)Buffer Nowait %:100.00Redo NoWait %:-50.01Buffer Hit %:...
-
编辑 删除
Solution The Error ORA-02068，ORA-03113
DBA Notes: 2011/11/14Cheng Li Solution The Error ORA-02068，ORA-031132010-01-05 09:45 Symptoms: alert日志经常报如下错误： Error 2068 trapped in 2PC on transaction 74.40.87328...
-
编辑 删除
Manage CBO statistics
DBA Notes: 2011/11/02Cheng LiManage CBOstatistics系统需要升级到11g R2， 想把现在的CBO统计信息保存起来，然后，万一升级后的性能下降了，可以从新导入。结合11g，SPM的特性，就起码可以保证升...
-
编辑 删除
Upgrade to 11g and ensure Optimizer Plan Stability using SQL Plan Baselines
DBA Notes: 2011/11/02Cheng Li Upgrade to 11gand ensure Optimizer Plan Stability using SQL Plan BaselinesLet us firstcreate a SQL Tuning Set in Oracle 10g and we will then load that SQL ...
-
编辑 删除
Oracle 11g SPM Usage Guide
DBA Notes: 2011/11/01Cheng Li Oracle 11g SPMUsage Guide Capturing PlansAutomaticallyAutomatic plan capture canbe switched on by setting the init.ora parameteroptimizer_captur...
-
编辑 删除
ORA-12542: TNS: address already in use
DBA Notes: 2011/10/31Cheng Li ORA-12542:TNS: address already in useThis part givesa simple example how to resolve issue ORA-12542 found from alerts file. ORA-12542: TNS:addressal...
-
编辑 删除
Configuring the RMAN Environment
DBA Notes: 2011/09/30Cheng Li Configuringthe RMAN Environment This part gives a simpleexample how to review and set RMAN backup environment. To view orchange your CONFIGURE c...
-
编辑 删除
How to ensure performance after upgrade to Oracle 11g R2
DBA Notes: 2011/10/29Cheng Li How to ensureperformance after upgrade to Oracle 11g R2 Steps to ensure database performance: 1 Perform. Pre-UpgradeC...
-
编辑 删除
Exadata 专辑一
Exadata 专辑一：在我揭开Exadata的神秘面纱之前，先讲一段进现在公司的小趣事. 第一次到CTM公司面试的时候，那位自我介绍叫做Terry的面试官（IT系统架构部门的总经理，后来我的老板）问我一些关于...
-
编辑 删除
Oracle RMAN in Noarchivelog mode
DBA Notes: 2011/10/27Cheng Li Oracle RMAN in Noarchivelog mode In order to increase backup time, we apply Oracle Rman backup in noarchivelog mode. RMAN> SHUTDOWN IMMEDIATE;RMAN> STARTU...
-
编辑 删除
Oracle Datafile Space Management in IBM AIX
DBA Notes: 2011/10/09Cheng Li Oracle Datafile Space Management in IBM AIX An example shows how to allocate space for Oracle datafile in IBM AIX.Scenario: we will add 4 GB to 8 Gb to o...
-
编辑 删除
Oracle Undo Management
DBA Notes: 2011/10/26Cheng Li Oracle Undo tablesapce management If you have a large database, then during the purge operation or large batch transactions that involve a lot of undo wor...
-
编辑 删除
How to setup X windows
DBA Notes: 2011/10/22Cheng Li How to set up X windowsXming X ServerXming is the leading X Window Server for Microsoft XP/2008/Windows7. It is a fully featured X Server and is lean, fas...
-
编辑 删除
Oracle RMAN Backup and Restore with EMC networker
DBA Notes: 2011/10/25Cheng Li Oracle Backup & Restore by using EMC networker Backup Strategy for Oracle Database Backup Method: Online database backupType: PhysicalReq...
-
编辑 删除
Truncate Stats pack data
DBA Notes: 2011/10/20Cheng Li Truncate Stats pack data For DBA routine operation, we meet a warning as following: Issue: Subject: EVENT Oracle DB Kenan Prod storage events WA...
-
编辑 删除
Buffer Cache Chain (Hot Block)
DBA Notes: 2011/10/11Cheng Li Buffer Cache Chain (Hot Block) From AWR reports, we found a huge number of cache buffers chain as following: &n...
-
编辑 删除
Buffer Cache Hit Ratio (BHR)
DBA Notes: 2011/10/12Cheng Li Buffer Cache Hit Ratio (BHR) From AWR reports as following, BHR is 99.17Instance Efficiency Percentages (Target 100%)~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~...
-
编辑 删除
AWR Reports: SQL Order By
DBA Notes: 2011/10/13Cheng Li AWR Reports: SQL Order By [oracle@ctmcmsdb dbalog]$ sqlplus SQL*Plus: Release 11.1.0.6.0 - Production on Tue Oct 11 09:18:35 2011 Copyright ...
-
编辑 删除
Enable Oracle Databases Asynchronous I/O
DBA Notes: 2011/10/14Cheng Li Enable Oracle Databases Asynchronous I/O From AWR reports, we found the event “control file parallel write” itself cost 10,480 second, while the system ...
