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 job ¹ÜÀí
SVRMGR> select * from dba_jobs;
³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000 ;job_queue_interval = 10 //µ÷¶È×÷ҵˢÐÂƵÂÊÃëΪµ¥Î»
DBA_JOBS describes all jobs in the database.
USER_JO ......
Êý¾Ý¿âϵͳºÍ²Ù×÷ϵͳһÑù£¬ÔÚ¼ÆËã»úÉÏ°²×°³É¹¦ºó£¬»¹ÐèÒª½øÒ»²½ÅäÖúÍÓÅ»¯£¬´Ó¶øʹÆä¾ßÓиüÇ¿´óµÄ¹¦ÄܺÍÔËÐÐÔÚ×î¼Ñ״̬¡£Èç¹ûÔÚÉè¼Æ½×¶ÎÒòΪ¸÷ÖÖÒòËØûÓнøÐнÏΪºÏÀíµÄÅäÖúͼƻ®£¬ÄÇô¾ÍÐèÒªÔÚºóÆÚ¶ÔÊý¾Ý¿âϵͳ½øÐÐÓÅ»¯¡£
Êý¾Ý¿âϵͳÐÔÄܵÄÓÅ»¯£¬³ýÁËÔÚÉè¼Æ½×¶Î¶ÔÆäÂß¼´æ´¢½á¹¹ºÍÎïÀí´æ´¢½á¹¹Éè¼Æ½øÐÐÓÅ»¯£¬Ê¹Ö®ÔÚÂú×ã ......
ÎÊÌâÃèÊö
=======
ÔÚÊÔͼÆô¶¯Êý¾Ý¿âµÄʱºò,Oracle±¨¸æÏÂÁдíÎó£º
ERROR:
ORA-27101 Shared memory realm does not exist
ORA-01034 ORACLE not available
»ù±¾½âÊÍ
=======
Error: ORA-27101
Text: shared memory realm does not exist
-------------------------------------------
Ca ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/expÃüÁî
Oracle Êý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°Ñ dmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл ......
OracleÊý¾Ý¿âÔÚʹÓùý³ÌÖУ¬Ëæ×ÅÊý¾ÝµÄÔö¼ÓÊý¾Ý¿âÎļþÒ²Öð½¥Ôö¼Ó£¬ÔÚ´ïµ½Ò»¶¨´óСºóÓпÉÄÜ»áÔì³ÉÓ²Å̿ռ䲻×ã;ÄÇôÕâʱÎÒÃÇ¿ÉÒÔ°ÑÊý¾Ý¿âÎļþÒƶ¯µ½ÁíÒ»¸ö´óµÄÓ²ÅÌ·ÖÇøÖС£ÏÂÃæÎÒ¾ÍÒÔOracle for Windows°æ±¾ÖаÑCÅ̵ÄÊý¾Ý¿âÎļþÒƶ¯µ½DÅÌΪÀý½éÉÜOracleÊý¾Ý¿âÎļþÒƶ¯µÄ·½·¨ºÍ²½Öè¡£
¡¡¡¡1.ÔÚsqlplusÖÐÁ¬½Óµ½ÒªÒƶ¯ÎļþµÄOr ......