- 博客(52)
- 收藏
- 关注
RSS订阅转载 Oracle 10g Review
Oracle 10gReview1.0 GENERAL INFORMATION1.1 PurposeOracle Database 10g is the first ...
2012-02-23 14:36:38
479
转载 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
132
转载 Oracle Automatic DBSTAT
Oracle Automatic DBSTATThe recommended approach to gathering statistics is to allow Oracle to automatically gath...
2012-02-23 11:37:52
156
转载 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
110
转载 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
120
转载 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
164
转载 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
137
转载 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
145
转载 Oracle Performance Tuning Case Analysis
DBA Notes: 2011/11/15Cheng LiOracle Performance Tuning Case AnalysisInstance Efficiency Percentages ...
2011-11-15 16:33:52
98
转载 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
349
转载 Configuring the RMAN Environment
DBA Notes: 2011/09/30Cheng LiConfiguringthe RMAN Environment This part gives a simpleexa...
2011-10-30 09:38:30
93
转载 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
112
转载 Exadata 专辑一
Exadata 专辑一：在我揭开Exadata的神秘面纱之前，先讲一段进现在公司的小趣事. 第一次到CTM公司面试的时候，那位自我介绍叫做Terry的面试官（IT系统架构部门的总经理，...
2011-10-28 12:12:32
93
转载 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
115
转载 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
159
转载 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
153
转载 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
306
转载 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
140
转载 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
157
转载 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
463
转载 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
137
转载 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
201
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人