{"id":713,"date":"2015-11-24T06:01:48","date_gmt":"2015-11-24T06:01:48","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=713"},"modified":"2015-11-24T06:01:48","modified_gmt":"2015-11-24T06:01:48","slug":"%ec%9d%b8%eb%8d%b1%ec%8a%a4-%eb%a6%ac%eb%b9%8c%eb%93%9cindex-rebuild-%eb%9e%80","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=713","title":{"rendered":"\uc778\ub371\uc2a4 \ub9ac\ube4c\ub4dc(Index Rebuild) \ub780"},"content":{"rendered":"

0.<\/span><\/p>\n

\uc778\ub371\uc2a4\ub294 \uc0ac\uc6a9\uc790\uac00 \uc784\uc758\uc801\uc73c\ub85c \uc0dd\uc131 \ubcc0\uacbd\uc774 \uac00\ub2a5\ud55c \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc5d0 \uc800\uc7a5\uac00\ub2a5\ud55c \ubb3c\ub9ac\uc801\uc778 \uad6c\uc870\uc785\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc778\ub371\uc2a4\ub294 \ub2e8\uc21c\ud558\uac8c \uc0c9\uc778\uc774\ub77c\ub294 \uac1c\ub150\uc5d0 \uc55e\uc11c \uc635\ud2f0\ub9c8\uc774\uc800\uac00 \uc2e4\ud589\uacc4\ud68d\uc744 \uc218\ub9bd\ud560 \ub54c \ucd5c\uc801\uc758 \uacbd\ub85c\ub97c \ucc3e\ub3c4\ub85d \ud558\ub294 ‘\uc804\ub7b5\uc801 \uc694\uc18c’\ub77c\ub294 \uc2dc\uac01\uc5d0\uc11c \uc811\uadfc\ud558\uc5ec\uc57c \ud569\ub2c8\ub2e4. \uc778\ub371\uc2a4\uac00 \uc874\uc7ac\ud558\uc9c0 \uc54a\ub294 \ub2e4\uba74 \ud14c\uc774\ube14\uc5d0\uc11c \ud589\ub4e4\uc740 \ud2b9\uc815\ud55c \uc21c\uc11c\uc5d0 \ub530\ub974\uc9c0 \uc54a\uace0 \uc800\uc7a5\ub429\ub2c8\ub2e4.<\/span><\/p>\n

\ud589\uc774 \ucc98\uc74c \uc0bd\uc785\ub420 \ub54c \uc0ac\uc6a9\uc790\ub294 \ud589\uc774 \ubcf4\uad00\ub420 \ubb3c\ub9ac\uc801\uc778 \uc704\uce58\ub97c \uc120\ud0dd\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uc774\uac83\uc740 \ud14c\uc774\ube14\uc5d0\uc11c \ud2b9\uc815\ud55c \ud589\uc744 \ucc3e\uae30 \uc704\ud574\uc11c\ub294 \ucc3e\uace0\uc790 \ud558\ub294 \ud589\uc744 \ub9cc\ub0a0 \ub54c\uae4c\uc9c0 \uc21c\ucc28\uc801\uc73c\ub85c \uac80\uc0c9\ud574\uc57c \ud568\uc744 \uc758\ubbf8\ud558\uae30\ub3c4 \ud569\ub2c8\ub2e4. \ub610\ud55c, \uc9c0\uc815\ud55c \uc870\uac74\uc5d0 \uc77c\uce58\ud558\ub294 \ud589\uc744 \ucc3e\uc558\ub2e4\uace0 \ud574\ub3c4 \ud14c\uc774\ube14\uc758 \ub17c\ub9ac\uc801\uc778 \ub05d\uc5d0 \ub3c4\ub2ec\ud558\uae30 \uc804\uae4c\uc9c0\ub294 \uac80\uc0c9\uc744 \uba48\ucd9c \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uc77c\uce58\ud558\ub294 \ud589\uc744 \ucc3e\uc558\ub2e4\uace0 \ud574\ub3c4 \uc870\uac74\uc5d0 \ub9de\ub294 \ud589\uc774 \ub354 \uc774\uc0c1 \uc5c6\ub2e4\ub294 \ud655\uc2e0\uc774 \uc5c6\uae30 \ub54c\ubb38\uc5d0 \uacc4\uc18d \uac80\uc0c9\ud558\uac8c \ub429\ub2c8\ub2e4.<\/span><\/p>\n

<\/span><\/p>\n

\uc774\uc640 \uac19\uc740 \uc815\ubcf4\uc758 \uac80\uc0c9 \ubc29\uc2dd\uc744 \uc644\uc804 \ud14c\uc774\ube14 \uac80\uc0c9(full table scan)\uc774\ub77c \ubd80\ub974\uba70, \uc644\uc804 \ud14c\uc774\ube14 \uac80\uc0c9\uc744 \uc218\ud589\ud558\uae30 \uc704\ud574\uc11c\ub294 \ud558\uc774 \uc6cc\ud130\ub9c8\ud06c(high water mark)\ub77c \ubd88\ub9ac\ub294 \ud14c\uc774\ube14\uc758 \ub17c\ub9ac\uc801 \ub05d\uc5d0 \uc774\ub97c \ub54c\uae4c\uc9c0 \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \ube14\ub85d\uc744 \ub85c\ub4dc\ud558\uace0 \uc77d\uc5b4\uc57c \ud569\ub2c8\ub2e4. <\/span><\/p>\n

\uc778\ub371\uc2a4\uc758 \ud6a8\uc728\uc131\uc744 \uc704\ud574 \ud14c\uc774\ube14\uc5d0 \uc0c8\ub85c\uc6b4 \ud589\uc744 \uc0bd\uc785\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc778\ub371\uc2a4\uc5d0\ub3c4 \ub300\uc751\ub418\ub294 \ud56d\ubaa9\uc744 \ucd94\uac00\ud574\uc57c \ud569\ub2c8\ub2e4. \uc989, \ud55c \ubc88\uc774 \uc544\ub2cc \ub450 \ubc88\uc758 \uc0bd\uc785 \uc791\uc5c5\uc774 \ud544\uc694\ud558\ub2e4\ub294 \uac83\uc774\uba70, \uacb0\uacfc\uc801\uc73c\ub85c \uc778\ub371\uc2a4\uc758 \uc874\uc7ac \ub54c\ubb38\uc5d0 \uc0bd\uc785 \uc791\uc5c5\uc758 \uc18d\ub3c4\uac00 \ub5a8\uc5b4\uc9c0\uba70 \uc0bd\uc785 \uc791\uc5c5\ubfd0\ub9cc \uc544\ub2c8\ub77c \uc778\ub371\uc2a4\uc5d0 \uc601\ud5a5\uc744 \uc8fc\ub294 \uac31\uc2e0\uc774\ub098 \uc0ad\uc81c \uc791\uc5c5\uc5d0\ub3c4 \uc5ed\uc2dc \uc778\ub371\uc2a4\ub97c \ucd5c\uc2e0\uc758 \uac83\uc73c\ub85c \uc720\uc9c0\ud558\ub294 \ubd80\uac00\uc801\uc778 \ucc98\ub9ac\uac00 \ud544\uc694\ud558\uac8c \ub429\ub2c8\ub2e4. \uc989, \uc77c\ubc18\uc801\uc73c\ub85c \uc778\ub371\uc2a4\ub294 DML(INSERT, UPDATE, DELETE, \ucffc\ub9ac)\uc744 \ub290\ub9ac\uac8c \ub9cc\ub4e4\uae30 \ub54c\ubb38\uc5d0 \ud6a8\uc728\uc801\uc778 \uc778\ub371\uc2a4 \uc0ac\uc6a9\uc744 \uc704\ud574 \uc778\ub371\uc2a4\ub97c \uacfc\uc6a9\ud558\uc9c0 \ub9d0\uc544\uc57c \ud569\ub2c8\ub2e4.<\/span><\/p>\n

\ud14c\uc774\ube14\ub85c\uc758 \ud589\uc774 insert \ub418\ub294 \uac83\uc740 \uc778\ub371\uc2a4 \uad6c\uc870\uc5d0 \uc0c1\ub2f9\ud55c \ubcc0\ud654\uac00 \uc0dd\uae41\ub2c8\ub2e4. \uc778\ub371\uc2a4 \uad6c\uc870\uc778 \ud2b8\ub9ac \uacc4\uce35\uc758 \uc704\ucabd\uc73c\ub85c\ub3c4 \uad6c\uc870\ub97c \ubcc0\ud654\uc2dc\ucf1c \uc778\ub371\uc2a4\uc758 \ub192\uc774\ub97c \uc99d\uac00\uc2dc\ud0a4\uace0 \uc131\ub2a5\uc744 \uac10\uc18c\uc2dc\ud0a4\uae30\ub3c4 \ud569\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c\ub294 \uc778\ub371\uc2a4\uc758 \ud6a8\uc728\uc744 \ub5a8\uc5b4\ub728\ub9ac\ub294 \uac83\uc740 \uc778\ub371\uc2a4\uc758 \ub192\uc774\ubcf4\ub2e4\ub294 \uc778\ub371\uc2a4 \ub0b4\uc758 \ubcc0\ud654 \uc790\uccb4\uc640 \ubd80\uac00\uc801\uc778 \ube14\ub85d\uc744 \uc5bb\ub294 \uacfc\uc815\uc785\ub2c8\ub2e4. <\/span><\/p>\n

\ud14c\uc774\ube14\uc758 DML\uc791\uc5c5\uc73c\ub85c \uc778\ud55c \ub370\uc774\ud130 \uac31\uc2e0\uc740 \uc778\ub371\uc2a4 \uac31\uc2e0\uc73c\ub85c \uc774\uc5b4\uc9c0\uc9c0 \uc54a\uc73c\ubbc0\ub85c \uc778\ub371\uc2a4\uc758 \ucd5c\ud558\uc704 \uacc4\uce35 \ub178\ub4dc(Leaf)\uc758 \uc704\uce58\ub294 \ub300\ubd80\ubd84 \uc798\ubabb\ub41c \uc0c1\ud0dc\ub85c \ub0a8\uaca8\uc9c0\uac8c \ub429\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc6d0\ub798\uc758 \ud56d\ubaa9\uc744 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\ub3c4\ub85d \ud45c\uc2dc\ud558\uace0, \uc0c8\ub85c\uc6b4 \ud56d\ubaa9\uc744 \uc801\uc808\ud55c \uc704\uce58\uc5d0 \uc0bd\uc785\ud558\ub294 \uacfc\uc815\uc774 \ud544\uc694\ud558\uac8c \ub429\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uacfc\uc815\uc744 \uc778\ub371\uc2a4 \ub9ac\ube4c\ub4dc\ub77c\uace0 \ud569\ub2c8\ub2e4. <\/span><\/p>\n

<\/p>\n

1. <\/span><\/p>\n

1) Index Offline Rebuild <\/span><\/p>\n

