Oracle AWR ½éÉÜ
Oracle Database 10g ÌṩÁËÒ»¸öÏÔÖø¸Ä½øµÄ¹¤¾ß£º×Ô¶¯¹¤×÷¸ºÔØÐÅÏ¢¿â (AWR:Automatic Workload Repository)¡£Oracle ½¨ÒéÓû§ÓÃÕâ¸öÈ¡´ú Statspack¡£AWR ʵÖÊÉÏÊÇÒ»¸ö Oracle µÄÄÚÖù¤¾ß£¬Ëü²É¼¯ÓëÐÔÄÜÏà¹ØµÄͳ¼ÆÊý¾Ý£¬²¢´ÓÄÇЩͳ¼ÆÊý¾ÝÖе¼³öÐÔÄÜÁ¿¶È£¬ÒÔ¸ú×ÙDZÔÚµÄÎÊÌâ¡£Óë Statspack ²»Í¬£¬¿ìÕÕÓÉÒ»¸ö³ÆΪ MMON µÄеĺǫ́½ø³Ì¼°Æä´Ó½ø³Ì×Ô¶¯µØÿСʱ²É¼¯Ò»´Î¡£ÎªÁ˽ÚÊ¡¿Õ¼ä£¬²É¼¯µÄÊý¾ÝÔÚ 7 Ììºó×Ô¶¯Çå³ý¡£¿ìÕÕƵÂʺͱ£Áôʱ¼ä¶¼¿ÉÒÔÓÉÓû§Ð޸ġ£Ëü²úÉúÁ½ÖÖÀàÐ͵ÄÊä³ö£ºÎı¾¸ñʽ£¨ÀàËÆÓÚ Statspack ±¨±íµÄÎı¾¸ñʽµ«À´×ÔÓÚ AWR ÐÅÏ¢¿â£©ºÍĬÈ쵀 HTML ¸ñʽ£¨ÓµÓе½²¿·ÖºÍ×Ó²¿·ÖµÄËùÓг¬Á´½Ó£©£¬´Ó¶øÌṩÁ˷dz£Óû§ÓѺõı¨±í¡£
AWR ʹÓü¸¸ö±íÀ´´æ´¢²É¼¯µÄͳ¼ÆÊý¾Ý£¬ËùÓÐµÄ±í¶¼´æ´¢ÔÚеÄÃû³ÆΪ SYSAUX µÄÌض¨±í¿Õ¼äÖÐµÄ SYS ģʽÏ£¬²¢ÇÒÒÔ WRM$_* ºÍ WRH$_* µÄ¸ñʽÃüÃû¡£Ç°Ò»ÖÖÀàÐÍ´æ´¢ÔªÊý¾ÝÐÅÏ¢£¨Èç¼ì²éµÄÊý¾Ý¿âºÍ²É¼¯µÄ¿ìÕÕ£©£¬ºóÒ»ÖÖÀàÐͱ£´æʵ¼Ê²É¼¯µÄͳ¼ÆÊý¾Ý¡£H ´ú±í“ÀúÊ·Êý¾Ý (historical)”¶ø M ´ú±í“ÔªÊý¾Ý (metadata)”¡£ÔÚÕâЩ±íÉϹ¹½¨Á˼¸ÖÖ´øǰ׺ DBA_HIST_ µÄÊÓͼ£¬ÕâЩÊÓͼ¿ÉÒÔÓÃÀ´±àдÄú×Ô¼ºµÄÐÔÄÜÕï¶Ï¹¤¾ß¡£ÊÓͼµÄÃû³ÆÖ±½ÓÓë±íÏà¹Ø£»ÀýÈ磬ÊÓͼ DBA_HIST_SYSMETRIC_SUMMARY ÊÇÔÚWRH$_SYSMETRIC_SUMMARY ±íÉϹ¹½¨µÄ¡£
Ò». AWRʹÓÃ
SQL>@?/rdbms/admin/awrrpt.sql
Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
ÊäÈë report_type µÄÖµ:
Type Specified: html
Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing <return> without
specifying a number lists all completed snapshots.
ÊäÈë num_days µÄÖµ: 1
Listing the last day's Completed Snapshots
Ïà¹ØÎĵµ£º
ÔÚORACLEÖиø±í¡¢ÁÐÔö¼Ó×¢ÊÍÒÔ¼°¶ÁȡעÊÍ
1¡¢¸ø±íÌî¼Ó×¢ÊÍ£ºSQL>comment on table ±íÃû is '±í×¢ÊÍ";
2¡¢¸øÁмÓ×¢ÊÍ£ºSQL>comment on column ±í.ÁÐ is 'ÁÐ×¢ÊÍ';
3¡¢¶ÁÈ¡±í×¢ÊÍ£ºSQL>select * from user_tab_comments where comments is not null;
4¡¢¶ÁÈ¡ÁÐ×¢ÊÍ£ºSQL>select * from user_col_commnents wh ......
Oracle ´¥·¢Æ÷ÓÐÓï¾ä¼¶´¥·¢Æ÷ºÍÐм¶´¥·¢Æ÷
Óï¾ä¼¶´¥·¢Æ÷ µ±É¾³ý²¿ÃűíÖеIJ¿ÃźÅʱ£¬Í¬Ê±É¾³ýµôÔ±¹¤±íÖв¿ÃźÅΪ£ºold.deptnoµÄ¼Ç¼
create or replace trigger del_dept_id
after delete on dept
for each row
begin
delete from emp where deptno=:old.deptno;
end;
µ±Íù²¿Ãűí²åÈëʱ£¬Í¬Ê±ÔÚÔ±¹¤±íÖ ......
ÎҵĻúÆ÷¸ÄÁ˼ÆËã»úÃû³Æ£¬ÔÙ¿ª»úʱ£¬oracle³öÏÖÎÊÌ⣬¿ª»úʱÀÏÊDZ¨“agntsrvc.exe³ö´í”£¬¾¹ýËÑË÷·¢ÏÖÊÇÏÂÁÐÎÊÌ⣺
1.agntsrvc.exeÊÇOracle Intelligent Agent·þÎñ¶ÔÓ¦µÄ³ÌÐò¡£
2.Òò´Ë·þÎñÊÇ×Ô¶¯Æô¶¯µÄ£¬ËùÒÔÒ»°ã¶àÔÚµçÄÔÆô¶¯Ê±µ¯³öϵͳ´íÎó¡£
3.ÎÊÌâ´¦Àí£º£¨±¾±¸·ÝÑø³ÉÏ°¹ßŶ£©
¡¡É¾³ýÁË %ORACLE_HOME%/ora ......
Tablespace
ORACLEÖУ¬±í¿Õ¼äÊÇÊý¾Ý¹ÜÀíµÄ»ù±¾·½·¨£¬ËùÓÐÓû§µÄ¶ÔÏóÒª´æ·ÅÔÚ±í¿Õ¼äÖУ¬Ò²¾ÍÊÇÓû§ÓпռäµÄʹÓÃȨ£¬²ÅÄÜ´´½¨Óû§¶ÔÏó£®·ñÔòÊDz»³äÐí´´½¨¶ÔÏó£¬ÒòΪ¾ÍÊÇÏë´´½¨¶ÔÏó,Èç±í,Ë÷ÒýµÈ£¬Ò²Ã»Óеط½´æ·Å,Oracle»áÌáʾ:ûÓд洢Åä¶î£®
¡¡¡¡Òò´Ë£¬ÔÚ´´½¨¶ÔÏó֮ǰ£¬Ê×ÏÈÒª·ÖÅä´æ´¢¿Õ¼ä£®¡¡¡¡
·ÖÅä´æ ......
Oracle ÈýÖÖ¼¯ºÏÊý¾ÝÀàÐ͵ıȽÏ:
PL/SQLÖÐûÓÐÊý×éµÄ¸ÅÄËûµÄ¼¯ºÏÊý¾ÝÀàÐͺÍÊý×éÊÇÏàËƵġ£ÔÚ7.3ÒÔÇ°µÄ°æ±¾ÖÐÖ»ÓÐÒ»ÖÖ¼¯ºÏ£¬³ÆΪPL/SQL±í£¬ÔÚÕâÖ®ºóÓÖÓÐÁ½ÖÖ¼¯ºÏÊý¾ÝÀàÐÍ:ǶÌ×±íºÍvarray¡£ÆäÖÐvarray¼¯ºÏÖеÄÔªËØÊÇÓÐÊýÁ¿ÏÞÖƵģ¬index_by±íºÍǶÌ×±íÊÇûÓÐÕâ¸öÏÞÖƵġ£index-by±íÊÇÏ¡ÊèµÄ£¬Ò²¾ÍÊÇ˵ϱê¿ÉÒÔ²»Á¬Ðø ......