{"id":3574,"date":"2018-02-05T20:11:23","date_gmt":"2018-02-05T11:11:23","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3574"},"modified":"2018-02-05T20:13:58","modified_gmt":"2018-02-05T11:13:58","slug":"sysaux-%ed%85%8c%ec%9d%b4%eb%b8%94-%ec%8a%a4%ed%8e%98%ec%9d%b4%ec%8a%a4","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3574","title":{"rendered":"SYSAUX \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4"},"content":{"rendered":"

SYSAUX Tablespace<\/h3>\n

SYSAUX Tablespace\ub294 Oracle Database 10g \ubd80\ud130 \uc81c\uc2dc\ub418\ub294 tablespace \uac1c\ub150\uc774\ub2e4.<\/p>\n

\ub9ce\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad6c\uc131 \uc694\uc18c\ub4e4\uc758 Default \uc800\uc7a5\uc18c\ub85c\uc368 SYSAUX tablespace\uac00 \uc0ac\uc6a9\ub41c\ub2e4. \uc989, SYSAUX tablespace\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc120\ud0dd\uc801\uc778 \uc0ac\ud56d\uc774 \uc544\ub2c8\ub2e4.<\/p>\n

SYSTEM tablespace\uc5d0 \uc801\uc6a9\ub418\ub294 \ubaa8\ub4e0 \uc131\uc9c8(online,locally managed tablespace,permanent etc)\uc744 \ub3d9\uc77c\ud558\uac8c \uc801\uc6a9\ud560 \uc218 \uc788\uc73c\uba70, \uc0ac\uc6a9\uc790\uc758 \uac1d\uccb4\ub97c \uc800\uc7a5\ud558\ub294 \uac83\uc774 \uac00\ub2a5\ud558\ub2e4. SYSTEM Tablespace\uc5d0 \uc800\uc7a5\ub418\uc9c0 \uc54a\uc9c0\ub9cc, \ub2e4\ub978 option\uc758 \uc0ac\uc6a9\uc5d0 \uc808\ub300\uc801\uc73c\ub85c \ud544\uc694\ud55c metadata\ub97c \uc911\uc559\uc9d1\uc911\uc801 \uad00\ub9ac\ub97c \uc218\ud589\ud558\ub294 \uc0c8\ub85c\uc6b4 Tablespace\uc778 \uac83\uc774\ub2e4. \uacb0\uacfc\uc801\uc73c\ub85c Tablespace\uc758 \uac1c\uc218\uac00 \uc904\uc5b4\ub4e4\uac8c \ub41c\ub2e4.<\/p>\n

\uc7a5\uc810<\/h4>\n

\u25a0<\/span> Tablespace\uc758 \uc218\uac00 \uc904\uc5b4\ub4e0\ub2e4<\/p>\n

\ub9ce\uc740 Oracle feature\ub4e4\uc740 \uadf8\ub4e4\uc758 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uae30 \uc704\ud574 \ud2b9\uc815 Tablespace\ub97c \uc694\uad6c\ud55c\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \uac01\uac01 \ubcc4\ub3c4\uc758 Tablespace\ub97c \ub9cc\ub4e4\uc5b4 \ud65c\uc6a9\ud588\uc5c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, XDB\/OLAP \uac19\uc740 feature \ub4e4\uc774 \uc120\ud0dd\ub418\uc5c8\uc744 \ub54c, \uc774 feature\ub4e4\uc758 \ub370\uc774\ud130\ub97c \uc704\ud55c \uc804\uc6a9 Tablespace\ub97c \ub9cc\ub4e4\uc5c8\ub358 \uac83\uc774\ub2e4. \uacb0\uacfc\uc801\uc73c\ub85c DBA\ub294 \uc218 \ub9ce\uc740 Tablespace\ub97c \uad00\ub9ac\ud574\uc57c\ub9cc \ub418\uc5c8\ub2e4. \uadf8\ub7ec\ub098, Oracle Database 10g\uc758 SYSAUX Tablespace\ub294 \uc774\ub7ec\ud55c feature\ub4e4\uc758 Default tablespace\uc774\ub2e4. \uc774\ub7ec\ud55c feature\ub4e4\uc5d0 \ub300\ud55c \ub370\uc774\ud130\ub97c \ud558\ub098\uc758 tablespace\ub85c \ud1b5\ud569 \uad00\ub9ac\ud568\uc73c\ub85c\uc368 DBA\uc758 \uc791\uc5c5\ub7c9\uc774 \uc904\uc5b4\ub4e4 \uc218 \uc788\ub294 \uac83\uc774\ub2e4.<\/p>\n

RAC \ud658\uacbd\uc5d0\uc11c RAW device\ub97c \uc0ac\uc6a9\ud558\uc5ec, \uac1c\ubcc4 Tablespace\ub97c \uc720\uc9c0\ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 \ub354\uc6b1 \ub354 \ub9ce\uc740 \uc791\uc5c5\ub7c9\uc774 \uc694\uad6c\ub420 \uac83\uc774\ub2e4. \uc774 \ubaa8\ub4e0 RAW Device\uc5d0 \ub300\ud55c tablespace\ub97c \ud558\ub098\ub85c \uad00\ub9ac\ud558\ub294 \uac83\uc774 \uc5bc\ub9c8\ub098 \ud6a8\uc728\uc801\uc774\uaca0\ub294\uac00 ?<\/p>\n

\u25a0<\/span> SYSTEM Tablespace\uc5d0 \ub300\ud55c \ubd80\ud558 \uac10\uc18c<\/p>\n

\uc5b4\ub5a0\ud55c Oracle feature\ub294 \uadf8\ub4e4\uc758 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uae30 \uc704\ud574 SYSTEM tablespace\ub97c \uc0ac\uc6a9\ud55c\ub2e4. \uc774\ub85c \uc778\ud574, SYSTEM tablespace\uc758 \ub370\uc774\ud130\uac00 \ub9ce\uc544 \uc9c0\uac8c \ub418\uace0 \uc131\ub2a5\uc744 \uc800\ud558\uc2dc\ud0ac \uc218 \uc788\ub294 \uc5ec\uc9c0\uac00 \uc788\ub2e4. \ub354\uc6b1\uc774 SYSTEM tablespace\uc758 \uacf5\uac04\ubd80\uc871 \ud604\uc0c1\uc774 \ubc1c\ud589\ub418\uc5b4 \uc2dc\uc2a4\ud15c\uc774 \uac00\uc6a9\ud558\uc9c0 \ubabb\ud558\ub294 \uc0c1\ud669\uc73c\ub85c \uc804\ud658\ub420 \uc218 \uc788\ub2e4. SYSAUX tablespace\ub97c \uc0ac\uc6a9\ud558\uba74 \uc774\ub7ec\ud55c \ubd80\ud558\ub97c \uc870\uc815\ud560 \uc218 \uc788\ub294 \uac83\uc774\ub2e4.<\/p>\n

SYSAUX Occupants<\/h4>\n

\uc544\ub798 \ud45c\ub294 SYSAUX tablespace\uc5d0 \uae30\ubcf8\uc801\uc73c\ub85c \uc800\uc7a5\ub418\ub294 Oracle feature\ub4e4\uc744 \ub098\ud0c0\ub0b4\uace0 \uc788\ub2e4. \ub610\ud55c, Oracle9i version\uae4c\uc9c0 \uc774\ub4e4 feature\ub97c \uc704\ud574 \uc9c0\uc815\/\uc0dd\uc131\ud558\uc600\ub358 Tablespace\ub97c \ubcf4\uc5ec\uc900\ub2e4.
\n<\/span><\/p>\n

\"\"<\/p>\n

\uadf8\ub9bc.SYSAUX Occupants<\/p>\n

Schema using SYSAUX tablespace<\/h4>\n
\n\n\n<\/colgroup>\n\n\n
SQL> select distinct owner
\n<\/span><\/p>\n

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

where tablespace_name = ‘SYSAUX<\/strong><\/span>‘;
\n<\/span><\/p>\n

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

———-
\n<\/span><\/p>\n

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

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

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

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

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

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

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

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

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

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

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

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

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

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

14 rows selected. <\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\ub2e4\ub978 Tablespace\ub85c \ub370\uc774\ud130 \uc774\uad00<\/h4>\n

SYSAUX Tablespace\uc5d0\ub294 \ub2e4\uc591\ud55c Oracle feature\uc5d0 \ub300\ud55c \ub370\uc774\ud130\uac00 \uc800\uc7a5\ub418\uc5b4 \uc788\ub2e4. \uacf5\uac04\ubd80\uc871 \ubb38\uc81c\ub85c \ud574\ub2f9 \ub370\uc774\ud130\ub97c \ub2e4\ub978 Tablespace\ub85c \uc774\uad00\ud558\ub294 \uae30\ub2a5\ub3c4 \uc81c\uacf5\ub41c\ub2e4.<\/p>\n

\u25a0 \ud604 \uc0c1\ud0dc \ud655\uc778<\/span><\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> select OCCUPANT_NAME,SPACE_USAGE_KBYTES
\n<\/span><\/p>\n

from V$SYSAUX_OCCUPANTS
\n<\/span><\/p>\n

order by 1;
\n<\/span><\/p>\n

OCCUPANT_NAME SPACE_USAGE_KBYTES
\n<\/span><\/p>\n

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

AO 960
\n<\/span><\/p>\n

EM 51072
\n<\/span><\/p>\n

JOB_SCHEDULER 256
\n<\/span><\/p>\n

LOGMNR 7488
\n<\/span><\/p>\n

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

ODM 5568
\n<\/span><\/p>\n

ORDIM 512
\n<\/span><\/p>\n

ORDIM\/PLUGINS 0
\n<\/span><\/p>\n

ORDIM\/SQLMM 0
\n<\/span><\/p>\n

SDO 6080
\n<\/span><\/p>\n

SMC 112768
\n<\/span><\/p>\n

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

STREAMS 192
\n<\/span><\/p>\n

TEXT 4864
\n<\/span><\/p>\n

ULTRASEARCH 6080
\n<\/span><\/p>\n

WM 6592
\n<\/span><\/p>\n

XSOQHIST 960
\n<\/span><\/p>\n

17 rows selected. <\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\u25a0 \uc774\uad00 \uc2dc \uc0ac\uc6a9\ub420 Procedure
\n<\/span><\/p>\n

SYSAUX Tablespace\uc5d0 \uc800\uc7a5\ub418\uc5b4 \uc788\ub294 \ub370\uc774\ud130\ub97c \uc774\uad00\ud558\uae30 \uc704\ud574\uc11c\ub294 \ud574\ub2f9 Procedure\ub97c \uc0ac\uc6a9\ud55c\ub2e4. \uc5b4\ub5a0\ud55c Procedure\ub97c \uc0ac\uc6a9\ud574\uc57c \ub418\ub294\uc9c0\ub294 \uc544\ub798 Query\ub97c \ud1b5\ud574 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.
\n<\/span><\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> SELECT OCCUPANT_NAME, MOVE_PROCEDURE
\n<\/span><\/p>\n

FROM V$SYSAUX_OCCUPANTS
\n<\/span><\/p>\n

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

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

OCCUPANT_NAME MOVE_PROCEDURE
\n<\/span><\/p>\n

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

AO DBMS_AW.MOVE_AWMETA
\n<\/span><\/p>\n

EM emd_maintenance.move_em_tblspc
\n<\/span><\/p>\n

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

LOGMNR SYS.DBMS_LOGMNR_D.SET_TABLESPACE
\n<\/span><\/p>\n

LOGSTDBY SYS.DBMS_LOGSTDBY.SET_TABLESPACE
\n<\/span><\/p>\n

ODM MOVE_ODM
\n<\/span><\/p>\n

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

ORDIM\/PLUGINS
\n<\/span><\/p>\n

ORDIM\/SQLMM
\n<\/span><\/p>\n

SDO MDSYS.MOVE_SDO
\n<\/span><\/p>\n

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

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

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

TEXT DRI_MOVE_CTXSYS
\n<\/span><\/p>\n

ULTRASEARCH MOVE_WK
\n<\/strong><\/span><\/p>\n

WM DBMS_WM.move_proc
\n<\/span><\/p>\n

XSOQHIST DBMS_XSOQ.OlapiMoveProc
\n<\/span><\/p>\n

17 rows selected.
\n<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

SYSAUX Tablespace SYSAUX Tablespace\ub294 Oracle Database 10g \ubd80\ud130 \uc81c\uc2dc\ub418\ub294 tablespace \uac1c\ub150\uc774\ub2e4. \ub9ce\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad6c\uc131 \uc694\uc18c\ub4e4\uc758 Default \uc800\uc7a5\uc18c\ub85c\uc368 SYSAUX tablespace\uac00 \uc0ac\uc6a9\ub41c\ub2e4. \uc989, SYSAUX tablespace\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc120\ud0dd\uc801\uc778 \uc0ac\ud56d\uc774 \uc544\ub2c8\ub2e4. SYSTEM tablespace\uc5d0 \uc801\uc6a9\ub418\ub294 \ubaa8\ub4e0 \uc131\uc9c8(online,locally managed tablespace,permanent etc)\uc744 \ub3d9\uc77c\ud558\uac8c \uc801\uc6a9\ud560 \uc218 \uc788\uc73c\uba70, \uc0ac\uc6a9\uc790\uc758 \uac1d\uccb4\ub97c \uc800\uc7a5\ud558\ub294 \uac83\uc774 \uac00\ub2a5\ud558\ub2e4. SYSTEM Tablespace\uc5d0 \uc800\uc7a5\ub418\uc9c0 \uc54a\uc9c0\ub9cc, \ub2e4\ub978 option\uc758 \uc0ac\uc6a9\uc5d0 \uc808\ub300\uc801\uc73c\ub85c \ud544\uc694\ud55c metadata\ub97c […]<\/p>\n","protected":false},"author":1,"featured_media":3401,"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":[1015,138],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/151.png?fit=655%2C437","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3574"}],"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=3574"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3574\/revisions"}],"predecessor-version":[{"id":3576,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3574\/revisions\/3576"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/3401"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3574"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}