-Rebuild<\/span>\uac00 \uc774\ub8e8\uc5b4\uc9c0\ub294 \ub3d9\uc548 DML blocking <\/span><\/p>\n

-Rebuild<\/span>\uac00 \uc644\ub8cc\ub420 \ub54c\uae4c\uc9c0 \ucd94\uac00\uc801\uc778 \uacf5\uac04 \ud544\uc694(<\/span>\uae30\uc874 Index+ <\/span>\uc2e0\uaddc Index)<\/span><\/p>\n

-Sparse<\/span>\uac00 \ub192\uace0 \ud06c\uae30\uac00 \ud070
\nIndex<\/span>\uc5d0 \ub300\ud55c Rebuild <\/span>\uc131\ub2a5\uc740 \uac00\uc7a5 \uc6b0\uc218<\/span><\/p>\n<\/p>\n

 *
\nSparse<\/span>\ub780 <\/span><\/span>\uc778\ub371\uc2a4 \ube14\ub85d \uc804\ubc18\uc5d0 \uac78\uccd0 \ubc00\ub3c4(density)<\/span>\uac00 \ub5a8\uc5b4\uc9c0\ub294 \ud604\uc0c1\uc744 \ub9d0\ud569\ub2c8\ub2e4.<\/span><\/span><\/p>\n

