Oracle AWRËÙ²é
SQL> SQLPLUS / AS SYSDBA
SQL> exec dbms_workload_repository.create_snapshot
SQL> exec:snap_id:=dbms_workload_repository.create_snapshot
SQL> var snap_id number
SQL> print snap_id
SQL> @?/rdbms/admin/awrrpt.sql
OracleAWRËÙ²é
1.²é¿´µ±Ç°µÄAWR±£´æ²ßÂÔ
select * from dba_hist_wr_control;
DBID,SNAP_INTERVAL,RETENTION,TOPNSQL
860524039,+00 01:00:00.000000,+07 00:00:00.000000,DEFAULT
ÒÔÉϽá¹û±íʾ,ÿСʱ²úÉúÒ»¸öSNAPSHOT£¬±£Áô7Ìì
2.µ÷ÕûAWRÅäÖÃ
AWRÅäÖö¼ÊÇͨ¹ýdbms_workload_repository°ü½øÐÐÅäÖÃ
2.1µ÷ÕûAWR²úÉúsnapshotµÄƵÂʺͱ£Áô²ßÂÔ£¬È磺È罫ÊÕ¼¯¼ä¸ôʱ¼ä¸ÄΪ30 ·ÖÖÓÒ»´Î¡£²¢ÇÒ±£Áô5Ììʱ¼ä£¨×¢£ºµ¥Î»¶¼ÊÇΪ·ÖÖÓ£©£º
exec dbms_workload_repository.modify_snapshot_settings(interval=>30, retention=>5*24*60);
2.2¹Ø±ÕAWR,°ÑintervalÉèΪ0Ôò¹Ø±Õ×Ô¶¯²¶×½¿ìÕÕ
exec dbms_workload_repository.modify_snapshot_settings(interval=>0, retention=>5*24*60);
2.3ÊÖ¹¤´´½¨Ò»¸ö¿ìÕÕ
exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();
2.4 ²é¿´¿ìÕÕ
select * from sys.wrh$_active_session_history
2.5ÊÖ¹¤É¾³ýÖ¸¶¨·¶Î§µÄ¿ìÕÕ
exec WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE(low_snap_id => 22, high_snap_id => 32, dbid => 3310949047);
2.6´´½¨baseline
exec dbms_workload_repository.create_baseline (56,59,'apply_interest_1')
2.7ɾ³ýbaseline
exec DBMS_WORKLOAD_REPOSITORY.DROP_BASELINE(baseline_name => ' apply_interest_1', cascade => FALSE);
3.Éú²úAWR±¨¸æ
@$ORACLE_HOME/rdbms/admin/awrrpt.sql
°´Õսű¾Ìáʾ£¬ÒÀ´ÎÑ¡Ôñ±¨¸æÀàÐÍ£¬±¨¸æͳ¼ÆÌìÊý£¬ÒÔ¼°¿ªÊ¼Í³¼Æ£¬½áÊøͳ¼ÆµÄ¿ìÕÕ±àºÅ¡£
ÈçÏ£º
µ¼³öÎļþλÖÃÔÚsqlplusÖ´ÐÐʱËùÔÚĿ¼¡£
Ïà¹ØÎĵµ£º
Oracle×îÐÂÈÏÖ¤Ìâ¿â×ÊÁÏÏÂÔØ
Actualtests Oracle 1Z0-200 V11.07.08
Actualtests Oracle 1Z0-211 V11.10.08
Actualtests Oracle 1Z0-212 V11.07.08
Actualtests Oracle 1Z0-213 V11.07.08
Actualtests Oracle 1Z0-101 V11.07.08
Actualtests Oracle 1Z0-132 V11.07.08
Actualtests Oracle 1Z0-140 V11.21.08
Actual ......
Oracle JOB Ó÷¨Ð¡½á
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
¡¡¡¡
¡¡¡¡¶þ£¬dbms_job package Ó÷¨½éÉÜ
¡¡¡¡ ......
×î½üÔÚÂÛ̳ÉÏÒ»Ö±¿´µ½ÓÐÅóÓѶÔÊý¾Ý×ÖµäÀïµÄÄÚÈݸ㲻̫Çå³þ£¬±ÈÈç˵V$¡¢V_$¡¢GV$µÈµÈ£¬µ½µ×ÄĸöÊÇͬÒå´Ê£¬ÄĸöÊÇÊÓͼ£¬Äĸö»ùÓÚÄĸö´´½¨¡£½ñÌìÕýºÃ¿´µ½¸Ç¹úÇ¿µÄ¡¶ÉîÈëdz³öORACLE¡·µÚÈýÕ½²µ½Õâ·½ÃæÄÚÈÝ£¬×ܽáһϣ¬Ò²·½±ã´ó¼Òѧϰ¡£
Êý¾Ý×ÖµäÓÉËIJ¿·Ö×é³É£º
1¡¢ÄÚ²¿RDBMS(X$)±í
X$ÊÇOracleÊý¾Ý¿âµÄºËÐIJ¿·Ö£¬ÕâЩ ......
============================Question================================
SQL> select * from emp;
EMPID EMPNAME SALARY DEPTID
---------- ----------- ......
1 ¾Û¼¯(cluster)
1.1 ¸ÅÄ
ÓÃÓÚ½«²»Í¬±íÖеÄÊý¾Ý´æ´¢µ½ÏàͬµÄÎïÀíÊý¾Ý¿éÖУ¬ÓÃÓÚ¶à±íÊý¾ÝÐèҪƵ·±½øÐÐÁªºÏ²éѯµÄÇé¿öÏ¡£¶à±íÊý¾Ý´æ´¢ÔÚÏàͬÊý¾Ý¿éºó£¬ÔÚ¶Ô¶Ô±í½øÐÐÁªºÏ²éѯʱ£¬ËùÐè¶ÁÈ¡µÄÎïÀí¿éÊý¼õÉÙ£¬´Ó¶øÌá¸ß²éѯÐÔÄÜ¡£
ÐèҪעÒâµÄÊǶԾۼ¯Öе¥±íµÄ²éѯºÍ¶Ô¾Û¼¯ÖбíÊý¾Ý½øÐÐÐ޸Ļò²åÈëµÈÊÂÎñ²Ù×÷ʱ£¬ÐÔÄܽ«Ê ......