{"id":429,"date":"2015-09-03T01:01:27","date_gmt":"2015-09-03T01:01:27","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=429"},"modified":"2015-09-03T01:01:27","modified_gmt":"2015-09-03T01:01:27","slug":"%eb%b0%94%ec%9d%b8%eb%93%9c-%eb%b3%80%ec%88%98-peeking-%eb%aa%b0%eb%9e%98-%ec%97%bf%eb%b3%b4%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=429","title":{"rendered":"\ubc14\uc778\ub4dc \ubcc0\uc218 Peeking ( \ubab0\ub798 \uc5ff\ubcf4\uae30 )"},"content":{"rendered":"

Oracle9i Online Document<\/span>\uc5d0\uc11c New Feature<\/span>\ub97c \uc870\ud68c\ud574 \ubcf4\uba74 \uc544\ub798\uc640 \uac19\uc774
\nBind Variable Peeking<\/span>\uc5d0 \ub300\ud574 \uc18c\uac1c \ud569\ub2c8\ub2e4.<\/span><\/p>\n

<\/p>\n
\n

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


\nPeeking of User-Defined Bind Variables
\nThe CBO peeks at the values of user-defined bind variables on the first
\ninvocation of a cursor. This feature lets the optimizer determine the
\nselectivity of any WHERE clause condition, as well as if literals have been
\nused instead of bind variables. On subsequent invocations of the cursor, no
\npeeking takes place, and the cursor is shared, based on the standard
\ncursor-sharing criteria, even if subsequent invocations use different bind
\nvalues. <\/span><\/p>\n

When bind variables are used in a statement, it is
\nassumed that cursor sharing is intended and that different invocations are
\nsupposed to use the same execution plan. If different invocations of the cursor
\nwould significantly benefit from different execution plans, then bind variables
\nmay have been used inappropriately in the SQL statement.<\/span><\/p>\n

<\/p>\n
\n

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


\n<\/span>\uc774 \uae30\ub2a5\uc744 \uc774\ud574\ud558\uae30 \uc804\uc5d0 \uc6b0\uc120 \uc54c\uc544\uc57c \ud560 \uc0ac\ud56d\uc774 \uc788\uc2b5\ub2c8\ub2e4. <\/span><\/span><\/p>\n

Bind Variable<\/span>\uc744 \uc0ac\uc6a9\ud55c SQL<\/span>\uc740 \uba3c\uc800 \ud30c\uc2f1(Parsing)<\/span>\uacfc \ucd5c\uc801\ud654(Optimization)<\/span>\uac00 \uc774\ub8e8\uc5b4\uc9c4 \ud6c4\uc5d0
\n\ubc14\uc778\ub4dc \ubcc0\uc218\uc758 \ubc14\uc778\ub529\uc774 \uc774\ub8e8\uc5b4\uc9c4\ub2e4\ub294 \uc0ac\uc2e4\uc785\ub2c8\ub2e4.<\/span><\/p>\n

\ub530\ub77c\uc11c \ucd5c\uc801\ud654\uac00 \uc774\ub8e8\uc5b4\uc9c0\ub294 \uc2dc\uc810\uc5d0\ub294 \ubcc0\uc218\ub85c \uc81c\uacf5\ub418\ub294 \uceec\ub7fc\uc758
\n\ubd84\ud3ec\uac00 \uade0\uc77c\ud558\ub2e4\ub294 \uac00\uc815\uc744 \uc138\uc6b4 \ud6c4\uc5d0 \ucd5c\uc801\ud654\ub97c \uc218\ud589\ud558\uac8c \ub418\uace0 <\/span>\ubd84\ud3ec\uac00 \uade0\uc77c\ud558\uc9c0 \ubabb\ud55c \uceec\ub7fc(highly skewed column)<\/span>\uc5d0 \ubc14\uc778\ub4dc \ubcc0\uc218\ub97c \uc0ac\uc6a9\ud558\uac8c \ub418\uba74 \ucd5c\uc545\uc758 \uc2e4\ud589\uacc4\ud68d\uc744 \uc0dd\uc131\ud558\uac8c \ub429\ub2c8\ub2e4.<\/span><\/p>\n

\uadf8\ub798\uc11c, <\/span>\uc6b0\ub9ac\uac00
\nHard Parsing<\/span>\uc758 \ubd80\ud558\ub97c \uc904\uc774\uae30 \uc704\ud574 Bind Variable<\/span>\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc88b\ub2e4\ub294
\n\uac83\uc744 \uc54c\uba74\uc11c\ub3c4 \uc0ac\uc2e4\uc0c1 \ub370\uc774\ud130\uc758 \ubd84\ud3ec\uac00 \uace0\ub974\uc9c0 \ubabb\ud55c \uacbd\uc6b0\uac00 \ub9ce\uae30 \ub54c\ubb38\uc5d0 \ud604\uc2e4\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\uae30 \uc5b4\ub824\uc6b4 \uacbd\uc6b0\uac00 \uc885\uc885 \uc788\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

\uc774\ub7ec\ud55c \ud55c\uacc4\ub97c \uadf9\ubcf5\ud558\uae30 \uc704\ud574 Oracle 9i<\/span>\ubd80\ud130 \uc81c\uacf5\ub418\uae30 \uc2dc\uc791\ud55c \uac83\uc774 “Peeking”<\/span>\uc774\ub77c\ub294 \uae30\ub2a5\uc785\ub2c8\ub2e4.
\n‘Peek’<\/span>\ub77c\ub294 \uc6a9\uc5b4\ub97c \uc0ac\uc804\uc5d0\uc11c \ucc3e\uc544\ubcf4\uba74 “<\/span>\ubab0\ub798 \uc5ff\ubcf4\ub2e4“<\/span>\ub77c\ub294 \ub73b\uc744 \uac16\ub294\ub370, <\/span>\uc704 \uc6d0\ubb38\uc744 \uc694\uc57d\ud574 \ubcf4\uba74 \uc774\ub807\uc2b5\ub2c8\ub2e4. <\/span><\/span>Bind Variable<\/span>\uc744 \uc0ac\uc6a9\ud55c SQL<\/span>\uc774 \uccab\ubc88\uc9f8 \uc2e4\ud589\ub420 \ub54c SQL <\/span>\uc635\ud2f0\ub9c8\uc774\uc800\ub294 \uc0ac\uc6a9\uc790\uac00 \uc9c0\uc815\ud55c \ubc14\uc778\ub4dc \ubcc0\uc218\uc758 \uac12\uc744 “<\/span>\uc0b4\uc9dd
\n\ucee8\ub2dd“<\/span>\ud568\uc73c\ub85c\uc368, <\/span>\uc870\uac74\uc808\uc758 \uceec\ub7fc\uac12\uc774 \uc0c1\uc218\ub85c \uc81c\uacf5\ub420
\n\ub54c\uc640 \ub9c8\ucc2c\uac00\uc9c0\ub85c \ud574\ub2f9 \uc870\uac74\uc758 \uc120\ud0dd\uc131(selectivity, \u203b Unique <\/span>\uc778\ub371\uc2a4\ub97c \uac16\ub294 \uceec\ub7fc\uc758 \uc120\ud0dd\uc131\uc774
\n\uac00\uc7a5 \ub192\ub2e4.)<\/span>\uc744 \ud655\uc778\ud55c \ud6c4\uc5d0 \ucd5c\uc801\ud654\ub97c \uc218\ud589\ud55c\ub2e4\ub294 \uc598\uae30\uc774\ub2e4. <\/span>\uadf8\ub9ac\uace0
\n\ub098\uc11c \ucee4\uc11c\uac00 \ub2e4\uc74c \ubc88\uc5d0 \uacc4\uc18d \uc2e4\ud589\ub420 \ub54c\uc5d0\ub294 \ubcc0\uc218\ub97c \ub2e4\ub978 \uac12\uc73c\ub85c \ubc14\uc778\ub529\ud558\ub354\ub77c\ub3c4 \ub354 \uc774\uc0c1 peeking<\/span>\uc774
\n\ubc1c\uc0dd\ud558\uc9c0 \uc54a\uc73c\uba70 \uc55e\uc5d0\uc11c \uc0dd\uc131\ub41c \uc2e4\ud589\uacc4\ud68d\uc744 \uadf8\ub300\ub85c \uc0ac\uc6a9\ud55c\ub2e4\ub294 \uac83\uc774\ub2e4. <\/span>\uc989, <\/span>\ucd5c\ucd08 Hard Parsing<\/span>\uc774 \uc77c\uc5b4\ub0a0 \ub54c \ub2e8 \ud55c\ubc88\ub9cc Bind Variable<\/span>\uc744 Peeking<\/span>\ud55c\ub2e4\ub294 \uc124\uba85\uc774\uace0, <\/span>\ub2e4\uc2dc \ub9d0\ud574\uc11c <\/span>\uccab\ubc88\uc9f8 Binding <\/span>\ub418\ub294 \uac12\uc5d0 \ub530\ub77c SQL Plan<\/span>\uc774 \uace0\uc815<\/span><\/b>\ub41c\ub2e4\ub294 \uac83\uc778\ub370, <\/span>\uc774\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uac1c\ubc1c\ud558\ub294 \uc785\uc7a5\uc5d0\uc11c \ub9e4\uc6b0 \uc911\uc694\ud55c
\n\ud2b9\uc9d5\uc785\ub2c8\ub2e4.<\/span><\/p>\n


<\/font><\/p>\n


<\/font><\/p>\n

— \ud14c\uc2a4\ud2b8<\/font><\/p>\n


<\/font><\/p>\n

\uc5b4\ub5a4 \ud559\uad50\uc758 \ud559\uc810 \ud14c\uc774\ube14\uc774 \uc544\ub798\uc640 \uac19\uc774 \ub3fc \uc788\ub2e4\uace0 \uac00\uc815\ud558\uba74<\/span><\/p>\n\n\n\n\n\n\n\n\n
<\/p>\n

\ud559\uc810<\/span><\/span><\/p>\n<\/td>\n

<\/p>\n

\uc2dc\uc791\uc810\uc218<\/span><\/span><\/p>\n<\/td>\n

<\/p>\n

\uc885\ub8cc\uc810\uc218<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

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

\n

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

\n

100<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

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

\n

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

\n

90<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

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

\n

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

\n

80<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

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

\n

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

\n

70<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

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

\n

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

\n

60<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

SQL> create table <\/span>\ud559\uc810\ud14c\uc774\ube14
\n  2  as
\n  3  select ‘A’ <\/span>\ud559\uc810, 91 <\/span>\uc2dc\uc791\uc810\uc218, 100 <\/span>\uc885\ub8cc\uc810\uc218 from dual union all
\n  4  select ‘B’, 81, 90 from dual union all
\n  5  select ‘C’, 71, 80 from dual union all
\n  6  select ‘D’, 61, 70 from dual union all
\n  7  select ‘F’,  0, 60 from dual
\n  8  \/<\/span><\/span><\/span><\/p>\n

\ud14c\uc774\ube14\uc774 \uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\uadf8\ub9ac\uace0 ‘<\/span>\ud559\uc0dd‘ <\/span>\ud14c\uc774\ube14\uc740 \ud559\ubc88, <\/span>\uc774\ub984, <\/span>\ud559\uc810\uc73c\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\ub294\ub370,
\n<\/span>\uc774 \uc911 \ub300\ubd80\ubd84\uc758 \ud559\uc0dd\uc774 ‘B’<\/span>\ud559\uc810\uc5d0 \uc18d\ud55c\ub2e4\uace0 \uac00\uc815\ud558\uace0 \uc544\ub798\uc640 \uac19\uc774 \uac00\uc0c1\uc73c\ub85c \ud14c\uc774\ube14\uc744 \uc0dd\uc131<\/span><\/p>\n

SQL> select object_type, count(*)
\n  2  from all_objects
\n  3  group by object_type
\n  4  order by 2
\n  5  \/<\/span><\/span><\/p>\n

OBJECT_TYPE         
\nCOUNT(*)
\n—————— ———-
\nEVALUATION CONTEXT         
\n1  —-> ‘A’
\nCONSUMER
\nGROUP             
\n2  —-> ‘C’
\nSEQUENCE                   
\n2  —-> ‘D’
\nINDEX                      
\n5  —-> ‘F’
\nINDEXTYPE                  
\n9  -+
\nLIBRARY                   
\n14   |
\nPROCEDURE                 
\n14   |
\nOPERATOR                  
\n28   |
\nTABLE                     
\n53   |
\nFUNCTION                  
\n90   |–> ‘B’
\nJAVA
\nRESOURCE            
\n184   |
\nPACKAGE                  
\n267   |
\nTYPE                     
\n536   |
\nVIEW                    
\n1102   |
\nJAVA CLASS              
\n9654   |
\nSYNONYM                
\n11540  -+<\/span><\/span><\/p>\n

16 <\/span>\uac1c\uc758 \ud589\uc774 \uc120\ud0dd\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

SQL> create table <\/span>\ud559\uc0dd
\n  2  as
\n  3  select object_id    <\/span>\ud559\ubc88
\n  4       , object_name  <\/span>\uc774\ub984
\n  5       , decode( object_type
\n  6           ,
\n‘EVALUATION CONTEXT’, ‘A’
\n  7           ,
\n‘CONSUMER GROUP’,     ‘C’
\n  8           ,
\n‘SEQUENCE’,           ‘D’
\n  9           ,
\n‘INDEX’,             
\n‘F’, ‘B’ ) <\/span>\ud559\uc810
\n 10  from all_objects
\n 11  \/<\/span><\/span><\/span><\/p>\n

\ud14c\uc774\ube14\uc774 \uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

SQL> alter table <\/span>\ud559\uc0dd add
\n  2  constraint pk_<\/span>\ud559\uc0dd primary key (<\/span>\ud559\ubc88)
\n  3  \/<\/span><\/span><\/span><\/p>\n

\ud14c\uc774\ube14\uc774 \ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

SQL> create index <\/span>\ud559\uc0dd_<\/span>\ud559\uc810_IDX on <\/span>\ud559\uc0dd(<\/span>\ud559\uc810);<\/span><\/span><\/span><\/p>\n

\uc778\ub371\uc2a4\uac00 \uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

SQL> analyze table <\/span>\ud559\uc0dd compute statistics
\n  2  for table for all indexes for all indexed columns
\n  3  \/<\/span><\/span><\/span><\/p>\n

\ud14c\uc774\ube14\uc774 \ubd84\uc11d\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

\ud14c\uc2a4\ud2b8\ub97c \uacc4\uc18d \uc9c4\ud589\ud558\uae30\uc5d0 \uc55e\uc11c <\/span>\uacb0\uacfc\ub97c \uba85\ud655\ud788 \ud558\uae30 \uc704\ud574 \uc6b0\uc120 shared pool<\/span>\uc744 \ube44\uc6cc\uc57c \ud569\ub2c8\ub2e4.<\/p>\n

<\/span><\/span>SQL> alter
\nsystem flush shared_pool;<\/span><\/span><\/p>\n

\uc2dc\uc2a4\ud15c\uc774 \ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

SQL> alter session set sql_trace = true;<\/span><\/span><\/p>\n

\uc138\uc158\uc774 \ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/p>\n

\uc774\uc81c \ud559\uc810 ‘A’<\/span>\uc5d0 \ub300\ud574 \uc544\ub798\uc640 \uac19\uc774 SQL<\/span>\uc744 \uc2e4\ud589\ud55c
\n\ud6c4 Trace <\/span>\uacb0\uacfc\ub97c \ud655\uc778\ud574 \ubcf4\uba74 \uc778\ub371\uc2a4\ub97c \ud1b5\ud55c \ud14c\uc774\ube14 \uc561\uc138\uc2a4\uac00 \ubc1c\uc0dd\ud55c \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n

<\/span><\/span>SQL> select
\ncount(*), min(<\/span>\ud559\ubc88)
\n  2  from   <\/span>\ud559\uc0dd
\n  3  where  <\/span>\ud559\uc810 = ‘A’;<\/span><\/span><\/span><\/p>\n

  COUNT(*)  MIN(<\/span>\ud559\ubc88)
\n———- ———-
\n        
\n1       5847<\/span><\/span><\/span><\/p>\n

Rows     Row Source
\nOperation
\n——-  —————————————————
\n      1  SORT AGGREGATE
\n      1   TABLE ACCESS BY INDEX ROWID <\/span>\ud559\uc0dd
\n      1    INDEX RANGE SCAN <\/span>\ud559\uc0dd_<\/span>\ud559\uc810_IDX (object id 30510)<\/span><\/span><\/span><\/p>\n

\uc774\uc81c \ub370\uc774\ud130 \ubc00\ub3c4\uac00 \uad49\uc7a5\ud788 \ub192\uc740 \uc989, <\/span>\uc120\ud0dd\uc131\uc774 \ub9e4\uc6b0 \ub0ae\uc740 \ud559\uc810 ‘B’<\/span>\uc5d0 \ub300\ud574 \uc544\ub798\uc640 \uac19\uc774 SQL<\/span>\uc744 \uc2e4\ud589\ud55c \ud6c4 Trace <\/span>\uacb0\uacfc\ub97c \ud655\uc778\ud574 \ubcf4\uba74 Table Full Scan<\/span>\uc73c\ub85c \ucc98\ub9ac\ub41c
\n\uac83\uc73c\ub85c \ud655\uc778<\/span><\/p>\n

SQL> select count(*), min(<\/span>\ud559\ubc88)
\n  2  from   <\/span>\ud559\uc0dd
\n  3  where  <\/span>\ud559\uc810 = ‘B’;<\/span><\/span><\/span><\/p>\n

  COUNT(*)  MIN(<\/span>\ud559\ubc88)
\n———- ———-
\n    
\n23491          4<\/span><\/span><\/span><\/p>\n

Rows     Row Source
\nOperation
\n——-  —————————————————
\n      1  SORT AGGREGATE
\n  23491   TABLE ACCESS FULL <\/span>\ud559\uc0dd<\/span> <\/span><\/p>\n

\uc774\ub807\uac8c \uc0c1\uc218\uc870\uac74\uc744 \uc0ac\uc6a9\ud560 \uacbd\uc6b0\uc5d0\ub294 \uc6b0\ub9ac\uac00 \uc608\uc0c1\ud588\ub358 \ubc14\ub300\ub85c, <\/span>\uc8fc\uc5b4\uc9c0\ub294 \uac12\uc758 \uc885\ub958\uc5d0 \ub530\ub77c \uc2e4\ud589\uacc4\ud68d\uc774
\n\ubc14\ub00c\uba74\uc11c \ud6a8\uc728\uc801\uc73c\ub85c \ucc98\ub9ac\ub418\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

\uc774\uc81c, Bind Variable<\/span>\uc744 \uc0ac\uc6a9\ud560 \uacbd\uc6b0\uc5d0\ub294 \uc5b4\ub5bb\uac8c \uc2e4\ud589\uacc4\ud68d\uc774 \ub9cc\ub4e4\uc5b4\uc9c0\ub294\uc9c0 \ud655\uc778<\/span><\/p>\n

SQL> variable x varchar2(1)
\nSQL> exec \ud83d\ude21 := ‘A’<\/span><\/span><\/p>\n

PL\/SQL <\/span>\ucc98\ub9ac\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

SQL> declare
\n  2    l_<\/span>\ud559\uc0dd\uc218  number;
\n  3    l_<\/span>\ud559\ubc88    <\/span>\ud559\uc0dd.<\/span>\ud559\ubc88%type;
\n  4  begin
\n  5    select count(*), min(<\/span>\ud559\ubc88)
\ninto l_<\/span>\ud559\uc0dd\uc218, l_<\/span>\ud559\ubc88
\n  6    from   <\/span>\ud559\uc0dd
\n  7    where  <\/span>\ud559\uc810 = :x;
\n  8  end;
\n  9  \/<\/span><\/span><\/span><\/p>\n

PL\/SQL <\/span>\ucc98\ub9ac\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

SQL> exec \ud83d\ude21 := ‘B’<\/span><\/span><\/p>\n

PL\/SQL <\/span>\ucc98\ub9ac\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

SQL> declare
\n  2    l_<\/span>\ud559\uc0dd\uc218  number;
\n  3    l_<\/span>\ud559\ubc88    <\/span>\ud559\uc0dd.<\/span>\ud559\ubc88%type;
\n  4  begin
\n  5    select count(*), min(<\/span>\ud559\ubc88)
\ninto l_<\/span>\ud559\uc0dd\uc218, l_<\/span>\ud559\ubc88
\n  6    from   <\/span>\ud559\uc0dd
\n  7    where  <\/span>\ud559\uc810 = :x;
\n  8  end;
\n  9  \/<\/span><\/span><\/span><\/p>\n

PL\/SQL<\/span> <\/span>\ucc98\ub9ac\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

SQL Trace <\/span>\uacb0\uacfc
\n<\/span><\/span>********************************************************************************<\/span><\/span><\/p>\n

SELECT count(*), min(<\/span>\ud559\ubc88) from   <\/span>\ud559\uc0dd
\n  where  <\/span>\ud559\uc810 = :b1<\/span><\/span><\/span><\/p>\n

call    
\ncount       cpu   
\nelapsed       disk     
\nquery    current        rows
\n——- ——  ——– ———- ———- ———- ———- 
\n———-
\nParse        1     
\n0.00      
\n0.00         
\n0          0         
\n0           0
\nExecute      1     
\n0.01      
\n0.00         
\n0         
\n0         
\n0           0
\nFetch        1     
\n0.00      
\n0.00         
\n0         
\n5         
\n0           1
\n——- ——  ——– ———- ———- ———- ———- 
\n———-
\ntotal        3     
\n0.01      
\n0.00         
\n0          5         
\n0           1<\/span><\/span><\/p>\n

Misses
\nin library cache during parse: 1<\/span><\/b>
\nOptimizer goal: CHOOSE
\nParsing user id: 61     (recursive depth: 1)<\/span><\/span><\/p>\n

Rows     Row Source
\nOperation
\n——-  —————————————————
\n      1  SORT AGGREGATE
\n      1   TABLE ACCESS BY INDEX ROWID <\/span>\ud559\uc0dd
\n      1    INDEX RANGE SCAN <\/span>\ud559\uc0dd_<\/span>\ud559\uc810_IDX (object id 30510)
\n    
\n********************************************************************************
\n    
\nSELECT count(*), min(<\/span>\ud559\ubc88) from   <\/span>\ud559\uc0dd
\n  where  <\/span>\ud559\uc810 = :b1<\/span><\/span><\/span><\/p>\n

call    
\ncount       cpu   
\nelapsed       disk     
\nquery    current        rows
\n——- ——  ——– ———- ———- ———- ———- 
\n———-
\nParse        1     
\n0.01      
\n0.00         
\n0          0         
\n0           0
\nExecute      1     
\n0.00      
\n0.00         
\n0         
\n0         
\n0           0
\nFetch        1     
\n0.08      
\n0.08         
\n0       
\n195         
\n0           1
\n——- ——  ——– ———- ———- ———- ———- 
\n———-
\ntotal        3     
\n0.09      
\n0.08         
\n0        195         
\n0           1<\/span><\/span><\/p>\n

Misses
\nin library cache during parse: 0<\/span><\/b>
\nOptimizer goal: CHOOSE
\nParsing user id: 61     (recursive depth: 1)<\/span><\/span><\/p>\n

Rows     Row Source
\nOperation
\n——-  —————————————————
\n      1  SORT AGGREGATE
\n  23491   TABLE ACCESS BY INDEX ROWID <\/span>\ud559\uc0dd
\n  23491    INDEX RANGE SCAN <\/span>\ud559\uc0dd_<\/span>\ud559\uc810_IDX (object id 30510)
\n    
\n********************************************************************************<\/span><\/span><\/span><\/p>\n

\ubc14\uc778\ub4dc \ubcc0\uc218\ub97c ‘B’<\/span>\ub85c \uc7ac\ud560\ub2f9\ud55c \ud6c4 \ub450\ubc88\uc9f8 \uc2e4\ud589\ud55c \uacbd\uc6b0\uc5d0\ub3c4 \ucd5c\ucd08 ‘A’<\/span>\ub97c \uc2e4\ud589\ud560 \ub54c\uc640 \ub611\uac19\uc774 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucc98\ub9ac\ub418\uc5c8\uc2b5\ub2c8\ub2e4. <\/span><\/span><\/p>\n

\uc8fc\ubaa9\ud574\uc11c
\n\ubcf4\uc544\uc57c \ud560 \uc810\uc740 \uccab\ubc88\uc9f8 \uc2e4\ud589\uc2dc\uc5d0\ub294 Hard Parse <\/span>\ud69f\uc218\uac00 1<\/span>\uc774\uace0
\n\ub450\ubc88\uc9f8 \uc2e4\ud589\uc2dc\uc5d0\ub294 0<\/span>\uc774\ub77c\ub294 \uac83\uc778\ub370, <\/span>\uc774\ub97c \ud1b5\ud574 \uc635\ud2f0\ub9c8\uc774\uc800\ub294 Hard Parse<\/span>\uc2dc\uc5d0\ub9cc peeking<\/span>\uc744 \uc218\ud589\ud558\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.\ucc38\uace0\ub85c, tkprof <\/span>\uc0ac\uc6a9\uc2dc aggregate=no <\/span>\uc635\uc158\uc744
\n\uc0ac\uc6a9\ud574\uc57c \uc774\ub807\uac8c \ubcc4\ub3c4\ub85c \ubd84\ub9ac\ub41c Trace <\/span>\uacb0\uacfc\ub97c \uc5bb\uc744 \uc218 \uc788\ub2e4.<\/span><\/span><\/p>\n

\ub2e4\uc2dc Shared Pool<\/span>\uc744 \ube44\uc6b0\uace0, <\/span>\uc774\ubc88\uc5d0\ub294 ‘B’–>’A’ <\/span>\uc21c\uc73c\ub85c \ubc14\uc778\ub529\ubcc0\uc218\uc758 \uac12\uc744 \ubc14\uafb8\uba74\uc11c \uac19\uc740 SQL<\/span>\uc744
\n\uc2e4\ud589\uc2dc\ucf1c \ubcf4\uc790. <\/span><\/span><\/p>\n

SQL> alter system flush shared_pool;<\/span><\/span><\/p>\n

\uc2dc\uc2a4\ud15c\uc774 \ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

SQL> exec \ud83d\ude21 := ‘B’<\/span><\/span><\/p>\n

PL\/SQL <\/span>\ucc98\ub9ac\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

SQL> declare
\n  2    l_<\/span>\ud559\uc0dd\uc218  number;
\n  3    l_<\/span>\ud559\ubc88    <\/span>\ud559\uc0dd.<\/span>\ud559\ubc88%type;
\n  4  begin
\n  5    select count(*), min(<\/span>\ud559\ubc88)
\ninto l_<\/span>\ud559\uc0dd\uc218, l_<\/span>\ud559\ubc88
\n  6    from   <\/span>\ud559\uc0dd
\n  7    where  <\/span>\ud559\uc810 = :x;
\n  8  end;
\n  9  \/<\/span><\/span><\/span><\/p>\n

PL\/SQL <\/span>\ucc98\ub9ac\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

SQL> exec \ud83d\ude21 := ‘A’<\/span><\/span><\/p>\n

PL\/SQL <\/span>\ucc98\ub9ac\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

SQL> declare
\n  2    l_<\/span>\ud559\uc0dd\uc218  number;
\n  3    l_<\/span>\ud559\ubc88    <\/span>\ud559\uc0dd.<\/span>\ud559\ubc88%type;
\n  4  begin
\n  5    select count(*), min(<\/span>\ud559\ubc88)
\ninto l_<\/span>\ud559\uc0dd\uc218, l_<\/span>\ud559\ubc88
\n  6    from   <\/span>\ud559\uc0dd
\n  7    where  <\/span>\ud559\uc810 = :x;
\n  8  end;
\n  9  \/<\/span><\/span><\/span><\/p>\n

PL\/SQL <\/span>\ucc98\ub9ac\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

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

SELECT count(*), min(<\/span>\ud559\ubc88) from   <\/span>\ud559\uc0dd
\n  where  <\/span>\ud559\uc810 = :b1<\/span><\/span><\/span><\/p>\n

call    
\ncount       cpu   
\nelapsed       disk     
\nquery    current        rows
\n——- ——  ——– ———- ———- ———- ———- 
\n———-
\nParse        1     
\n0.01      
\n0.00         
\n0          0         
\n0           0
\nExecute      1     
\n0.01      
\n0.00         
\n0         
\n0         
\n0           0
\nFetch        1     
\n0.04      
\n0.03         
\n0        147         
\n0           1
\n——- ——  ——– ———- ———- ———- ———- 
\n———-
\ntotal        3     
\n0.06      
\n0.05         
\n0        147         
\n0           1<\/span><\/span><\/p>\n

Misses
\nin library cache during parse: 1<\/span><\/b>
\n<\/span><\/b>Optimizer goal:
\nCHOOSE
\nParsing user id: 61     (recursive depth: 1)<\/span><\/span><\/p>\n

Rows     Row Source
\nOperation
\n——-  —————————————————
\n      1  SORT AGGREGATE
\n  23491   TABLE ACCESS FULL <\/span>\ud559\uc0dd <\/span><\/span><\/p>\n

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

SELECT count(*), min(<\/span>\ud559\ubc88) from   <\/span>\ud559\uc0dd
\n  where  <\/span>\ud559\uc810 = :b1<\/span><\/span><\/span><\/p>\n

call    
\ncount       cpu   
\nelapsed       disk     
\nquery    current        rows
\n——- ——  ——– ———- ———- ———- ———- 
\n———-
\nParse        1     
\n0.00      
\n0.00          0         
\n0         
\n0           0
\nExecute      1     
\n0.00      
\n0.00         
\n0         
\n0         
\n0           0
\nFetch        1     
\n0.02      
\n0.02         
\n0        147         
\n0           1
\n——- ——  ——– ———- ———- ———- ———- 
\n———-
\ntotal        3     
\n0.02      
\n0.02         
\n0        147         
\n0           1<\/span><\/span><\/p>\n

Misses
\nin library cache during parse: 0<\/span><\/b>
\nOptimizer goal: CHOOSE
\nParsing user id: 61     (recursive depth: 1)<\/span><\/span><\/p>\n

Rows     Row Source
\nOperation
\n——-  —————————————————
\n      1  SORT AGGREGATE
\n      1   TABLE ACCESS FULL <\/span>\ud559\uc0dd <\/span><\/span><\/p>\n

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

\uc774\ubc88\uc5d0\ub294 \uc55e\uc5d0\uc11c\uc758 \ud14c\uc2a4\ud2b8\uc640 \ubc18\ub300\ub85c \uccab\ubc88\uc9f8 \uc2e4\ud589\uc5d0 ‘B’<\/span>\ub97c \uc0ac\uc6a9\ud558\uc600\uae30 \ub54c\ubb38\uc5d0 Table Full Scan<\/span>\uc73c\ub85c \ucc98\ub9ac\ub418\uc5c8\uace0 \uc774\ud6c4\uc5d0 \uc5b4\ub5a4 \uac12\uc73c\ub85c \ubc14\uc778\ub529\ub418\ub354\ub77c\ub3c4 \uac19\uc740 \uc2e4\ud589\uacc4\ud68d\uc73c\ub85c \ucc98\ub9ac\ub41c \uac83\uc744 \ud655\uc778\ud560
\n\uc218 \uc788\ub2e4.<\/span><\/span><\/p>\n

\uc774\ucc98\ub7fc Bind Variable Peeking <\/span>\uae30\uc220\uc774 \ub3c4\uc785\ub428\uc73c\ub85c\uc368, <\/span>\uceec\ub7fc\uc758 \uc2e4\uc9c8\uc801\uc778 \ubd84\ud3ec\ub97c \uace0\ub824\ud558\uc9c0 \uc54a\uace0 \ud3c9\uade0\uac12\uc744 \uc774\uc6a9\ud558\ub294 \uae30\uc874 \ucd5c\uc801\ud654 \ubc29\uc2dd\uc758 \ud55c\uacc4\ub97c \uc77c\ubd80 \uadf9\ubcf5\ud588\ub2e4\uace0 \ubcfc \uc218 \uc788\uc73c\ub098
\n\ube44\ud6a8\uc728\uc758 \uac00\ub2a5\uc131\uc744 \uc5ec\uc804\ud788 \uc548\uace0 \uc788\ub2e4\ub294 \uc0ac\uc2e4\uc744 \ub208\uc73c\ub85c \ud655\uc778\ud560 \uc218 \uc788\uc5c8\ub2e4.<\/span><\/span><\/p>\n

\uc774\uc81c, <\/span>\uc774\ub7ec\ud55c \uae30\ub2a5\uc744 \uc5b4\ub5bb\uac8c \uc798 \uc0ac\uc6a9\ud574\uc11c \uac00\uc7a5 \ud6a8\uacfc\uc801\uc774\uace0 \ud6a8\uc728\uc801\uc778 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uac1c\ubc1c\ud560\uc9c0\ub294
\n\uc624\ub77c\ud074 \uc0ac\uc6a9\uc790 \uc989, <\/span>\uac1c\ubc1c\uc790\uc758 \ubaab\uc778 \uac83\uc774\ub2e4.
\n<\/span>\uc635\ud2f0\ub9c8\uc774\uc800 \uc6d0\ub9ac\uc5d0 \ub300\ud574 \uc870\uae08\uc774\ub77c\ub3c4 \uad00\uc2ec\uc744 \uac00\uc9c0\uace0 \uacf5\ubd80\ud55c \uac1c\ubc1c\uc790\ub77c\uba74 \ub204\uad6c\ub098 \uc54c\uace0 \uc788\ub294 \uc0ac\uc2e4\uc774 \ud558\ub098 \uc788\ub2e4. <\/span>\uc774\uc804\uc5d0 \uc2e4\ud589\ub41c SQL<\/span>\uacfc \uc77c\uc810\uc77c\ud68d\uc774\ub77c\ub3c4 \ub2e4\ub978 \ubd80\ubd84\uc774 \uc788\ub2e4\uba74 SQL <\/span>\uc635\ud2f0\ub9c8\uc774\uc800\ub294 \uc774\uac83\uc744 \ub2e4\ub978 SQL<\/span>\ub85c \uac04\uc8fc\ud558\uace0 \uc0c8\ub85c\uc6b4 \uc2e4\ud589\uacc4\ud68d\uc744
\n\uc791\uc131\ud55c\ub2e4\ub294 \uac83\uc778\ub370, <\/span>\uc774\uc810\uc744 \uc774\uc6a9\ud574 Bind Variable
\nPeeking<\/span>\uc774 \uac16\ub294 \ud55c\uacc4\ub97c \uadf9\ubcf5\ud574 \ubcf4\uc790.<\/span><\/span><\/p>\n

SQL> create or replace function getdata(
\np_<\/span>\ud559\uc810 varchar2 ) return
\nvarchar2
\n  2  as
\n  3    l_<\/span>\ud559\ubc88    <\/span>\ud559\uc0dd.<\/span>\ud559\ubc88%type;
\n  4    l_<\/span>\ud559\uc0dd\uc218  number;
\n  5  begin
\n  6    if(p_<\/span>\ud559\uc810 = ‘B’)
\n  7    then
\n  8      select count(*), min(<\/span>\ud559\ubc88) into l_<\/span>\ud559\uc0dd\uc218, l_<\/span>\ud559\ubc88
\n  9      from   <\/span>\ud559\uc0dd <\/span>B_TYPE<\/span><\/b>
\n 10      where  <\/span>\ud559\uc810 = p_<\/span>\ud559\uc810;
\n 11    else
\n 12      select count(*), min(<\/span>\ud559\ubc88) into l_<\/span>\ud559\uc0dd\uc218, l_<\/span>\ud559\ubc88
\n 13      from   <\/span>\ud559\uc0dd <\/span>OTHER_TYPE<\/span><\/b>
\n 14      where  <\/span>\ud559\uc810 = p_<\/span>\ud559\uc810;
\n 15    end if;
\n 16    return l_<\/span>\ud559\uc0dd\uc218 || ‘<\/span>\uba85 , <\/span>\ucd5c\uc18c\ud559\ubc88‘ || l_<\/span>\ud559\ubc88;
\n 17  end;
\n 18  \/<\/span><\/span><\/span><\/p>\n

\ud568\uc218\uac00 \uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

SQL> begin
\n  2    for l_cursor in (select <\/span>\ud559\uc810 from <\/span>\ud559\uc810\ud14c\uc774\ube14)
\n  3    loop
\n  4      dbms_output.put_line( l_cursor.<\/span>\ud559\uc810 || ‘ : ‘ ||
\n 
\n5                          
\n getdata(l_cursor.<\/span>\ud559\uc810) );
\n  6    end loop;
\n  7  end;
\n  8  \/
\nA : 1<\/span>\uba85 , <\/span>\ucd5c\uc18c\ud559\ubc885847
\nB : 23491<\/span>\uba85 , <\/span>\ucd5c\uc18c\ud559\ubc884
\nC : 2<\/span>\uba85 , <\/span>\ucd5c\uc18c\ud559\ubc883844
\nD : 2<\/span>\uba85 , <\/span>\ucd5c\uc18c\ud559\ubc88140
\nF : 5<\/span>\uba85 , <\/span>\ucd5c\uc18c\ud559\ubc883<\/span><\/span><\/span><\/p>\n

PL\/SQL <\/span>\ucc98\ub9ac\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/span><\/p>\n

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


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

SELECT count(*), min(<\/span>\ud559\ubc88) from   <\/span>\ud559\uc0dd
\n<\/span>OTHER_TYPE<\/span>
\n    where  <\/span>\ud559\uc810 = :b1<\/span><\/span><\/span><\/p>\n

call    
\ncount       cpu   
\nelapsed       disk     
\nquery    current        rows
\n——- ——  ——– ———- ———- ———- ———- 
\n———-
\nParse        1     
\n0.00      
\n0.00         
\n0          0         
\n0           0
\nExecute      4     
\n0.00      
\n0.00         
\n0         
\n0         
\n0           0
\nFetch        4     
\n0.01      
\n0.00         
\n0         60         
\n0           4
\n——- ——  ——– ———- ———- ———- ———- 
\n———-
\ntotal        9     
\n0.01      
\n0.00         
\n0         60         
\n0           4<\/span><\/span><\/p>\n

Misses in library cache during parse: 1
\nOptimizer goal: CHOOSE
\nParsing user id: 61     (recursive depth: 1)<\/span><\/span><\/p>\n

Rows     Row Source
\nOperation
\n——-  —————————————————
\n      1  SORT AGGREGATE
\n      5   TABLE ACCESS BY INDEX ROWID <\/span>\ud559\uc0dd
\n      5    INDEX RANGE SCAN <\/span>\ud559\uc0dd_<\/span>\ud559\uc810_IDX (object id 30510)<\/span><\/span><\/span><\/p>\n

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

SELECT count(*), min(<\/span>\ud559\ubc88) from   <\/span>\ud559\uc0dd
\n<\/span>B_TYPE
\n<\/span>   
\nwhere  <\/span>\ud559\uc810
\n= :b1<\/span><\/span><\/span><\/p>\n

call    
\ncount       cpu   
\nelapsed       disk     
\nquery    current        rows
\n——- ——  ——– ———- ———- ———- ———- 
\n———-
\nParse        1     
\n0.00      
\n0.00         
\n0          0         
\n0           0
\nExecute      1     
\n0.01      
\n0.00         
\n0         
\n0         
\n0           0
\nFetch        1     
\n0.04      
\n0.04         
\n0        147         
\n0           1
\n——- ——  ——– ———- ———- ———- ———- 
\n———-
\ntotal        3     
\n0.05      
\n0.04         
\n0        147         
\n0           1<\/span><\/span><\/p>\n

Misses in library cache during parse: 1
\nOptimizer goal: CHOOSE
\nParsing user id: 61     (recursive depth: 1)<\/span><\/span><\/p>\n


\n<\/span>Rows    
\nRow Source Operation
\n——-  —————————————————
\n      1  SORT AGGREGATE
\n  23491   TABLE ACCESS FULL <\/span>\ud559\uc0dd <\/span><\/span><\/p>\n

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

\ucc38\uace0\ub85c, <\/span>\uc5ec\uae30\uc11c\ub294 \ud14c\uc774\ube14 Alias<\/span>\uc744 \uc774\uc6a9\ud574\uc11c \uc2e4\ud589\uc744
\n\ubd84\ub9ac\ud588\ub294\ub370 \uc8fc\uc11d( \/* *\/ )<\/span>\uc744 \uc774\uc6a9\ud574\ub3c4 \uac19\uc740 \ud6a8\uacfc\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/p>\n

\ud55c\uac00\uc9c0 \ub354 \uc54c\uc544 \ub450\uc5b4\uc57c \ud560 \uc810\uc740, EXPLAIN PLAN FOR … <\/span>\uba85\ub839\uc5b4\ub97c \ud1b5\ud574 Bind Variable<\/span>\uc758 \uc2e4\ud589\uacc4\ud68d\uc744 \uc0ac\uc804\uc5d0 \ud655\uc778\ud558\ub824\uace0 \ud560 \ub54c\uc5d0\ub294 \uc635\ud2f0\ub9c8\uc774\uc800\uac00
\npeeking <\/span>\ud574 \ubcfc \uc218 <\/span>\uc788\ub294 \ubcc0\uc218\uac12\uc774 \uc81c\uacf5\ub418\uc9c0 <\/span>\uc54a\uae30
\n\ub54c\ubb38\uc5d0 \ud560 \uc218 \uc5c6\uc774 \ud3c9\uade0 \ubd84\ud3ec\ub97c \uac00\uc815\ud55c \uc2e4\ud589\uacc4\ud68d\uc744 \uc81c\uc2dc\ud558\uac8c \ub429\ub2c8\ub2e4. <\/span>\ub530\ub77c\uc11c Bind Variable Peeking<\/span>\uc774 \uc0ac\uc6a9\ub418\ub294\uc9c0 \uc5ec\ubd80\uc5d0 \ub300\ud55c \uc2e4\uc9c8\uc801\uc778 \uacb0\uacfc\ub97c <\/span>\ud655\uc778\ud560 <\/span>\uc218 \uc5c6\uace0,
\n<\/span>\ubc18\ub4dc\uc2dc SQL Trace <\/span>\uacb0\uacfc\ub97c \ud1b5\ud574\uc11c\ub9cc \uc815\ud655\ud55c \uacb0\uacfc\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<\/p>\n

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

Oracle9i Online Document\uc5d0\uc11c New Feature\ub97c \uc870\ud68c\ud574 \ubcf4\uba74 \uc544\ub798\uc640 \uac19\uc774 Bind Variable Peeking\uc5d0 \ub300\ud574 \uc18c\uac1c \ud569\ub2c8\ub2e4. Peeking of User-Defined Bind Variables The CBO peeks at the values of user-defined bind variables on the first invocation of a cursor. This feature lets the optimizer determine the selectivity of any WHERE clause condition, as well as if literals […]<\/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":[11],"tags":[189,190,191],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/429"}],"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=429"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/429\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=429"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}