<\/span>
<\/span><\/span><\/p>\n

<\/p>\n


<\/span><\/span><\/span><\/p>\n

2) Index Online Rebuild(E.E <\/span>\uc9c0\uc6d0) <\/span><\/p>\n

– PK, UK<\/span>\ub294 \uc81c\uc57d\uc870\uac74\uc73c\ub85c \uc778\ud574 \uc778\ub371\uc2a4 \ub9ac\ube4c\ub4dc\uc5d0\uc11c \uc81c\uc678\ub428<\/span><\/p>\n

– Rebuild<\/span>\uac00 \uc774\ub8e8\uc5b4\uc9c0\ub294 \ub3d9\uc548 DML <\/span>\ud5c8\uc6a9(<\/span>\ub2e8, <\/span>\ucd5c\ucd08
\n\uc791\uc5c5\uacfc \ucd5c\uc885 \uc791\uc5c5 \ub2e8\uacc4\uc758 \uc9e7\uc740 \uc2dc\uac04 \ub3d9\uc548 DML Blocking <\/span>\ubc1c\uc0dd\uac00\ub2a5)<\/span><\/p>\n

– Rebuild<\/span>\uac00 \uc644\ub8cc\ub420 \ub54c\uae4c\uc9c0 \ucd94\uac00\uc801\uc778 \uacf5\uac04 \ud544\uc694(<\/span>\uae30\uc874 Index+ <\/span>\uc2e0\uaddc Index)<\/span><\/p>\n

