第3章 Oracle性能问题汇总-3.10 sql tuning advisor优化建议

背景：

有时在分析复杂SQL性能问题时比较耗时，当没有头绪时，可以通过sql tuning advisor看一下oracle的建议，
但是最终是否接受建议，需要DBA根据综合情况自己判断，也是一种调优有效的方式。

一：创建测试数据

SQL> create user cjc identified by cjc;                   
User created.
SQL> grant connect,resource,dba to cjc;
Grant succeeded.
SQL> conn cjc/cjc
Connected.
SQL> create table t1 as select * from dba_tables;
Table created.
SQL> create table t2 as select * from dba_users;
Table created.
SQL> create table t3 as select * from dba_objects;
Table created.
SQL> create table t5 as select * from dba_data_files;
Table created.
SQL> create view v1 as select t1.table_name,t1.owner,t1.TABLESPACE_NAME,t1.NUM_ROWS,t3.CREATED,t3.LAST_DDL_TIME from t1,t3 where t1.table_name=t3.object_name and t1