摘要：
-----sqlplus中执行（AWR时间段 ） @?/rdbms/admin/awrrpt.sql -----手工生成快照 exec dbms_workload_repository.create_snapshot();--语句三次执行，归入快照 --查询快照 select * from dba_hist_snapshot order by begin_interval_time ... 阅读全文
摘要：
-------------demo.ctl LOAD DATA INFILE * INTO TABLE DEPT APPEND FIELDS TERMINATED BY ',' ( DEPTNO, DNAME, LOC, LAST_UPDATA ) BEGINDATA 10,Sales,Virginia,2015-01-01 20,Accounting,Virginia,... 阅读全文