ITPub博客

Exadata 专辑一：在我揭开Exadata的神秘面纱之前，先讲一段进现在公司的小趣事. 第一次到CTM公司面试的时候，那位自我介绍叫做Terry的面试官（IT系统架构部门的总经理，后来我的老板）问我一些关于...

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

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

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

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

DBA Notes: 2011/10/25Cheng Li Oracle Backup & Restore by using EMC networker Backup Strategy for Oracle Database Backup Method: Online database backupType: PhysicalReq...

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

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

DBA Notes: 2011/10/12Cheng Li Buffer Cache Hit Ratio (BHR) From AWR reports as following, BHR is 99.17Instance Efficiency Percentages (Target 100%)~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~...

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

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

Use Oracle Databases 11g AMM         In this blog, I will presnt an user case about how to use AMM in Oracle 11g and how to monitor the memory stat...

DBA Notes: 2011/10/14Cheng Li Manage Oracle Databases Memory in Linux Oracle database level At Oracle database level, we use AMM to manage the memory automatically. For this ex...

DBA Notes: 2011/09/26Cheng Li Oracle database Statistics Before database migration or upgrade, we should collect and restore database statistics to compare performance before and afte...

DBA Notes: 2011/10/11Cheng Li Oracle 11g memory setting From ehealthy or OEM tools, one issue is raised. Oracle consumes almost 100% of OS memory. The system  is an Oracle 11g R1 ...

DBA Notes: 2011/10/10Cheng Li How to process  ORA-1653 From Alert log, we got following error message: ORA-1653: unable to extend table SYS.AUD$ by 7156 in tablespace SYSTEM...

DBA Notes: 2011/09/30Cheng Li Configuring the RMAN Environment  This part gives a simple example how to review and set RMAN backup environment. To view or change your CONFIGURE comman...

DBA Notes: 2011/09/29Cheng Li How to manager alert file Oracle的alert日志文件的特殊性在于，即便该文件被误删除也不会对系统产生任何影响。当有新的警告信息需要写入到alert日志时，如找不到对...

DBA Notes: 2011/09/28Cheng Li How to calculate HWM and reclaim space 1.      How to calculate HWM To manage space, Oracle Database tracks the state of b...

DBA Notes: 2011/09/23Cheng Li How to resize temporary tablespace We got an alert about temporary tablespace as following:  For the alert level, it is now 80%. If you need any ad...