ITPub博客

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

DBA Notes: 2011/09/21Cheng Li Upgrade Oracle database  As part of eHealthy application server upgrading, we support to upgrade repository database from Oracle 10.2.0.1 to Oracle 10.2.0....

DBA Notes: 2011/09/20Cheng Li MYSQL Repair Table MySQL tables can become corrupt for several reasons, such as hardware failure, operating system bugs, viruses and bugs in MySQL. It is ...

DBA Notes: 2011/09/19Cheng Li ORA-16019 The usage of flash recovery area During our Oracle system upgrade to Oracle 10.2.0.1, we apply the flash recovery area feature. &nbs...

DBA Notes: 2011/09/16Cheng Li How to use MYSQL Enterprise backup (MEB) MySQL enterprise backup, MEB, is a superset of the InnoDB Hot Backup product. The ibbackup command is available o...

DBA Notes: 2011/09/15 Cheng Li How to resolve Oracle Deadlock From alert log, we are reported for ORA-000060: Deadlock detected. By diggering into trace file we can see following infor...

DBA Notes: 2011/09/14 Cheng Li Oracle notes: sharing a article about oracle events Reference of Oracle event dump 1 Oracle background traces files     &...

How to build database connection among heterogeneous database 1 Build database connection from SQL SERVER by linked server For the request to be access data from MYSQL from SQL server 2...

How to use Oracle utility EXPORT/IMPORTIn this case, we will use Oracle export/import to refresh database schema from production to DEV. Oracle data pump can enable parallel processing for high...

In this case, we use networker to online backup a tablespace. For transportable tablespace, we can directly backup and copy among platform. and databases. For other tablespace, we should change the m...

Just for a technical hint, we can use temporary tablespace group in place of singe temporary tablespacce to be dynamic management of temporary space.  Using a tablespace group f...

DBA Notes: 2011/09/09 Cheng Li(Database: Oracle 10g, OS: AIX 5L) How to handle ORA-01654 From daily alerts, we are reported an ORA-01645 oracle error, as following:  18:43:32 j...