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.
相关文档：
oracle表空间操作详解
1
2
3作者： 来源： 更新日期：2006-01-04
5
6
7建立表空间
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
update customers a
set city_name=(select b.city_name from tmp_cust_city b where b.customer_id=a.customer_id)
where exists (select 1
from ......
[精华] ORACLE的几种启动方式
http://www.chinaunix.net 作者:wuwenlong 发表于：2003-07-27 16:58:57
【发表评论】 【查看原文】 【Oracle讨论区】【关闭】
1、startup nomount
非安装启动，这种方式启动下可执行：重建控制文件、重建数据库
读取 ......
oracle常用经典SQL查询
常用SQL查询：
1、查看表空间的名称及大小
select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
from dba_tablespaces t, dba_data_files d
where t.tablespace_name = d.tablespace_name
group by t.tablespace_name;
2、查看表空间物理文件的名称 ......
Oracle 中的树查询和 connect by
使用 connect by 和 start with 来建立类似于树的报表并不难，只要遵循以下基本原则即可：
使用 connect by 时各子句的顺序应为：
select
from
where
start with
connect by
order by
prior 使报表的顺序为从根到叶（如果 prior 列是父辈）或从叶到根（如果 prior 列是后代）。
......