– Offline Rebuild<\/span>\uc5d0 \ube44\ud574 \uc131\ub2a5\uc740 \uc88b\uc9c0 \uc54a\uc74c(Full table Scan, Journal Table, Merge)<\/span><\/p>\n

<\/span><\/p>\n

<\/p>\n

<\/p>\n

2. <\/p>\n

1) Sparse Index \uc870\ud68c \ucffc\ub9ac<\/p>\n

\n

 (sparse Index <\/span>\uc870\ud68c \ucffc\ub9ac<\/span>)<\/span><\/p>\n

 <\/span><\/p>\n

select \/* ordered *\/<\/span><\/p>\n

u.name  “Owner”,<\/span><\/p>\n

o.name  “Index”,<\/span><\/p>\n

  op.subname 
\n“Partition”,<\/span><\/p>\n

 
\ndecode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,o.subname,”)
\n“SubPartition”,<\/span><\/p>\n

  (1-<\/span><\/p>\n

floor(decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.leafcnt,ip.obj#,ip.leafcnt,i.lea<\/span><\/p>\n

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

          –<\/span><\/p>\n

decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.rowcnt
\n,ip.obj#,ip.rowcnt ,i.rowcnt<\/span><\/p>\n

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

          *(sum(h.avgcln)+10)<\/span><\/p>\n

          \/((p.value-66-<\/span><\/p>\n

decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.initrans,ip.obj#,ip.initrans,i.initrans<\/span><\/p>\n

)*24)<\/span><\/p>\n

          
\n*(1-decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.pctfree<\/span><\/p>\n

$,ip.obj#,ip.pctfree$,i.pctfree$)\/100))<\/span><\/p>\n

         
\n)\/decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.leafcnt,ip.obj#,ip.leafcnt,<\/span><\/p>\n

i.leafcnt))
\n“Density”,<\/span><\/p>\n

  <\/span><\/p>\n

floor(decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.leafcnt,ip.obj#,ip.leafcnt,i.lea<\/span><\/p>\n

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

       –<\/span><\/p>\n

decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.rowcnt
\n,ip.obj#,ip.rowcnt ,i.rowcnt<\/span><\/p>\n

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

       *(sum(h.avgcln) + 10)<\/span><\/p>\n

       \/((p.value-66-<\/span><\/p>\n

decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.initrans,ip.obj#,ip.initrans,i.initrans<\/span><\/p>\n

)*24)<\/span><\/p>\n

       
\n*(1-decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.pctfree<\/span><\/p>\n

$,ip.obj#,ip.pctfree$,i.pctfree$)\/100)))
\n“Extra.Block”<\/span><\/p>\n

from<\/span><\/p>\n

  sys.ind$ 
\ni,<\/span><\/p>\n

  sys.icol$ 
\nic,<\/span><\/p>\n

  ( select
\nobj#,part#,bo#,ts#,rowcnt,leafcnt,initrans,pctfree$,analyzetime,flags from <\/span><\/p>\n

sys.indpart$<\/span><\/p>\n

    union all<\/span><\/p>\n

    select <\/span><\/p>\n

obj#,part#,bo#,defts#,rowcnt,leafcnt,definitrans,defpctfree,analyzetime,flags
\nfrom <\/span><\/p>\n

sys.indcompart$<\/span><\/p>\n

  ) ip,<\/span><\/p>\n

  sys.indsubpart$ isp,<\/span><\/p>\n

  ( select ts#,blocksize value from sys.ts$<\/span><\/p>\n

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

  sys.hist_head$  h,<\/span><\/p>\n

  sys.obj$  
\no,<\/span><\/p>\n

sys.user$  u,<\/span><\/p>\n

  sys.obj$ 
\nop<\/span><\/p>\n

where
\ni.obj# = ip.bo#(+)<\/span><\/p>\n

  and ip.obj# = isp.pobj#(+)<\/span><\/p>\n

  and <\/span><\/p>\n

decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.leafcnt,ip.obj#,ip.leafcnt,i.leafcnt)<\/span><\/p>\n

> 1<\/span><\/p>\n

  and i.type# in (1)  \/* exclude special types *\/<\/span><\/p>\n

  and i.pctthres$ is null  \/* exclude IOT secondary indexes *\/<\/span><\/p>\n

  and decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.ts#,ip.obj#,ip.ts#,i.ts#)
\n= <\/span><\/p>\n

p.ts#<\/span><\/p>\n

  and ic.obj# = i.obj#<\/span><\/p>\n

  and h.obj# = i.bo#<\/span><\/p>\n

  and h.intcol# = ic.intcol#<\/span><\/p>\n

and o.obj# = nvl(isp.obj#,nvl(ip.obj#,i.obj#))<\/span><\/p>\n

  and o.owner# != 0<\/span><\/p>\n

  and u.user# = o.owner#<\/span><\/p>\n

  and op.obj# = nvl(ip.obj#,i.obj#)<\/span><\/p>\n

  and u.name not in <\/span><\/p>\n

(‘SYS’,’SYSTEM’,’SYSMAN’,’XDB’,’HR’,’ODM’,’OUTLN’,’OE’,’SH’,’PM’,’SYSAUX’,’IX’,’WK_T<\/span><\/p>\n

EST’,’PERFSTAT’,’DBSNMP’,’OLAPSYS’,’QS_CS’,’QS_CB’,’QS_CBADM’,’QS_OS’,’QS_WS’,’<\/span><\/p>\n

QS’,’QS_ADM’,’ODM_MTR’
\n,’WKPROXY’,’QS_ES’,’ANONYMOUS’,’WKSYS’,’WMSYS’,’A<\/span><\/p>\n

PEX_<\/span><\/p>\n

030200′,’APEX_PUBLIC_USER’,’APPQOSSYS’,’BI’,’CTXSYS’,’DIP’,’EXFSYS’,’FLOWS_FILES’<\/span><\/p>\n

,’MDDATA’,’MDSYS’,’MGMT_VIEW’,’ORACLE_OCM’,’ORDDATA’,’ORDPLUGINS’,’ORDS<\/span><\/p>\n

YS’,’OWBSYS’,’OWBSYS_AUDIT’,’SCOTT’,’SI_INFORMTN_SCHEMA’,’SPATIAL_CSW_AD<\/span><\/p>\n

MIN_USR’,’SPATIAL_WFS_ADMIN_USR’,’XS$NULL’)<\/span><\/p>\n

group
\nby<\/span><\/p>\n

  u.name,<\/span><\/p>\n

  o.name,<\/span><\/p>\n

  op.subname,<\/span><\/p>\n

 
\ndecode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,o.subname,”),<\/span><\/p>\n

  <\/span><\/p>\n

decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.rowcnt
\n,ip.obj#,ip.rowcnt ,i.rowcnt<\/span><\/p>\n

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

  <\/span><\/p>\n

decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.leafcnt,ip.obj#,ip.leafcnt,i.leafcnt),<\/span><\/p>\n

  <\/span><\/p>\n

decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.initrans,ip.obj#,ip.initrans,i.initrans<\/span><\/p>\n

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

decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.pctfree$,ip.obj#,ip.pctfree<\/span><\/p>\n

$,i.pctfree$),<\/span><\/p>\n

  p.value<\/span><\/p>\n

having<\/span><\/p>\n

(1-<\/span><\/p>\n

floor(decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.leafcnt,ip.obj#,ip.leafcnt,i.lea<\/span><\/p>\n

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

          –<\/span><\/p>\n

decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.rowcnt
\n,ip.obj#,ip.rowcnt ,i.rowcnt<\/span><\/p>\n

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

          *(sum(h.avgcln)+10)<\/span><\/p>\n

          \/((p.value-66-<\/span><\/p>\n

decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.initrans,ip.obj#,ip.initrans,i.initrans<\/span><\/p>\n

)*24)<\/span><\/p>\n

          
\n*(1-decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.pctfree<\/span><\/p>\n

$,ip.obj#,ip.pctfree$,i.pctfree$)\/100))<\/span><\/p>\n

          )\/decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.leafcnt,ip.obj#,ip.leafcnt,<\/span><\/p>\n

i.leafcnt)<\/span><\/p>\n

  ) <= 0.75<\/b><\/span><\/p>\n

  And<\/span><\/p>\n

floor(decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.leafcnt,ip.obj#,ip.leafcnt,i.lea<\/span><\/p>\n

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

       –<\/span><\/p>\n

decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.rowcnt,ip.obj#,ip.rowcnt,i.rowcnt)<\/span><\/p>\n

       *(sum(h.avgcln) + 10)<\/span><\/p>\n

       \/((p.value-66-<\/span><\/p>\n

decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.initrans,ip.obj#,ip.initrans,i.initrans<\/span><\/p>\n

)*24)<\/span><\/p>\n

       
\n*(1-decode(nvl(isp.obj#,nvl(ip.obj#,i.obj#)),isp.obj#,isp.pctfree<\/span><\/p>\n

$,ip.obj#,ip.pctfree$,i.pctfree$)\/100))<\/span><\/p>\n

) > 1000<\/b><\/span><\/p>\n

order
\nby 6 desc,5<\/span><\/p>\n

\/<\/span><\/p>\n<\/div>\n

<\/p>\n

2) Index rebuild \uba85\ub839\uc5b4<\/span><\/p>\n

SQL>Alter
\nindex ‘owner.Index_name’ rebuild; <– <\/span>\uae30\ubcf8 \uad6c\ubb38<\/p>\n

\uc791\uc5c5\uc774 \uc644\ub8cc\ub41c \ud6c4 sparse Index \uc870\ud68c\ud558\ub294 \ucffc\ub9ac\ub97c \uc218\ud589\ud574\uc11c \ub300\uc0c1 Index \uac00 \uc870\ud68c \ub418\ub294 \uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.<\/p>\n

\ub610\ub294 \ubcfc\ub4dc\uccb4 \ubd80\ubd84\uc758 \uc218\uce58\ub97c \uc870\uc815\ud558\uc5ec \uc870\ud68c\ub97c \ud574\ubd05\ub2c8\ub2e4<\/span>.<\/span><\/p>\n


<\/span><\/p>\n

<\/p>\n

<\/p>\n


<\/span><\/p>\n

<\/p>\n

<\/span><\/span><\/p>\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

0. \uc778\ub371\uc2a4\ub294 \uc0ac\uc6a9\uc790\uac00 \uc784\uc758\uc801\uc73c\ub85c \uc0dd\uc131 \ubcc0\uacbd\uc774 \uac00\ub2a5\ud55c \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc5d0 \uc800\uc7a5\uac00\ub2a5\ud55c \ubb3c\ub9ac\uc801\uc778 \uad6c\uc870\uc785\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc778\ub371\uc2a4\ub294 \ub2e8\uc21c\ud558\uac8c \uc0c9\uc778\uc774\ub77c\ub294 \uac1c\ub150\uc5d0 \uc55e\uc11c \uc635\ud2f0\ub9c8\uc774\uc800\uac00 \uc2e4\ud589\uacc4\ud68d\uc744 \uc218\ub9bd\ud560 \ub54c \ucd5c\uc801\uc758 \uacbd\ub85c\ub97c \ucc3e\ub3c4\ub85d \ud558\ub294 ‘\uc804\ub7b5\uc801 \uc694\uc18c’\ub77c\ub294 \uc2dc\uac01\uc5d0\uc11c \uc811\uadfc\ud558\uc5ec\uc57c \ud569\ub2c8\ub2e4. \uc778\ub371\uc2a4\uac00 \uc874\uc7ac\ud558\uc9c0 \uc54a\ub294 \ub2e4\uba74 \ud14c\uc774\ube14\uc5d0\uc11c \ud589\ub4e4\uc740 \ud2b9\uc815\ud55c \uc21c\uc11c\uc5d0 \ub530\ub974\uc9c0 \uc54a\uace0 \uc800\uc7a5\ub429\ub2c8\ub2e4. \ud589\uc774 \ucc98\uc74c \uc0bd\uc785\ub420 \ub54c \uc0ac\uc6a9\uc790\ub294 \ud589\uc774 \ubcf4\uad00\ub420 \ubb3c\ub9ac\uc801\uc778 \uc704\uce58\ub97c \uc120\ud0dd\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uc774\uac83\uc740 […]<\/p>\n","protected":false},"author":1,"featured_media":714,"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":[11],"tags":[399,400],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile26.uf.224230455653FA30263D0A.jpg?fit=561%2C251","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/713"}],"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=713"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/713\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/714"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=713"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=713"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}