ITPub博客

 Oracle 10g Review   1.0       GENERAL INFORMATION 1.1    PurposeOracle Database 10g is the first database designed f...

Oracle Solaris Server VMSTAT Memory management in UNIXMost operating systems today possess what is commonly called virtual memory.  In a virtual memory configuration it is possible to extend th...

Oracle Automatic DBSTATThe recommended approach to gathering statistics is to allow Oracle to automatically gather the statistics. Oracle gathers statistics on all database objects automatically and ...

Global Temporary TablesCollect statistics Applications often use some form. of temporary data store for processes that are to complicated to complete in a single pass. Often, these temporary stores ...

Oracle Sleep Timedrop user usera cascade;drop user userb cascade;create user usera default tablespace users identified by abc123;grant create session to usera;grant resource to u...

DB FILE PARALLEL WRITEThe db file parallel write wait event in last 24 hours. $ sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 1 13:00:42 2012Copyright (c) 1982, 2005, Ora...

TRSPRD performance analysis$ uname -aSunOS ctmtrs 5.10 Generic_144488-09 sun4u sparc SUNW,Sun-Fire-V445$ prtconf | grep MemoryMemory size: 8192 Megabytes$ cd /usr/sbin$ psrinfo -vStatus of vir...

DBA Notes: 2012/01/20Cheng Li(Database: Oracle 9i, OS: AIX) How to check database recovery status ORA-1195 Following is the meaning of the error messageError: ORA 1195 Text: onlin...

DBA Notes: 2011/12/27Cheng Li(Database: Oracle 9i, OS: AIX) Database Media Recovery Failure  Problem Description: We are using EMC BCV technique to perform. our recovery the same data ...

DBA Notes: 2012/01/19 Cheng Li(Database: Oracle 10g, OS: Solaris) How to housekeeping SYSAUX tablespace Following Steps to perform. SYSAUX tablespaceSELECT * FROM dba_jobs WHERE owner...

DBA Notes: 2012/01/18Cheng Li(Database: Oracle 9i, OS: AIX) ORA-1146 tablespace is already in backup mode We meet alert error message ORA-1146 on a 9i database for a hot back-up.What w...

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...

DBA Notes: 2011/11/15Cheng Li Oracle Performance Tuning Case Analysis Instance Efficiency Percentages (Target 100%)Buffer Nowait %:100.00Redo NoWait %:-50.01Buffer Hit %:...

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...

DBA Notes: 2011/11/02Cheng LiManage CBOstatistics系统需要升级到11g R2， 想把现在的CBO统计信息保存起来，然后，万一升级后的性能下降了，可以从新导入。结合11g，SPM的特性，就起码可以保证升...

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 ...

DBA Notes: 2011/11/01Cheng Li Oracle 11g SPMUsage Guide Capturing PlansAutomaticallyAutomatic plan capture canbe switched on by setting the init.ora parameteroptimizer_captur...

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...

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...

DBA Notes: 2011/10/29Cheng Li How to ensureperformance after upgrade to Oracle 11g R2 Steps to ensure database performance: 1  Perform. Pre-UpgradeC...