发布时间：2014-01-06 10:16:29

一、查看当前AWR保留策略SQL> select * from dba_hist_wr_control;       DBID SNAP_INTERVAL       RETENTION           TOPNSQL---------- ------------------- ------------------- ----------1310729769 +00000 00:30:00.0   +00007 00:00:00.0.........【阅读全文】

发布时间：2014-01-05 21:49:41

调整AWR保留时间时，报错： SQL> exec dbms_workload_repository.modify_snapshot_settings(interval=>30,retention => 7*24*60); begin dbms_workload_repository.modify_snapshot_settings(interval=>30,retention => 7*24*60); end; ORA-13541: system moving window baseline size (691200) great.........【阅读全文】

发布时间：2014-01-05 18:33:46

一、建表（如果不在管理员用户下面实验，则grant advisor to username）SQL> create table bigtab as select rownum as id,a.* from sys.all_objects a ;Table created.SQL> create table smalltab as  select rownum as id,a.* from sys.all_objects a ;Table created.二插入数据，多执行几次SQL> ins.........【阅读全文】

发布时间：2014-01-05 14:34:16

一、建表SQL> create table bigtab tablespace jerry as select rownum as id,a.* from dba_objects a; Table createdSQL> create table smalltab tablespace jerry as select rownum as id,a.* from dba_objects a; Table created二、插入数据SQL> declare  2  num number;  3 &n.........【阅读全文】

发布时间：2014-01-03 11:50:52

一、查看共享池Latch争用select * From v$latchname where name like 'library cache%';二、资源争用：select event,count(*) from v$session_wait group by event;三、查看造成latch buffer cache chains等待事件的热块SQL> select distinct a.owner,a.segment_name from dba_extents a  2  join (select .........【阅读全文】