Oracle Database Tuning ADDM
ADDM (Automatic Database Diagnostic Monitor) implements the Oracle performance method and analyzes statistics to provide automatic diagnosis of major performance problems. Because ADDM can significantly shorten the time required to improve the performance of a system, it is one of the most used performance tuning tools of Oracle database.
1. Run some operations on your database instance.
First, start your database instance and do the database operations (select, update, delete...) which will be optimized. e.g. run a script to make some queries in database:
sh run.sh -r rdf1mm-performance -t p -f p3.txt
2. Login to EM
Login to Database EM home page (https://:5500/em), click Performance tab.
3. Run ADDM
Click Button "Run ADDM Now", and click "Yes" on the confirmation page. After a while, we will see the ADDM analysis page.
Database Activity chart shows the database activity during the ADDM analysis period.
In the ADDM Performance Analysis table, ADDM findings are listed in descending order, from highest to least impact. The Informational Findings section lists areas that have no performance impact and are for information only.
4. Implement ADDM recommendations
Click the ADDM findings that has the impact on performance. e.g. Top SQL Statements.
The Category column displays the category of recommendation. The Benefit column displays the estimated benefit of implementing the recommendation.
If we click "Run Advisor Now", SQL tuning advisor will give us some recommendations on how to tune the SQLs.
相关文档：
自己刚开始用PL/SQL来写一点东西，现在还肤浅的很，说这些不是想谦虚，而是想如果有高手看到自己有什么地方写错的，希望给我一点指点。
今天下午找了一下午自己的那个PL/SQL包的错误，最后还是解决了。。。两个小的不能再小的问题，和大家分享一下。
1、在PL/SQL中如果是函数，就可以SQL语句中使用，也可以在其他的PL/SQL ......
前些日子，数据库空间爆满，已经增长到存储空间单个存储文件的最大值32G。但是，采用了很多办法才释放掉表空间，主要是系统中大量使用分区表，而针对分区表清除数据，不会释放表空间，必须把分区drop掉，才会释放空间。记录一下当时操作时学习和使用的一些语句：
一、dr ......
oracle从9i开始支持一种新的数据类型---- xmltype，用于存储和管理xml数据，并提供了很多的functions，用来直接读取xml文档和管理节点。下面将介绍xmltype的一些基本使用。
1.建立含有xmltype数据类型的表
create table abc (id number,xmldoc sys.xmltype);
声明xmltype型字段用:sys.xmltype
2.向带有xmltype类型的表 ......
Oracle 中的树查询和 connect by
使用 connect by 和 start with 来建立类似于树的报表并不难，只要遵循以下基本原则即可：
使用 connect by 时各子句的顺序应为：
select
from
where
start with
connect by
order by
prior 使报表的顺序为从根到叶（如果 prior 列是父辈）或从叶到根（如果 prior 列是后代）。
......
