发布时间：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 .........【阅读全文】

发布时间：2014-01-02 15:38:40

一、建按月自增分区表：1.1建表SQL> create table month_interval_partition_table (id number,time_col date) partition by range(time_col)  2  interval (numtoyminterval(1,'month'))  3  (  4  partition p_month_1 values less than (to_date('2014-01-01','yyyy-mm-dd')) .........【阅读全文】