{"id":1297,"date":"2016-02-11T07:05:10","date_gmt":"2016-02-11T07:05:10","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1297"},"modified":"2016-02-11T07:05:10","modified_gmt":"2016-02-11T07:05:10","slug":"dbmsstats-%ec%82%ac%ec%9a%a9","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1297","title":{"rendered":"DBMS_STATS \uc0ac\uc6a9"},"content":{"rendered":"

DBMS_STATS <\/span>\uc0ac\uc6a9<\/span>
\n\t\t\t\t<\/span><\/strong><\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

\uac1c\uc694<\/span>
\n\t\t\t\t<\/span><\/strong><\/span><\/p>\n

Oracle8\uae4c\uc9c0\ub294 \ud14c\uc774\ube14, \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0dd\uc131\ud558\uae30 \uc704\ud574 \u300e<\/span>ANALYZE\u300f<\/span>
\n\t\t<\/span>\uba85\ub839\ub9cc\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc5c8\uc73c\ub098 Oracle8i \ubd80\ud130\ub294 \u300e<\/span>ANALYZE\u300f<\/span>
\n\t\t<\/span>\uba85\ub839 \uc678\uc5d0\u300e<\/span>DBMS_STATS\u300f<\/span>Package\ub97c \uc81c\uacf5\ud55c\ub2e4.\n<\/p>\n

ANALYZE\uba85\ub839\uc744 \uc0ac\uc6a9\ud560 \uacbd\uc6b0\uc5d0\ub294 \uc2e0\uaddc\ub85c \uc0dd\uc131\ud55c \ud1b5\uacc4\uc815\ubcf4\uac00 \uc131\ub2a5\uc800\ud558\ub97c \uc720\ubc1c\uc2dc\ud0a4\ub354\ub77c\ub3c4 \uc774\uc804\uacfc \uac19\uc740 \ud1b5\uacc4\uc815\ubcf4\ub97c \ucd94\ucd9c\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub2e4\uc2dc ANALYZE \uc791\uc5c5\uc744 \uc218\ud589\ud574\uc57c \ub418\uae30 \ub54c\ubb38\uc5d0 \ud14c\uc774\ube14\uc758 \ud06c\uae30\uac00 \ud074 \uacbd\uc6b0 \ub9ce\uc740 \uc2dc\uac04\uc744 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0dd\uc131\ud558\ub294\ub370 \uc18c\ube44\ud558\uac8c \ub41c\ub2e4.\n<\/p>\n

\ub610\ud55c \uc77c\ubd80 Partitioned Table\uc5d0 \ub300\ud574 \ubd80\uc815\ud655\ud55c \ud1b5\uacc4\uc815\ubcf4\ub97c \ucd94\ucd9c\ud560 \uc218\ub3c4 \uc788\uae30 \ub54c\ubb38\uc5d0 Oracle8i\ubd80\ud130\ub294\u300e<\/span>DBMS_STATS\u300f<\/span>Package\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0dd\uc131\ud558\uace0 \uad00\ub9ac\ud560 \uac83\uc744 \uad8c\uace0\ud558\uace0 \uc788\ub2e4.\n<\/p>\n

\u300e<\/span>DBMS_STATS\u300f<\/span>Package\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \ud1b5\uacc4\uc815\ubcf4\uc5d0<\/span>
\n\t\t<\/span>\ub300\ud55c<\/span>
\n\t\t<\/span>\uc774\ub825\uad00\ub9ac\uac00<\/span>
\n\t\t<\/span>\uac00\ub2a5\ud558\ub2e4<\/span>.
\n\t\t\t<\/span><\/span><\/p>\n

ANALYZE\uba85\ub839\uc744 \uc0ac\uc6a9\ud560 \ub54c\ub294 \ud1b5\uacc4\uc815\ubcf4\uac00 \uc798\ubabb\ub420 \uacbd\uc6b0 \ub2e4\uc2dc ANALYZE\uc791\uc5c5\uc744 \uc218\ud589\ud574\uc57c \ud588\uace0 \uc774\uc804\uacfc \ub3d9\uc77c\ud55c \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0dd\uc131\ud558\ub294 \ub370\uc5d0\ub3c4 \ub9ce\uc740 \uc5b4\ub824\uc6c0\uc774 \uc788\uc5c8\ub2e4.(\ud14c\uc774\ube14 \ud06c\uae30\uac00 \ud074\uc218\ub85d \ubb38\uc81c\ub294 \ub354 \uc2ec\uac01\ud574 \uc9c4\ub2e4)\n<\/p>\n

\uadf8\ub7ec\ub098\u300eDBMS_STATS\u300fPackage\ub97c \uc0ac\uc6a9\ud558\uba74 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\ub354\ub77c\ub3c4 \ud604\uc7ac Data Dictionary\uc5d0 \uc788\ub294 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0ad\uc81c\ud55c \ud6c4 User Statistics Table\uc5d0 \uc800\uc7a5\ub418\uc5b4 \uc788\ub294 \uc774\uc804 \ud1b5\uacc4\uc815\ubcf4\ub97c IMPORT\ud558\uc5ec \ub2e8\uc2dc\uac04 \ub0b4\uc5d0 \uc774\uc804\uacfc \ub3d9\uc77c\ud55c \ud658\uacbd\uc73c\ub85c \ub3cc\uc544\uac00\ub294 \uac83\uc774 \uac00\ub2a5\ud558\ub2e4.\n<\/p>\n

\n <\/p>\n

\uc5ec\uae30\uc5d0\uc11c\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \uac00\uc7a5 \ub9ce\uc774 \uc4f0\uc774\ub294 Procedure\uc5d0 \ub300\ud55c Syntax \ubc0f \uc0ac\uc6a9 \uc608\ub97c \uc124\uba85\ud55c\ub2e4. (\uc790\uc138\ud55c \ub0b4\uc6a9\uc740 “Oracle8i supplied PL\/SQL Packages Reference” <\/span>\ub9e4\ub274\uc5bc \ucc38\uc870)\n<\/p>\n

\n <\/p>\n

\n <\/p>\n

\n <\/p>\n

\n <\/p>\n

CREATE_STAT_TABLE
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

\ud1b5\uacc4\uc815\ubcf4\ub97c \uc800\uc7a5\ud560 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud55c\ub2e4.\n<\/p>\n

Syntax
\n<\/strong><\/span><\/p>\n

DBMS_STATS.CREATE_STAT_TABLE (\n<\/p>\n

Ownname VARCHAR2,\n<\/p>\n

Stattab VARCHAR2,\n<\/p>\n

Tblspace VARCHAR2 DEFAULT NULL);\n<\/p>\n

\n <\/p>\n

\n <\/p>\n

Parameter
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

\n\n\n\n<\/colgroup>\n\n\n\n\n\n
\n

Parameter<\/strong><\/span> <\/p>\n<\/td>\n

\n

Descrition<\/strong><\/span> <\/p>\n<\/td>\n<\/tr>\n

\n

Ownname<\/span> <\/p>\n<\/td>\n

\n

Table Owner<\/span> <\/p>\n<\/td>\n<\/tr>\n

\n

Stattab<\/span> <\/p>\n<\/td>\n

\n

Table Name<\/span> <\/p>\n<\/td>\n<\/tr>\n

\n

Tblspace<\/span> <\/p>\n<\/td>\n

\n

Tablespace Name<\/span> <\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Example
\n<\/strong><\/span><\/p>\n

EXEC DBMS.CREATE_STAT_TABLE(‘SCOTT’,’STATSTBL’,’USERS’);
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

DROP_STAT_TABLE
\n<\/strong><\/span><\/p>\n

\ud1b5\uacc4\uc815\ubcf4\ub97c \uc800\uc7a5\ud588\ub358 \ud14c\uc774\ube14\uc744 \uc0ad\uc81c\ud55c\ub2e4.\n<\/p>\n

\n <\/p>\n

Syntax
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

DBMS_STATS.DROP_STAT_TABLE (\n<\/p>\n

Ownname VARCHAR2,\n<\/p>\n

Stattab VARCHAR2);\n<\/p>\n

Parameter
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

\n\n\n\n<\/colgroup>\n\n\n\n\n
\n

Parameter<\/strong> <\/p>\n<\/td>\n

\n

Descrition<\/strong> <\/p>\n<\/td>\n<\/tr>\n

\n

Ownname<\/span> <\/p>\n<\/td>\n

\n

Table Owner<\/span> <\/p>\n<\/td>\n<\/tr>\n

\n

Stattab <\/p>\n<\/td>\n

\n

Table Name <\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\n <\/p>\n

Example
\n<\/strong><\/span><\/p>\n

EXEC DBMS.DROP_STAT_TABLE(‘SCOTT’,’STATSTBL’);\n<\/p>\n

\n <\/p>\n

\n <\/p>\n

GATHER_TABLE_STATS
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

\ud14c\uc774\ube14, \uceec\ub7fc\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0dd\uc131\ud55c\ub2e4. CASCADE parameter\uc5d0 TRUE\ub97c \uc9c0\uc815\ud560 \uacbd\uc6b0 \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc815\ubcf4\ub3c4 \uc0dd\uc131\ud55c\ub2e4.\n<\/p>\n

\n <\/p>\n

Syntax
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

DBMS_STATS.GATHER_TABLE_STATS (\n<\/p>\n

ownname VARCHAR2,\n<\/p>\n

tabname VARCHAR2,\n<\/p>\n

partname VARCHAR2 DEFAULT NULL,\n<\/p>\n

estimate_percent NUMBER DEFAULT NULL,\n<\/p>\n

block_sample BOOLEAN DEFAULT FALSE,\n<\/p>\n

method_opt VARCHAR2 DEFAULT ‘FOR ALL COLUMNS SIZE 1’,\n<\/p>\n

degree NUMBER DEFAULT NULL,\n<\/p>\n

granularity VARCHAR2 DEFAULT ‘DEFAULT’,\n<\/p>\n

cascade BOOLEAN DEFAULT FALSE,\n<\/p>\n

stattab VARCHAR2 DEFAULT NULL,\n<\/p>\n

statid VARCHAR2 DEFAULT NULL,\n<\/p>\n

statown VARCHAR2 DEFAULT NULL);\n<\/p>\n

\n <\/p>\n

Parameter
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

Parameter<\/strong><\/span> <\/p>\n<\/td>\n

\n

Descrition<\/strong><\/span> <\/p>\n<\/td>\n<\/tr>\n

\n

Ownname<\/span> <\/p>\n<\/td>\n

\n

Schema of table to analyze<\/span> <\/p>\n<\/td>\n<\/tr>\n

\n

Tabname<\/span> <\/p>\n<\/td>\n

\n

Table Name<\/span> <\/p>\n<\/td>\n<\/tr>\n

\n

Partname<\/span> <\/p>\n<\/td>\n

\n

Name of Partition<\/span> <\/p>\n<\/td>\n<\/tr>\n

\n

Estimate_percent<\/span> <\/p>\n<\/td>\n

\n

Percentage of Rows to estimate<\/span> <\/p>\n<\/td>\n<\/tr>\n

\n

Block_sample<\/span> <\/p>\n<\/td>\n

\n

Whether or not to use random block sampling instead of random row sampling<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Method_opt<\/span> <\/p>\n<\/td>\n

\n

Options used to create histograms.<\/span> <\/p>\n<\/td>\n<\/tr>\n

\n

Degree<\/span> <\/p>\n<\/td>\n

\n

Degree of parallelism<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Granularity<\/p>\n<\/td>\n

\n

Granularity of statistics to collect ( only pertinet if the table is partitioned )<\/span> <\/p>\n<\/td>\n<\/tr>\n

\n

Cascade<\/span> <\/p>\n<\/td>\n

\n

Gather statistics on the indexes for this table.<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Stattab<\/span><\/p>\n<\/td>\n

\n

User stat table identifier describing where to save the current statistics.<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Statid<\/span> <\/p>\n<\/td>\n

\n

Identifier (optional) to associate with these statistics within stattab.<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

STATOWN<\/span> <\/p>\n<\/td>\n

\n

STATTAB TABLE OWNER<\/span> <\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\n <\/p>\n

Example
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

EXEC DBMS_STATS.GATHER_TABLE_STATS( –\n<\/p>\n

OWNNAME=>’SCOTT’ –\n<\/p>\n

,TABNAME=>’EMP’ –\n<\/p>\n

,PARTNAME=>NULL –\n<\/p>\n

,ESTIMATE_PERCENT=>25 –\n<\/p>\n

,BLOCK_SAMPLE=>TRUE –\n<\/p>\n

,METHOD_OPT=>’FOR ALL COLUMNS SIZE 1′ –\n<\/p>\n

,DEGREE=>4 –\n<\/p>\n

,GRANULARITY=>’DEFAULT’ –\n<\/p>\n

,CASCADE=>TRUE –\n<\/p>\n

,STATTAB=>’STATSTBL’ –\n<\/p>\n

,STATID=>’EMP_011229′ –\n<\/p>\n

,STATOWN=>’SCOTT’);\n<\/p>\n

\n <\/p>\n

\n <\/p>\n

\n <\/p>\n

\n <\/p>\n

\n <\/p>\n

\n <\/p>\n

\n <\/p>\n

GATHER_INDEX_STATS
\n<\/strong><\/span><\/p>\n

\uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0dd\uc131\ud55c\ub2e4.\n<\/p>\n

\n <\/p>\n

Syntax
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

DBMS_STATS.GATHER_INDEX_STATS (
\n<\/span><\/p>\n

Ownname VARCHAR2,
\n<\/span><\/p>\n

indname VARCHAR2,
\n<\/span><\/p>\n

partname VARCHAR2 DEFAULT NULL,
\n<\/span><\/p>\n

estimate_percent NUMBER DEFAULT NULL,
\n<\/span><\/p>\n

stattab VARCHAR2 DEFAULT NULL,
\n<\/span><\/p>\n

statid VARCHAR2 DEFAULT NULL,
\n<\/span><\/p>\n

statown VARCHAR2 DEFAULT NULL);\n<\/p>\n

\n <\/p>\n

Parameter
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n
\n

Parameter<\/strong> <\/p>\n<\/td>\n

\n

Descrition<\/strong> <\/p>\n<\/td>\n<\/tr>\n

\n

Ownname<\/span> <\/p>\n<\/td>\n

\n

Schema of index to analyze <\/p>\n<\/td>\n<\/tr>\n

\n

Indname <\/p>\n<\/td>\n

\n

Index Name<\/span> <\/p>\n<\/td>\n<\/tr>\n

\n

Partname <\/p>\n<\/td>\n

\n

Name of Partition <\/p>\n<\/td>\n<\/tr>\n

\n

Estimate_percent <\/p>\n<\/td>\n

\n

Percentage of Rows to estimate <\/p>\n<\/td>\n<\/tr>\n

\n

Stattab <\/p>\n<\/td>\n

\n

User stat table identifier describing where to save the current statistics.<\/p>\n<\/td>\n<\/tr>\n

\n

Statid <\/p>\n<\/td>\n

\n

Identifier (optional) to associate with these statistics within stattab.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\n <\/p>\n

Example
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

EXEC DBMS_STATS.GATHER_INDEX_STATS(ownname=>’scott’\n<\/p>\n

,indname=>’emp’\n<\/p>\n

,partname=>NULL\n<\/p>\n

,stattab=>’STATSTBL’\n<\/p>\n

,estimate_percent=>25\n<\/p>\n

,statid=>’indemp_20010520′\n<\/p>\n

);\n<\/p>\n

\n <\/p>\n

\n <\/p>\n

DELETE_TABLE_STATS
\n<\/strong><\/span><\/p>\n

\ud14c\uc774\ube14, \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc815\ubcf4\ub97c Data Dictionary \ub610\ub294 User Statistics Table\ub85c \ubd80\ud130 \uc0ad\uc81c\ud55c\ub2e4. (Default\ub85c \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0ad\uc81c\ud560 \uacbd\uc6b0 \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc815\ubcf4\ub3c4 \uc0ad\uc81c\ub41c\ub2e4)\n<\/p>\n

\n <\/p>\n

Syntax
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

DBMS_STATS.DELETE_TABLE_STATS (\n<\/p>\n

Ownname VARCHAR2,\n<\/p>\n

Tabname VARCHAR2,\n<\/p>\n

Partname VARCHAR2 DEFAULT NULL,\n<\/p>\n

Stattab VARCHAR2 DEFAULT NULL,\n<\/p>\n

statid VARCHAR2 DEFAULT NULL,\n<\/p>\n

cascade_parts BOOLEAN DEFAULT TRUE,\n<\/p>\n

cascade_columns BOOLEAN DEFAULT TRUE,\n<\/p>\n

cascade_indexes BOOLEAN DEFAULT TRUE,\n<\/p>\n

statown VARCHAR2 DEFAULT NULL);\n<\/p>\n

\n <\/p>\n

Parameter
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n
\n

Parameter<\/strong> <\/p>\n<\/td>\n

\n

Descrition<\/strong> <\/p>\n<\/td>\n<\/tr>\n

\n

Ownname<\/span> <\/p>\n<\/td>\n

\n

Schema of index to analyze <\/p>\n<\/td>\n<\/tr>\n

\n

Tabname <\/p>\n<\/td>\n

\n

Index Name<\/span> <\/p>\n<\/td>\n<\/tr>\n

\n

Partname <\/p>\n<\/td>\n

\n

Name of Partition <\/p>\n<\/td>\n<\/tr>\n

\n

Stattab <\/p>\n<\/td>\n

\n

User stat table identifier describing where to save the current statistics.<\/p>\n<\/td>\n<\/tr>\n

\n

Statid <\/p>\n<\/td>\n

\n

Identifier (optional) to associate with these statistics within stattab.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\n <\/p>\n

Example
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

EXEC DBMS_STATS.DELETE_TABLE_STATS(ownname=>’scott’
\n<\/span><\/p>\n

,tabname=>’emp’
\n<\/span><\/p>\n

,partname=>NULL
\n<\/span><\/p>\n

,stattab=>NULL
\n<\/span><\/p>\n

,statid=>NULL
\n<\/span><\/p>\n

);
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

EXPORT_TABLE_STATS
\n<\/strong><\/span><\/p>\n

\ud14c\uc774\ube14 \ubc0f \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc815\ubcf4\ub97c Data Dictionary\ub85c \ubd80\ud130 Export\ud558\uc5ec User Statistics Table\uc5d0 \uc800\uc7a5\ud55c\ub2e4.\n<\/p>\n

\n <\/p>\n

Syntax
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

DBMS_STATS.EXPORT_TABLE_STATS (\n<\/p>\n

Ownname VARCHAR2,\n<\/p>\n

Tabname VARCHAR2,\n<\/p>\n

Partname VARCHAR2 DEFAULT NULL,\n<\/p>\n

Stattab VARCHAR2 DEFAULT NULL,\n<\/p>\n

Statid VARCHAR2 DEFAULT NULL,\n<\/p>\n

Cascade BOOLEAN DEFAULT TRUE,\n<\/p>\n

Statown VARCHAR2 DEFAULT NULL);\n<\/p>\n

\n <\/p>\n

Parameter
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n
\n

Parameter<\/strong> <\/p>\n<\/td>\n

\n

Descrition<\/strong> <\/p>\n<\/td>\n<\/tr>\n

\n

Ownname<\/span> <\/p>\n<\/td>\n

\n

Schema of index to analyze <\/p>\n<\/td>\n<\/tr>\n

\n

Tabname <\/p>\n<\/td>\n

\n

Table Name <\/p>\n<\/td>\n<\/tr>\n

\n

Partname <\/p>\n<\/td>\n

\n

Name of Partition <\/p>\n<\/td>\n<\/tr>\n

\n

Stattab <\/p>\n<\/td>\n

\n

User stat table identifier describing where to save the current statistics.<\/p>\n<\/td>\n<\/tr>\n

\n

Statid <\/p>\n<\/td>\n

\n

Identifier (optional) to associate with these statistics within stattab.<\/p>\n<\/td>\n<\/tr>\n

\n

Cascade <\/p>\n<\/td>\n

\n

If true, then column and index statistics for this table are also exported..<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\n <\/p>\n

Example
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

EXEC DBMS_STATS.EXPORT_TABLE_STATS(ownname=>’scott’\n<\/p>\n

,tabname=>’emp’\n<\/p>\n

,partname=>NULL\n<\/p>\n

,stattab=>’statstab’\n<\/p>\n

,statid=>’emp_20010321′\n<\/p>\n

,cascade=>TRUE\n<\/p>\n

);\n<\/p>\n

\n <\/p>\n

\n <\/p>\n

\n <\/p>\n

\n <\/p>\n

IMPORT_TABLE_STATS
\n<\/strong><\/span><\/p>\n

User Statistics Table\uc5d0 \uc800\uc7a5\ub418\uc5b4 \uc788\ub294 \ud14c\uc774\ube14 \ubc0f \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc815\ubcf4\ub97c Data Dictionary\ub85c Import\ud55c\ub2e4.\n<\/p>\n

\n <\/p>\n

Syntax
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

DBMS_STATS.IMPORT_TABLE_STATS (\n<\/p>\n

Ownname VARCHAR2,\n<\/p>\n

Tabname VARCHAR2,\n<\/p>\n

Partname VARCHAR2 DEFAULT NULL,\n<\/p>\n

Stattab VARCHAR2 DEFAULT NULL,\n<\/p>\n

Statid VARCHAR2 DEFAULT NULL,\n<\/p>\n

Cascade BOOLEAN DEFAULT TRUE,\n<\/p>\n

Statown VARCHAR2 DEFAULT NULL);\n<\/p>\n

\n <\/p>\n

Parameter
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n
\n

Parameter<\/strong> <\/p>\n<\/td>\n

\n

Descrition<\/strong> <\/p>\n<\/td>\n<\/tr>\n

\n

Ownname<\/span> <\/p>\n<\/td>\n

\n

Schema of index to analyze<\/span> <\/p>\n<\/td>\n<\/tr>\n

\n

Tabname <\/p>\n<\/td>\n

\n

Table Name <\/p>\n<\/td>\n<\/tr>\n

\n

Partname <\/p>\n<\/td>\n

\n

Name of Partition <\/p>\n<\/td>\n<\/tr>\n

\n

Stattab <\/p>\n<\/td>\n

\n

User stat table identifier describing where to save the current statistics.<\/p>\n<\/td>\n<\/tr>\n

\n

Statid <\/p>\n<\/td>\n

\n

Identifier (optional) to associate with these statistics within stattab.<\/p>\n<\/td>\n<\/tr>\n

\n

Cascade <\/p>\n<\/td>\n

\n

If true, then column and index statistics for this table are also exported..<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\n <\/p>\n

Example
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

EXEC DBMS_STATS.IMPORT_TABLE_STATS(ownname=>’scott’\n<\/p>\n

,tabname=>’emp’\n<\/p>\n

,partname=>NULL\n<\/p>\n

,stattab=>’statstab’\n<\/p>\n

,statid=>’emp_20010321′\n<\/p>\n

,cascade=>TRUE\n<\/p>\n

);\n<\/p>\n

\n <\/p>\n

\n <\/p>\n

\uc720\ud615\ubcc4<\/span>
\n\t\t\t\t<\/span>\uc791\uc5c5\uc0ac\ub840<\/span>
\n\t\t\t\t<\/span><\/strong><\/span><\/p>\n

User Statistics Table<\/span>\uc0dd\uc131<\/span>
\n\t\t\t\t<\/span><\/strong><\/span><\/p>\n

\n <\/p>\n

EXEC DBMS_STATS.CREATE_STAT_TABLE(‘SCOTT’,’STATSTBL’,\n<\/p>\n

‘USERS’);\n<\/p>\n

\n <\/p>\n

    \n
  • \ud1b5\uacc4\uc815\ubcf4\ub97c<\/span>
    \n\t\t\t\t<\/span>\uc800\uc7a5\ud558\uae30<\/span>
    \n\t\t\t\t<\/span>\uc704\ud55c<\/span> User Statistics Table<\/span>\uc744<\/span>
    \n\t\t\t\t<\/span>\uc0dd\uc131\ud55c\ub2e4<\/span>.
    \n<\/span><\/span><\/li>\n
  • SCOTT Schema<\/span>\uc5d0<\/span> “STATSTBL” <\/span>\ud14c\uc774\ube14\uc744<\/span>
    \n\t\t\t\t<\/span>\uc0dd\uc131\ud55c\ub2e4<\/span>. (Tablespace Name: “USERS”)
    \n<\/span><\/span><\/li>\n<\/ul>\n

    \n <\/p>\n

    User Statistics Table<\/span>\uc0ad\uc81c<\/span>
    \n\t\t\t\t<\/span><\/strong><\/span><\/p>\n

    \n <\/p>\n

    EXEC DBMS_STATS.DROP_STAT_TABLE(‘SCOTT’,’STATSTBL’)\n<\/p>\n

    \n <\/p>\n

      \n
    • SCOTT Schema<\/span>\uc5d0\uc11c<\/span> “STATSTBL” <\/span>\ud14c\uc774\ube14\uc744<\/span>
      \n\t\t\t\t<\/span>\uc0ad\uc81c\ud55c\ub2e4<\/span>.
      \n<\/span><\/span><\/li>\n<\/ul>\n

      \n <\/p>\n

      \ud14c\uc774\ube14\uc5d0<\/span>
      \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
      \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4<\/span>
      \n\t\t\t\t<\/span>\uc0dd\uc131<\/span>
      \n\t\t\t\t<\/span><\/strong><\/span><\/p>\n

      EXEC DBMS_STATS.GATHER_TABLE_STATS(ownname=>’scott’\n<\/p>\n

      ,tabname=>’emp’\n<\/p>\n

      ,partname=>NULL\n<\/p>\n

      ,estimate_percent=>25\n<\/p>\n

      ,method_opt=>\n<\/p>\n

      ‘FOR ALL INDEXED COLUMNS’\n<\/p>\n

      ,degree=>1\n<\/p>\n

      ,block_sample=>TRUE\n<\/p>\n

      ,cascade=>TRUE\n<\/p>\n

      ,stattab=>’STATSTBL’\n<\/p>\n

      ,statid=>’emp_20010520′\n<\/p>\n

      );
      \n\t\t<\/strong><\/p>\n

      \n <\/p>\n

        \n
      • SCOTT Schema<\/span>\ub0b4<\/span> EMP <\/span>\ud14c\uc774\ube14\uc5d0<\/span>
        \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
        \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span>
        \n\t\t\t\t<\/span>\uc0dd\uc131\ud55c\ub2e4<\/span>.(ownname=>’scott’, tabname=>’emp’)
        \n<\/span><\/span><\/li>\n
      • Partition<\/span>\uc774<\/span>
        \n\t\t\t\t<\/span>\uc544\ub2cc<\/span>
        \n\t\t\t\t<\/span>\uc804\uccb4<\/span>
        \n\t\t\t\t<\/span>\ud14c\uc774\ube14\uc5d0<\/span>
        \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
        \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span>
        \n\t\t\t\t<\/span>\uc0dd\uc131\ud55c\ub2e4<\/span>.(partname=>NULL)
        \n<\/span><\/span><\/li>\n
      • Data Dictionary<\/span>\ub0b4\uc5d0<\/span>
        \n\t\t\t\t<\/span>\ud14c\uc774\ube14<\/span>, <\/span>\uc778\ub371\uc2a4\uc5d0<\/span>
        \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
        \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\uac00<\/span>
        \n\t\t\t\t<\/span>\uc774\ubbf8<\/span>
        \n\t\t\t\t<\/span>\uc874\uc7ac\ud558\uba74<\/span>
        \n\t\t\t\t<\/span>\uc0c8\ub85c\uc6b4<\/span>
        \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span>
        \n\t\t\t\t<\/span>\uc0dd\uc131\ud558\uae30<\/span>
        \n\t\t\t\t<\/span>\uc804\uc5d0<\/span> stattab<\/span>\ud30c\ub77c\ubbf8\ud130\uc5d0<\/span>
        \n\t\t\t\t<\/span>\uc9c0\uc815\ub41c<\/span> “STATSTBL” <\/span>\ud14c\uc774\ube14\uc5d0<\/span>
        \n\t\t\t\t<\/span>\uc774\uc804<\/span>
        \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span>
        \n\t\t\t\t<\/span>\uc800\uc7a5\ud55c\ub2e4<\/span>.(stattab=>’STATSTBL’)
        \n<\/span><\/span><\/li>\n
      • Random Block Sampling <\/span>\ubc29\uc2dd\uc774<\/span>
        \n\t\t\t\t<\/span>\uc0ac\uc6a9\ub41c\ub2e4<\/span>.(block_sample=>TRUE, FLASE<\/span>\uac00<\/span>
        \n\t\t\t\t<\/span>\uc0ac\uc6a9\ub420<\/span>
        \n\t\t\t\t<\/span>\uacbd\uc6b0<\/span> Random Row Sampling<\/span>\uc774<\/span>
        \n\t\t\t\t<\/span>\uc0ac\uc6a9\ub41c\ub2e4<\/span>.)
        \n<\/span><\/span><\/li>\n
      • \uc778\ub371\uc2a4\uc5d0<\/span>
        \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
        \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub3c4<\/span>
        \n\t\t\t\t<\/span>\uac19\uc774<\/span>
        \n\t\t\t\t<\/span>\uc0dd\uc131\ud55c\ub2e4<\/span>.(cascade=>TRUE)
        \n<\/span><\/span><\/li>\n
      • ’emp_20010520′<\/span>\ub77c\ub294<\/span> Unique ID<\/span>\ub97c<\/span>
        \n\t\t\t\t<\/span>\uc0ac\uc6a9\ud558\uc5ec<\/span>
        \n\t\t\t\t<\/span>\uae30\uc874<\/span>
        \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span> User Statistics Table<\/span>\uc800\uc7a5\ud55c\ub2e4<\/span>. <\/span>\uc774<\/span> ID<\/span>\ub294<\/span>
        \n\t\t\t\t<\/span>\ud6c4\uc5d0<\/span>
        \n\t\t\t\t<\/span>\uc0ad\uc81c<\/span>
        \n\t\t\t\t<\/span>\ub610\ub294<\/span> Data Dictionary<\/span>\ub85c<\/span> Import<\/span>\uc2dc\uc5d0<\/span>
        \n\t\t\t\t<\/span>\uc0ac\uc6a9\ub41c\ub2e4<\/span>.
        \n<\/span><\/span><\/li>\n<\/ul>\n

        \n <\/p>\n

        \ud14c\uc774\ube14\uc758<\/span>
        \n\t\t\t\t<\/span>\ud2b9\uc815<\/span> PARTITION<\/span>\uc5d0<\/span>
        \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
        \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4<\/span>
        \n\t\t\t\t<\/span>\uc0dd\uc131<\/span>
        \n\t\t\t\t<\/span><\/strong><\/span><\/p>\n

        \n <\/p>\n

        EXEC DBMS_STATS.GATHER_TABLE_STATS( –\n<\/p>\n

        OWNNAME=>’SCOTT’ –\n<\/p>\n

        ,TABNAME=>’EMP’ –\n<\/p>\n

        ,PARTNAME=>NULL –\n<\/p>\n

        ,ESTIMATE_PERCENT=>25 –\n<\/p>\n

        ,BLOCK_SAMPLE=>TRUE –\n<\/p>\n

        ,METHOD_OPT=>’FOR ALL COLUMNS SIZE 1′ –\n<\/p>\n

        ,DEGREE=>4 –\n<\/p>\n

        ,GRANULARITY=>’DEFAULT’ –\n<\/p>\n

        ,CASCADE=>TRUE –\n<\/p>\n

        ,STATTAB=>’STATSTBL’ –\n<\/p>\n

        ,STATID=>’EMP_011229′ –\n<\/p>\n

        ,STATOWN=>’SCOTT’);
        \n\t\t<\/span><\/p>\n

        \n <\/p>\n

          \n
        • \uc804\uccb4<\/span>
          \n\t\t\t\t<\/span>\ud14c\uc774\ube14\uc774<\/span>
          \n\t\t\t\t<\/span>\uc544\ub2cc<\/span> “P06” Partition<\/span>\uc5d0<\/span>
          \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
          \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span>
          \n\t\t\t\t<\/span>\uc0dd\uc131\ud55c\ub2e4<\/span>.(partname=>’P06′)
          \n<\/span><\/span><\/li>\n
        • “P06” Partition<\/span>\uc5d0<\/span>
          \n\t\t\t\t<\/span>\ub300\uc751\ub418\ub294<\/span> Local Index Partition<\/span>\uc5d0<\/span>
          \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
          \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub294<\/span>
          \n\t\t\t\t<\/span>\uc0dd\uc131\ud558\uc9c0<\/span>
          \n\t\t\t\t<\/span>\uc54a\ub294\ub2e4<\/span>.(cascade=>FALSE)
          \n<\/span><\/span><\/li>\n<\/ul>\n

          \n <\/p>\n

          \n <\/p>\n

          \uc778\ub371\uc2a4\uc5d0<\/span>
          \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
          \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4<\/span>
          \n\t\t\t\t<\/span>\uc0dd\uc131<\/span>
          \n\t\t\t\t<\/span><\/strong><\/span><\/p>\n

          \n <\/p>\n

          EXEC DBMS_STATS.GATHER_INDEX_STATS(ownname=>’scott’\n<\/p>\n

          ,indname=>’ix_emp’\n<\/p>\n

          ,partname=>NULL\n<\/p>\n

          ,estimate_percent=>25\n<\/p>\n

          ,stattab=>’STATSTBL’\n<\/p>\n

          ,statid=> ‘ix_emp_p06_20010520’\n<\/p>\n

          );\n<\/p>\n

          \n <\/p>\n

            \n
          • SCOTT Schema<\/span>\ub0b4<\/span> IX_EMP <\/span>\uc778\ub371\uc2a4\uc5d0<\/span>
            \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
            \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span>
            \n\t\t\t\t<\/span>\uc0dd\uc131\ud55c\ub2e4<\/span>.(ownname=>’scott’, tabname=>’ix_emp’)
            \n<\/span><\/span><\/li>\n
          • \ud30c\ud2f0\uc158\uc5d0<\/span>
            \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
            \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\uac00<\/span>
            \n\t\t\t\t<\/span>\uc774\ubbf8<\/span>
            \n\t\t\t\t<\/span>\uc874\uc7ac\ud558\uba74<\/span>
            \n\t\t\t\t<\/span>\uc0c8\ub85c\uc6b4<\/span>
            \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span>
            \n\t\t\t\t<\/span>\uc0dd\uc131\ud558\uae30<\/span>
            \n\t\t\t\t<\/span>\uc804\uc5d0<\/span> stattab<\/span>\ud30c\ub77c\ubbf8\ud130\uc5d0<\/span>
            \n\t\t\t\t<\/span>\uc9c0\uc815\ub41c<\/span> “STATSTBL” <\/span>\ud14c\uc774\ube14\uc5d0<\/span>
            \n\t\t\t\t<\/span>\uc774\uc804<\/span>
            \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span>
            \n\t\t\t\t<\/span>\uc800\uc7a5\ud55c\ub2e4<\/span>.(stattab=>’STATSTBL’)
            \n<\/span><\/span><\/li>\n
          • \n
            ‘ix_emp_p20010520’<\/span>\ub77c\ub294<\/span> Unique ID<\/span>\ub97c<\/span>
            \n\t\t\t\t\t<\/span>\uc0ac\uc6a9\ud558\uc5ec<\/span>
            \n\t\t\t\t\t<\/span>\uae30\uc874<\/span>
            \n\t\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span> User Statistics Table<\/span>\uc800\uc7a5\ud55c\ub2e4<\/span>. <\/span>\uc774<\/span> ID<\/span>\ub294<\/span>
            \n\t\t\t\t\t<\/span>\ud6c4\uc5d0<\/span>
            \n\t\t\t\t\t<\/span>\uc0ad\uc81c<\/span>
            \n\t\t\t\t\t<\/span>\ub610\ub294<\/span> Data Dictionary<\/span>\ub85c<\/span> Import<\/span>\uc2dc\uc5d0<\/span>
            \n\t\t\t\t\t<\/span>\uc0ac\uc6a9\ub41c\ub2e4<\/span>.
            \n<\/span><\/span><\/div>\n

            \n <\/p>\n<\/li>\n<\/ul>\n

            \uc804\uccb4<\/span>
            \n\t\t\t\t<\/span>\ud14c\uc774\ube14\uc5d0<\/span>
            \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
            \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4<\/span>
            \n\t\t\t\t<\/span>\uc0ad\uc81c<\/span>
            \n\t\t\t\t<\/span><\/strong><\/span><\/p>\n

            \n <\/p>\n

            EXEC DBMS_STATS.DELETE_TABLE_STATS(ownname=>’scott’\n<\/p>\n

            ,tabname=>’emp’\n<\/p>\n

            ,partname=>NULL\n<\/p>\n

            ,stattab=>NULL\n<\/p>\n

            ,statid=>NULL\n<\/p>\n

            );\n<\/p>\n

            \n <\/p>\n

              \n
            • SCOTT Schema<\/span>\ub0b4<\/span> EMP <\/span>\ud14c\uc774\ube14\uc5d0<\/span>
              \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
              \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span>
              \n\t\t\t\t<\/span>\uc0ad\uc81c\ud55c\ub2e4<\/span>.(ownname=>’scott’, tabname=>’emp’)
              \n<\/span><\/span><\/li>\n
            • Partition<\/span>\uc774<\/span>
              \n\t\t\t\t<\/span>\uc544\ub2cc<\/span>
              \n\t\t\t\t<\/span>\uc804\uccb4<\/span>
              \n\t\t\t\t<\/span>\ud14c\uc774\ube14\uc5d0<\/span>
              \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
              \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span>
              \n\t\t\t\t<\/span>\uc0ad\uc81c\ud55c\ub2e4<\/span>.(partname=>NULL)
              \n<\/span><\/span><\/li>\n
            • User Statistics Table<\/span>\uc774<\/span>
              \n\t\t\t\t<\/span>\uc544\ub2cc<\/span> Data Dictionary<\/span>\ub85c<\/span>
              \n\t\t\t\t<\/span>\ubd80\ud130<\/span>
              \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span>
              \n\t\t\t\t<\/span>\uc0ad\uc81c\ud55c\ub2e4<\/span>.(stattab=>NULL) <\/span>\ub9cc\uc57d<\/span> stattab<\/span>\uc5d0<\/span> User Statistics Table<\/span>\uc744<\/span>
              \n\t\t\t\t<\/span>\uc9c0\uc815\ud560<\/span>
              \n\t\t\t\t<\/span>\uacbd\uc6b0<\/span> User Statistics Table<\/span>\uc5d0\uc11c\ub9cc<\/span>
              \n\t\t\t\t<\/span>\ud14c\uc774\ube14\uc5d0<\/span>
              \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
              \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span>
              \n\t\t\t\t<\/span>\uc0ad\uc81c\ud55c\ub2e4<\/span>.
              \n<\/span><\/span><\/li>\n
            • \n
              Data Dictionary<\/span>\ub85c<\/span>
              \n\t\t\t\t\t<\/span>\ubd80\ud130<\/span>
              \n\t\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span>
              \n\t\t\t\t\t<\/span>\uc0ad\uc81c\ud558\uae30<\/span>
              \n\t\t\t\t\t<\/span>\ub54c\ubb38\uc5d0<\/span> statid<\/span>\uc5d0\ub294<\/span> Default<\/span>\uac12\uc744<\/span>
              \n\t\t\t\t\t<\/span>\uc0ac\uc6a9\ud55c\ub2e4<\/span>.
              \n<\/span><\/span><\/div>\n

              \n <\/p>\n<\/li>\n<\/ul>\n

              \ud14c\uc774\ube14\uc5d0<\/span>
              \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
              \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4<\/span> EXPORT
              \n<\/span><\/strong><\/span><\/p>\n

              \n <\/p>\n

              EXEC DBMS_STATS.EXPORT_TABLE_STATS(ownname=>’scott’\n<\/p>\n

              ,tabname=>’emp’\n<\/p>\n

              ,partname=>NULL\n<\/p>\n

              ,stattab=>’statstab’\n<\/p>\n

              ,statid=>’emp_20010321′\n<\/p>\n

              ,cascade=>TRUE\n<\/p>\n

              );\n<\/p>\n

              \n <\/p>\n

                \n
              • Data Dictionary<\/span>\ub85c<\/span>
                \n\t\t\t\t<\/span>\ubd80<\/span>
                \n\t\t\t\t<\/span>\ud130<\/span>SCOTT Schema<\/span>\ub0b4<\/span> EMP <\/span>\ud14c\uc774\ube14\uc5d0<\/span>
                \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
                \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span> EXPORT<\/span>\ud55c\ub2e4<\/span>.(ownname=>’scott’, tabname=>’emp’)
                \n<\/span><\/span><\/li>\n
              • \ud2b9\uc815<\/span> Partition<\/span>\uc774<\/span>
                \n\t\t\t\t<\/span>\uc544\ub2cc<\/span>
                \n\t\t\t\t<\/span>\uc804\uccb4<\/span>
                \n\t\t\t\t<\/span>\ud14c\uc774\ube14\uc5d0<\/span>
                \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
                \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span> EXPORT<\/span>\ud55c\ub2e4<\/span>.(partname=>NULL)
                \n<\/span><\/span><\/li>\n
              • EXPORT<\/span>\ud55c<\/span>
                \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span> “statstab” <\/span>\ud14c\uc774\ube14\uc5d0<\/span> “emp_20010321”<\/span>\ub77c\ub294<\/span> Key<\/span>\uac12\uc744<\/span>
                \n\t\t\t\t<\/span>\uac00\uc9c0\uace0<\/span>
                \n\t\t\t\t<\/span>\uc800\uc7a5\ud55c\ub2e4<\/span>.(stattab=>’statstab’, statid=>’emp_20010321′)
                \n<\/span><\/span><\/li>\n
              • \n
                \uc778\ub371\uc2a4\uc5d0<\/span>
                \n\t\t\t\t\t<\/span>\ub300\ud55c<\/span>
                \n\t\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub3c4<\/span>
                \n\t\t\t\t\t<\/span>\uac19\uc774<\/span> EXPORT<\/span>\ud55c\ub2e4<\/span>. (cascade=>TRUE)
                \n<\/span><\/span><\/div>\n
                  \n
                • \n\t\t\t\t<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                  \ud14c\uc774\ube14\uc5d0<\/span>
                  \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
                  \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4<\/span> IMPORT
                  \n<\/span><\/strong><\/span><\/p>\n

                  \n <\/p>\n

                  EXEC DBMS_STATS.IMPORT_TABLE_STATS(ownname=>’scott’\n<\/p>\n

                  ,tabname=>’emp’\n<\/p>\n

                  ,partname=>NULL\n<\/p>\n

                  ,stattab=>’statstab’\n<\/p>\n

                  ,statid=>’emp_20010321′\n<\/p>\n

                  ,cascade=>TRUE\n<\/p>\n

                  );\n<\/p>\n

                  \n <\/p>\n

                    \n
                  • SCOTT Schema<\/span>\ub0b4<\/span> EMP <\/span>\ud14c\uc774\ube14\uc5d0<\/span>
                    \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
                    \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span> IMPORT<\/span>\ud55c\ub2e4<\/span>.(ownname=>’scott’, tabname=>’emp’)
                    \n<\/span><\/span><\/li>\n
                  • “statstab” User Statistics Table<\/span>\ub85c<\/span>
                    \n\t\t\t\t<\/span>\ubd80<\/span>
                    \n\t\t\t\t<\/span>\ud130<\/span> “emp_20010321”<\/span>\uc758<\/span> Key<\/span>\ub97c<\/span>
                    \n\t\t\t\t<\/span>\uac16\ub294<\/span>
                    \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span> IMPORT<\/span>\ud55c\ub2e4<\/span>.(stattab=>’statstab’, statid=>’emp_20010321′)
                    \n<\/span><\/span><\/li>\n
                  • \ud2b9\uc815<\/span> Partition<\/span>\uc774<\/span>
                    \n\t\t\t\t<\/span>\uc544\ub2cc<\/span>
                    \n\t\t\t\t<\/span>\uc804\uccb4<\/span>
                    \n\t\t\t\t<\/span>\ud14c\uc774\ube14\uc5d0<\/span>
                    \n\t\t\t\t<\/span>\ub300\ud55c<\/span>
                    \n\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub97c<\/span> IMPORT<\/span>\ud55c\ub2e4<\/span>.(partname=>NULL)
                    \n<\/span><\/span><\/li>\n
                  • \n
                    \uc778\ub371\uc2a4\uc5d0<\/span>
                    \n\t\t\t\t\t<\/span>\ub300\ud55c<\/span>
                    \n\t\t\t\t\t<\/span>\ud1b5\uacc4\uc815\ubcf4\ub3c4<\/span>
                    \n\t\t\t\t\t<\/span>\uac19\uc774<\/span> IMPORT<\/span>\ud55c\ub2e4<\/span>. (cascade=>TRUE)
                    \n<\/span><\/span><\/div>\n

                    \n <\/p>\n<\/li>\n<\/ul>\n

                    \n <\/p>\n

                    \ucc38\uace0\uc0ac\ud56d<\/span>
                    \n\t\t\t\t<\/span><\/strong><\/span><\/p>\n

                      \n
                    • \uc2e0\uaddc\ub85c \uc791\uc5c5\uc744 \uc218\ud589\ud558\uae30 \uc804\uc5d0 \ud604\uc7ac ANALYZE \uba85\ub839\uc744 \ud1b5\ud574 \uc0dd\uc131\ub418\uc5b4 \uc788\ub294 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc704\uc5d0\uc11c \uc124\uba85\ud55c EXPORT\uba85\ub839\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc800\uc7a5\ud560 \uac83\uc744 \uad8c\uace0\ud568.\n<\/li>\n
                    • DBMS_STATS Package\ub294 \uc2e4\ud589 \uc911 \ub0b4\ubd80\uc801\uc73c\ub85c \ub2e4\ub7c9\uc758 SORT\uc791\uc5c5\uc774 \uc788\uc73c\ubbc0\ub85c \uc2e4\ud589\ud558\uae30 \uc804\uc5d0 \ub2e4\uc74c \uba85\ub839\uc744 \uc2e4\ud589\ud558\uc5ec RESOURCE\ub97c \ucda9\ubd84\ud788 \ud560\ub2f9\ud560 \uacbd\uc6b0 \uc2e4\ud589\uc2dc\uac04\uc744 \ub2e8\ucd95\uc2dc\ud0ac \uc218 \uc788\ub2e4.\n<\/li>\n<\/ul>\n

                      \n <\/p>\n

                      ALTER SESSION SET SORT_AREA_SIZE = XXXX;\n<\/p>\n

                      (byte\ub2e8\uc704\ub85c \uac12\uc744 \uc9c0\uc815\ud55c\ub2e4.)\n<\/p>\n

                      \n <\/p>\n

                        \n
                      1. \n

                        \n\t\t\t\t<\/span> <\/div>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

                        DBMS_STATS \uc0ac\uc6a9     \uac1c\uc694 Oracle8\uae4c\uc9c0\ub294 \ud14c\uc774\ube14, \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0dd\uc131\ud558\uae30 \uc704\ud574 \u300eANALYZE\u300f \uba85\ub839\ub9cc\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc5c8\uc73c\ub098 Oracle8i \ubd80\ud130\ub294 \u300eANALYZE\u300f \uba85\ub839 \uc678\uc5d0\u300eDBMS_STATS\u300fPackage\ub97c \uc81c\uacf5\ud55c\ub2e4. ANALYZE\uba85\ub839\uc744 \uc0ac\uc6a9\ud560 \uacbd\uc6b0\uc5d0\ub294 \uc2e0\uaddc\ub85c \uc0dd\uc131\ud55c \ud1b5\uacc4\uc815\ubcf4\uac00 \uc131\ub2a5\uc800\ud558\ub97c \uc720\ubc1c\uc2dc\ud0a4\ub354\ub77c\ub3c4 \uc774\uc804\uacfc \uac19\uc740 \ud1b5\uacc4\uc815\ubcf4\ub97c \ucd94\ucd9c\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub2e4\uc2dc ANALYZE \uc791\uc5c5\uc744 \uc218\ud589\ud574\uc57c \ub418\uae30 \ub54c\ubb38\uc5d0 \ud14c\uc774\ube14\uc758 \ud06c\uae30\uac00 \ud074 \uacbd\uc6b0 \ub9ce\uc740 \uc2dc\uac04\uc744 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0dd\uc131\ud558\ub294\ub370 \uc18c\ube44\ud558\uac8c \ub41c\ub2e4. \ub610\ud55c \uc77c\ubd80 Partitioned […]<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[326,161,709,134,162],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1297"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1297"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1297\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1297"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}