Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 SQLÐÔÄÜÓÅ»¯

£¨1£©      Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ, ÄÇ ......

Oracle ÓÅ»¯ÅäÖà ÊÕ²Ø

Êý¾Ý¿âϵͳºÍ²Ù×÷ϵͳһÑù£¬ÔÚ¼ÆËã»úÉÏ°²×°³É¹¦ºó£¬»¹ÐèÒª½øÒ»²½ÅäÖúÍÓÅ»¯£¬´Ó¶øʹÆä¾ßÓиüÇ¿´óµÄ¹¦ÄܺÍÔËÐÐÔÚ×î¼Ñ״̬¡£Èç¹ûÔÚÉè¼Æ½×¶ÎÒòΪ¸÷ÖÖÒòËØûÓнøÐнÏΪºÏÀíµÄÅäÖúͼƻ®£¬ÄÇô¾ÍÐèÒªÔÚºóÆÚ¶ÔÊý¾Ý¿âϵͳ½øÐÐÓÅ»¯¡£
Êý¾Ý¿âϵͳÐÔÄܵÄÓÅ»¯£¬³ýÁËÔÚÉè¼Æ½×¶Î¶ÔÆäÂß¼­´æ´¢½á¹¹ºÍÎïÀí´æ´¢½á¹¹Éè¼Æ½øÐÐÓÅ»¯£¬Ê¹Ö®ÔÚÂú×ã ......

[·ÖÏí]OracleÊý¾Ýµ¼Èëµ¼³öimp/expÃüÁî

OracleÊý¾Ýµ¼Èëµ¼³öimp/expÃüÁî
    Oracle Êý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°Ñ dmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл ......

Oracle ¾Û¼¯

¾Û¼¯(cluster)ÊÇ´æ´¢±íÊý¾ÝµÄ¿ÉÑ¡ÔñµÄ·½·¨¡£Ò»¸ö¾Û¼¯ÊÇÒ»×é±í£¬½«¾ßÓÐͬһ¹«¹²ÁÐÖµµÄÐд洢ÔÚÒ»Æ𣬲¢ÇÒËüÃǾ­³£Ò»ÆðʹÓá£ÕâЩ¹«¹²Áй¹³É¾Û¼¯Âë¡£
¾­³£±»Í¬Ê±·ÃÎʵıíÔÚÎïÀíλÖÃÉÏ¿ÉÒÔ´æ´¢ÔÚÒ»Æð¡£ÎªÁ˽«ËüÃÇ´æ´¢ÔÚÒ»Æ𣬾ÍÒª´´½¨Ò»¸ö´Ø( c l u s t e r )À´¹ÜÀíÕâЩ±í¡£±íÖеÄÊý¾ÝÒ»Æð´æ´¢ÔÚ´ØÖУ¬´Ó¶ø×îС»¯±ØÐëÖ´ÐеÄI ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