<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[congyi0986的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congyi0986</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congyi0986]]></copyright><item><title><![CDATA[Oracle 10g Review]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314921</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314921</guid><author>congyi0986</author><pubDate>Thu, 23 Feb 2012 14:36:38 +0800</pubDate><description><![CDATA[Oracle 10gReview



1.0 GENERAL INFORMATION

1.1 Purpose
Oracle Database 10g is the first ...]]></description><category></category></item><item><title><![CDATA[Oracle Solaris Server VMSTAT]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314922</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314922</guid><author>congyi0986</author><pubDate>Thu, 23 Feb 2012 11:59:14 +0800</pubDate><description><![CDATA[Oracle Solaris Server VMSTAT 
Memory management in UNIX
Most operating systems today possess what is commonly ca...]]></description><category></category></item><item><title><![CDATA[Oracle Automatic DBSTAT]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314913</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314913</guid><author>congyi0986</author><pubDate>Thu, 23 Feb 2012 11:37:52 +0800</pubDate><description><![CDATA[Oracle Automatic DBSTAT
The recommended approach to gathering statistics is to allow Oracle to automatically gath...]]></description><category></category></item><item><title><![CDATA[Global Temporary Tables]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314917</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314917</guid><author>congyi0986</author><pubDate>Thu, 09 Feb 2012 18:03:50 +0800</pubDate><description><![CDATA[Global Temporary Tables
Collect statistics 
Applications often use some form. of temporary data store for proces...]]></description><category></category></item><item><title><![CDATA[Oracle Sleep Time]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314916</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314916</guid><author>congyi0986</author><pubDate>Thu, 09 Feb 2012 18:01:35 +0800</pubDate><description><![CDATA[Oracle Sleep Timedrop  user  usera  cascade;
drop  user  userb  cascade;
create  user  usera  default  tablespac...]]></description><category></category></item><item><title><![CDATA[db file parallel write wait event]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314915</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314915</guid><author>congyi0986</author><pubDate>Thu, 09 Feb 2012 17:51:48 +0800</pubDate><description><![CDATA[DB FILE PARALLEL WRITE
The db file parallel write wait event in last 24 hours.
$ sqlplus /nolog
SQL*Plus: Rele...]]></description><category></category></item><item><title><![CDATA[Oracle Performance Tuing: BITMAP CONVERSION TO ROWID]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314910</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314910</guid><author>congyi0986</author><pubDate>Thu, 09 Feb 2012 17:43:21 +0800</pubDate><description><![CDATA[TRSPRD performance analysis

$ uname -a
SunOS ctmtrs 5.10 Generic_144488-09 sun4u sparc SUNW,Sun-Fire-V445
$ p...]]></description><category></category></item><item><title><![CDATA[How to check database recovery status ORA-1195]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314914</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314914</guid><author>congyi0986</author><pubDate>Fri, 20 Jan 2012 12:36:50 +0800</pubDate><description><![CDATA[DBA Notes: 2012/01/20
Cheng Li
(Database: Oracle 9i, OS: AIX)

How to check database recovery status ORA-1195...]]></description><category></category></item><item><title><![CDATA[Database Media Recovery Failure]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314907</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314907</guid><author>congyi0986</author><pubDate>Fri, 20 Jan 2012 12:24:40 +0800</pubDate><description><![CDATA[DBA Notes: 2011/12/27
Cheng Li
(Database: Oracle 9i, OS: AIX)

Database Media Recovery Failure 

Problem D...]]></description><category></category></item><item><title><![CDATA[How to housekeeping SYSAUX tablespace]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314911</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314911</guid><author>congyi0986</author><pubDate>Thu, 19 Jan 2012 12:35:12 +0800</pubDate><description><![CDATA[DBA Notes: 2012/01/19 
Cheng Li
(Database: Oracle 10g, OS: Solaris)

How to housekeeping SYSAUX tablespace
...]]></description><category></category></item><item><title><![CDATA[ORA-1146 tablespace is already in backup mode]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314912</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314912</guid><author>congyi0986</author><pubDate>Wed, 18 Jan 2012 12:38:12 +0800</pubDate><description><![CDATA[DBA Notes: 2012/01/18
Cheng Li
(Database: Oracle 9i, OS: AIX)

ORA-1146 tablespace is already in backup mode...]]></description><category></category></item><item><title><![CDATA[ORA-04031 share pool can’t allocate memory]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314908</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314908</guid><author>congyi0986</author><pubDate>Mon, 19 Dec 2011 12:20:07 +0800</pubDate><description><![CDATA[DBA Notes: 2011/12/19
Cheng Li
(Database: Oracle 9i, OS: AIX)

ORA-04031 share pool can’t allocate memory
Is...]]></description><category></category></item><item><title><![CDATA[Oracle Performance Tuning Case Analysis]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314904</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314904</guid><author>congyi0986</author><pubDate>Tue, 15 Nov 2011 16:33:52 +0800</pubDate><description><![CDATA[DBA Notes: 2011/11/15
Cheng Li

Oracle Performance Tuning Case Analysis

Instance Efficiency Percentages ...]]></description><category></category></item><item><title><![CDATA[Solution The Error ORA-02068，ORA-03113]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314905</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314905</guid><author>congyi0986</author><pubDate>Mon, 14 Nov 2011 16:38:13 +0800</pubDate><description><![CDATA[DBA Notes: 2011/11/14

Cheng Li



Solution The Error ORA-02068，ORA-03113

2010-01-05 09:45


 
  
 ...]]></description><category></category></item><item><title><![CDATA[Manage CBO statistics]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314903</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314903</guid><author>congyi0986</author><pubDate>Wed, 02 Nov 2011 15:56:21 +0800</pubDate><description><![CDATA[DBA Notes: 2011/11/02

Cheng Li

Manage CBO
statistics

系统需要升级到11gR2，想把现在的CBO统计信息保存起来，然后，万一升级后的性能下降了，可以从新...]]></description><category></category></item><item><title><![CDATA[Upgrade to 11g and ensure Optimizer Plan Stability using SQL Plan Baselines]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314909</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314909</guid><author>congyi0986</author><pubDate>Wed, 02 Nov 2011 10:04:37 +0800</pubDate><description><![CDATA[DBA Notes: 2011/11/02

Cheng Li



Upgrade to 11g
and ensure Optimizer Plan Stability using SQL Plan Basel...]]></description><category></category></item><item><title><![CDATA[Oracle 11g SPM Usage Guide]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314901</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314901</guid><author>congyi0986</author><pubDate>Tue, 01 Nov 2011 12:29:33 +0800</pubDate><description><![CDATA[DBA Notes: 2011/11/01

Cheng Li



Oracle 11g SPM
Usage Guide



Capturing Plans
Automatically

Au...]]></description><category></category></item><item><title><![CDATA[ORA-12542: TNS: address already in use]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314906</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314906</guid><author>congyi0986</author><pubDate>Mon, 31 Oct 2011 09:34:59 +0800</pubDate><description><![CDATA[DBA Notes: 2011/10/31

Cheng Li

ORA-12542:
TNS: address already in use

This part gives
a simple example...]]></description><category></category></item><item><title><![CDATA[Configuring the RMAN Environment]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314899</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314899</guid><author>congyi0986</author><pubDate>Sun, 30 Oct 2011 09:38:30 +0800</pubDate><description><![CDATA[DBA Notes: 2011/09/30

Cheng Li



Configuring
the RMAN Environment 



This part gives a simple
exa...]]></description><category></category></item><item><title><![CDATA[How to ensure performance after upgrade to Oracle 11g R2]]></title><link>https://blog.youkuaiyun.com/congyi0986/article/details/100314896</link><guid>https://blog.youkuaiyun.com/congyi0986/article/details/100314896</guid><author>congyi0986</author><pubDate>Sat, 29 Oct 2011 09:07:44 +0800</pubDate><description><![CDATA[DBA Notes: 2011/10/29

Cheng Li



How to ensure
performance after upgrade to Oracle 1...]]></description><category></category></item></channel></rss>