{"id":2577,"date":"2018-02-02T11:18:47","date_gmt":"2018-02-02T02:18:47","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2577"},"modified":"2018-02-02T11:19:49","modified_gmt":"2018-02-02T02:19:49","slug":"awr-%ec%9d%80-%ec%9c%a0%eb%a3%8c-statspack-%ec%9d%80-%eb%ac%b4%eb%a3%8c","status":"publish","type":"post","link":"https:\/\/haisins.synology.me\/wordpress\/?p=2577","title":{"rendered":"AWR \uc740 \uc720\ub8cc ? STATSPACK \uc740 \ubb34\ub8cc !"},"content":{"rendered":"<h4>STATSPACK (Oracle 8.1.6 \uc774\uc0c1)<\/h4>\n<h5>STATSPACK \uc774\ub780 ?<\/h5>\n<p>Statspack \uc740 Oracle 8.1.6 \ubd80\ud130 Database \uc131\ub2a5\uc5d0 \uad00\ub828\ub41c data\ub97c \uc218\uc9d1, \uac00\uacf5, \uc800\uc7a5\ud558\uace0 \uc774\ub97c report\ud615\ud0dc\ub85c \ubcf4\uc5ec\uc8fc\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud55c\ub2e4.<\/p>\n<p>\uacfc\uac70\uc5d0 \uc81c\uacf5\ub418\uc5c8\ub358 UTLBSTAT\/UTLESTAT \uc640 \ub2e4\ub978 \uc810\uc740 \ubd84\uc11d data\ub97c table\ub0b4\uc5d0 \uc800\uc7a5\ud558\uc5ec \uc6d0\ud558\ub294 \uae30\uac04\ubcc4\ub85c \ube44\uad50\ud558\uc5ec \ubd84\uc11d\ud560 \uc218 \uc788\uace0, \uc774\uc804\uc5d0\ub294 \uc5c6\uc5c8\ub358 \ucd94\uac00\uc801\uc778 \uc815\ubcf4\ub97c \ubcf4\uc5ec\uc900\ub2e4.<\/p>\n<p>PERFSTAT \uc774\ub77c\ub294 user\uac00 \uc0dd\uc131\ub418\uace0, \uadf8 user\uc5d0 \uc758\ud574 \uc18c\uc720\ub418\ub294 table\ub4e4\uc5d0\ub294 \uc131\ub2a5\uad00\ub828 \ud1b5\uacc4\uc815\ubcf4\ub4e4\uc774 \uc2dc\uac04\ub300\ubcc4\ub85c \ub204\uc801\ub418\uc5b4 \uc800\uc7a5\ub418\uc5b4 \uc9c0\ubbc0\ub85c \uac01 \uc2dc\uac04\ub300\ubcc4\ub85c \ube44\uad50 \ubd84\uc11d\uc774 \uac00\ub2a5\ud558\uba70, dbms_job\uc774\ub098 OS Utility (\uc608\ub97c \ub4e4\uba74 cron)\ub4f1\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc8fc\uae30\uc801\uc73c\ub85c Data\uc758 \uc218\uc9d1\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<h5>STATSPACK \uc778\uc2a4\ud1a8<\/h5>\n<h6>Database Space Requirements<\/h6>\n<p>\uac01 table\uc758 Default INITIAL \uac12\uacfc NEXT \uac12\uc740 1M \uc774\uba70, \ucd5c\uc18c 35M\uc758 \uc6a9\ub7c9\uc774 \ud544\uc694\ud558\ub2e4. (8.1.7 \uc740 script\uba85\uc774 \ud2c0\ub9ac\ubbc0\ub85c \uc544\ub798 \uae30\ud0c0\ubd80\ubd84\uc744 \ucc38\uc870)<\/p>\n<h6>Install Script<\/h6>\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"166\"><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td width=\"459\">\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td>$ sqlplus \/as sysdba<\/p>\n<p>SQL&gt; @$ORACLE_HOME\/rdbms\/admin\/statscre<\/p>\n<p>\u2026.<\/p>\n<p>Specify PERFSTAT user&#8217;s default tablespace: TOOLS<\/p>\n<p>\u2026.<\/p>\n<p>Specify PERFSTAT user&#8217;s temporary tablespace: TEMP<\/p>\n<p>\u2026.<\/p>\n<p>Enter tablespace where STATSPACK objects will be created: TOOLS<\/p>\n<p>\u2026.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\uc704 statscre.sql \uc744 \uc218\ud589\ud558\uba74 \uc544\ub798\uc758 3\uac1c SQL\uc774 \uc218\ud589\ub41c\ub2e4. \uc218\ud589\ub3c4\uc911 tablespace \uba85\uc744 \uc785\ub825 \ubc1b\ub294\ub370, SYSTEM tablespace \uba85\uc744 \uc81c\uc678\ud55c \uad00\ub828 tablespace \uba85\uc744 \uc8fc\uba74 \ub41c\ub2e4.<\/p>\n<p>1. statscusr.sql &#8211; PERFSTAT user \uc0dd\uc131 \ubc0f \uad8c\ud55c \ubd80\uc5ec<\/p>\n<p>2. statsctab \u2013 \uad00\ub828 table \uc0dd\uc131<\/p>\n<p>3. statspack \u2013 \uad00\ub828 package \uc0dd\uc131<\/p>\n<h5>Data \uc218\uc9d1<\/h5>\n<h6>Data \uc218\uc9d1 command<\/h6>\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"439\">\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td>$ sqlplus perfstat\/perfstat<\/p>\n<p>SQL&gt; execute statspack.snap;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u00a7 \ub9cc\uc57d \ud658\uacbd\uc774\ub77c\uba74 data\ub97c \uc218\uc9d1\ud558\uace0\uc790 \ud558\ub294 instance\uc5d0\uc11c \uc218\ud589\ud574\uc57c \ud55c\ub2e4.<\/p>\n<p>\uc704\uc758 package\ub97c \uc218\ud589\ud558\uba74 STATSPACK table\uc5d0 \ud574\ub2f9 \uc2dc\uc810\uc758 \uc131\ub2a5 \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc800\uc7a5\ud558\uace0 \uc774\ud6c4\uc758 \ud2b9\uc815 \uc2dc\uc810\uacfc \ube44\uad50\ud558\ub294 \uae30\uc900\uc774 \ub41c\ub2e4.<\/p>\n<p>\uc774\ub54c timed_statistics \ub97c true \ub85c \uc900\ub2e4\uba74 \uc2dc\uac04 \uc815\ubcf4\ub97c \uc5bb\uc744 \uc218 \uc788\ub2e4. (init.ora \ud639\uc740 \u2018alter system set timed_statistics = true\u2019 )<\/p>\n<h6>\uc8fc\uae30\uc801\uc73c\ub85c Data \uc218\uc9d1\ud558\ub824\uba74 ?<\/h6>\n<p>\u00a7 database \ub0b4\uc5d0\uc11c\ub294 dbms_job procedure\ub97c \uc0ac\uc6a9<\/p>\n<p>&#8211; $ORACLE_HOME\/rdbms\/admin\/ststsauto.sql \ucc38\uc870<\/p>\n<p>&#8211; init.ora \ub0b4\uc5d0 job_queue_processes \uac00 0 \ubcf4\ub2e4 \ucee4\uc57c \ud55c\ub2e4.<\/p>\n<p>\u00a7 OS utility \uc0ac\uc6a9 (UNIX\uc5d0\uc11c\ub294 \u2018cron\u2019, NT\uc5d0\uc11c\ub294 \u2018at\u2019)<\/p>\n<h5>Report \uc0dd\uc131<\/h5>\n<h6>Report \uc0dd\uc131 script<\/h6>\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"92\"><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/clip_image0017.png\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"clip_image001[7]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/clip_image0017_thumb.png?resize=640%2C304\" alt=\"clip_image001[7]\" width=\"640\" height=\"304\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u00a7 Enter beginning Snap Id \u2013 \uae30\uc900\uc774 \ub418\ub294 \uc2dc\uc810\uc758 snapshot id \uc785\ub825<\/p>\n<p>\u00a7 Enter ending Snap Id \u2013 \uc885\ub8cc \uc2dc\uc810\uc758 snapshot id \uc785\ub825<\/p>\n<h6>PERFSTAT schema\uc758 analyzing<\/h6>\n<p>Report\ub97c \uc0dd\uc131\uc2dc \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\uae30 \uc704\ud574\uc11c\ub294 PERFSTAT user\uac00 \uc18c\uc720\ud55c table\uacfc index\ub97c analyze \ud574\uc57c \ud55c\ub2e4.<\/p>\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"152\"><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td width=\"460\">\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td>$ sqlplus internal<\/p>\n<p>SQL&gt; execute dbms_utility.analyze_schema(&#8216;PERFSTAT&#8217;,&#8217;COMPUTE&#8217;);<\/p>\n<p>\ud639\uc740<\/p>\n<p>SQL&gt; execute dbms_stats.gather_schema_stats(\u2018PERFSTAT\u2019);<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h5>STATSPACK \uad00\ub828 configuration<\/h5>\n<h6>Snapshot Level<\/h6>\n<p>\uc218\uc9d1\ub418\ub294 \uc815\ubcf4\uc758 \uc591\uc744 Level\ub85c \uc870\uc808\ud560 \uc218\uac00 \uc788\ub2e4.<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"14%\">&nbsp;<\/td>\n<td valign=\"top\" width=\"35%\"><b>\uc218\uc9d1 <\/b><b>\uc815\ubcf4<\/b><\/td>\n<td valign=\"top\" width=\"50%\"><b>\ube44\uace0<\/b><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"14%\">Level 0<\/td>\n<td valign=\"top\" width=\"35%\">General Performance statistics<\/td>\n<td valign=\"top\" width=\"50%\">Wait stats, system event, system stats, rollback segment data, row cache, SGA, background event, session event, lock stats, buffer pool stats, parent latch stats<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"14%\">Level 5<\/td>\n<td valign=\"top\" width=\"35%\">Level 0 + SQL statement<\/td>\n<td valign=\"top\" width=\"50%\">\ubaa8\ub4e0 stats \ubc0f resource \uacfc\ub2e4 SQL\ubb38<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"14%\">Level 10<\/td>\n<td valign=\"top\" width=\"35%\">Level 5 + Child Latches<\/td>\n<td valign=\"top\" width=\"50%\">Data\uc218\uc9d1\uc5d0 \ub9ce\uc740 \uc2dc\uac04 \uc18c\uc694<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"459\">\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td>SQL&gt; execute statspack.snap(i_snap_level =&gt; 10, i_modify_parameter =&gt; &#8216;true&#8217;);<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>i_snap_level \uc740 snapshot level\uc744 \uc9c0\uc815\ud558\uba70, i_modify_parameter \ub294 stats$statspack_parameter table\uc5d0 \uac12\uc744 \uc800\uc7a5\ud560 \uac83\uc778\uc9c0\ub97c \uacb0\uc815\ud558\ub294 \uac83\uc73c\ub85c, \uc704\uc758 \uc608\ucc98\ub7fc true \ub85c \uc900\ub2e4\uba74 \uc774\ud6c4 level\ub3c4 \uac19\uc740 \uac12\uc744 \uc801\uc6a9\ubc1b\uc744 \uac83\uc774\uace0, \ub9cc\uc57d false\ub85c \uc9c0\uc815\ud558\uac70\ub098 \uac12\uc744 \uc8fc\uc9c0 \uc54a\ub294\ub2e4\uba74 \ud574\ub2f9 \uc2dc\uc810\ub9cc \uc801\uc6a9\uc744 \ubc1b\ub294\ub2e4.<\/p>\n<h6>Snapshot SQL threshold<\/h6>\n<p>Threshold\ub97c \ub450\uc5b4 \uadf8 \uac12\uc744 \ucd08\uacfc\ud558\ub294 SQL\ub9cc\uc744 \uc218\uc9d1\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub41c\ub2e4.<\/p>\n<p>Default\uac12<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"50%\">SQL \uc218\ud589 \ud69f\uc218<\/td>\n<td valign=\"top\" width=\"49%\">100<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"50%\">SQL \uc218\ud589\uc2dc disk read \uc218<\/td>\n<td valign=\"top\" width=\"49%\">1000<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"50%\">SQL \uc218\ud589\uc2dc parse call \uc218<\/td>\n<td valign=\"top\" width=\"49%\">1000<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"50%\">SQL \uc218\ud589\uc2dc buffer gets \uc218<\/td>\n<td valign=\"top\" width=\"49%\">10000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\uc704 default \uac12\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\ub85c stats$statspack_parameter table \uc5d0 \uc800\uc7a5\ub418\uc5b4 \uc788\uc73c\uba70, STATSPACK package\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubcc0\uacbd\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"166\"><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td width=\"452\">\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td>SQL&gt; execute statspack.modify_statspack_parameter(i_snap_level =&gt; 10, i_buffer_gets_th =&gt; 10000, i_disk_reads_th =&gt; 1000);<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\uc704 procedure\ub294 snapshot\uc758 \uac12\uc744 \uc800\uc7a5\ud558\uc9c0 \uc54a\uace0 \ub2e8\uc9c0 parameter\ub9cc \ubc14\uafb8\ub294\ub370\uc5d0 \uc0ac\uc6a9\uc774 \ub41c\ub2e4.<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"24%\"><b>Parameter Name<\/b><\/td>\n<td valign=\"top\" width=\"25%\"><b>\uc720\ud6a8\ud55c <\/b><b>\uac12\uc758 <\/b><b>\ubc94\uc704<\/b><\/td>\n<td valign=\"top\" width=\"18%\"><b>Default Value<\/b><\/td>\n<td valign=\"top\" width=\"32%\"><b>\ube44\uace0<\/b><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"24%\">i_snap_level<\/td>\n<td valign=\"top\" width=\"25%\">0, 5, 10<\/td>\n<td valign=\"top\" width=\"18%\">5<\/td>\n<td valign=\"top\" width=\"32%\">Snapshot Level<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"24%\">i_ucomment<\/td>\n<td valign=\"top\" width=\"25%\">Text<\/td>\n<td valign=\"top\" width=\"18%\">Blank<\/td>\n<td valign=\"top\" width=\"32%\">Snapshot \uc124\uba85<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"24%\">i_executions_th<\/td>\n<td valign=\"top\" width=\"25%\">Integer &gt;= 0<\/td>\n<td valign=\"top\" width=\"18%\">100<\/td>\n<td valign=\"top\" width=\"32%\">SQL \uc218\ud589 \ud69f\uc218<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"24%\">i_disk_reads_th<\/td>\n<td valign=\"top\" width=\"25%\">Integer &gt;= 0<\/td>\n<td valign=\"top\" width=\"18%\">1000<\/td>\n<td valign=\"top\" width=\"32%\">SQL\uc758 disk read \uc218<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"24%\">i_parse_calls+th<\/td>\n<td valign=\"top\" width=\"25%\">Integer &gt;= 0<\/td>\n<td valign=\"top\" width=\"18%\">1000<\/td>\n<td valign=\"top\" width=\"32%\">SQL\uc758 parse call \uc218<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"24%\">i_buffer_gets_th<\/td>\n<td valign=\"top\" width=\"25%\">Integer &gt;= 0<\/td>\n<td valign=\"top\" width=\"18%\">10000<\/td>\n<td valign=\"top\" width=\"32%\">SQL\uc758 buffer gets \uc218<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"24%\">i_session_id<\/td>\n<td valign=\"top\" width=\"25%\">v$session\uc758 \uc720\ud6a8 SID<\/td>\n<td valign=\"top\" width=\"18%\">0 (no session)<\/td>\n<td valign=\"top\" width=\"32%\">\ud1b5\uacc4\uce58\ub97c \uc218\uc9d1\ud560 session ID<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"24%\">i_modify_parameter<\/td>\n<td valign=\"top\" width=\"25%\">True, False<\/td>\n<td valign=\"top\" width=\"18%\">False<\/td>\n<td valign=\"top\" width=\"32%\">\ubcc0\uacbd\uac12\uc758 \uc800\uc7a5 \uc5ec\ubd80<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h5>\uae30\ud0c0<\/h5>\n<h6>\ud1b5\uacc4\uc815\ubcf4\ub97c \uc800\uc7a5\ud560 \ud2b9\uc815 Session ID \uc9c0\uc815<\/h6>\n<p>\ud2b9\uc815 session \uc744 \uc9c0\uc815\ud574\uc11c \ud1b5\uacc4\uc815\ubcf4\ub97c \ubcf4\uace0 \uc2f6\ub2e4\uba74<\/p>\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"166\"><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td width=\"459\">\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td>SQL&gt; execute statspack.snap(i_session_id =&gt; 3);<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h6>Wait event\uc5d0 \uc0ac\uc6a9\ub418\ub294 Time \ub2e8\uc704<\/h6>\n<p>Oracle \uc740 centisecond(1\/100\ucd08) \ub97c wait time\uc5d0 \uc0ac\uc6a9\ud558\uace0 \uc788\uc73c\ub098 \uc774 statspack report\uc5d0\uc11c\ub294 IO time \uad00\ub828\ud574\uc11c\ub294 millisecond(1\/1000\ucd08)\ub85c \ud45c\ud604\ud558\uace0 \uc788\ub2e4.<\/p>\n<h6>\uc131\ub2a5 data\uc758 \uacf5\uc720<\/h6>\n<p>\uc131\ub2a5 data\ub97c \ub2e4\ub978 site\uc5d0\uc11c \uacf5\uc720\ud558\uace0\uc790 \ud55c\ub2e4\uba74 PERFSTAT user\ub97c export \ubc1b\ub294\ub2e4. export\uc5d0 \uad00\ud55c parameter file\uc740 $ORACLE_HOME\/rdbms\/admin\/statsuexp.par \ub85c \uc81c\uacf5\ub41c\ub2e4.<\/p>\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"166\"><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td width=\"452\">\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td>$ exp userid=perfstat\/perfstat parfile=statsuexp.par<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\ud574\ub2f9 directory\uc5d0 statsuexp.dmp file\uc774 \uc0dd\uc131\ub41c\ub2e4.<\/p>\n<h6>UTLBSTAT\/UTLESTAT \uacfc\uc758 conflict<\/h6>\n<p>statspack\uacfc \uac19\uc740 user\uc5d0\uc11c \uc218\ud589\ud560 \uc218 \uc5c6\ub2e4. stats$waitstat table\uba85\uc774 \uac19\uae30 \ub54c\ubb38\uc774\ub2e4.<\/p>\n<h6>Package\uc758 \uc0ad\uc81c<\/h6>\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"166\"><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td width=\"452\">\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td>$ sqlplus internal<\/p>\n<p>SQL&gt; @$ORACLE_HOME\/rdbms\/admin\/statsdrp<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h6>Script \uc124\uba85<\/h6>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"112\"><b>Script <\/b><b>\uba85(8.1.6)<\/b><\/td>\n<td valign=\"top\" width=\"233\"><b>\uc124\uba85<\/b><\/td>\n<td valign=\"top\" width=\"124\"><b>Script <\/b><b>\uba85(8.1.7)<\/b><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"112\">statscre.sql<\/td>\n<td valign=\"top\" width=\"233\">STATSPACK \uc778\uc2a4\ud1a8 script<\/td>\n<td valign=\"top\" width=\"124\">spcreate.sql<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"112\">statsdrp.sql<\/td>\n<td valign=\"top\" width=\"233\">STATSPACK \uc0ad\uc81c script<\/td>\n<td valign=\"top\" width=\"124\">spdrop.sql<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"112\">statscusr.sql<\/td>\n<td valign=\"top\" width=\"233\">STATSPACK user (PERFSTAT)\uc0dd\uc131<\/td>\n<td valign=\"top\" width=\"124\">spcusr.sql<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"112\">statsdusr.sql<\/td>\n<td valign=\"top\" width=\"233\">STATSPACK user (PERFSTAT)\uc0ad\uc81c<\/td>\n<td valign=\"top\" width=\"124\">spdusr.sql<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"112\">statsctab.sql<\/td>\n<td valign=\"top\" width=\"233\">STATSPACK table \uc0dd\uc131<\/td>\n<td valign=\"top\" width=\"124\">spctab.sql<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"112\">statsdtab.sql<\/td>\n<td valign=\"top\" width=\"233\">STATSPACK table \uc0ad\uc81c<\/td>\n<td valign=\"top\" width=\"124\">spdtab.sql<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"112\">statspack.sql<\/td>\n<td valign=\"top\" width=\"233\">STATSPACK package \uc0dd\uc131<\/td>\n<td valign=\"top\" width=\"124\">apcpkg.sql<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"112\">statsrep.sql<\/td>\n<td valign=\"top\" width=\"233\">STATSPACK report \uc0dd\uc131<\/td>\n<td valign=\"top\" width=\"124\">spreport.sql<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"112\">statsauto.sql<\/td>\n<td valign=\"top\" width=\"233\">\uc790\ub3d9 STATSPACK \uc2e4\ud589(dbms_job)<\/td>\n<td valign=\"top\" width=\"124\">spauto.sql<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"112\">statsuexp.par<\/td>\n<td valign=\"top\" width=\"233\">PERFSTAT user\uc758 export parameter file<\/td>\n<td valign=\"top\" width=\"124\">spuexp.par<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>STATSPACK (Oracle 8.1.6 \uc774\uc0c1) STATSPACK \uc774\ub780 ? Statspack \uc740 Oracle 8.1.6 \ubd80\ud130 Database \uc131\ub2a5\uc5d0 \uad00\ub828\ub41c data\ub97c \uc218\uc9d1, \uac00\uacf5, \uc800\uc7a5\ud558\uace0 \uc774\ub97c report\ud615\ud0dc\ub85c \ubcf4\uc5ec\uc8fc\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud55c\ub2e4. \uacfc\uac70\uc5d0 \uc81c\uacf5\ub418\uc5c8\ub358 UTLBSTAT\/UTLESTAT \uc640 \ub2e4\ub978 \uc810\uc740 \ubd84\uc11d data\ub97c table\ub0b4\uc5d0 \uc800\uc7a5\ud558\uc5ec \uc6d0\ud558\ub294 \uae30\uac04\ubcc4\ub85c \ube44\uad50\ud558\uc5ec \ubd84\uc11d\ud560 \uc218 \uc788\uace0, \uc774\uc804\uc5d0\ub294 \uc5c6\uc5c8\ub358 \ucd94\uac00\uc801\uc778 \uc815\ubcf4\ub97c \ubcf4\uc5ec\uc900\ub2e4. PERFSTAT \uc774\ub77c\ub294 user\uac00 \uc0dd\uc131\ub418\uace0, \uadf8 user\uc5d0 \uc758\ud574 \uc18c\uc720\ub418\ub294 table\ub4e4\uc5d0\ub294 \uc131\ub2a5\uad00\ub828 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2410,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[69,173],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/databaetail.jpg?fit=905%2C480&ssl=1","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2577"}],"collection":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2577"}],"version-history":[{"count":2,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2577\/revisions"}],"predecessor-version":[{"id":2579,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2577\/revisions\/2579"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2410"}],"wp:attachment":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}