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Ö´ÐÐʱËùÔÚĿ¼¡£
Ïà¹ØÎĵµ£º
£¨1£© Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ, ÄÇ ......
Êý¾Ý¿âϵͳºÍ²Ù×÷ϵͳһÑù£¬ÔÚ¼ÆËã»úÉÏ°²×°³É¹¦ºó£¬»¹ÐèÒª½øÒ»²½ÅäÖúÍÓÅ»¯£¬´Ó¶øʹÆä¾ßÓиüÇ¿´óµÄ¹¦ÄܺÍÔËÐÐÔÚ×î¼Ñ״̬¡£Èç¹ûÔÚÉè¼Æ½×¶ÎÒòΪ¸÷ÖÖÒòËØûÓнøÐнÏΪºÏÀíµÄÅäÖúͼƻ®£¬ÄÇô¾ÍÐèÒªÔÚºóÆÚ¶ÔÊý¾Ý¿âϵͳ½øÐÐÓÅ»¯¡£
Êý¾Ý¿âϵͳÐÔÄܵÄÓÅ»¯£¬³ýÁËÔÚÉè¼Æ½×¶Î¶ÔÆäÂß¼´æ´¢½á¹¹ºÍÎïÀí´æ´¢½á¹¹Éè¼Æ½øÐÐÓÅ»¯£¬Ê¹Ö®ÔÚÂú×ã ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/expÃüÁî
Oracle Êý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°Ñ dmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл ......
¾Û¼¯(cluster)ÊÇ´æ´¢±íÊý¾ÝµÄ¿ÉÑ¡ÔñµÄ·½·¨¡£Ò»¸ö¾Û¼¯ÊÇÒ»×é±í£¬½«¾ßÓÐͬһ¹«¹²ÁÐÖµµÄÐд洢ÔÚÒ»Æ𣬲¢ÇÒËüÃǾ³£Ò»ÆðʹÓá£ÕâЩ¹«¹²Áй¹³É¾Û¼¯Âë¡£
¾³£±»Í¬Ê±·ÃÎʵıíÔÚÎïÀíλÖÃÉÏ¿ÉÒÔ´æ´¢ÔÚÒ»Æð¡£ÎªÁ˽«ËüÃÇ´æ´¢ÔÚÒ»Æ𣬾ÍÒª´´½¨Ò»¸ö´Ø( c l u s t e r )À´¹ÜÀíÕâЩ±í¡£±íÖеÄÊý¾ÝÒ»Æð´æ´¢ÔÚ´ØÖУ¬´Ó¶ø×îС»¯±ØÐëÖ´ÐеÄI ......