{"id":3784,"date":"2018-04-18T14:22:18","date_gmt":"2018-04-18T05:22:18","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3784"},"modified":"2018-04-18T14:22:18","modified_gmt":"2018-04-18T05:22:18","slug":"oracle-db-18c-%ec%83%88%eb%a1%9c-%eb%82%98%ec%98%a8-%ea%b8%b0%eb%8a%a5-%ec%a0%95%eb%a6%ac","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3784","title":{"rendered":"Oracle DB 18c \uc0c8\ub85c \ub098\uc628 \uae30\ub2a5 \uc815\ub9ac"},"content":{"rendered":"

1. Oracle Data Guard \ub2e4\uc911 \uc778\uc2a4\ud134\uc2a4 \uc7ac\uc2e4\ud589 \uc801\uc6a9\uc740 RMAN \ubc31\uc5c5\uc744 \uc704\ud55c \ube14\ub85d \ubcc0\uacbd \ucd94\uc801 \ud30c\uc77c \uc0ac\uc6a9\uc744 \uc9c0\uc6d0<\/strong>
\n<\/span><\/p>\n

Multiple-Instance Redo Apply (MIRA) \uc740 \uc774\uc81c BCT (\ube14\ub85d \ubcc0\uacbd \ucd94\uc801) \ubc31\uc5c5\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

\uc774\uac83\uc740 \ud6a8\uacfc\uc801\uc778 \uc99d\ubd84 \ubc31\uc5c5 \ubc29\uc2dd\uc758 \ub300\uc6a9\ub7c9 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc774\uba70 \ub9c8\uc2a4\ud130 \uc640 \uc2ac\ub808\uc774\ube0c\uac00 \ubaa8\ub450 RAC \uc774\uba70 \uc774\ub7ec\ud55c \uc885\ub958\uc758 DB \ud658\uacbd\uc5d0\uc11c \uc2ac\ub808\uc774\ube0c \uc5d0\uc11c \ubc31\uc5c5\uc774 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

2. Data Guard \ud658\uacbd Stand by \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c Nologging \ube14\ub85d\uc758 \uc790\ub3d9 \uc218\uc815 \uc9c0\uc6d0<\/strong>
\n<\/span><\/p>\n

\ub450 \uac00\uc9c0 \uc0c8\ub85c\uc6b4 \ub300\uae30 \ub85c\uae45 \ubaa8\ub4dc\uac00 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4 (\uc8fc\ub85c \uae30\ubcf8 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub85c\ub529 \ub370\uc774\ud130 \uc18d\ub3c4 \ud5a5\uc0c1).
\n<\/span><\/p>\n

\ud558\ub098\ub294 \ubaa8\ub4e0 \ub300\uae30\uac00 \ub370\uc774\ud130\ub97c \uc801\uc6a9 \ud560 \ub54c\uae4c\uc9c0 \ub85c\ub529 \uc791\uc5c5 \ud655\uc57d\uc774 \uc9c0\uc5f0\ub418\ub294 \ub370\uc774\ud130 \uac00\uc6a9\uc131\uc744\uc704\ud55c \ub300\uae30 Nologging\uc785\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

SQL> ALTER DATABASE SET STANDBY NOLOGGING FOR DATA AVAILABILITY;
\n<\/strong><\/span><\/p>\n

 <\/p>\n

\ud558\ub098\ub294 \ubd80\ud558 \uc131\ub2a5\uc744 \uc704\ud55c \ub300\uae30 Nologging\uc785\ub2c8\ub2e4. \uc774 \ubaa8\ub4dc\ub294 \uc774\uc804 \ubaa8\ub4dc\uc640 \uc720\uc0ac\ud558\uc9c0\ub9cc \ub370\uc774\ud130 \ub85c\ub4dc \uc911 \ub124\ud2b8\uc6cc\ud06c \ubcd1\ubaa9 \ud604\uc0c1\uc774 \ubc1c\uc0dd\ud558\uba74 \ub370\uc774\ud130\ub97c \uc804\uc1a1\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\uc774\ub807\uac8c \ud558\uba74 \ub85c\ub4dc \uc131\ub2a5\uc740 \ubcf4\uc7a5\ub418\uc9c0\ub9cc \uae30\ubcf8 \ub370\uc774\ud130\uc5d0\uc11c \ub2e4\uc2dc \uc5bb\uc744 \uc218 \uc788\ub294 \ub370\uc774\ud130\ub294 \uc190\uc2e4 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

SQL> ALTER DATABASE SET STANDBY NOLOGGING FOR LOAD PERFORMANCE;
\n<\/strong><\/span><\/p>\n

 <\/p>\n

3. Shadow Lost Write Protection (\uc0e4\ub529)<\/strong>
\n<\/span><\/p>\n

\ub370\uc774\ud130 \ubcf4\ud638\ub97c \uc81c\uacf5\ud558\ub294 Shadow \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub97c \uc0dd\uc131 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/span><\/p>\n

\uc774 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uba74 \ucd94\uac00 \uc190\uc2e4 \uae30\ub85d \ubc29\uc9c0 \uae30\ub2a5\uc744 \uc81c\uacf5\ud558\uae30 \uc704\ud574 ADG\uac00 \ud544\uc694\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\uc774 \uae30\ub2a5\uc740 MySQL\uc758 Double Write \uc640 \uac19\uc740 \uae30\ub2a5\uc785\ub2c8\ub2e4.
\n<\/span><\/p>\n

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

4. CDB \ub85c\uc758 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ud6c4\uc5d0 Non-CDB\uc758 \ubc31\uc5c5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/strong>
\n<\/span><\/p>\n

\uae30\ubcf8\uc801\uc778 Non-CDB \ub294 \uc774 \uc0c8\ub85c\uc6b4 \uae30\ub2a5\uc73c\ub85c PDB\uac00 \uc874\uc7ac\ud558\ub294 CDB \ud658\uacbd\uc73c\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

5. \ub2e4\uc591\ud55c PDB \ub4e4\uc744 \uc704\ud55c Shards and Catalogs \uc9c0\uc6d0<\/strong>
\n<\/span><\/p>\n

oracle pdb\ub294 \uacf5\uc720 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ub2e8\uc77c cdb\uc5d0\uc11c \ub2e8\uc77c pdb \ub9cc \uc9c0\uc6d0\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

6. User-Defined\u00a0Sharding\u00a0Method \uc9c0\uc6d0<\/strong>
\n<\/span><\/p>\n

\uc774 \uae30\ub2a5\uc740 Oracle 12.2\uc758 Beta \ubc84\uc804\uc5d0 \ub4f1\uc7a5\ud588\uc9c0\ub9cc \uacf5\uc2dd 12.2 \ub9b4\ub9ac\uc2a4\uc5d0\uc11c\ub294 \ucde8\uc18c\ub418\uc5c8\uc2b5\ub2c8\ub2e4. 18c \uc5d0\uc11c \ub2e4\uc2dc \uacf5\uac1c\ub418\uc5c8\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

7. Consistency Levels for Multi-Shard Queries<\/strong>
\n<\/span><\/p>\n

MULTISHARD_QUERY_DATA_CONSISTENCY \ucd08\uae30\ud654 \ub9e4\uac1c \ubcc0\uc218\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

\uc2e4\ud589 \uc804\uc5d0 \uc2ac\ub77c\uc774\uc2a4 \uc804\ubc18\uc5d0 \uac78\uccd0 \uc2ac\ub77c\uc774\uc2a4\ub97c \ubd84\ud560\ud558\ub294 \ub3d9\uc548 SCN \ub3d9\uae30\ud654\ub97c \ud53c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4
\n<\/span><\/p>\n

 <\/p>\n

8. Manual termination of run-away queries<\/strong>
\n<\/span><\/p>\n

\uc774\uc81c\u00a0<\/span>\uc138\uc158\uc744<\/span> KILL <\/span>\ud558\uc9c0\u00a0<\/span>\uc54a\uace0\u00a0<\/span>\uba85\ub839\ubb38\uc744\u00a0<\/span>\uc218\ub3d9\uc73c\ub85c\u00a0<\/span>\uc885\ub8cc\u00a0<\/span>\ud560\u00a0<\/span>\uc218\u00a0<\/span>\uc788\uc2b5\ub2c8\ub2e4<\/span>. <\/span>:
\n<\/span><\/span><\/p>\n

 <\/p>\n

ALTER SYSTEM CANCEL SQL.
\n<\/strong><\/span><\/p>\n

ALTER SYSTEM CANCEL SQL ‘SID, SERIAL, @INST_ID, SQL_ID’ ;
\n<\/strong><\/span><\/p>\n

 <\/p>\n

9. Approximate Top-N Query Processing<\/strong>
\n<\/span><\/p>\n

Oracle DB 18c \ubc84\uc804\ubd80\ud130 APPROX_RANK\ud568\uc218\ub97c \ucd5c\ub300\ud55c \ud65c\uc6a9\ud558\uae30 \uc704\ud574 APPROX_COUNT\uc640 APPROX_SUM \uc774 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

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

 <\/p>\n

10. LOB support with In Memory Column, Big Data SQL<\/strong>
\n<\/span><\/p>\n

IN MEMORY DATABASE \uc758 LOB \uc624\ube0c\uc81d\ud2b8\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

11. Copying a PDB in an Oracle Data Guard Environment<\/strong>
\n<\/span><\/p>\n

ADG \ud658\uacbd\uc5d0\uc11c PDB \uc0dd\uc131\uc744 \uc27d\uac8c\ud558\uae30 \uc704\ud574 \ub450 \uac1c\uc758 \uc0c8\ub85c\uc6b4 \ub9e4\uac1c \ubcc0\uc218\uac00 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\u27a2<\/span>\u00a0STANDBY_PDB_SOURCE_FILE_DIRECTORY :<\/strong> \uc790\ub3d9\uc73c\ub85c ADG \ub370\uc774\ud130 \ud30c\uc77c \uacbd\ub85c\ub97c \ucc3e\uc2b5\ub2c8\ub2e4.
\n<\/span><\/span><\/span><\/span><\/p>\n

Oracle 18c \uc774\uc804\uc5d0 pdb\ub97c Stand by \ud658\uacbd\uc73c\ub85c \uc804\ud658 \ud55c \uacbd\uc6b0 cdb\ub294 \uc218\ub3d9\uc73c\ub85c \ud30c\uc77c\uc744 pdb\uc758 OMF \uacbd\ub85c\uc5d0 \ubcf5\uc0ac \ud574\uc57c \ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

\u27a2<\/span>\u00a0STANDBY_PDB_SOURCE_FILE_DBLINK :<\/strong> \uc6d0\uaca9 \ubcf5\uc81c\ubcf8\uc774 \uc0ac\uc6a9\ub420 \ub54c \uc790\ub3d9\uc73c\ub85c ADG \ud30c\uc77c \uacbd\ub85c\ub97c \ucc3e\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.
\n<\/span><\/span><\/span><\/span><\/p>\n

Oracle 18c \uc774\uc804\uc5d0\ub294 \ub85c\uceec \ubcf5\uc81c DB \uc778 \uacbd\uc6b0 \ub370\uc774\ud130 \ud30c\uc77c\uc744 \ubcf5\uc0ac \ud560 \ud544\uc694\uac00 \uc5c6\uc9c0\ub9cc \uc6d0\uaca9 \ubcf5\uc81c DB\ub294 \uc218\ub3d9\uc73c\ub85c \ubcf5\uc0ac \ud574\uc57c \ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

12. \ud5a5\uc0c1\ub41c PDB Lockdown(\uc7a0\uae08) Profile <\/strong>
\n<\/span><\/p>\n

PDB Lockdown \ud504\ub85c\ud30c\uc77c \uc744 Application root \ubc0f CDB root \uc5d0 \uc791\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

PDB Lockdown \ud504\ub85c\ud30c\uc77c\uc744 \uae30\ubc18\uc73c\ub85c \ub2e4\ub978 PDB Lockdown \ud504\ub85c\ud30c\uc77c\uc744 \uc791\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

Oracle 18c contains 3\uac1c\uc758 \uae30\ubcf8 lockdown profiles \uc774 \ud3ec\ud568 \ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. : PRIVATE_DBAAS, SAAS, PUBLIC_DBAAS
\n<\/span><\/p>\n

 <\/p>\n

13. \uc2e0\uaddc\ubc18\uc601 \/ \uc7ac\ubc18\uc601 \uc774 \uc190\uc26c\uc5b4\uc9c4 PDB \uc2a4\uc704\uce58(Switchover) \uae30\ub2a5<\/strong>
\n<\/span><\/p>\n

ADG \ud658\uacbd\uc5d0\uc11c \uc758 PDB \ub300\uc0c1\uc758 <\/span>Refresh (\uc7ac\ubc18\uc601) \uc791\uc5c5<\/strong><\/span> \uc740 \ud56d\uc0c1 \uc190\uc774 \ub9ce\uc774 \uac00\uace0 \uc808\ucc28\uac00 \ubcf5\uc7a1\ud55c \uc791\uc5c5 \uc785\ub2c8\ub2e4.
\n<\/span><\/span><\/p>\n

\uc774 \uae30\ub2a5\uc774 18c\ubd80\ud130 \ub9ce\uc774 \ub098\uc544\uc838\uc11c \uc190\uc26c\uc6b4 \uc804\ud658\uc774 \uc9c0\uc6d0\ub429\ub2c8\ub2e4.
\n<\/span><\/p>\n

\uc804\ud658(switchover)\uc758 \ud575\uc2ec plan \uc740 \ud06c\uac8c \ub450 \uac00\uc9c0 \ubd84\ub958\uc758 \uc2dc\ub098\ub9ac\uc624\ub85c \ub098\ub269\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

\u00a0 \u00a0 \u00a0\u3131.\uacc4\ud68d\ub41c \uc804\ud658 : CDB\uc758 \ubd80\ud558\ub97c \uade0\ud615 \uc788\uac8c \uc870\uc808\ud558\uae30 \uc704\ud574 \uc8fc\ub85c \ud558\uac8c \ub429\ub2c8\ub2e4.
\n<\/span><\/p>\n

\u00a0 \u00a0 \u00a0\u3134.\uacc4\ud68d \ub418\uc9c0 \uc54a\uc740 \uc804\ud658 : \ub300\ubd80\ubd84\uc758 PDB \ub9c8\uc2a4\ud130 \uc7a5\uc560 \uc2dc \uc804\uccb4 CDB\ub294 \uc804\ud658\uc774 \uc548\ub429\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

14. PDB Snapshot \ubc31\uc5c5 \uc21c\ud658 \uae30\ub2a5<\/strong>
\n<\/span><\/p>\n

PDB \uc2a4\ub0c5 \uc0f7 \ubc31\uc5c5 \uc21c\ud658 \uae30\ub2a5\uc740 8 \uac1c\uc758 \ubc31\uc5c5 \uc0ac\ubcf8\uc744 \uc9c0\uc815 \uc608\uc57d\ud558\uace0 \uae30\ubcf8\uc801\uc73c\ub85c 24 \uc2dc\uac04\ub9c8\ub2e4 \ubc31\uc5c5\ub429\ub2c8\ub2e4.
\n<\/span><\/p>\n

ALTER PLUGGABLE DATABASE SNAPSHOT MODE EVERY 24 HOURS;
\n<\/strong><\/span><\/p>\n

 <\/p>\n

15. New Default Location of Oracle Database Password File<\/strong>
\n<\/span><\/p>\n

orapwd password file \uacbd\ub85c\ub294 ORACLE_BASE\uc5d0 \uc788\uc73c\uba70 ORACLE_HOME\uc5d0 \uc5c6\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

16. Read-Only Oracle Home<\/strong>
\n<\/span><\/p>\n

dbca \ub610\ub294 roohctl -enable\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc77d\uae30 \uc804\uc6a9 oracle home\uc744 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\ud604\uc7ac Oracle Home\uc774 \uc77d\uae30 \uc804\uc6a9\uc778\uc9c0 \uccb4\ud06c\ud558\ub824\uba74 orabase home \uba85\ub839\uc744 \uc2e4\ud589\ud558\uba74 \ub429\ub2c8\ub2e4.
\n<\/span><\/p>\n

\uc774 \uba85\ub839\uc758 \ucd9c\ub825\uc774 $ORACLE_HOME\uacfc \uac19\uc73c\uba74 Oracle Home\uc740 \uc77d\uae30 – \uc4f0\uae30\uc785\ub2c8\ub2e4.
\n<\/span><\/p>\n

\ucd9c\ub825\uc774 ORACLE_BASE \/ homes \/ HOME_NAME \uc778 \uacbd\uc6b0 Oracle Home\uc740 \uc77d\uae30 \uc804\uc6a9\uc785\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

17. Online Merging of Partitions and\u00a0Subpartitions<\/strong>
\n<\/span><\/p>\n

\ud30c\ud2f0\uc158 \ud14c\uc774\ube14\uc758 \ud30c\ud2f0\uc158 \uc628\ub77c\uc778 \ud1b5\ud569\uc791\uc5c5\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

ONLINE \ud0a4\uc6cc\ub4dc\uac00 \ucd94\uac00 \ud558\uba74 \ub429\ub2c8\ub2e4.(EE)
\n<\/span><\/p>\n

 <\/p>\n

18. Concurrent SQL Execution with SQL Performance Analyzer<\/strong>
\n<\/span><\/p>\n

SPA\ub294 \ubcd1\ub82c\ub85c \uc2e4\ud589 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. (\uae30\ubcf8\uc801\uc73c\ub85c Serial \ub9cc \uc9c0\uc6d0 \ud569\ub2c8\ub2e4)
\n<\/span><\/p>\n

\uc774 \uacbd\uc6b0 SPA \ud14c\uc2a4\ud2b8\ub97c \ub354 \ube68\ub9ac \uc644\ub8cc \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

19. Automatic In-Memory<\/strong>
\n<\/span><\/p>\n

\uc774 \uae30\ub2a5\uc740 Heat Map\uc744 \uae30\ubc18\uc73c\ub85c \uba54\ubaa8\ub9ac\uac00 \ubd80\uc871\ud55c \uc0c1\ud669\uc5d0\uc11c \uc790\uc8fc \uc561\uc138\uc2a4\ud558\uc9c0 \uc54a\ub294 In-Memory \uceec\ub7fc\uc744 \uba54\ubaa8\ub9ac\uc5d0\uc11c \uc81c\uac70\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

20. Database In-Memory Support for External Tables<\/strong>
\n<\/span><\/p>\n

\uc678\ubd80 \ud14c\uc774\ube14\ub3c4 In-Memory \uae30\ub2a5\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

21.\u00a0Memory optimized\u00a0Row store<\/strong>
\n<\/span><\/p>\n

SGA\uc5d0\ub294 \uba54\ubaa8\ub9ac \ucd5c\uc801\ud654 POOL \uc601\uc5ed\uc774 \uc0dd\uacbc\uc2b5\ub2c8\ub2e4. \uc774 \ud06c\uae30\ub294 MEMOPTIMIZE_POOL_SIZE \ub9e4\uac1c \ubcc0\uc218\uc5d0 \uc758\ud574 \uc124\uc815\ub429\ub2c8\ub2e4.
\n<\/span><\/p>\n

\ud14c\uc774\ube14\uc5d0 FAST LOOKUP \uae30\ub2a5\uc774 \ucf1c\uc838 \uc788\uc73c\uba74 \ube60\ub978 \uc870\ud68c\ub97c \uc704\ud574 Memory \uc601\uc5ed\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

FAST LOOKUP \uae30\ub2a5 \uc0ac\uc6a9 \ud558\ub824\uba74, \ud14c\uc774\ube14 \uc0dd\uc131\/\uc218\uc815 \uba85\ub839\uc5b4\uc5d0 \ub2e4\uc74c\uacfc \uac19\uc774 \ud0a4\uc6cc\ub4dc\ub97c \ucd94\uac00 \ud574\uc57c \ud569\ub2c8\ub2e4 :
\n<\/span><\/p>\n

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

FAST LOOKUP \uac80\uc0c9\uc740 PK \ud0a4\ub97c \uac80\uc0c9\ud558\ub294 \ucffc\ub9ac(Unique Scan)\ub97c \uae30\ubc18\uc73c\ub85c \uc0ac\uc6a9 \ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

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

\uba54\ubaa8\ub9ac \ucd5c\uc801\ud654 \ub41c ROW \uc800\uc7a5\uc18c\ub294 Things of Internet\uc758 PK \ud0a4\ub97c \uae30\ubc18\uc73c\ub85c \uc790\uc8fc \ud638\ucd9c \uc218\ud589 \ud558\ub294 \ucffc\ub9ac \uc18d\ub3c4\ub97c \ud06c\uac8c \ud5a5\uc0c1<\/strong>\uc2dc\ud0b5\ub2c8\ub2e4.
\n<\/span><\/span><\/span><\/p>\n

 <\/p>\n

22. ASM Database Cloning<\/strong>
\n<\/span><\/p>\n

ASM Flex\u00a0diskgroup\u00a0\uc744 \uc0ac\uc6a9\ud558\uba74 ASM\uc744 \uae30\ubc18\uc73c\ub85c \ud558\ub294 pdb\ub97c \ubcf5\uc81c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

23. Converting Normal or High Redundancy Disk Groups to Flex Disk Groups without Restricted Mount<\/strong>
\n<\/span><\/p>\n

\uc77c\ubc18 ASM \ub514\uc2a4\ud06c \uadf8\ub8f9 \ubcf4\ub2e4 Flex \ub514\uc2a4\ud06c \uadf8\ub8f9\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \ud070 \uc774\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

24. Oracle Database\uc5d0 MS – Active Directory Services \ub97c \ud1b5\ud569
\n<\/strong><\/span><\/p>\n

Combined with Microsoft’s AD.
\n<\/span><\/p>\n

18c \uc774\uc804 \uc5d0\ub294 AD \ud658\uacbd\uc758 \uc0ac\uc6a9\uc790\uac00 \uc811\uadfc\ud558\uae30 \uc704\ud558\uc5ec Oracle Directory Service \uc778 Oracle Enterprise User Security (EUS) \uc758 \uc0c1\ud638 \uc5f0\uacb0 \uc791\uc5c5\uc774 \ud544\uc694\ud588\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

18c \ubd80\ud130 AD \uc11c\ubc84 \uc758 \uc911\uc559 \uad00\ub9ac \uc0ac\uc6a9\uc790 (CMU) \ub97c \uc0ac\uc6a9\ud558\uc5ec AD \uc0ac\uc6a9\uc790 \ubc0f \uadf8\ub8f9\uc744 Oracle \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc758 \uc0ac\uc6a9\uc790 \ubc0f \uc5ed\ud560\uacfc \uc9c1\uc811<\/strong>
\n\ub9e4\ud551 <\/strong>\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/span><\/span><\/p>\n

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

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

 <\/p>\n

25. \ucd08\uae30\ud654 Parameters \uac00 \ucd94\uac00 \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/strong>
\n<\/span><\/p>\n

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

 <\/p>\n

*.\u00a0OPTIMIZER_IGNORE_PARALLEL_HINTS.<\/strong><\/span><\/span><\/p>\n

\uc21c\uc218 OLTP \uc2dc\uc2a4\ud15c\uc5d0\uc11c\ub294 \ub9c8\uce68\ub0b4 \uac1c\ubc1c\uc790\uc758 \ud1b5\uc81c\ub418\uc9c0 \uc54a\uc740 \ub3d9\uc2dc\uc131 (\uc885\uc885 \ub3d9\uc2dc\uc131\uc744 \uc4f0\uc9c0 \uc54a\ub294)\uc744 \ube44\ud65c\uc131\ud654 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span>
\n<\/span><\/span><\/p>\n

 <\/p>\n

26.\u00a0dbms_session.sleep<\/strong>
\n<\/span><\/p>\n

exec\u00a0dbms_session.sleep (3); PL\/SQL\uc218\ud589\uc2dc DB \uc138\uc158\uc758 \uc2dc\uac04\uc744 \uc7a0\uc2dc \uba48\ucd94\ub294 \ud504\ub85c\uc2dc\uc800\uac00 \uc0dd\uacbc\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

 <\/p>\n

\ucc38\uace0
\n<\/span><\/p>\n

https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/18\/index.html<\/strong><\/span><\/a>
\n<\/strong><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

1. Oracle Data Guard \ub2e4\uc911 \uc778\uc2a4\ud134\uc2a4 \uc7ac\uc2e4\ud589 \uc801\uc6a9\uc740 RMAN \ubc31\uc5c5\uc744 \uc704\ud55c \ube14\ub85d \ubcc0\uacbd \ucd94\uc801 \ud30c\uc77c \uc0ac\uc6a9\uc744 \uc9c0\uc6d0 Multiple-Instance Redo Apply (MIRA) \uc740 \uc774\uc81c BCT (\ube14\ub85d \ubcc0\uacbd \ucd94\uc801) \ubc31\uc5c5\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc774\uac83\uc740 \ud6a8\uacfc\uc801\uc778 \uc99d\ubd84 \ubc31\uc5c5 \ubc29\uc2dd\uc758 \ub300\uc6a9\ub7c9 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc774\uba70 \ub9c8\uc2a4\ud130 \uc640 \uc2ac\ub808\uc774\ube0c\uac00 \ubaa8\ub450 RAC \uc774\uba70 \uc774\ub7ec\ud55c \uc885\ub958\uc758 DB \ud658\uacbd\uc5d0\uc11c \uc2ac\ub808\uc774\ube0c \uc5d0\uc11c \ubc31\uc5c5\uc774 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.   2. Data Guard \ud658\uacbd […]<\/p>\n","protected":false},"author":1,"featured_media":3739,"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":[20],"tags":[1061,1060,1062],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/03\/Capture18c000.png?fit=470%2C270","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3784"}],"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=3784"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3784\/revisions"}],"predecessor-version":[{"id":3786,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3784\/revisions\/3786"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/3739"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3784"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3784"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}