- 博客(52)
- 收藏
- 关注
转载 Oracle 10g Review
Oracle 10gReview1.0 GENERAL INFORMATION1.1 PurposeOracle Database 10g is the first ...
2012-02-23 14:36:38 483
转载 Oracle Solaris Server VMSTAT
Oracle Solaris Server VMSTAT Memory management in UNIXMost operating systems today possess what is commonly ca...
2012-02-23 11:59:14 133
转载 Oracle Automatic DBSTAT
Oracle Automatic DBSTATThe recommended approach to gathering statistics is to allow Oracle to automatically gath...
2012-02-23 11:37:52 157
转载 Global Temporary Tables
Global Temporary TablesCollect statistics Applications often use some form. of temporary data store for proces...
2012-02-09 18:03:50 112
转载 Oracle Sleep Time
Oracle Sleep Timedrop user usera cascade;drop user userb cascade;create user usera default tablespac...
2012-02-09 18:01:35 134
转载 db file parallel write wait event
DB FILE PARALLEL WRITEThe db file parallel write wait event in last 24 hours.$ sqlplus /nologSQL*Plus: Rele...
2012-02-09 17:51:48 69
转载 Oracle Performance Tuing: BITMAP CONVERSION TO ROWID
TRSPRD performance analysis$ uname -aSunOS ctmtrs 5.10 Generic_144488-09 sun4u sparc SUNW,Sun-Fire-V445$ p...
2012-02-09 17:43:21 115
转载 How to check database recovery status ORA-1195
DBA Notes: 2012/01/20Cheng Li(Database: Oracle 9i, OS: AIX)How to check database recovery status ORA-1195...
2012-01-20 12:36:50 121
转载 Database Media Recovery Failure
DBA Notes: 2011/12/27Cheng Li(Database: Oracle 9i, OS: AIX)Database Media Recovery Failure Problem D...
2012-01-20 12:24:40 165
转载 How to housekeeping SYSAUX tablespace
DBA Notes: 2012/01/19 Cheng Li(Database: Oracle 10g, OS: Solaris)How to housekeeping SYSAUX tablespace...
2012-01-19 12:35:12 139
转载 ORA-1146 tablespace is already in backup mode
DBA Notes: 2012/01/18Cheng Li(Database: Oracle 9i, OS: AIX)ORA-1146 tablespace is already in backup mode...
2012-01-18 12:38:12 262
转载 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 memoryIs...
2011-12-19 12:20:07 147
转载 Oracle Performance Tuning Case Analysis
DBA Notes: 2011/11/15Cheng LiOracle Performance Tuning Case AnalysisInstance Efficiency Percentages ...
2011-11-15 16:33:52 102
转载 Solution The Error ORA-02068,ORA-03113
DBA Notes: 2011/11/14Cheng LiSolution The Error ORA-02068,ORA-031132010-01-05 09:45 ...
2011-11-14 16:38:13 126
转载 Manage CBO statistics
DBA Notes: 2011/11/02Cheng LiManage CBOstatistics系统需要升级到11gR2,想把现在的CBO统计信息保存起来,然后,万一升级后的性能下降了,可以从新...
2011-11-02 15:56:21 81
转载 Upgrade to 11g and ensure Optimizer Plan Stability using SQL Plan Baselines
DBA Notes: 2011/11/02Cheng LiUpgrade to 11gand ensure Optimizer Plan Stability using SQL Plan Basel...
2011-11-02 10:04:37 104
转载 Oracle 11g SPM Usage Guide
DBA Notes: 2011/11/01Cheng LiOracle 11g SPMUsage GuideCapturing PlansAutomaticallyAu...
2011-11-01 12:29:33 103
转载 ORA-12542: TNS: address already in use
DBA Notes: 2011/10/31Cheng LiORA-12542:TNS: address already in useThis part givesa simple example...
2011-10-31 09:34:59 353
转载 Configuring the RMAN Environment
DBA Notes: 2011/09/30Cheng LiConfiguringthe RMAN Environment This part gives a simpleexa...
2011-10-30 09:38:30 94
转载 How to ensure performance after upgrade to Oracle 11g R2
DBA Notes: 2011/10/29Cheng LiHow to ensureperformance after upgrade to Oracle 1...
2011-10-29 09:07:44 113
转载 Exadata 专辑一
Exadata 专辑一:在我揭开Exadata的神秘面纱之前,先讲一段进现在公司的小趣事. 第一次到CTM公司面试的时候,那位自我介绍叫做Terry的面试官(IT系统架构部门的总经理,...
2011-10-28 12:12:32 95
转载 Oracle RMAN in Noarchivelog mode
DBA Notes: 2011/10/27Cheng LiOracle RMAN in Noarchivelog modeIn order to increase backup time, we ap...
2011-10-27 11:05:53 118
转载 Oracle Datafile Space Management in IBM AIX
DBA Notes: 2011/10/09Cheng LiOracle Datafile Space Management in IBM AIXAn example shows how to allo...
2011-10-26 16:37:26 86
转载 Oracle Undo Management
DBA Notes: 2011/10/26Cheng LiOracle Undo tablesapce managementIf you have a large database, then dur...
2011-10-26 11:19:22 54
转载 How to setup X windows
DBA Notes: 2011/10/22Cheng LiHow to set up X windowsXming X ServerXming is the leading X Wi...
2011-10-25 16:06:15 69
转载 Oracle RMAN Backup and Restore with EMC networker
DBA Notes: 2011/10/25Cheng LiOracle Backup & Restore by using EMC networkerBackup Stra...
2011-10-25 15:36:50 160
转载 Truncate Stats pack data
DBA Notes: 2011/10/20Cheng LiTruncate Stats pack data For DBA routine operation, we meet a warning a...
2011-10-24 16:34:49 74
转载 Buffer Cache Chain (Hot Block)
DBA Notes: 2011/10/11Cheng LiBuffer Cache Chain (Hot Block)From AWR reports, we found a huge number ...
2011-10-14 17:37:21 94
转载 Buffer Cache Hit Ratio (BHR)
DBA Notes: 2011/10/12Cheng LiBuffer Cache Hit Ratio (BHR)From AWR reports as following, BHR is 99.17...
2011-10-14 16:48:20 155
转载 AWR Reports: SQL Order By
DBA Notes: 2011/10/13Cheng LiAWR Reports: SQL Order By[oracle@ctmcmsdb dbalog]$ sqlplusSQL*Plus...
2011-10-14 15:37:38 120
转载 Enable Oracle Databases Asynchronous I/O
DBA Notes: 2011/10/14Cheng LiEnable Oracle Databases Asynchronous I/OFrom AWR reports, we found the ...
2011-10-14 15:10:24 113
转载 Use Oracle Databases 11g AMM
UseOracle Databases 11g AMM In this blog, I will presntan user case about how to use AMM in Oracle...
2011-10-14 14:57:50 308
转载 Manage Oracle Databases Memory in Linux
DBA Notes: 2011/10/14Cheng LiManage Oracle Databases Memory in LinuxOracle database levelAt O...
2011-10-14 14:54:30 3650
转载 Oracle database Statistics
DBA Notes: 2011/09/26Cheng LiOracle database StatisticsBefore database migration or upgrade, we sh...
2011-10-14 14:26:55 141
转载 Oracle 11g memory setting
DBA Notes: 2011/10/11Cheng LiOracle 11g memory settingFrom ehealthy or OEM tools, one issue is raise...
2011-10-12 10:09:19 158
转载 ORA-1653: unable to extend table SYS.AUD$
DBA Notes: 2011/10/10Cheng LiHow to process ORA-1653From Alert log, we got following error mes...
2011-10-10 15:24:15 465
转载 Configuring the RMAN Environment
DBA Notes: 2011/09/30Cheng LiConfiguring the RMAN Environment This part gives a simple example how t...
2011-09-30 18:09:14 54
转载 How to manager alert file
DBA Notes: 2011/09/29Cheng LiHow to manager alert fileOracle的alert日志文件的特殊性在于,即便该文件被误删除也不会对系统产生任何影响。当...
2011-09-28 15:38:49 56
转载 How to calculate HWM and reclaim space
DBA Notes: 2011/09/28Cheng LiHow to calculate HWM and reclaim space1. How to calculate HWM...
2011-09-28 15:25:02 139
转载 How to reclaim space from temporary tablespace
DBA Notes: 2011/09/23Cheng LiHow to resize temporary tablespaceWe got an alert about temporary table...
2011-09-27 17:24:46 203
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人