{"id":432,"date":"2013-10-24T18:39:26","date_gmt":"2013-10-25T03:39:26","guid":{"rendered":"\/blog\/?p=432"},"modified":"2023-09-21T09:38:49","modified_gmt":"2023-09-21T00:38:49","slug":"oracle-data-dictionary","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=432","title":{"rendered":"Oracle Data Dictionary"},"content":{"rendered":"\n

<\/span><\/p>

\u261e  <\/span><\/span>Data Dictionary <\/span><\/strong><\/span><\/div>\n<\/span>
\n<\/span><\/strong><\/span> <\/span><\/div>\n<\/span>
\n<\/span> <\/span>Oracle database<\/span><\/font><\/span>\uc758<\/span><\/span> <\/span><\/font>\uac00\uc7a5<\/span><\/span> <\/span><\/font>\uc911\uc694\ud55c<\/span><\/span> <\/span><\/font>\ubd80\ubd84<\/span><\/span> <\/span><\/font>\uc911<\/span><\/span> <\/span><\/font>\ud558\ub098\ub294<\/span><\/span> data dictionary<\/span><\/font><\/span>\uc774\ub2e4<\/span><\/span>. Data dictionary<\/span><\/font><\/span>\ub294<\/span><\/span> <\/span><\/font>\uc5f0\uad00\ub41c<\/span><\/span> database<\/span><\/font><\/span>\uc5d0<\/span><\/span> <\/span><\/font>\uad00\ud55c<\/span><\/span> <\/span><\/font>\uc815\ubcf4\ub97c<\/span><\/span> <\/span><\/font>\uc81c\uacf5\ud558\ub294<\/span><\/span> <\/span>read-only<\/span><\/span><\/b> table<\/span><\/span><\/font>\ub4e4\uc758<\/span><\/span> <\/span><\/font>\uc9d1\ud569\uc774\ub2e4<\/span><\/span>. <\/span><\/font><\/span>\uc608\ub97c<\/span><\/span> <\/span><\/font>\ub4e4\uba74<\/span><\/span>, data dictionary<\/span><\/font><\/span>\ub294<\/span><\/span> <\/span><\/font>\ub2e4\uc74c\uacfc<\/span><\/span> <\/span><\/font>\uac19\uc740<\/span><\/span> <\/span><\/font>\uc815\ubcf4\ub97c<\/span><\/span> <\/span><\/font>\uc81c\uacf5\ud55c\ub2e4<\/span><\/span>.<\/span><\/font><\/span><\/font> \n<\/span>
\n<\/span>
\n<\/span>

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

l<\/span><\/font>        <\/span><\/span><\/span><\/span>Oracle user<\/span><\/font><\/span>\ub4e4\uc758<\/span><\/span> <\/span><\/font>\uc774\ub984\ub4e4<\/span><\/span><\/font><\/p>\n<\/span>

l<\/span><\/font>        <\/span><\/span><\/span><\/span>\uac01\uac01\uc758<\/span><\/span> user<\/span><\/font><\/span>\ub4e4\uc5d0\uac8c<\/span><\/span> <\/span><\/font>\ubd80\uc5ec\ub41c<\/span><\/span> privilege<\/span><\/font><\/span>\ub4e4\uacfc<\/span><\/span> role<\/span><\/font><\/span>\ub4e4<\/span><\/span><\/font><\/p>\n<\/span>

l<\/span><\/font>        <\/span><\/span><\/span><\/span>schema object<\/span><\/font><\/span>\ub4e4\uc758<\/span><\/span> <\/span><\/font>\uc774\ub984\ub4e4<\/span><\/span>(table, view, snapshot, index, cluster, synonym, sequence, procedure, function, package, trigger <\/span><\/font><\/span>\ub4f1<\/span><\/span>)<\/span><\/font><\/span><\/font><\/p>\n<\/span>

l<\/span><\/font>        <\/span><\/span><\/span><\/span>integrity constraint(<\/span><\/font><\/span>\ubb34\uacb0\uc131<\/span><\/span> <\/span><\/font>\uc81c\uc57d<\/span><\/span>)<\/span><\/font><\/span>\ub4e4\uc5d0<\/span><\/span> <\/span><\/font>\ub300\ud55c<\/span><\/span> <\/span><\/font>\uc815\ubcf4<\/span><\/span> <\/span><\/font><\/span><\/font><\/p>\n<\/span>

l<\/span><\/font>        <\/span><\/span><\/span><\/span>column<\/span><\/font><\/span>\ub4e4\uc5d0<\/span><\/span> <\/span><\/font>\ub300\ud55c<\/span><\/span> default value<\/span><\/font><\/span>\ub4e4<\/span><\/span><\/font><\/p>\n<\/span>

l<\/span><\/font>        <\/span><\/span><\/span><\/span>database<\/span><\/font><\/span>\ub0b4\uc5d0<\/span><\/span> <\/span><\/font>\uc788\ub294<\/span><\/span> object<\/span><\/font><\/span>\ub4e4\uc5d0<\/span><\/span> <\/span><\/font>\ub300\ud574\uc11c<\/span><\/span> <\/span><\/font>\ud560\ub2f9\ub41c<\/span><\/span> space<\/span><\/font><\/span>\uc758<\/span><\/span> <\/span><\/font>\uc591\uc640<\/span><\/span> <\/span><\/font>\ud604\uc7ac<\/span><\/span> <\/span><\/font>\uc0ac\uc6a9\ub418\uace0<\/span><\/span> <\/span><\/font>\uc788\ub294<\/span><\/span> space<\/span><\/font><\/span>\uc758<\/span><\/span> <\/span><\/font>\uc591<\/span><\/span><\/font><\/p>\n<\/span>

l<\/span><\/font>        <\/span><\/span><\/span><\/span>\uc5ec\ub7ec<\/span><\/span> object<\/span><\/font><\/span>\ub4e4\uc744<\/span><\/span> access<\/span><\/font><\/span>\ud558\uace0<\/span><\/span> update<\/span><\/font><\/span>\ud55c<\/span><\/span> <\/span><\/font>\uc0ac\uc6a9\uc790\uc5d0<\/span><\/span> <\/span><\/font>\uad00\ud55c<\/span><\/span> auditing(<\/span><\/font><\/span>\uac10\uc2dc<\/span><\/span>) <\/span><\/font><\/span>\uc815\ubcf4<\/span><\/span><\/font><\/p>\n<\/span>

l<\/span><\/font>        <\/span><\/span><\/span><\/span>Trusted Oracle<\/span><\/font><\/span>\uc5d0\uc11c<\/span><\/span>, <\/span><\/font><\/span>\ubaa8\ub4e0<\/span><\/span> object<\/span><\/font><\/span>\ub4e4\uacfc<\/span><\/span> user<\/span><\/font><\/span>\ub4e4\uc758<\/span><\/span> label<\/span><\/font><\/span>\ub4e4<\/span><\/span><\/font><\/p>\n<\/span>

l<\/span><\/font>        <\/span><\/span><\/span><\/span>\ub2e4\ub978<\/span><\/span> <\/span><\/font>\uc77c\ubc18\uc801\uc778<\/span><\/span> database <\/span><\/font><\/span>\uc815\ubcf4<\/span><\/span> <\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

Data dictionary<\/span><\/font><\/span>\ub294<\/span><\/span> <\/span><\/font>\ub2e4\ub978<\/span><\/span> database data<\/span><\/font><\/span>\uc640<\/span><\/span> <\/span><\/font>\ub9c8\ucc2c\uac00\uc9c0\ub85c<\/span><\/span>, table<\/span><\/font><\/span>\ub4e4\uacfc<\/span><\/span> view<\/span><\/font><\/span>\ub4e4\ub85c<\/span><\/span> <\/span><\/font>\uad6c\uc131\ub41c\ub2e4<\/span><\/span>. Data dictionary<\/span><\/font><\/span>\ub97c<\/span><\/span> access<\/span><\/font><\/span>\ud558\uae30<\/span><\/span> <\/span><\/font>\uc704\ud558\uc5ec<\/span><\/span>, SQL<\/span><\/font><\/span>\uc744<\/span><\/span> <\/span><\/font>\uc0ac\uc6a9\ud55c\ub2e4<\/span><\/span>. Data dictionary<\/span><\/font><\/span>\ub294<\/span><\/span> read-only<\/span><\/font><\/span>\uc774\uae30<\/span><\/span> <\/span><\/font>\ub54c\ubb38\uc5d0<\/span><\/span>, user<\/span><\/font><\/span>\ub294<\/span><\/span> data dictionary<\/span><\/font><\/span>\uc758<\/span><\/span> table<\/span><\/font><\/span>\uacfc<\/span><\/span> view<\/span><\/font><\/span>\ub4e4\uc5d0<\/span><\/span> <\/span><\/font>\ub300\ud574\uc11c<\/span><\/span> query(SQL <\/span><\/font><\/span>\ubb38\uc7a5<\/span><\/span>)<\/span><\/font><\/span>\ub9cc\uc744<\/span><\/span> <\/span><\/font>\uc0ac\uc6a9\ud560<\/span><\/span> <\/span><\/font>\uc218<\/span><\/span> <\/span><\/font>\uc788\ub2e4<\/span><\/span>. <\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

\u261e<\/span><\/span>  <\/span><\/span>The Structure of the Data Dictionary<\/span><\/strong><\/font><\/span><\/p>\n<\/span>

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

Database<\/span><\/font><\/span>\uc758<\/span><\/span>data dictionary<\/span><\/font><\/span>\ub294<\/span><\/span> <\/span><\/font>\ub2e4\uc74c\uc758<\/span><\/span> <\/span><\/font>\uc694\uc18c\ub85c<\/span><\/span> <\/span><\/font>\uad6c\uc131\ub418\uc5b4<\/span><\/span> <\/span><\/font>\uc788\ub2e4<\/span><\/span>.<\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

Base Tables<\/span><\/strong><\/font><\/span><\/p>\n<\/span>

Data dictionary<\/span><\/font><\/span>\uc758<\/span><\/span> <\/span><\/font>\uae30\ucd08\ub294<\/span><\/span> <\/span><\/font>\uad00\ub828\ub41c<\/span><\/span> database<\/span><\/font><\/span>\uc758<\/span><\/span> <\/span><\/font>\uc815\ubcf4\ub97c<\/span><\/span> <\/span><\/font>\uc800\uc7a5\ud558\ub294<\/span><\/span> <\/span><\/font>\uae30\ubcf8<\/span><\/span> <\/span><\/font>\ub610\ub294<\/span><\/span> <\/span><\/font>\uadfc\uc6d0\uc801\uc778<\/span><\/span> table<\/span><\/font><\/span>\ub4e4\uc758<\/span><\/span> <\/span><\/font>\uc9d1\ud569\uc73c\ub85c<\/span><\/span> <\/span><\/font>\uad6c\uc131\ub41c\ub2e4<\/span><\/span>. Oracle<\/span><\/font><\/span>\ub9cc\uc774<\/span><\/span> <\/span><\/font>\uc774<\/span><\/span> table<\/span><\/font><\/span>\ub4e4\uc744<\/span><\/span> <\/span><\/font>\uc77d\uace0<\/span><\/span> <\/span><\/font>\uc4f8<\/span><\/span> <\/span><\/font>\uc218<\/span><\/span> <\/span><\/font>\uc788\ub2e4<\/span><\/span>. <\/span><\/font><\/span>\uadf8<\/span><\/span> table<\/span><\/font><\/span>\ub4e4\uc740<\/span><\/span> <\/span><\/font>\uc815\uaddc\ud654<\/span><\/span> <\/span><\/font>\ub418\uc5b4<\/span><\/span> <\/span><\/font>\uc788\uace0<\/span><\/span>, data<\/span><\/font><\/span>\ub4e4\uc758<\/span><\/span> <\/span><\/font>\ub300\ubd80\ubd84\uc740<\/span><\/span> cryptic(<\/span><\/font><\/span>\uc554\ud638\ub97c<\/span><\/span> <\/span><\/font>\uc0ac\uc6a9\ud55c<\/span><\/span>) format<\/span><\/font><\/span>\uc73c\ub85c<\/span><\/span> <\/span><\/font>\uc800\uc7a5\ub418\uae30<\/span><\/span> <\/span><\/font>\ub54c\ubb38\uc5d0<\/span><\/span>,<\/span>  <\/span><\/span><\/font><\/span>\uc0ac\uc6a9\uc790\uac00<\/span><\/span> <\/span><\/font>\uc9c1\uc811<\/span><\/span> access<\/span><\/font><\/span>\ud558\ub294<\/span><\/span> <\/span><\/font>\uacbd\uc6b0\ub294<\/span><\/span> <\/span><\/font>\ub4dc\ubb3c\ub2e4<\/span><\/span>.<\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

User Accessible Views<\/span><\/strong><\/font><\/span><\/p>\n<\/span>

Data dictionary<\/span><\/font><\/span>\ub294<\/span><\/span> base table<\/span><\/font><\/span>\ub4e4<\/span><\/span> <\/span><\/font>\ub0b4\uc5d0<\/span><\/span> <\/span><\/font>\uc788\ub294<\/span><\/span> <\/span><\/font>\uc815\ubcf4\ub97c<\/span><\/span> <\/span><\/font>\ubcf4\uae30<\/span><\/span> <\/span><\/font>\uc88b\uac8c<\/span><\/span> display <\/span><\/font><\/span>\ud558\uace0<\/span><\/span> <\/span><\/font>\uc694\uc57d\ub418\uc5b4<\/span><\/span> <\/span><\/font>\uc788\ub294<\/span><\/span> <\/span><\/font>\uc0ac\uc6a9\uc790<\/span><\/span> <\/span><\/font>\uc811\uadfc<\/span><\/span> <\/span><\/font>\uac00\ub2a5\ud55c<\/span><\/span> view<\/span><\/font><\/span>\ub4e4\uc744<\/span><\/span> <\/span><\/font>\ud3ec\ud568\ud55c\ub2e4<\/span><\/span>. <\/span><\/font><\/span>\uadf8<\/span><\/span> View<\/span><\/font><\/span>\ub4e4\uc740<\/span><\/span> base table<\/span><\/font><\/span>\ub4e4\uc5d0<\/span><\/span> <\/span><\/font>\uc788\ub294<\/span><\/span> <\/span><\/font>\uc815\ubcf4\ub97c<\/span><\/span> user <\/span><\/font><\/span>\ub610\ub294<\/span><\/span> table name<\/span><\/font><\/span>\ub4e4<\/span><\/span> <\/span><\/font>\ub0b4\uc5d0<\/span><\/span> <\/span><\/font>\uc788\ub294<\/span><\/span> <\/span><\/font>\uc720\uc6a9\ud55c<\/span><\/span> <\/span><\/font>\uc815\ubcf4\ub97c<\/span><\/span> decode(<\/span><\/font><\/span>\uc554\ud638\ub97c<\/span><\/span> <\/span><\/font>\ud480\uc5b4<\/span><\/span>)<\/span><\/font><\/span>\ud558\uace0<\/span><\/span>, <\/span><\/font><\/span>\uadf8\ub9ac\uace0<\/span><\/span> <\/span><\/font>\uc815\ubcf4\ub97c<\/span><\/span> <\/span><\/font>\uac04\ub2e8\ud788<\/span><\/span> <\/span><\/font>\ud558\uae30<\/span><\/span> <\/span><\/font>\uc704\ud558\uc5ec<\/span><\/span> join<\/span><\/font><\/span>\ub4e4\uacfc<\/span><\/span> WHERE<\/span><\/font><\/span>\uad6c\ub97c<\/span><\/span> <\/span><\/font>\uc0ac\uc6a9\ud55c\ub2e4<\/span><\/span>. <\/span><\/font><\/span>\ub300\ubd80\ubd84\uc758<\/span><\/span> user<\/span><\/font><\/span>\ub4e4\uc740<\/span><\/span> base table<\/span><\/font><\/span>\ub4e4\ubcf4\ub2e4\ub294<\/span><\/span> view<\/span><\/font><\/span>\ub4e4\uc5d0<\/span><\/span> <\/span><\/font>\ub300\ud55c<\/span><\/span> access<\/span><\/font><\/span>\uac00<\/span><\/span> <\/span><\/font>\uc8fc\uc5b4\uc9c4\ub2e4<\/span><\/span>.<\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

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

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

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

\u261e<\/span><\/span>  <\/span><\/span>How Oracle Users Can Use the Data Dictionary<\/span><\/strong><\/font><\/span><\/p>\n<\/span>

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

Data dictionary<\/span><\/font><\/span>\uc758<\/span><\/span> view<\/span><\/font><\/span>\ub4e4\uc740<\/span><\/span> <\/span><\/font>\ubaa8\ub4e0<\/span><\/span>database user<\/span><\/font><\/span>\ub4e4\uc5d0<\/span><\/span> <\/span><\/font>\ub300\ud55c<\/span><\/span> <\/span><\/font>\ucc38\uc870\ub85c<\/span><\/span> <\/span><\/font>\uc774\uc6a9\ud55c\ub2e4<\/span><\/span>. Data dictionary view<\/span><\/font><\/span>\ub4e4\uc5d0<\/span><\/span> <\/span><\/font>\ub300\ud55c<\/span><\/span> access<\/span><\/font><\/span>\ub294<\/span><\/span> SQL language<\/span><\/font><\/span>\uc744<\/span><\/span> <\/span><\/font>\ud1b5\ud558\uc5ec<\/span><\/span> <\/span><\/font>\uc774\ub8e8\uc5b4\uc9c4\ub2e4<\/span><\/span>. <\/span><\/font><\/span>\uc77c\ubd80<\/span><\/span> view<\/span><\/font><\/span>\ub4e4\uc740<\/span><\/span> Oracle user <\/span><\/font><\/span>\ubaa8\ub450\uc5d0\uac8c<\/span><\/span> <\/span><\/font>\uc811\uadfc\uc744<\/span><\/span> <\/span><\/font>\ud5c8\uc6a9\ud558\ub294<\/span><\/span> <\/span><\/font>\ubc18\uba74\uc5d0<\/span><\/span> <\/span><\/font>\uc77c\ubd80\ub294<\/span><\/span> admnstrator<\/span><\/font><\/span>\uc5d0<\/span><\/span> <\/span><\/font>\ub300\ud574\uc11c\ub9cc\uc774<\/span><\/span> <\/span><\/font>\uac00\ub2a5\ud558\ub2e4<\/span><\/span>. <\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

Prefix<\/span><\/font><\/span><\/p>\n<\/span><\/td>\n

\n<\/span>

Scope<\/span><\/font><\/span><\/p>\n<\/span><\/td>\n<\/tr>\n

\n<\/span>

USER<\/span><\/font><\/span><\/p>\n<\/span><\/td>\n

\n<\/span>

user schema<\/span><\/font><\/span>\ub0b4\uc5d0<\/span><\/span> <\/span><\/font>\uc788\ub294<\/span><\/span> user view<\/span><\/font><\/span><\/p>\n<\/span><\/td>\n<\/tr>\n

\n<\/span>

ALL<\/span><\/font><\/span><\/p>\n<\/span><\/td>\n

\n<\/span>

user<\/span><\/font><\/span>\uac00<\/span><\/span> access<\/span><\/font><\/span>\ud560<\/span><\/span> <\/span><\/font>\uc218<\/span><\/span> <\/span><\/font>\uc788\ub294<\/span><\/span> <\/span><\/font>\ud655\uc7a5\ub41c<\/span><\/span>user view<\/span><\/font><\/span><\/p>\n<\/span><\/td>\n<\/tr>\n

\n<\/span>

DBA<\/span><\/font><\/span><\/p>\n<\/span><\/td>\n

\n<\/span>

\ubaa8\ub4e0<\/span><\/span> user<\/span><\/font><\/span>\uac00<\/span><\/span> access<\/span><\/font><\/span>\ud560<\/span><\/span> <\/span><\/font>\uc218<\/span><\/span> <\/span><\/font>\uc788\ub294<\/span><\/span> database administrator view <\/span><\/font><\/span><\/p>\n<\/span><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>

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

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

\u2192<\/span><\/span> <\/span><\/span> <\/span>USER_<\/span><\/strong><\/font><\/span><\/p>\n<\/span>

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

\uc804\ud615\uc801\uc778<\/span><\/span> database user<\/span><\/font><\/span>\ub4e4\uc5d0\uac8c<\/span><\/span> <\/span><\/font>\uad00\uc2ec\uc774<\/span><\/span> <\/span><\/font>\uc788\ub294<\/span><\/span> <\/span><\/font>\ub300\ubd80\ubd84\uc758<\/span><\/span> view<\/span><\/font><\/span>\ub4e4\uc740<\/span><\/span> USER prefix<\/span><\/font><\/span>\uac00<\/span><\/span> <\/span><\/font>\ubd99\ub294\ub2e4<\/span><\/span>. <\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

\uc774\ub7ec\ud55c<\/span><\/span> view<\/span><\/font><\/span>\ub4e4\uc740<\/span><\/span> <\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

l<\/span><\/font>        <\/span><\/span><\/span><\/span>User<\/span><\/font><\/span>\uc5d0<\/span><\/span> <\/span><\/font>\uc758\ud574\uc11c<\/span><\/span> <\/span><\/font>\uc0dd\uc131\ub41c<\/span><\/span> object<\/span><\/font><\/span>\uc640<\/span><\/span> user<\/span><\/font><\/span>\uc5d0<\/span><\/span> <\/span><\/font>\uc758\ud574\uc11c<\/span><\/span> <\/span><\/font>\ub9cc\ub4e4\uc5b4\uc9c4<\/span><\/span> grant<\/span><\/font><\/span>\ub4e4<\/span><\/span> <\/span><\/font>\ub4f1\uc5d0<\/span><\/span> <\/span><\/font>\uad00\ud55c<\/span><\/span> <\/span><\/font>\uc815\ubcf4\ub97c<\/span><\/span> <\/span><\/font>\ud3ec\ud568\ud558\ub294<\/span><\/span>, <\/span><\/font><\/span>\uadf8<\/span><\/span> database<\/span><\/font><\/span>\uc5d0<\/span><\/span> <\/span><\/font>\uc788\ub294<\/span><\/span> user <\/span><\/font><\/span>\uc790\uc2e0\uc758<\/span><\/span> <\/span><\/font>\ud658\uacbd\uc5d0<\/span><\/span> <\/span><\/font>\ub300\ud574\uc11c<\/span><\/span> <\/span><\/font>\ucc38\uc870\ud55c\ub2e4<\/span><\/span>.<\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

l<\/span><\/font>        <\/span><\/span><\/span><\/span>User<\/span><\/font><\/span>\uc640<\/span><\/span> <\/span><\/font>\uad00\ub828\ub41c<\/span><\/span> row<\/span><\/font><\/span>\ub9cc<\/span><\/span> display <\/span><\/font><\/span>\ud55c\ub2e4<\/span><\/span>.<\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

l<\/span><\/font>        <\/span><\/span><\/span><\/span>OWNER column(<\/span><\/font><\/span>\ud604\uc7ac<\/span><\/span> user)<\/span><\/font><\/span>\uc774<\/span><\/span> <\/span><\/font>\ud3ec\ud568\ub418\ub294<\/span><\/span> <\/span><\/font>\uac83\uc744<\/span><\/span> <\/span><\/font>\uc81c\uc678\ud558\uace0<\/span><\/span>, <\/span><\/font><\/span>\ub2e4\ub978<\/span><\/span> view<\/span><\/font><\/span>\ub4e4\uacfc<\/span><\/span> <\/span><\/font>\ub3d9\uc77c\ud55c<\/span><\/span> column<\/span><\/font><\/span>\uc744<\/span><\/span> <\/span><\/font>\uac00\uc9c4\ub2e4<\/span><\/span>.<\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

l<\/span><\/font>        <\/span><\/span><\/span><\/span>ALL_ view<\/span><\/font><\/span>\ub4e4<\/span><\/span> <\/span><\/font>\ub0b4\uc5d0<\/span><\/span> <\/span><\/font>\uc815\ubcf4\uc758<\/span><\/span> <\/span><\/font>\ubd80\ubd84\uc9d1\ud569\uc744<\/span><\/span> <\/span><\/font>\ub3cc\ub824\uc900\ub2e4<\/span><\/span>.<\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

l<\/span><\/font>        <\/span><\/span><\/span><\/span>\ud3b8\uc758\ub97c<\/span><\/span> <\/span><\/font>\uc704\ud574<\/span><\/span> <\/span><\/font>\ucd95\uc57d\ub41c<\/span><\/span> PUBLIC synonym<\/span><\/font><\/span>\uc744<\/span><\/span> <\/span><\/font>\uac00\uc9c8<\/span><\/span> <\/span><\/font>\uc218<\/span><\/span> <\/span><\/font>\uc788\ub2e4<\/span><\/span>.<\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

\uc608\ub97c<\/span><\/span> <\/span><\/font>\ub4e4\uba74<\/span><\/span>, <\/span><\/font><\/span>\ub2e4\uc74c<\/span><\/span> query<\/span><\/font><\/span>\ub294<\/span><\/span> user schema<\/span><\/font><\/span>\ub0b4\uc5d0<\/span><\/span> <\/span><\/font>\ud3ec\ud568\ub41c<\/span><\/span> <\/span><\/font>\ubaa8\ub4e0<\/span><\/span> object<\/span><\/font><\/span>\ub4e4\uc744<\/span><\/span> <\/span><\/font>\ub3cc\ub824\uc900\ub2e4<\/span><\/span>.<\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

SELECT<\/span>  <\/span><\/span>object_name,<\/span>  <\/span><\/span>object_type<\/span>  <\/span><\/span>FROM<\/span>  <\/span><\/span>user_objects;<\/span><\/font><\/span><\/p>\n<\/span>

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

                   <\/span>\u2192<\/span><\/span> <\/span><\/span> <\/span>ALL_<\/span><\/strong><\/font><\/span><\/p>\n<\/span>

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

ALL prefix<\/span><\/font><\/span>\uc744<\/span><\/span> <\/span><\/font>\uac00\uc9c4<\/span><\/span> view<\/span><\/font><\/span>\ub4e4\uc740<\/span><\/span> user<\/span><\/font><\/span>\uc5d0\uac8c<\/span><\/span> database<\/span><\/font><\/span>\uc758<\/span><\/span> <\/span><\/font>\uc804\ubc18\uc801\uc778<\/span><\/span> perspective<\/span><\/font><\/span>\ub97c<\/span><\/span> <\/span><\/font>\uc81c\uacf5\ud55c\ub2e4<\/span><\/span>. <\/span><\/font><\/span>\uc774<\/span><\/span> view<\/span><\/font><\/span>\ub4e4\uc740<\/span><\/span> user<\/span><\/font><\/span>\uac00<\/span><\/span> <\/span><\/font>\uc18c\uc720\ud55c<\/span><\/span> object<\/span><\/font><\/span>\ub4e4<\/span><\/span> <\/span><\/font>\uc678\uc5d0\ub3c4<\/span><\/span>, <\/span><\/font><\/span>\uacf5\ud1b5\uc774\uac70\ub098<\/span><\/span> <\/span><\/font>\uba85\ubc31\ud55c<\/span><\/span> privilege<\/span><\/font><\/span>\ub4e4\uacfc<\/span><\/span> role<\/span><\/font><\/span>\ub4e4\uc758<\/span><\/span> grant<\/span><\/font><\/span>\ub4e4\uc744<\/span><\/span> <\/span><\/font>\ud1b5\ud574\uc11c<\/span><\/span> access<\/span><\/font><\/span>\ud558\ub294<\/span><\/span> object<\/span><\/font><\/span>\ub4e4\uc5d0<\/span><\/span> <\/span><\/font>\uad00\ud55c<\/span><\/span> <\/span><\/font>\uc815\ubcf4\ub97c<\/span><\/span> <\/span><\/font>\ub3cc\ub824\uc900\ub2e4<\/span><\/span>. <\/span><\/font><\/span>\uc608\ub97c<\/span><\/span> <\/span><\/font>\ub4e4\uba74<\/span><\/span>, <\/span><\/font><\/span>\ub2e4\uc74c<\/span><\/span> query<\/span><\/font><\/span>\ub294<\/span><\/span> user<\/span><\/font><\/span>\uac00<\/span><\/span> access<\/span><\/font><\/span>\ud558\ub294<\/span><\/span> <\/span><\/font>\ubaa8\ub4e0<\/span><\/span>object<\/span><\/font><\/span>\ub4e4\uc5d0<\/span><\/span> <\/span><\/font>\uad00\ud55c<\/span><\/span> <\/span><\/font>\uc815\ubcf4\ub97c<\/span><\/span> <\/span><\/font>\ub3cc\ub824\uc900\ub2e4<\/span><\/span>.<\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

SELECT owner, object_name, object_type FROM all_objects;<\/span><\/font><\/span><\/p>\n<\/span>

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

                   <\/span>\u2192<\/span><\/span> <\/span><\/span> <\/span>DBA_<\/span><\/strong><\/font><\/span><\/p>\n<\/span>

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

DBA prefix<\/span><\/font><\/span>\ub97c<\/span><\/span> <\/span><\/font>\uac00\uc9c4<\/span><\/span> view<\/span><\/font><\/span>\ub4e4\uc740<\/span><\/span> <\/span><\/font>\uc804\uccb4<\/span><\/span> database<\/span><\/font><\/span>\uc758<\/span><\/span> global view<\/span><\/font><\/span>\ub97c<\/span><\/span> <\/span><\/font>\ubcf4\uc5ec\uc900\ub2e4<\/span><\/span>. <\/span><\/font><\/span>\uadf8\ub7ec\ubbc0\ub85c<\/span><\/span> DBA<\/span><\/font><\/span>\uc5d0<\/span><\/span> <\/span><\/font>\uc758\ud574\uc11c\ub9cc<\/span><\/span> query<\/span><\/font><\/span>\ub420<\/span><\/span> <\/span><\/font>\uc218<\/span><\/span> <\/span><\/font>\uc788\ub2e4\ub294<\/span><\/span> <\/span><\/font>\uac83\uc744<\/span><\/span> <\/span><\/font>\uc758\ubbf8\ud55c\ub2e4<\/span><\/span>. System <\/span><\/font><\/span>\uad8c\ud55c<\/span><\/span> SELECT ANY TABLE<\/span><\/font><\/span>\uc744<\/span><\/span> <\/span><\/font>\ubd80\uc5ec<\/span><\/span> <\/span><\/font>\ubc1b\uc740<\/span><\/span> <\/span><\/font>\uc5b4\ub5a4<\/span><\/span> user<\/span><\/font><\/span>\ub3c4<\/span><\/span> data dictionary<\/span><\/font><\/span>\uc758<\/span><\/span> DBA-prefixed view<\/span><\/font><\/span>\ub4e4\uc744<\/span><\/span> query<\/span><\/font><\/span>\ud560<\/span><\/span> <\/span><\/font>\uc218<\/span><\/span> <\/span><\/font>\uc788\ub2e4<\/span><\/span>. <\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

DBA view<\/span><\/font><\/span>\ub4e4\uc740<\/span><\/span> Synonym<\/span><\/font><\/span>\uc740<\/span><\/span> <\/span><\/font>\uc774\ub7ec\ud55c<\/span><\/span> view<\/span><\/font><\/span>\ub4e4\uc5d0<\/span><\/span> <\/span><\/font>\ub300\ud574\uc11c\ub294<\/span><\/span> <\/span><\/font>\uc0dd\uc131\ub418\uc9c0<\/span><\/span> <\/span><\/font>\uc54a\uc73c\ubbc0\ub85c<\/span><\/span>, DBA view<\/span><\/font><\/span>\ub4e4\uc740<\/span><\/span> adminstrator<\/span><\/font><\/span>\uc5d0<\/span><\/span> <\/span><\/font>\uc758\ud574\uc11c\ub9cc<\/span><\/span> query<\/span><\/font><\/span>\ub420<\/span><\/span> <\/span><\/font>\uc218<\/span><\/span> <\/span><\/font>\uc788\ub2e4<\/span><\/span>. <\/span><\/font><\/span>\uadf8\ub7ec\ubbc0\ub85c<\/span><\/span>, DBA view<\/span><\/font><\/span>\ub4e4\uc744<\/span><\/span> query<\/span><\/font><\/span>\ud558\uae30<\/span><\/span> <\/span><\/font>\uc704\ud574\uc11c<\/span><\/span>, administrator<\/span><\/font><\/span>\ub4e4\uc740<\/span><\/span> <\/span><\/font>\ubc18\ub4dc\uc2dc<\/span><\/span> view<\/span><\/font><\/span>\uc774\ub984<\/span><\/span> <\/span><\/font>\uc55e\uc5d0<\/span><\/span> owner SYS<\/span><\/font><\/span>\ub97c<\/span><\/span> <\/span><\/font>\ub2e4\uc74c\uacfc<\/span><\/span> <\/span><\/font>\uac19\uc774<\/span><\/span> <\/span><\/font>\uba85\uae30\ud574<\/span><\/span> <\/span><\/font>\uc8fc\uc5b4\uc57c<\/span><\/span> <\/span><\/font>\ud55c\ub2e4<\/span><\/span>.<\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

SELECT owner,object_name,object_type FROM sys.dba_objects;<\/span><\/font><\/span><\/p>\n<\/span>

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

\ub9cc\uc57d<\/span><\/span> Administrator<\/span><\/font><\/span>\ub4e4\uc774<\/span><\/span> SELECT ANY TABLE system privilege<\/span><\/font><\/span>\ub97c<\/span><\/span> <\/span><\/font>\uac00\uc9c0\uace0<\/span><\/span> <\/span><\/font>\uc788\ub2e4\uba74<\/span><\/span> <\/span><\/font>\uadf8\ub4e4\uc758<\/span><\/span> <\/span><\/font>\uacc4\uc815\ub4e4\uc5d0<\/span><\/span> DBA view<\/span><\/font><\/span>\ub4e4\uc5d0<\/span><\/span> <\/span><\/font>\ub300\ud55c<\/span><\/span> private synonym<\/span><\/font><\/span>\uc744<\/span><\/span> <\/span><\/font>\ub9cc\ub4e4\uae30<\/span><\/span> <\/span><\/font>\uc704\ud574\uc11c<\/span><\/span>  <\/span><\/span>script file DBA_SYNONYMS.SQL<\/span><\/font><\/span>\uc744<\/span><\/span> <\/span><\/font>\uc218\ud589\uc2dc\ud0ac<\/span><\/span> <\/span><\/font>\uc218<\/span><\/span> <\/span><\/font>\uc788\ub2e4<\/span><\/span>. <\/span><\/font><\/span>\uc774<\/span><\/span> script<\/span><\/font><\/span>\ub97c<\/span><\/span> <\/span><\/font>\uc2e4\ud589\ud558\ub294<\/span><\/span> <\/span><\/font>\uac83\uc740<\/span><\/span> <\/span><\/font>\ud604\uc7ac\uc758<\/span><\/span> user<\/span><\/font><\/span>\uc5d0<\/span><\/span> <\/span><\/font>\ub300\ud574\uc11c\ub9cc<\/span><\/span> synonym<\/span><\/font><\/span>\uc744<\/span><\/span> <\/span><\/font>\ub9cc\ub4e0\ub2e4<\/span><\/span>.<\/span><\/font><\/span><\/font><\/p>\n<\/span>

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

\n<\/span>\u2192<\/span><\/span><\/span> DD\uc5d0\ub294 \uc11c\ubc84\uac00 \uc0ac\uc6a9\uc790\uc758 \uc791\uc5c5\uc5d0 \ub530\ub77c \uc790\ub3d9\uc73c\ub85c DML\uc791\uc5c5\uc744 \ud55c\ub2e4.<\/span><\/strong> <\/span><\/span><\/div>\n<\/span>
\n<\/span> <\/span><\/div>\n<\/span>
\n<\/span>        \uc0ac\uc6a9\uc790 DDL<\/span><\/span>\uba85\ub839<\/span><\/span>(create table, drop table) <\/span><\/span>\u00e0<\/span><\/span> DD DML\uc791\uc5c5(DD insert,DD delete)<\/span><\/span><\/div>\n<\/span>
\n<\/span>                              <\/span><\/span><\/span><\/div>\n<\/span>
\n<\/span>      <\/span><\/span> <\/span><\/span>\uc0ac\uc6a9\uc790<\/span><\/span> <\/span><\/span>\uc77c\ubd80<\/span><\/span> DML<\/span><\/span>\ubb38\uc7a5<\/span><\/span> (insert<\/span><\/span>\uc791\uc5c5<\/span><\/span>)<\/span><\/span> DD DML\uc791\uc5c5(DD update) : tablespace\uc5d0 \ub300\ud55c \uc815\ubcf4 \ubcc0\uacbd <\/span><\/span><\/div>\n<\/span>
\n<\/span> <\/span><\/div>\n<\/span>
\n<\/span>\u2192 <\/span><\/span><\/span>sys.AUD$ <\/span><\/span>\u00e0<\/span><\/span> \uac10\uc0ac\uc815\ubcf4 : \uc9c1\uc811\uc801\uc778 select\uac00 \uac00\ub2a5\ud558\uba70 \uc554\ud638\ud654\ub418\uc5b4 \uc788\uc9c0 \uc54a\ub2e4. \ub610\ud55c \uac10\uc0ac\uc815\ubcf4\ub97c \uc77d\uace0 delete\ud574\ub3c4 \ub41c\ub2e4.  <\/span><\/span>(DD\uc815\ubcf4\uc911 AUD$\ub9cc \uc0ad\uc81c \uac00\ub2a5\ud558\ub2e4.)<\/span><\/strong> <\/span><\/span><\/div>\n<\/span>
\n<\/span>\n <\/span><\/div>\n<\/span>
\n<\/span>\n <\/span><\/div>\n<\/span>
\n<\/span> <\/span><\/span><\/span><\/div>\n\n<\/span>
\n<\/span> <\/span><\/span>\u261e<\/span><\/span>   <\/span><\/span>Data dictionary \ucd1d\uc815\ub9ac<\/span><\/strong><\/span><\/span><\/div>\n<\/span><\/div>\n<\/span><\/span><\/span><\/span><\/div>\n<\/span>\n<\/span>

<\/p>

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

All_all_tables : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 Table <\/span>
<\/span>\n<\/span>\nAll_catalog : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 Table, Views, synonyms, sequence <\/span>
\n<\/span>\nAll_clusters : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 clusters <\/span>
\n<\/span>\nAll_col_comments : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 Table,Views\uc5d0 \ub300\ud55c \uce7c\ub7fccomments <\/span>
\n<\/span>\nAll_col_privs : user\uc5d0\uac8c \ub610\ub294 Public\uc5d0\uac8c \ud5c8\uc6a9\ub41c \ubaa8\ub4e0 \uce7c\ub7fc\uc5d0 \ub300\ud55c \uad8c\ud55c. <\/span>
\n<\/span>\nAll_col_privs_made : user\uac00 \ubd80\uc5ec\ud55c \uce7c\ub7fc\uc5d0 \ub300\ud55c \uad8c\ud55c. <\/span>
\n<\/span>\nAll_col_privs_recd : user\uc5d0\uac8c \ub610\ub294 Public\uc5d0\uac8c \ud5c8\uc6a9\ub41c \ubaa8\ub4e0 \uce7c\ub7fc\uc5d0 \ub300\ud55c \uad8c\ud55c. <\/span>
\n<\/span>\nAll_coll_types : user\uac00 access \ud560\uc218 \uc788\ub294 \ubaa8\ub4e0 collection type <\/span>
\n<\/span>\nAll_cons_columns : \uc81c\uc57d\uc870\uac74\uc5d0 \uad00\ub828\ub41c \uce7c\ub7fc, access\ud560\uc218 \uc788\ub294 \ub300\ud55c \uc815\ubcf4 <\/span>
\n<\/span>\nAll_constraints : access\ud560\uc218 \uc788\ub294 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uc81c\uc57d\uc870\uac74. <\/span>
\n<\/span>\nAll_db_links : user\uac00 access \ud560\uc218 \uc788\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 link <\/span>
\n<\/span>\nAll_def_audit_opts : \uc624\ube0c\uc81d\ud2b8\uac00 \uc0dd\uc131\ub420\ub54c \uc801\uc6a9\ub420\uc218\uc788\ub294 default\uc624\ube0c\uc81d\ud2b8\uac10\uc0ac\ub0b4\uc6a9. <\/span>
\n<\/span>\nAll_dependencies : user\uac00 access\ud560\uc218\uc788\ub294 \uc624\ube0c\uc81d\ud2b8\uac04\uc758 dependencies(\ucc38\uc870,link) <\/span>
\n<\/span>\nAll_directories : user\uac00 access\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0 directories (owner \ub294 \ud56d\uc0c1 sys) <\/span>
\n<\/span>\nAll_errors : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 objects(view,procedure,package, function, packagebody) \uc5d0 \ub300\ud55c \uc5d0\ub7ec. <\/span>
\n<\/span>\nAll_ind_columns : user\uac00 access\ud560\uc218\uc788\ub294 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uc778\ub371\uc2a4\uc758 \uce7c\ub7fc. <\/span>
\n<\/span>\nAll_ind_partitions : user\uac00 access\ud560\uc218\uc788\ub294 \uc778\ub371\uc2a4partition, partition\uc5d0 \ub300\ud55c storage\ub9e4\uac1c\ubcc0\uc218, Analyze\uba85\ub839\uc5d0 \uc758\ud574 \uacb0\uc815\ub41c partition\ud1b5\uacc4. <\/span>
\n<\/span>\nAll_indexes : user\uac00 access\ud560\uc218\uc788\ub294 \ud14c\uc774\ube14\uc758 \uc778\ub371\uc2a4. \uc774 view\uc758 \ud1b5\uacc4\ub97c \uc218\uc9d1\ud558\uae30\uc704\ud574, Analyze\uba85\ub839\uc744 \uc0ac\uc6a9\ud55c\ub2e4. \ubcd1\ub82cpartition\uc778\ud14d\uc2a4\ud0d0\uc0c9\uc744 \uc9c0\uc6d0\ud55c\ub2e4. <\/span>
\n<\/span>\nAll_labels : system labels \uc5d0 \ub300\ud55c Oracle server view. <\/span>
\n<\/span>\nAll_libraries : user\uac00 access\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0 libraries. <\/span>
\n<\/span>\nAll_lobs : user\uac00 access\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0\ud14c\uc774\ube14\uc5d0 \ud3ec\ud568\ub41c LOBs. <\/span>
\n<\/span>\nAll_method_params : user\uac00 access\ud560 \uc218 \uc788\ub294 method\uc640 \uadf8method\uc758 parameter. <\/span>
\n<\/span>\nAll_method_results : <\/span>
\n<\/span>\nAll_nested_tables : user\uac00 access\ud560\uc218\uc788\ub294\ud14c\uc774\ube14\ub0b4\uc758 Nested Table <\/span>
\n<\/span>\nAll_object_tables : user\uac00 access\ud560\uc218\uc788\ub294\ud14c\uc774\ube14\uc758\ubaa8\ub4e0\uc815\ubcf4. <\/span>
\n<\/span>\nAll_objects : user\uac00 access\ud560\uc218\uc788\ub294objects(index partition,table partition,package, package body, trigger) <\/span>
\n<\/span>\nAll_part_col_statistics : user\uac00 access\ud560 \uc218 \uc788\ub294 \ud14c\uc774\ube14partition\uc5d0 \ub300\ud55c \uce7c\ub7fc\ud1b5\uacc4\uc640 \ub9c9\ub300\uadf8\ub798\ud504\ud654\ub41c \uc815\ubcf4. <\/span>
\n<\/span>\nAll_part_histograms : user\uac00 access\ud560\uc218\uc788\ub294 \ud14c\uc774\ube14partition\uc758 histograms\uc5d0 \ub300\ud55c histogram\uc815\ubcf4. <\/span>
\n<\/span>\nAll_part_indexes : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0partition\ub41c index\uc758 partition\uc815\ubcf4. <\/span>
\n<\/span>\nAll_part_key_columns :user\uac00 access\ud560\uc218\uc788\ub294 partition\ub41c objects\uc758 partition key \uce7c\ub7fc\uc5d0 \ub300\ud55c\uc815\ubcf4 <\/span>
\n<\/span>\nAll_part_tables : user\uac00 access\ud560\uc218\uc788\ub294partition\ub41c Table\uc5d0 \ub300\ud55c partition\uc815\ubcf4. <\/span>
\n<\/span>\nAll_refresh : user\uac00 access\ud560\uc218\uc788\ub294\ubaa8\ub4e0 refresh groups. <\/span>
\n<\/span>\nAll_refresh_children : user\uac00 access\ud560 \uc218 \uc788\ub294 refresh groups \uc548\uc758 \ubaa8\ub4e0objects <\/span>
\n<\/span>\nAll_refs : user\uac00 access\ud560 \uc218 \uc788\ub294 \uce7c\ub7fc\uc911 REF\uce7c\ub7fc\uacfc, REF\uc18d\uc131. <\/span>
\n<\/span>\nAll_registered_snapshots : \ubaa8\ub4e0 \ub4f1\ub85d\ub41c snapshots. <\/span>
\n<\/span>\nAll_sequences : user\uac00 access\ud560\uc218\uc788\ub294 sequences. <\/span>
\n<\/span>\nAll_snapshot_logs : \ubaa8\ub4e0 snapshot logs. <\/span>
\n<\/span>\nAll_snapshot_refresh_times : \ubaa8\ub4e0 snapshot refresh times. <\/span>
\n<\/span>\nAll_snapshots : user\uac00 acces\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 snapshots. <\/span>
\n<\/span>\nAll_source : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 stored objects\uc758 text source. <\/span>
\n<\/span>\nAll_synonyms : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 synonyms. <\/span>
\n<\/span>\nAll_tab_col_statistics : 'User_tab_columns' view\uc548\uc758 \uc815\ubcf4\uc5d0\ub300\ud55c \uce7c\ub7fc\ud1b5\uacc4\uc640 \uadf8\ub798\ud504\uc815\ubcf4 <\/span>
\n<\/span>\nAll_tab_columns : user\uac00 access\ud560\uc218\uc788\ub294\ubaa8\ub4e0 table, views, clusters\uc5d0 \ub300\ud55c \uce7c\ub7fc. \uc774view\ub97c \ud65c\uc6a9\ud558\uae30\uc704\ud574\uc11c\ub294 Analyze\uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud55c\ub2e4.<\/span>
\n<\/span>\nAll_tab_comments : user\uac00 access\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0 table, views\uc5d0 \ub300\ud55c comments. <\/span>
\n<\/span>\nAll_tab_histograms : user\uac00 access\ud560\uc218\uc788\ub294table, views\uc5d0 \ub300\ud55c histograms. <\/span>
\n<\/span>\nAll_tab_partitions : user\uac00 access\ud560\uc218 \uc788\ub294 \uac01\uac01\uc758 \ud14c\uc774\ube14partition\uc5d0 \ub300\ud55c partition\uc815\ubcf4, storage parameter, Analyze\uba85\ub839\uc5d0 \uc758\ud55c \ud1b5\uacc4\uc815\ubcf4\ub4f1\uc744 \uc11c\uc220\ud55c\ub2e4. <\/span>
\n<\/span>\nAll_tab_privs : user\ud639\uc740 PUBLIC\uac00 \ubd80\uc5ec\ubc1b\uc740 \uc624\ube0c\uc81d\ud2b8\uad8c\ud55c. <\/span>
\n<\/span>\nAll_tab_privs_made : user\uac00 \ubd80\uc5ec\ud55c user\uad8c\ud55c\uacfc \uc624\ube0c\uc81d\ud2b8\uad8c\ud55c. <\/span>
\n<\/span>\nAll_tab_privs_recd : user \ub610\ub294 PUBLIC\uc774 \ubd80\uc5ec\ubc1b\uc740 \uc624\ube0c\uc81d\ud2b8\uad8c\ud55c. <\/span>
\n<\/span>\nAll_tables : user\uac00 access\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0 \ud14c\uc774\ube14. Analyze\uba85\ub839\uc73c\ub85c \uc774 view\uc758 \ud1b5\uacc4\ub97c \uc5bb\uc744 \uc218 \uc788\ub2e4. <\/span>
\n<\/span>\nAll_triggers : user\uc18c\uc720\uc758 trigger, user\uc18c\uc720\ud14c\uc774\ube14\uc758 trigger, \ub610\ub294 user\uac00 CREATE ANY TRIGGER \uad8c\ud55c\uc744 \uac16\uace0\uc788\ub2e4\uba74, \ubaa8\ub4e0 \ud2b8\ub9ac\uac70\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nAll_trigger_cols : user\uc18c\uc720\uc758 trigger, user\uc18c\uc720\ud14c\uc774\ube14\uc758 trigger, \ub610\ub294 user\uac00 CREATE ANY TRIGGER \uad8c\ud55c\uc744 \uac16\uace0\uc788\ub2e4\uba74, \ubaa8\ub4e0 \ud2b8\ub9ac\uac70\uc5d0 \ub300\ud55c \uce7c\ub7fc\uc815\ubcf4. <\/span>
\n<\/span>\nAll_type_attrs : user\uac00 access\ud560 \uc218 \uc788\ub294 type\uc758 attributes. <\/span>
\n<\/span>\nAll_type_methods : user\uac00 access\ud560\uc218\uc788\ub294type\uc758 methods. <\/span>
\n<\/span>\nAll_types : user\uac00 access\ud560 \uc218 \uc788\ub294 type. <\/span>
\n<\/span>\nAll_updatable_columns : join view\uc5d0\uc11c update\uac00\ub2a5\ud55c \uce7c\ub7fc\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nAll_users : \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubaa8\ub4e0 user\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nAll_views : user\uac00 access\ud560\uc218\uc788\ub294view\uc758 \ud14d\uc2a4\ud2b8. <\/span>
\n<\/span>\nAudit_actions : \uac10\uc0ac\ucd94\uc801type\ucf54\ub4dc \uc815\ubcf4. <\/span>
\n<\/span>\ncatalog : Oracle 5.0 version\uacfc\uc758 \ud638\ud658\uc815\ubcf4\ub97c \ud3ec\ud568\ud55c\ub2e4. \uc774view\uc758 \uc0ac\uc6a9\uc740 \ucd94\ucc9c\ud560\ub9cc\ud558\uc9c0 \ubabb\ud558\ub2e4. <\/span>
\n<\/span>\ncat : user_catalog \uc5d0 \ub300\ud55c synonym. <\/span>
\n<\/span>\nchained_rows : ANALYZE LIST CHAINED ROWS \uba85\ub839\uc5d0 \ub300\ud55c default table. <\/span>
\n<\/span>\nclu : user_clusters \ud14c\uc774\ube14\uc758 synonym. <\/span>
\n<\/span>\ncode_pieces : dba_object_size \uc640 user_object_size view\ub97c create \uc2dc\uc5d0 \uc0ac\uc6a9\ub428. <\/span><\/p>\n<\/span>


\n<\/span>\ncode_size : dba_object_size \uc640 user_object_size view\ub97c create \uc2dc\uc5d0 \uc0ac\uc6a9\ub428. <\/span>
\n<\/span>\ncol : Oracle 5.0version \ud638\ud658\uc815\ubcf4\ub97c \ud3ec\ud568\ud558\uace0 \uc788\ub2e4. <\/span>
\n<\/span>\ncols : user_tab_columns view \uc758 synonym. <\/span>
\n<\/span>\ncolumn_privileges : user\uac00 \ubd80\uc5ec\ud55c\uad8c\ud55c,\ubd80\uc5ec\ubc1b\uc740\uad8c\ud55c, owner\uc778\uad8c\ud55c, \ub610\ub294 PUBLIC\uc5d0\uac8c \ubd80\uc5ec\ubc1b\uc740 \uad8c\ud55c\uc5d0 \ub300\ud55c \uce7c\ub7fc\uc815\ubcf4. <\/span>
\n<\/span>\nDba_2pc_neighbors : \uc9c4\ud589\uc911\uc778 \ud2b8\ub79c\uc7ad\uc158\uc5d0 \ub300\ud55c \uc5f0\uacb0 \ubc0f \uc885\ub8cc\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_2pc_pending : recovery\ub97c \uae30\ub2e4\ub9ac\ub294 \ubd84\uc0b0\ub41c\ud2b8\ub79c\uc7ad\uc158\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_all_tables : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0\ud14c\uc774\ube14(object table, relational table). <\/span>
\n<\/span>\nDba_audit_exists : \"AUDIT NOT EXISTS\" and \"AUDIT EXISTS\"\uc5d0 \uc758\ud574 \uc0dd\uc131\ub41c \uac10\uc0ac\ucd94\uc801\uc694\uc18c. <\/span>
\n<\/span>\nDba_audit_object : \uc2dc\uc2a4\ud15c\ub0b4\uc758 \ubaa8\ub4e0 object\uc5d0 \ub300\ud55c \uac10\uc0ac\ucd94\uc801\uae30\ub85d. <\/span>
\n<\/span>\nDba_audit_session : \uc138\uc158\uc5f0\uacb0\uacfc \uc885\ub8cc\uc5d0 \uad00\ub828\ub41c \ubaa8\ub4e0 \uac10\uc0ac \ucd94\uc801\uae30\ub85d. <\/span>
\n<\/span>\nDba_audit_statement : GRANT, REVOKE, AUDIT, NOAUDIT, ALTER SYSTEM \uad00\ub828\ub41c \uac10\uc0ac\ucd94\uc801\uae30\ub85d. <\/span>
\n<\/span>\nDba_audit_trail : \ubaa8\ub4e0 \uac10\uc0ac\ucd94\uc801\uc694\uc18c. <\/span>
\n<\/span>\nDba_blockers : \ub204\uad70\uac00\uac00 \uc2a4\uc2a4\ub85c \uac78\uc9c0\uc54a\uc740 lock\uc774 \ud574\uc81c\ub418\uae30\ub97c \uae30\ub2e4\ub9ac\ub294 session\uc815\ubcf4. <\/span>
\n<\/span>\nDba_catalog : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 table, views, synonyms \uacfc sequence\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_clu_columns : cluster\uce7c\ub7fc\uacfc table\uce7c\ub7fc\uc758 mapping\uc815\ubcf4. <\/span>
\n<\/span>\nDba_clusters : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \uc788\ub294 \ubaa8\ub4e0 cluster. <\/span>
\n<\/span>\nDba_col_comments : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 table, views\uc758 \uce7c\ub7fc\uc5d0\ub300\ud55c comments. <\/span>
\n<\/span>\nDba_col_privs : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \uce7c\ub7fc\uc5d0 \ub300\ud55c \ubaa8\ub4e0\uad8c\ud55c. <\/span>
\n<\/span>\nDba_coll_types : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 collection type, VARRAYs, nested tables, object tables \ub4f1\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_constraints : \ubaa8\ub4e0\ud14c\uc774\ube14\uc5d0 \ub300\ud55c constraint(primary, check, unique, <\/span>
\n<\/span>\nreferential\nintegrity, with check option on a view, with read only on a view) \uc815\ubcf4.\nDba_cons_columns : constraint \uc815\uc758\uc548\uc5d0 \uc788\ub294 access\uac00\ub2a5\ud55c \uce7c\ub7fc\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_data_files : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ud30c\uc77c\uc5d0 \uad00\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_db_links : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 Link. <\/span>
\n<\/span>\nDba_Ddl_locks : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 DDL lock\uacfc DDL lock\uc774 \ud604\uc800\ud558\uac8c \uc694\uad6c\ub418\ub294 \uc0ac\ud56d\uc5d0 \uad00\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nDba_dependencies : object \uc5d0 \ub300\ud55c Dependence.(REF, HARD) <\/span>
\n<\/span>\nDba_directories : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 directory objects. <\/span>
\n<\/span>\nDba_Dml_locks : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \uad6c\uc131\ub41c\ubaa8\ub4e0 DML lock\uacfc DML lock\uc774 \ud604\uc800\ud558\uac8c \uc694\uad6c\ub418\ub294\uc0ac\ud56d\uc5d0 \uad00\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nDba_errors : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \uc800\uc7a5\ub41c object\uc5d0 \ub300\ud574 \uac00\uc7a5\ucd5c\uadfc\uc5d0 \ubc1c\uc0dd\ub41c error. <\/span>
\n<\/span>\nDba_exp_files : export\ud30c\uc77c\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_exp_objects : \uc810\uc9c4\uc801\uc73c\ub85c export \ub418\uace0\uc788\ub294 object\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_exp_version : \uac00\uc7a5\ucd5c\uadfc\uc5d0 export\ub41c session\uc5d0 \ub300\ud55c version \uc815\ubcf4. <\/span><\/p>\n<\/span>

Dba_extents : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 \uc138\uadf8\uba3c\ud2b8\ub97c \uc774\ub8e8\ub294 extents\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_free_space : \ubaa8\ub4e0 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub0b4\uc758 free extents\uc758 \uc815\ubcf4. <\/span>
\n<\/span>\nDba_free_space_coalesced : \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub0b4\uc758 \ud569\uccd0\uc9c4 \uacf5\uac04\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc815\ubcf4. <\/span><\/p>\n<\/span>

Dba_indexes : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 index. \ud1b5\uacc4\uc815\ubcf4\ub97c \uc5bb\uae30\uc704\ud574 Analyze\ub97c \uc0ac\uc6a9. <\/span>
\n<\/span>\nDba_ind_columns : \ubaa8\ub4e0\ud14c\uc774\ube14\uacfc \ud074\ub7ec\uc2a4\ud130\uc5d0\uc11c \uc778\ub371\uc2a4\ub97c \uad6c\uc131\ud558\ub294 \uce7c\ub7fc\uc5d0 \ub300\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nDba_ind_partitions : \uac01\uac01\uc758 index\ud30c\ud2f0\uc158\uc5d0 \ub300\ud574\uc11c, \ud30c\ud2f0\uc158\uc815\ubcf4, \ud30c\ud2f0\uc158\uc5d0\ub300\ud55c <\/span>
\n<\/span>\nstorage \ub9e4\uac1c\ubcc0\uc218, Analyze\uc5d0 \uacb0\uc815\ub41c \ud30c\ud2f0\uc158\ud1b5\uacc4\uc790\ub8cc. <\/span>
\n<\/span>\nDba_jobs : \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc788\ub294 \ubaa8\ub4e0 Jobs. <\/span>
\n<\/span>\nDba_jobs_running : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \ud604\uc7ac \uc2e4\ud589\uc911\uc778 \ubaa8\ub4e0 Jobs. <\/span>
\n<\/span>\nDba_libraries : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 libraries. <\/span>
\n<\/span>\nDba_lobs : \ubaa8\ub4e0 \ud14c\uc774\ube14\uc5d0 \ud3ec\ud568\ub41c LOBs. <\/span>
\n<\/span>\nDba_locks : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \uc0dd\uc131\ub41c \ubaa8\ub4e0 lock, latch\uacfc lock,latch\uac00 \ud604\uc800\ud558\uac8c \uc694\uad6c\ub418\ub294 \uc0ac\ud56d\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_method_params : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 type\uc5d0 \ub300\ud55c method \ub9e4\uac1c\ubcc0\uc218. <\/span>
\n<\/span>\nDba_method_results : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 type\uc5d0 \ub300\ud55c method results. <\/span>
\n<\/span>\nDba_nested_tables : \ubaa8\ub4e0\ud14c\uc774\ube14\ub0b4\uc5d0 \ud3ec\ud568\ub41c nested table\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_object_size : PL\/SQL object\uc5d0 \ub300\ud55c size, bytes. <\/span>
\n<\/span>\nDba_object_tables : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \ubaa8\ub4e0 object tables. <\/span>
\n<\/span>\nDba_objects : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \ubaa8\ub4e0 objects.(index partition, table partition, package,package_body,trigger) <\/span>
\n<\/span>\nDba_obj_audit_opts : \ubaa8\ub4e0 table, view\uc5d0 \ub300\ud55c \uac10\uc0ac option. <\/span>
\n<\/span>\nDba_part_col_statistics : \ubaa8\ub4e0 table \ud30c\ud2f0\uc158\uc5d0 \ub300\ud55c \uce7c\ub7fc\ud1b5\uacc4\uc640 \uadf8\ub798\ud504\uc815\ubcf4. <\/span>
\n<\/span>\nDba_part_histograms : \ubaa8\ub4e0 table \ud30c\ud2f0\uc158\uc758 histogram\uc5d0 \ub300\ud55c \ub370\uc774\ud130(endpoint). <\/span>
\n<\/span>\nDba_part_indexes : \ubaa8\ub4e0 partition index\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_part_key_columns : \ubaa8\ub4e0 partition\ub41c object\uc5d0 \ub300\ud55c \ubd84\ud560\ud0a4\uce7c\ub7fc\uc815\ubcf4. <\/span>
\n<\/span>\nDba_part_tables : \ubaa8\ub4e0 partition\ub41c table\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_priv_audit_opts : \uc2dc\uc2a4\ud15c\uacfc user\uc5d0 \uc758\ud574 \uac10\uc0ac\ub97c \ubc1b\uace0\uc788\ub294 \uc2dc\uc2a4\ud15c privileges. <\/span>
\n<\/span>\nDba_profiles : \ubaa8\ub4e0 profiles\uacfc \ud574\ub2f9 profile\uc758 limit\uc744 \ub098\ud0c0\ub0c4. <\/span>
\n<\/span>\nDba_queue_schedules : \uba54\uc2dc\uc9c0\ub97c \uc804\ub2ec\ud558\ub294 schedule. <\/span>
\n<\/span>\nDba_queue_tables : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \uc0dd\uc131\ub41c \ubaa8\ub4e0 queue\ud14c\uc774\ube14\uc758 queue type\uc758 name\uacfc type. <\/span>
\n<\/span>\nDba_Queus : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 queue\uc5d0 \ub300\ud55c \ub3d9\uc791\ud2b9\uc131. <\/span>
\n<\/span>\nDba_rchild : refresh group \uc548\uc758 \ubaa8\ub4e0 children object. <\/span>
\n<\/span>\nDba_refresh : \ubaa8\ub4e0 refresh group \uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_refresh_children : refresh group \uc548\uc758 \ubaa8\ub4e0 object\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_refs : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc758 REF\uce7c\ub7fc\uacfc, REF \uc18d\uc131\uc744 \uac00\uc9c4 \uce7c\ub7fc. <\/span>
\n<\/span>\nDba_refistered_snapshot_groups : \ubaa8\ub4e0 snapshot \uc0ac\ubcf8 \uadf8\ub8f9. <\/span><\/p>\n<\/span>


\n<\/span>\nDba_registered_snapshots : \uc9c0\uc5ed\ud14c\uc774\ube14\uc758 \uc6d0\uaca9snapshot \uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_rgroup : \ubaa8\ub4e0 refresh group. <\/span>
\n<\/span>\nDba_roles : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \uc874\uc7ac\ud558\ub294 roles. <\/span>
\n<\/span>\nDba_role_privs : user\uc640 role\uc5d0 \ubd80\uc5ec\ub41c role\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_rollback_segs : rollback segments \uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_segments : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 segment\uc5d0 \ub300\ud55c \ud560\ub2f9\ub41c storage\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_sequences : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 sequences \uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_snapshot_logs : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 snapshot_logs. <\/span>
\n<\/span>\nDba_snapshot_refresh_times : snapshot refresh \ud55c \uc2dc\uac04. <\/span>
\n<\/span>\nDba_snapshots : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 snapshots. <\/span>
\n<\/span>\nDba_source : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \uc800\uc7a5object \uc758 source\ub97c\ud3ec\ud568. <\/span>
\n<\/span>\nDba_stmt_audit_opts : system, user\uc5d0 \uc758\ud55c \ud604\uc7ac\uc758 \uac10\uc0acoption\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDba_synonyms : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 synonyms <\/span>
\n<\/span>\nDba_sys_privs : user\uc5d0\uac8c \ubd80\uc5ec\ub41c system privilege\uc640 role. <\/span>
\n<\/span>\nDba_tab_col_statistics : Dba_tab_columns view\uc5d0 \uc788\ub294\uc815\ubcf4\uc5d0 \ub300\ud55c \uce7c\ub7fc\ud1b5\uacc4\uc640 \uadf8\ub798\ud504\uc815\ubcf4 <\/span>
\n<\/span>\nDba_tab_columns : \ubaa8\ub4e0 table, view, cluster\uc5d0 \ub300\ud55c \uce7c\ub7fc\uc815\ubcf4. Analyze\uba85\ub839\uc5b4\uc0ac\uc6a9. <\/span>
\n<\/span>\nDba_tab_comments : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 table, view\uc5d0 \ub300\ud55c \uc8fc\uc11d. <\/span>
\n<\/span>\nDba_tab_histograms : \ubaa8\ub4e0 table\uc758 \uce7c\ub7fc\uc5d0 \ub300\ud55c histogram. <\/span>
\n<\/span>\nDba_tab_partitions : \uac01\uac01\uc758 table partition\uc5d0 \ub300\ud574\uc11c, partition level\uc758 partition\uc815\ubcf4\uc640, <\/span>
\n<\/span>\npartition\uc758 storage\ub9e4\uac1c\ubcc0\uc218 ,Analyze \uc5d0\uc758\ud574 \uacb0\uc815\ub41c \uc5ec\ub7ec partition\ud1b5\uacc4\uc815\ubcf4. <\/span>
\n<\/span>\nDba_tab_privs : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 object\uc5d0 \ubd80\uc5ec\ub41c \uad8c\ud55c. <\/span>
\n<\/span>\nDba_tables : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \uad00\uacc4\ud615\ud14c\uc774\ube14\uc5d0 \uad00\ud55c\uc815\ubcf4.Analyze\ub85c \ud1b5\uacc4\uc815\ubcf4\ub97c \uc5bb\uc744\uc218 \uc788\ub2e4. <\/span>
\n<\/span>\nDba_tablespaces : \ubaa8\ub4e0 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \uad00\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nDba_triggers : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 trigger \uc815\ubcf4. <\/span>
\n<\/span>\nDba_trigger_cols : \ubaa8\ub4e0 trigger\uc5d0\uc11c \uc0ac\uc6a9\ub41c \uce7c\ub7fc\uc815\ubcf4. <\/span>
\n<\/span>\nDba_ts_quotas : \ubaa8\ub4e0 user\uc5d0\uac8c \ud560\ub2f9\ub41c tablespace. <\/span>
\n<\/span>\nDba_type_attrs : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 type\uc5d0 \ub300\ud55c \uc18d\uc131. <\/span>
\n<\/span>\nDba_type_methods : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 type\uc5d0 \ub300\ud55c methods. <\/span>
\n<\/span>\nDba_types : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 \ucd94\uc0c1\uc801\ub370\uc774\ud130type. <\/span>
\n<\/span>\nDba_updatable_columns : join view\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uad00\ub9ac\uc790\uac00 update\ud560\uc218\uc788\ub294\uce7c\ub7fc\uc815\ubcf4. <\/span>
\n<\/span>\nDba_users : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 user\uc815\ubcf4. <\/span>
\n<\/span>\nDba_views : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 view\uc758 text. <\/span>
\n<\/span>\nDbms_alert_info : \ub4f1\ub85d\ub41c alert\uc815\ubcf4. <\/span>
\n<\/span>\nDbms_lock_allocated : \uc0ac\uc6a9\uc790\uc5d0\uac8c \ud560\ub2f9\ub41c lock\uc815\ubcf4. <\/span>
\n<\/span>\nDeptree : utldtree.sql \uc5d0\uc758\ud574 \uc0dd\uc131\ub418\uba70, object\uc758 dependency tree\uc815\ubcf4\ub97c \ud3ec\ud568\ud568. <\/span>
\n<\/span>\n'Sys' user\uc778 \uacbd\uc6b0. \uc774 object\uc5d0 \uad00\ub828\ub41c \uacf5\uc720\ucee4\uc11c\ub97c \ub098\ud0c0\ub0b4\uace0, <\/span>
\n<\/span>\n\ub2e4\ub978 user\uc778 \uacbd\uc6b0\uacf5\uc720\ucee4\uc11c\uc774\uc678\uc758 object\ub97c \ub098\ud0c0\ub0b8\ub2e4. <\/span>
\n<\/span>\n\ub2e4\ub978 user\ub294 \uacf5\uc720\ucee4\uc11c\uc815\ubcf4\ub97c \uc5bb\uae30\uc704\ud574, Sys.deptree\ub97c access\ud560\uc218\uc788\ub2e4. <\/span><\/p>\n<\/span>

Dictionary : data dictionary table, view\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nDict_columns : data dictionary table, view\uc5d0 \ub300\ud55c \uce7c\ub7fc. <\/span>
\n<\/span>\nError_size : Dba_obejct_size \uc640 user_obejct_size view\ub97c create \ud560\ub54c \uc0ac\uc6a9\ub41c\ub2e4. <\/span>
\n<\/span>\nExceptions : \ubb34\uacb0\uc131\uc81c\uc57d\uc870\uac74\uc5d0 \uc704\ubc30\ub418\ub294 \uc815\ubcf4\ub97c \ud3ec\ud568. utlexcpt.sql \ub85c \uc0dd\uc131. <\/span>
\n<\/span>\nFile_lock : \ubcd1\ub82c\uc11c\ubc84view. \ucd08\uae30\ud654\ud30c\ub77c\ubbf8\ud130 GC_FILE_TO_LOCKS \uc5d0 \uba85\uc2dc\ub41c, \ub370\uc774\ud130\ud30c\uc77c\uc5d0 PCM lock\uc758 mapping\uc815\ubcf4. <\/span>
\n<\/span>\nFile_ping : \ubcd1\ub82c\uc11c\ubc84view.\uac01\ub370\uc774\ud0c0\ud30c\uc77c\uc5d0 \ud560\ub2f9\ub41c block\uc758 \uc218. <\/span>
\n<\/span>\nGC_FILES_TO_LOCKS \ucd5c\uc801\uac12\uc744 \uad6c\ud558\uae30 \uc704\ud574 \ud604\uc874\ud558\ub294 \ub370\uc774\ud130\ud30c\uc77c\uc758 access\ubc29\ubc95\uc744 \uacb0\uc815\ud558\ub294\ub370 \uc774 \uc815\ubcf4\ub97c\uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. <\/span>
\n<\/span>\nFILEXT$ : DBA_DATA_FILES \uc640 \ub3d9\uc77c. (DBA_DATA_FILES\uc758 \uc0ac\uc6a9\uc744 \ucd94\ucc9c) <\/span>
\n<\/span>\nGLOBAL_NAME : \ud604\uc81c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc720\uc77c\ud55c \uc774\ub984. <\/span>
\n<\/span>\nHS_ALL_CAPS : \ubaa8\ub4e0 \ube44 Oracle Data store (FDS) \uc640 \uad00\ub828\ub41c \ud2b9\uc131\uc5d0 \uad00\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nHS_ALL_DD : \ubaa8\ub4e0 \ube44 Oracle Data store(FDS)\uc5d0 \ub300\ud55c Data dictionary. <\/span>
\n<\/span>\nHS_ALL_INITS : \ube44 Oracle Data store(FDS)\uc5d0 \ub300\ud55c \ucd08\uae30\ud654 \ub9e4\uac1c\ubcc0\uc218. <\/span>
\n<\/span>\nHS_BASE_CAPS : \ube44 Oracle Data store(FDS)\uc5d0 \ub300\ud55c \uae30\ubcf8\ud2b9\uc131\uc5d0 \uad00\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nHS_BASE_DD : \ube44 Oracle Data store(FDS)\uc5d0 \ub300\ud55c Data dictionary. <\/span>
\n<\/span>\nHS_CLASS_CAPS : \ube44 Oracle Data store(FDS)\uc5d0 \ud3ec\ud568\ub41c class-specific \ud2b9\uc131\uc815\ubcf4. <\/span>
\n<\/span>\nHS_CLASS_DD : \ube44 Oracle Data store(FDS) class_specific data dictionary. <\/span>
\n<\/span>\nHS_CLASS_INIT : \ube44 Oracle Data store(FDS) class-specific \ucd08\uae30\ud654 \ub9e4\uac1c\ubcc0\uc218. <\/span>
\n<\/span>\nHS_EXTERNAL_OBJECT_PRIVILEGES : user\uc5d0\uac8c \ubd80\uc5ec\ub41c object\uad8c\ud55c. <\/span>
\n<\/span>\nHS_EXTERNAL_OBJECTS : oracle server\uc5d0\uc11c access\uac00\ub2a5\ud55c external obejct. <\/span>
\n<\/span>\nHS_EXTERNAL_USER_PRIVILEGES : \uc5b4\ub290 \ud2b9\uc815object\uc5d0 \uad6d\ud55c\ub418\uc9c0\uc54a\uc740 \ubaa8\ub4e0 \ubd80\uc5ec\ub41c\uad8c\ud55c <\/span>
\n<\/span>\nHS_FDS_CLASS : \ube44 oracle (FDS) class \uc5d0 \uad00\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nHS_FDS_INST : \ube44 oracle (FDS) instance\uc5d0 \uad00\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nHS_INST_CAPS : instance-specific \ud2b9\uc131\uc815\ubcf4. <\/span>
\n<\/span>\nHS_INST_DD : \ube44 oracle (FDS) instance-specific data dictionary \ubcc0\uacbd\uc815\ubcf4. <\/span>
\n<\/span>\nHS_INST_INIT : \ube44 oracle (FDS) instance-specific \ucd08\uae30\ud654 \ub9e4\uac1c\ubcc0\uc218\uc815\ubcf4. <\/span>
\n<\/span>\nIDEPTREE : UTLDTREE.sql \ub85c \uc0dd\uc131\ud558\uace0, \uad00\ub828tree\ub97c \ub098\ud0c0\ub0c4. Deptree\uc758 \uc790\ub3d9\uc815\ub82c\ubc84\uc83c. <\/span>
\n<\/span>\nINDEX_HISTOGRAM : Analyze index...validate structure \uba85\ub839\uc5d0 \ub300\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nINDEX_STATS : \ub9c8\uc9c0\ub9c9 Analyze index..validate structure \uba85\ub839\uc5d0 \ub300\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nNLS_DATABASE_PARAMETERS : \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 NLS \ub9e4\uac1c\ubcc0\uc218. <\/span>
\n<\/span>\nNLS_INSTANCE_PARAMETERS : instance\uc758 NLS \ub9e4\uac1c\ubcc0\uc218. <\/span>
\n<\/span>\nNLS_SESSION_PARAMETERS : user session\uc758 NLS \ub9e4\uac1c\ubcc0\uc218. <\/span><\/p>\n<\/span>

OBJ : user_objects \uc758 synonym. <\/span>
\n<\/span>\nPARSED_PIECES : Dba_object_size, User_object_size view\ub97c \uc0dd\uc131\uc2dc\uc5d0 \ud544\uc694. <\/span>
\n<\/span>\nPARSED_SIZE : Dba_obejct_size, User_object_size view\ub97c \uc0dd\uc131\uc2dc\uc5d0 \ud544\uc694. <\/span>
\n<\/span>\nPlan_table : explain plan\uc758 \uacb0\uacfc\uc5d0 \ub300\ud55c table. utlxplan.sql\ub85c \uc0dd\uc131. <\/span>
\n<\/span>\nProduct_component_version : Oracle \uc81c\ud488\uad70\uc758 \ubc84\uc804\uacfc \uc0c1\ud0dc\uc124\uba85. <\/span><\/p>\n<\/span>


\n<\/span>\nPstubtbl : Pstub utility\uc5d0 \uc758\ud574 \uc0dd\uc131\ub41c stub\uc5d0 \uad00\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nPublicsyn : public synonym \uc5d0 \uad00\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nPublic_dependency : object\uc640 \uad00\ub828\ub41c dependencies.(parent object) <\/span>
\n<\/span>\nResource_cost : \uac01\uac01\uc758 resource\uc5d0 \ub300\ud55c cost. <\/span>
\n<\/span>\nResource_map : \uac01\uac01\uc758 resource\uc5d0 \ub300\ud55c \uc815\ubcf4.(resource name, resource number) <\/span>
\n<\/span>\nRole_role_privs : \ub2e4\ub978 role\uc5d0 \ubd80\uc5ec\ub41c role\uc815\ubcf4.(user\uac00 access\uac00\ub2a5\ud55c role\uc5d0 \ud55c\ud574) <\/span>
\n<\/span>\nRole_sys_privs : \ub2e4\ub978 role\uc5d0 \ubd80\uc5ec\ub41c system role\uc815\ubcf4(user\uac00 access\uac00\ub2a5\ud55crole\uc5d0 \ud55c\ud574) <\/span>
\n<\/span>\nRole_tab_privs : \ub2e4\ub978 role\uc5d0 \ubd80\uc5ec\ub41c table privileges\uc815\ubcf4. (user\uac00 access\uac00\ub2a5\ud55crole\uc5d0 \ud55c\ud574) <\/span><\/p>\n<\/span>

SEQ : user_sequences \uc758 synonym. <\/span>
\n<\/span>\nSession_privs : \ud604\uc7ac user\uc5d0\uac8c \uc0ac\uc6a9\uac00\ub2a5\ud55c \uad8c\ud55c. <\/span>
\n<\/span>\nSession_roles : \ud604\uc7ac user\uc5d0\uac8c \uc0ac\uc6a9\uac00\ub2a5\ud55c roles. <\/span>
\n<\/span>\nSource_size : Dba_object_size, User_object_size view\ub97c \uc0dd\uc131\uc2dc \ud544\uc694. <\/span>
\n<\/span>\nStmt_audit_option_map : \uac10\uc0ac option type code\uc815\ubcf4. <\/span>
\n<\/span>\nSyn : user_synonyms \uc5d0 \ub300\ud55c synonym. <\/span>
\n<\/span>\nSynonyms : Oracle ver 5.\uc640 \ud638\ud658\uc131\uc744 \ud3ec\ud568. not recommend <\/span>
\n<\/span>\nSyscatalog : Oracle ver 5.\uc640 \ud638\ud658\uc131\uc744 \ud3ec\ud568. not recommend <\/span>
\n<\/span>\nSysfiles : Oracle ver 5.\uc640 \ud638\ud658\uc131\uc744 \ud3ec\ud568. not recommend <\/span>
\n<\/span>\nSyssegobj : Oracle ver 5.\uc640 \ud638\ud658\uc131\uc744 \ud3ec\ud568. not recommend <\/span>
\n<\/span>\nSystem_privilege_map : system privilege code\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nSys_objects : object ID\uc640 object type \uadf8\ub9ac\uace0 segment data block\uc8fc\uc18c\ub97c \ub9e4\ud551\ud558\ub294\uc815\ubcf4. <\/span>
\n<\/span>\nTab : Oracle ver 5.\uc640 \ud638\ud658\uc131\uc744 \ud3ec\ud568. not recommend <\/span>
\n<\/span>\nTable_privileges : user\uac00 \ubd80\uc5ec\ud55c, \ubd80\uc5ec\ubc1b\uc740, \uc18c\uc720\ud55c, \uadf8\ub9ac\uace0 PUBLIC\uc73c\ub85c \ubd80\uc5ec\ub41c object \uad8c\ud55c\uc815\ubcf4. Oracle ver 6.\uacfc \ud638\ud658\uc131\uc744 \ud3ec\ud568. not recommend. <\/span>
\n<\/span>\nTable_privilege_map : access \uac00\ub2a5\ud55c \uad8c\ud55ccode\/\uad8c\ud55c\uba85\uce6d \uc815\ubcf4. <\/span>
\n<\/span>\nTabs : User_tables \uc758 synonym. <\/span>
\n<\/span>\nTabquotas : Oracle ver 5.\uc640 \ud638\ud658\uc131\uc744 \ud3ec\ud568. not recommend <\/span>
\n<\/span>\nTrusted_servers : \ubd84\uc0b0\ud658\uacbd\uc5d0\uc11c \uc11c\ubc84\uac00 \uc2e0\ub8b0\ud560\ub9cc\ud55c\uc9c0\ub97c \ub098\ud0c0\ub0c4. <\/span>
\n<\/span>\nTp_pitr_check : catpitr.sql \uc5d0 \uc758\ud574 \uc0dd\uc131. \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 point-in-time\ubcf5\uad6c\ub97c \ubc29\ud574\ud560\uc9c0\ub3c4 \ubaa8\ub974\ub294 dependencies\ud639\uc740 restriction\uc5d0 \uad00\ud55c \uc815\ubcf4\uc81c\uacf5. <\/span>
\n<\/span>\nTs_pitr_objects_to_be_dropped : \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 point-in-time\ubcf5\uad6c\uc218\ud589\uc758 \uacb0\uacfc \uc190\uc2e4\ub41c object\uc5d0 \ub300\ud55c \uc815\ubcf4. (point-in-time recovery\uc758 \uacbd\uc6b0\ub9cc \ud574\ub2f9). <\/span>
\n<\/span>\nUser_all_tables : user\uac00 \uc0ac\uc6a9\uac00\ub2a5\ud55c \ud14c\uc774\ube14(object table, relational table)\uc815\ubcf4. <\/span>
\n<\/span>\nUser_arguments : user\uac00 access\uac00\ub2a5\ud55c object\uc758 \ub9e4\uac1c\ubcc0\uc218\uc815\ubcf4. <\/span>
\n<\/span>\nUser_Audit_object : cataudit.sql\ub85c \uc0dd\uc131. object\uc5d0 \uad00\ub828\ub41c \uac10\uc0ac\ucd94\uc801\uae30\ub85d. <\/span>
\n<\/span>\nUser_Audit_session : cataudit.sql\ub85c \uc0dd\uc131. user\uc758 \uc5f0\uacb0\/\uc885\ub8cc\uc5d0 \uad00\ub828\ub41c \uac10\uc0ac\ucd94\uc801\uae30\ub85d. <\/span>
\n<\/span>\nUser_Audit_statement : cataudit.sql\ub85c \uc0dd\uc131. user\uc5d0 \uc758\ud574 \uc2e4\ud589\ub41c GRANT,REVOKE, AUDIT, NOAUDIT, ALTER SYSTEM \uba85\ub839\uc5d0 \ub300\ud55c \uac10\uc0ac\ucd94\uc801\uae30\ub85d.<\/span><\/p>\n<\/span>


\n<\/span>\nUser_Audit_trail : user\uc640 \uad00\ub828\ub41c \uc804\ubc18\uc801\uc778 \uc0ac\ud56d\uc758 \uac10\uc0ac\ucd94\uc801\uae30\ub85d. <\/span>
\n<\/span>\nUser_catalog : user \uc18c\uc720\uc758 table, views, synonyms, sequences \uc758 \uc774\ub984\uacfc type. <\/span>
\n<\/span>\nUser_clusters : user\uc18c\uc720\uc758 cluster. <\/span>
\n<\/span>\nUser_clu_columns : user table \uc758 \uce7c\ub7fc\uacfc cluster\uce7c\ub7fc\uacfc\uc758 \ub9e4\ud551\ud14c\uc774\ube14. <\/span>
\n<\/span>\nUser_col_comments : user \uc758 table, view\uc758 \uce7c\ub7fc\uc5d0 \ub300\ud55c \uc8fc\uc11d. <\/span>
\n<\/span>\nUser_col_privs : user \uac00 \uc18c\uc720\ud55c, \ubd80\uc5ec\ud55c, \ubd80\uc5ec\ubc1b\uc740 \uce7c\ub7fc\uc5d0 \ub300\ud55c \uad8c\ud55c. <\/span>
\n<\/span>\nUser_col_privs_made : user \uc18c\uc720 object\uc758 \uce7c\ub7fc\uc5d0 \ub300\ud55c \uad8c\ud55c. <\/span>
\n<\/span>\nUser_col_privs_recd : user\uac00 \ubd80\uc5ec\ubc1b\uc740 \uce7c\ub7fc\uc5d0 \ub300\ud55c \uad8c\ud55c. <\/span>
\n<\/span>\nUser_coll_types : user\uac00 \uba85\uba85\ud55c collection type\uc815\ubcf4. <\/span>
\n<\/span>\nUser_constraints : user\uc18c\uc720 \ud14c\uc774\ube14\uc758 \uc81c\uc57d\uc870\uac74\uc815\uc758. <\/span>
\n<\/span>\nUser_cons_columns : user\uc18c\uc720 \uc81c\uc57d\uc870\uac74\uc5d0 \uc815\uc758\ub41c \uce7c\ub7fc\uc5d0 \ub300\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nUser_db_links : user\uc18c\uc720 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub9c1\ud06c\uc5d0 \ub300\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nUser_dependencies : user\uc18c\uc720 object\uc5d0 \ub300\ud55c dependencies. <\/span>
\n<\/span>\nUser_errors : user\uc18c\uc720 \uc800\uc7a5 object\uc5d0 \ub300\ud55c \ud604\uc7ac\uc758 \uc5d0\ub7ec. <\/span>
\n<\/span>\nUser_extents : user\uc18c\uc720 object\uc5d0 \uc18d\ud558\ub294 \uc138\uadf8\uba3c\ud2b8\uc758 extent \uc815\ubcf4. <\/span>
\n<\/span>\nUser_free_space : user\uac00 access\uac00\ub2a5\ud55c \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub0b4\uc758 free extent \uc815\ubcf4. <\/span>
\n<\/span>\nUser_indexes : user \uc18c\uc720\uc758 indexes. Analyze\uba85\ub839\uc744 \uc0ac\uc6a9\ud574\uc57c\ud568. \ubcd1\ub82c\uc11c\ubc84\ub97c \uc9c0\uc6d0. <\/span>
\n<\/span>\nUser_ind_columns : user\uc18c\uc720 index \ub610\ub294 user\uc18c\uc720 table \uc758 \uce7c\ub7fc\uc815\ubcf4. <\/span>
\n<\/span>\nUser_ind_partitions : user\uc18c\uc720\uc758 index partition\uac01\uac01\uc5d0 \ub300\ud55c\uc124\uba85\uacfc, partition\uc815\ubcf4, partition\uc758 storage \ub9e4\uac1c\ubcc0\uc218, Analyze\uba85\ub839\uc73c\ub85c \uacb0\uc815\ub41c \uc5ec\ub7ecpartition\ud1b5\uacc4 <\/span>
\n<\/span>\nUser_jobs : user\uc18c\uc720\uc758 \ubaa8\ub4e0 job.(export\/import, execution) <\/span>
\n<\/span>\nUser_libraries : user\uc18c\uc720\uc758 \ubaa8\ub4e0 libraries . <\/span>
\n<\/span>\nUser_lobs : user\uc18c\uc720\uc758 table\uc5d0\ud3ec\ud568\ub41c LOBs\uc815\ubcf4. internal LOBs( BLOBs, NCLOBs) \ub9cc\ud574\ub2f9, external LOBs(i.e, BFILES)\uc740 \uc544\ub2d8. <\/span>
\n<\/span>\nUser_method_params : user type\uc758 method \ub9e4\uac1c\ubcc0\uc218. <\/span>
\n<\/span>\nUser_method_results : user type\uc758 method \uc758 results. <\/span>
\n<\/span>\nUser_nested_tables : user\uc18c\uc720 \ud14c\uc774\ube14\uc5d0 \ud3ec\ud568\ub41c nested tables. <\/span>
\n<\/span>\nUser_object_tables : user\uac00 \uc0ac\uc6a9\uac00\ub2a5\ud55c object table. <\/span>
\n<\/span>\nUser_objects : user\uc18c\uc720\uc758 object.(index partition, table partition, package, packagebody, trigger) <\/span>
\n<\/span>\nUser_object_size : user\uc18c\uc720\uc758 PL\/SQL object. <\/span>
\n<\/span>\nUser_obj_audit_opts : cataudit.sql\ub85c \uc0dd\uc131. user\uc18c\uc720\uc758 table,view\uc5d0 \ub300\ud55c \uac10\uc0acoption <\/span>
\n<\/span>\nUser_part_col_statistics : user\uc18c\uc720\uc758 tablepartition\uc815\ubcf4\uc5d0 \ub300\ud55c \uce7c\ub7fc\ud1b5\uacc4\uc640 \uadf8\ub798\ud504\uc815\ubcf4. <\/span>
\n<\/span>\nUser_part_histograms : user\uac00 access\ud560\uc218\uc788\ub294 table partition\uc758 histogram\uc5d0 \ub300\ud55c \uadf8\ub798\ud504\ub370\uc774\ud130(end-pointer). <\/span>
\n<\/span>\nUser_part_key_columns : user\uc18c\uc720\uc758 partition object\uc758 partition key\uce7c\ub7fc\uc5d0 \ub300\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nUser_part_indexes : \ubaa8\ub4e0 user\uc18c\uc720\uc758 partition index\uc758 partition\uc815\ubcf4. <\/span>
\n<\/span>\nUser_part_tables : user\uc18c\uc720\uc758 partition table\uc5d0 \ub300\ud55c object \ub808\ubca8\uc758 partition\uc815\ubcf4. <\/span><\/p>\n<\/span>


\n<\/span>\nUser_password_limits : user\uc5d0\uac8c \uc801\uc6a9\ub41c password profile parameter. <\/span>
\n<\/span>\nUser_queue_tables : user\uc18c\uc720 \uc2a4\ud0a4\ub9c8\uc5d0 \uc0dd\uc131\ub41c queue table\ub0b4\ubd80\uc758 queues\uc815\ubcf4. <\/span>
\n<\/span>\nUser_Queues : user\uc2a4\ud0a4\ub9c8\uc758 \ubaa8\ub4e0 queue\uc5d0 \ub300\ud55c \ub3d9\uc791 \ud2b9\uc131\uc744 \ub098\ud0c0\ub0c4. <\/span>
\n<\/span>\nUser_refresh : \ubaa8\ub4e0 refresh group. <\/span>
\n<\/span>\nUser_refresh_children : user\uac00 \uc18c\uc720\ud55c refresh group \ub0b4\ubd80\uc758 object\uc5d0 \uad00\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nUser_refs : user\uc18c\uc720\ud14c\uc774\ube14\uc758 object type\uce7c\ub7fc\uc911 REF\uce7c\ub7fc, REF\uc18d\uc131. <\/span>
\n<\/span>\nUser_resource_limits : \ud604\uc7ac user\uc758 resource \ud55c\uacc4. <\/span>
\n<\/span>\nUser_role_privs : user\uc5d0\uac8c \ubd80\uc5ec\ub41c roles. <\/span>
\n<\/span>\nUser_segments : user\uc624\ube0c\uc81d\ud2b8\uc5d0 \ud3ec\ud568\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4 segments\uc758 storage\ud560\ub2f9\uc815\ubcf4. <\/span>
\n<\/span>\nUser_sequences : user \uc18c\uc720\uc758 sequences. <\/span>
\n<\/span>\nUser_snapshots : user \uac00 \ubcfc\uc218\uc788\ub294 snapshots. <\/span>
\n<\/span>\nUser_snapshot_logs : user \uc18c\uc720\uc758 \ubaa8\ub4e0 snapshot logs. <\/span>
\n<\/span>\nUser_source : user\uc18c\uc720 \uc800\uc7a5 objects \uc758 \ubaa8\ub4e0 text source. <\/span>
\n<\/span>\nUser_snapshot_refresh_times : snapshot refresh time. <\/span>
\n<\/span>\nUser_synonyms : user\uc18c\uc720\uc758 synonym. <\/span>
\n<\/span>\nUser_sys_privs : user\uc5d0\uac8c \ubd80\uc5ec\ub41c system \uad8c\ud55c. <\/span>
\n<\/span>\nUser_tab_col_statistics : user_tab_columns view\uc5d0 \ub300\ud55c \uce7c\ub7fc\ud1b5\uacc4\uc640 \uadf8\ub798\ud504\uc815\ubcf4\ub97c \ub098\ud0c0\ub0c4. <\/span>
\n<\/span>\nUser_tab_columns : user\uc18c\uc720\uc758 table, view, cluster\uc758 \uce7c\ub7fc\uc815\ubcf4.(Analyze\uba85\ub839\uc0ac\uc6a9) <\/span>
\n<\/span>\nUser_tab_comments : user\uc18c\uc720\uc758 table, view\uc5d0 \ub300\ud55c \uc8fc\uc11d. <\/span>
\n<\/span>\nUser_tab_histograms : user\uc18c\uc720 table\uc758 \uce7c\ub7fc\uc5d0 \ub300\ud55c histogram. <\/span>
\n<\/span>\nUser_tab_partitions : user\uc18c\uc720 table partition\uc5d0 \ub300\ud55c, partition \ub808\ubca8\uc758 \ubd84\ud560\uc815\ubcf4\uc640, partition\uc758 storage\ub9e4\uac1c\ubcc0\uc218, Analyze\uc5d0 \uc758\ud574 \uc9d1\uacc4\ub41c \uc5ec\ub7ec\ud1b5\uacc4\uc815\ubcf4. <\/span>
\n<\/span>\nUser_tab_privs : user\uac00 \uc18c\uc720\ud55c, \ubd80\uc5ec\ud55c, \ubd80\uc5ec\ubc1b\uc740 object\uc5d0 \ub300\ud55c \uad8c\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nUser_tab_privs_made : user\uac00 \uc18c\uc720\ud55c object\uc5d0 \uad00\ud55c \ubaa8\ub4e0 \uad8c\ud55c. <\/span>
\n<\/span>\nUser_tab_privs_recd : user\uac00 \ubd80\uc5ec\ubc1b\uc740 object \uad8c\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nUser_tables : user\uc18c\uc720\uc758 relational table\uc5d0 \ub300\ud55c \uc815\ubcf4. (Analyze\uba85\ub839\uc0ac\uc6a9) <\/span>
\n<\/span>\nUser_tablespaces : user\uac00 access \uac00\ub2a5\ud55c tablespaces\uc5d0 \ub300\ud55c \uc124\uba85. <\/span>
\n<\/span>\nUser_triggers : user\uac00 \uc18c\uc720\ud55c triggers \uc815\ubcf4. <\/span>
\n<\/span>\nUser_trigger_cols : user\uac00 \uc18c\uc720\ud55c \ub610\ub294 user\ud14c\uc774\ube14\uc5d0 \uc788\ub294 trigger\uc548\uc758 column \uc815\ubcf4. <\/span>
\n<\/span>\nUser_ts_quotas : user\uc5d0\uac8c \ud560\ub2f9\ub41c tablespace quotas \uc815\ubcf4. <\/span>
\n<\/span>\nUser_types : \ud14c\uc774\ube14\uc548\uc758 user\uc18c\uc720\uc758 type. <\/span>
\n<\/span>\nUser_type_attrs : user type\uc758 \uc18d\uc131\uc744 \ub098\ud0c0\ub0c4. <\/span>
\n<\/span>\nUser_type_methods : user type\uc758 methods\ub97c \ub098\ud0c0\ub0c4. <\/span>
\n<\/span>\nUser_updatable_columns : join view\uc5d0\uc11c \uc0ac\uc6a9\uc790\uc5d0\uac8c update\uac00 \ud5c8\uc6a9\ub41c \uce7c\ub7fc\uc815\ubcf4. <\/span>
\n<\/span>\nUser_users : \ud604\uc7ac user\uc5d0 \uad00\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nUser_views : user \uc18c\uc720\uc758 view\uc5d0 \ub300\ud55c text. <\/span><\/p>\n<\/span>

FILEXT$ : \ub370\uc774\ud130\ud30c\uc77c\uc758 AUTOEXTEND\ub97c ON\uc73c\ub85c \ubcc0\uacbd\ud588\uc744 \ub54c \ucc98\uc74c \uc0dd\uc131. <\/span><\/p>\n<\/span>


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

\n<\/span>\uc2e4\uc2b5) <\/span><\/strong><\/span><\/div>\n<\/span>
\n<\/span><\/strong><\/span> <\/span><\/div>\n<\/span>
\n<\/span>SQL> set pages 80 <\/span><\/span><\/div>\n<\/span>
\n<\/span> <\/span><\/div>\n<\/span>
\n<\/span>SQL> set long 8000<\/span><\/span><\/div>\n<\/span>
\n<\/span> <\/span><\/div>\n<\/span>
\n<\/span>SQL> select text<\/span>
\n<\/span>\n  2     from dba_views<\/span>
\n<\/span>\n  3     where view_name='USER_TABLES';<\/span><\/span><\/div>\n<\/span>
\n<\/span> <\/span><\/div>\n<\/span>
\n<\/span>TEXT<\/span>
\n<\/span>\n--------------------------------------------------------------------------------<\/span>
\n<\/span>\nselect o.name, decode(bitand(t.property, 4194400), 0, ts.name, null),<\/span>
\n<\/span>\n       decode(bitand(t.property, 1024), 0, null, co.name),<\/span>
\n<\/span>\n       decode((bitand(t.property, 512)+bitand(t.flags, 536870912)),<\/span>
\n<\/span>\n              0, null, co.name),<\/span>
\n<\/span>\n       decode(bitand(t.property, 32+64), 0, mod(t.pctfree$, 100), 64, 0, null),<\/span>
\n<\/span>\n       decode(bitand(ts.flags, 32), 32, to_number(NULL),<\/span>
\n<\/span>\n          decode(bitand(t.property, 32+64), 0, t.pctused$, 64, 0, null)),<\/span>
\n<\/span>\n       decode(bitand(t.property, 32), 0, t.initrans, null),<\/span>
\n<\/span>\n       decode(bitand(t.property, 32), 0, t.maxtrans, null),<\/span>
\n<\/span>\n       s.iniexts * ts.blocksize,<\/span>
\n<\/span>\n       decode(bitand(ts.flags, 3), 1, to_number(NULL),<\/span>
\n<\/span>\n                                      s.extsize * ts.blocksize),<\/span>
\n<\/span>\n       s.minexts, s.maxexts,<\/span>
\n<\/span>\n       decode(bitand(ts.flags, 3), 1, to_number(NULL),<\/span>
\n<\/span>\n                                      s.extpct),<\/span>
\n<\/span>\n       decode(bitand(ts.flags, 32), 32, to_number(NULL),<\/span>
\n<\/span>\n         decode(bitand(o.flags, 2), 2, 1, decode(s.lists, 0, 1, s.lists))),<\/span>
\n<\/span>\n       decode(bitand(ts.flags, 32), 32, to_number(NULL),<\/span>
\n<\/span>\n         decode(bitand(o.flags, 2), 2, 1, decode(s.groups, 0, 1, s.groups))),<\/span>
\n<\/span>\n       decode(bitand(t.property, 32), 32, null,<\/span>
\n<\/span>\n                decode(bitand(t.flags, 32), 0, 'YES', 'NO')),<\/span>
\n<\/span>\n       decode(bitand(t.flags,1), 0, 'Y', 1, 'N', '?'),<\/span>
\n<\/span>\n       t.rowcnt,<\/span>
\n<\/span>\n       decode(bitand(t.property, 64), 0, t.blkcnt, null),<\/span>
\n<\/span>\n       decode(bitand(t.property, 64), 0, t.empcnt, null),<\/span>
\n<\/span>\n       decode(bitand(t.property, 64), 0, t.avgspc, null),<\/span>
\n<\/span>\n       t.chncnt, t.avgrln, t.avgspc_flb,<\/span>
\n<\/span>\n       decode(bitand(t.property, 64), 0, t.flbcnt, null),<\/span>
\n<\/span>\n       lpad(decode(t.degree, 32767, 'DEFAULT', nvl(t.degree,1)),10),<\/span>
\n<\/span>\n       lpad(decode(t.instances, 32767, 'DEFAULT', nvl(t.instances,1)),10),<\/span>
\n<\/span>\n       lpad(decode(bitand(t.flags, 8), 8, 'Y', 'N'),5),<\/span>
\n<\/span>\n       decode(bitand(t.flags, 6), 0, 'ENABLED', 'DISABLED'),<\/span>
\n<\/span>\n       t.samplesize, t.analyzetime,<\/span>
\n<\/span>\n       decode(bitand(t.property, 32), 32, 'YES', 'NO'),<\/span>
\n<\/span>\n       decode(bitand(t.property, 64), 64, 'IOT',<\/span>
\n<\/span>\n               decode(bitand(t.property, 512), 512, 'IOT_OVERFLOW',<\/span>
\n<\/span>\n               decode(bitand(t.flags, 536870912), 536870912, 'IOT_MAPPING', null<\/span>
\n<\/span>\n))),<\/span>
\n<\/span>\n       decode(bitand(o.flags, 2), 0, 'N', 2, 'Y', 'N'),<\/span>
\n<\/span>\n       decode(bitand(o.flags, 16), 0, 'N', 16, 'Y', 'N'),<\/span>
\n<\/span>\n       decode(bitand(t.property, 8192), 8192, 'YES',<\/span>
\n<\/span>\n              decode(bitand(t.property, 1), 0, 'NO', 'YES')),<\/span>
\n<\/span>\n       decode(bitand(o.flags, 2), 2, 'DEFAULT',<\/span>
\n<\/span>\n             decode(s.cachehint, 0, 'DEFAULT', 1, 'KEEP', 2, 'RECYCLE', NULL)),<\/span>
\n<\/span>\n       decode(bitand(t.flags, 131072), 131072, 'ENABLED', 'DISABLED'),<\/span>
\n<\/span>\n       decode(bitand(t.flags, 512), 0, 'NO', 'YES'),<\/span>
\n<\/span>\n       decode(bitand(t.flags, 256), 0, 'NO', 'YES'),<\/span>
\n<\/span>\n       decode(bitand(o.flags, 2), 0, NULL,<\/span>
\n<\/span>\n           decode(bitand(t.property, 8388608), 8388608,<\/span>
\n<\/span>\n                  'SYS$SESSION', 'SYS$TRANSACTION')),<\/span>
\n<\/span>\n       decode(bitand(t.flags, 1024), 1024, 'ENABLED', 'DISABLED'),<\/span>
\n<\/span>\n       decode(bitand(t.flags, 2097152), 2097152, 'YES', 'NO'),<\/span>
\n<\/span>\n       decode(bitand(t.property, 1024), 0, null, cu.name),<\/span>
\n<\/span>\n       decode(bitand(t.flags, 8388608), 8388608, 'ENABLED', 'DISABLED')<\/span>
\n<\/span>\nfrom sys.ts$ ts, sys.seg$ s, sys.obj$ co, sys.tab$ t, sys.obj$ o,<\/span>
\n<\/span>\n     sys.obj$ cx, sys.user$ cu<\/span>
\n<\/span>\nwhere o.owner# = userenv('SCHEMAID')<\/span>
\n<\/span>\n  and o.obj# = t.obj#<\/span>
\n<\/span>\n  and bitand(t.property, 1) = 0<\/span>
\n<\/span>\n  and t.bobj# = co.obj# (+)<\/span>
\n<\/span>\n  and t.ts# = ts.ts#<\/span>
\n<\/span>\n  and t.file# = s.file# (+)<\/span>
\n<\/span>\n  and t.block# = s.block# (+)<\/span>
\n<\/span>\n  and t.ts# = s.ts# (+)<\/span>
\n<\/span>\n  and t.dataobj# = cx.obj# (+)<\/span>
\n<\/span>\n  and cx.owner# = cu.user# (+)<\/span><\/span><\/div>\n<\/span>
\n<\/span>  \n<\/span>

[data dictionary \ub97c \uc774\uc6a9\ud55c \uc720\uc6a9\ud55c SQL]<\/span><\/strong><\/font><\/p>\n<\/span>

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

<\/strong>0 <\/span>\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \uc5ec\uc720\uacf5\uac04 \ud655\uc778<\/span><\/font><\/span><\/span><\/font><\/span><\/span><\/p>\n<\/span>

<\/span><\/font><\/span><\/span>1 \ud14c\uc774\ube14\uc774 \uc0ac\uc6a9\uc911\uc778 \ube14\ub85d \ud06c\uae30\ub97c \uacc4\uc0b0\ud574\uc8fc\ub294 SQL<\/span>
\n<\/span>\n2 \uc774\ubbf8 \ucef4\ud30c\uc77c\ub41c \ud504\ub85c\uc2dc\uc838\uc18c\uc2a4\ub97c \ubcf4\uace0\uc2f6\uc744 \ub54c \uc0ac\uc6a9\ud558\ub294 \uc2a4\ud06c\ub9bd\ud2b8<\/span>
\n<\/span>\n3 \ud14c\uc774\ube14\uc744 \ubcf5\uc0ac\ud574\uc8fc\ub294 \uc2a4\ud06c\ub9bd\ud2b8 (v8.0 only)<\/span>
\n<\/span>\n4 Table Data Size\ub97c \uc815\ud655\ud788 \uacc4\uc0b0\ud574\uc8fc\ub294 \uc2a4\ud06c\ub9bd\ud2b8<\/span>
\n<\/span>\n5 dead lock\uc774 \ubc1c\uc0dd\ud588\uc744\ub54c \ubc1c\uc0dd\uc2dc\ud0a8 \uc720\uc800\uc640 SQL\ubb38\uc744 \ucc3e\uc544\uc8fc\ub294 SQL<\/span>
\n<\/span>\n6 \ub515\uc154\ub108\ub9ac\uc5d0\uc11c \ud574\ub2f9 \ud0a4\uc6cc\ub4dc\uc5d0 \uad00\ud55c \ubdf0, \ud14c\uc774\ube14\uc744 \ucc3e\uc544\uc8fc\ub294 SQL<\/span>
\n<\/span>\n7 \uceec\ub7fc\uba85\ub9cc \uac00\uc9c0\uace0 \ud14c\uc774\ube14\uacfc \uc124\uc815\uc0c1\ud0dc\ub97c \ucc3e\uc544\uc8fc\ub294 SQL<\/span>
\n<\/span>\n8 Constraint \uc774\ub984\uc73c\ub85c \ud574\ub2f9 \ud14c\uc774\ube14\uacfc \uceec\ub7fc\ucc3e\ub294 SQL<\/span>
\n<\/span>\n9 PK\uc640 FK\uac04\uc758 \uc5f0\uad00\uad00\uacc4\ub97c \ucc3e\uc544 \ubcf4\uc5ec\uc8fc\ub294 SQL<\/span>
\n<\/span>\n10 \ud14c\uc774\ube14\uc758 \ud2b9\uc815 \uceec\ub7fc\uc5d0 \uc911\ubcf5\ub41c \uac12\uc744 \ucc3e\ub294 SQL<\/span><\/p>\n<\/span>

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

\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \uc5ec\uc720\uacf5\uac04 \ud655\uc778<\/span><\/font><\/strong><\/span><\/span><\/p>\n<\/span>

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

SQL> col file_name for a50<\/span><\/span><\/span><\/p>\n<\/span>

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

SQL> <\/span><\/span><\/span>select\nb.tablespace_name, b.file_name, b.bytes\"\ucd1d\ud06c\uae30\",sum(nvl(a.bytes,0)) \n\"\uc5ec\uc720\uacf5\uac04\",sum(nvl(a.bytes,0))\/sum(nvl(b.bytes,0))*100  \"\uc5ec\uc720\uacf5\uac04\uc728%\"<\/span>
\n<\/span>\n   from dba_free_space a, dba_data_files b<\/span>
\n<\/span>\n   where a.file_id(+) = b.file_id<\/span>
\n<\/span>\n   group by b.tablespace_name, b.file_name, b.bytes<\/span>
\n<\/span>\n    order by b.tablespace_name; <\/span><\/span><\/span><\/p>\n<\/span>

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

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

\ud14c\uc774\ube14\uc774 \uc0ac\uc6a9\uc911\uc778 \ube14\ub85d \ud06c\uae30\ub97c \uacc4\uc0b0\ud574\uc8fc\ub294 SQL<\/span>
\n<\/span><\/strong>\/*<\/span>
\n<\/span>\n** Table\uc774 \uc0ac\uc6a9\ud558\ub294 \ube14\ub7ed \ud06c\uae30\ub97c \uad6c\ud558\ub294 \uc2a4\ud06c\ub9bd\ud2b8... <<\uc720\uc5f0\uc218>><\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n** \uc0ac\uc6a9\ubc95 : 1) DBA \uad8c\ud55c\uc73c\ub85c \ub85c\uadf8\uc778\ud55c\ub2e4.<\/span>
\n<\/span>\n** 2) SQL> @tab_block [table\uba85]<\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n** Notice : sum(blocks)\ub294 \uc0ac\uc6a9\ud558\ub294 \ube14\ub7ed\uc758 \uac2f\uc218\uc774\uba70 \uc0ac\uc774\uc988\ub294 db_block_size\ub97c<\/span>
\n<\/span>\n** \uacf1\ud558\uc5ec \uc5bb\uc744 \uc218 \uc788\ub2e4.<\/span>
\n<\/span>\n*\/<\/span>
\n<\/span>\nSELECT OWNER, TABLESPACE_NAME, SEGMENT_NAME, SUM(BLOCKS)<\/span>
\n<\/span>\nFROM DBA_EXTENTS<\/span>
\n<\/span>\nWHERE SEGMENT_NAME = UPPER('&1')<\/span>
\n<\/span>\nGROUP BY OWNER, TABLESPACE_NAME, SEGMENT_NAME<\/span>
\n<\/span>\n\/<\/span>
\n<\/span>
\n<\/span>\uc774\ubbf8 \ucef4\ud30c\uc77c\ub41c \ud504\ub85c\uc2dc\uc838\uc18c\uc2a4\ub97c \ubcf4\uace0\uc2f6\uc744 \ub54c \uc0ac\uc6a9\ud558\ub294 \uc2a4\ud06c\ub9bd\ud2b8<\/span><\/strong>
\n<\/span>\n\/*<\/span>
\n<\/span>\n** PL\/SQL \uc18c\uc2a4\ub97c \ubcf4\uae30\uc704\ud55c \uc2a4\ud06c\ub9bd\ud2b8.. <\uc720\uc5f0\uc218><\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n** \uc0ac\uc6a9\ubc95 : find_plsql [\ud504\ub85c\uc2dc\uc838\uba85\uce6d]<\/span>
\n<\/span>\n** <\/span>
\n<\/span>\n** <\/span>
\n<\/span>\n*\/<\/span>
\n<\/span>\nselect text<\/span>
\n<\/span>\nfrom user_source<\/span>
\n<\/span>\nwhere name = upper('&1')<\/span>
\n<\/span>\norder by line;<\/span>
\n<\/span>
\n<\/span>\ud14c\uc774\ube14\uc744 \ubcf5\uc0ac\ud574\uc8fc\ub294 \uc2a4\ud06c\ub9bd\ud2b8 (v8.0 only)<\/span><\/strong>
\n<\/span>\n\/*<\/span>
\n<\/span>\n** table\uc744 \ub2e4\ub978 \uc2a4\ud0a4\ub9c8 \ud639\uc740 table\ub85c \ubcf5\uc0ac <<\uc720\uc5f0\uc218>><\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n** Notice) 1. Oracle 8.0 \uc774\uc0c1\uc5d0\uc11c\ub9cc \uc9c0\uc6d0. <\/span>
\n<\/span>\n** 2. sql*net \uc774 \uc124\uc815\ub418\uc5b4 \uc788\uc5b4\uc57c\ub9cc \ud55c\ub2e4.<\/span>
\n<\/span>\n** 3. \ud14c\uc774\ube14\uacfc PK\ub9cc \ubcf5\uc0ac\ud558\uace0 \uc778\ub371\uc2a4\ub294 \ubaa8\ub450 \ub2e4\uc2dc \uc0dd\uc131\ud574\uc8fc\uc5b4\uc57c \ud55c\ub2e4.<\/span>
\n<\/span>\n** \ub530\ub77c\uc11c \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud574 \uc8fc\uace0 \uc785\ub825\ud558\ub294\uac83\uc774 \uc88b\ub2e4.<\/span>
\n<\/span>\n** 4. sql*plus \uc5d0\uc11c\ub9cc \uc2e4\ud589\ub41c\ub2e4.<\/span>
\n<\/span>\n** \uc0ac\uc6a9\ubc95) @tab_copy scott\/tiger@link source_table_name target_table_name<\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n*\/<\/span>
\n<\/span>\ncopy from &1 create &3 using select * from &2<\/span>
\n<\/span>
\n<\/span>\n\/* \ub2e4\ub978 DB\ub85c \ubcf5\uc0ac\ud560\ub54c\ub294<\/span>
\n<\/span>\ncopy from &1 to &2 create &4 using select * from &3 <\/span>
\n<\/span>\n*\/<\/span>
\n<\/span>
\n<\/span>\n\/* \ubbf8\ub9ac \ub9cc\ub4e4\uc5b4\uc9c4 table\uc5d0 \uc785\ub825\ud560\ub54c\ub294<\/span>
\n<\/span>\ncopy from &1 insert &3 using select * from &2<\/span>
\n<\/span>\n*\/<\/span>
\n<\/span>
\n<\/span>Table Data Size\ub97c \uc815\ud655\ud788 \uacc4\uc0b0\ud574\uc8fc\ub294 \uc2a4\ud06c\ub9bd\ud2b8<\/span><\/strong>
\n<\/span>\n\/*<\/span>
\n<\/span>\n** Table Data Size\ub97c \uc815\ud655\ud788 \uacc4\uc0b0\ud574\uc8fc\ub294 \uc2a4\ud06c\ub9bd\ud2b8. <<\uc720\uc5f0\uc218>><\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n** \uc0ac\uc6a9\ubc95 : @tab_size [table_name]<\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n*\/<\/span>
\n<\/span>\nanalyze table &1 delete statistics;<\/span>
\n<\/span>\nanalyze table &1 compute statistics;<\/span>
\n<\/span>
\n<\/span>\nSELECT GREATEST(4, ceil(NUM_ROWS\/<\/span>
\n<\/span>\n( (round(((1958-(INI_TRANS*23))*((100-PCT_FREE)\/100))\/AVG_ROW_LEN)))) * 2048) TableSize_Kbytes<\/span>
\n<\/span>\nFROM user_tables<\/span>
\n<\/span>\nWHERE table_name = upper('&1'); <\/span>
\n<\/span>
\n<\/span>dead lock\uc774 \ubc1c\uc0dd\ud588\uc744\ub54c \ubc1c\uc0dd\uc2dc\ud0a8 \uc720\uc800\uc640 SQL\ubb38\uc744 \ucc3e\uc544\uc8fc\ub294 SQL<\/span><\/strong>
\n<\/span>\n\/*\u3000\u3000 <\/span>
\n<\/span>\n**\u3000\u3000 <\/span>
\n<\/span>\n**\u3000 \uc0ac\uc6a9\ubc95\u3000\u3000 :SQL> @find_deadlock<\/span>
\n<\/span>\n**\u3000 Description : \ub370\ub4dc\ub77d\uc774 \ubc1c\uc0dd\ud560 \uacbd\uc6b0 locking \ub41c \uc720\uc800\uc640 sql\ubb38\uc744 \ubcf4\uc5ec\uc900\ub2e4.<\/span>
\n<\/span>\n**\u3000\u3000 <\/span>
\n<\/span>\n**\u3000 \ub370\ub4dc\ub77d\uc774 \ubc1c\uc0dd\ud55c \uc720\uc800\ub97c kill \ud558\ub824\uba74.<\/span>
\n<\/span>\n** Alter system kill session ''{serial#},{SID}'';<\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n*\/<\/span>
\n<\/span>\nSelect a.serial#, a.sid, a.username, b.id1, c.sql_text<\/span>
\n<\/span>\nfrom v$session a, v$lock b, v$sqltext c<\/span>
\n<\/span>\nwhere b.id1 in( select distinct e.id1 from v$session d, v$lock e<\/span>
\n<\/span>\nwhere d.lockwait = e.kaddr)<\/span>
\n<\/span>\nand a.sid = b.sid<\/span>
\n<\/span>\nand c.hash_value = a.sql_hash_value<\/span>
\n<\/span>\nand b.request = 0;<\/span>
\n<\/span>
\n<\/span>\ub515\uc154\ub108\ub9ac\uc5d0\uc11c \ud574\ub2f9 \ud0a4\uc6cc\ub4dc\uc5d0 \uad00\ud55c \ubdf0, \ud14c\uc774\ube14\uc744 \ucc3e\uc544\uc8fc\ub294 SQL<\/span><\/strong>
\n<\/span>\n\/*<\/span>
\n<\/span>\n** \ub515\uc154\ub108\ub9ac\ub85c\ubd80\ud130 \uc785\ub825\ud55c \ud0a4\uc6cc\ub4dc\uc5d0 \uad00\ud55c \ud14c\uc774\ube14\uba85\uc744 \uc870\ud68c\ud55c\ub2e4. <<\uc720\uc5f0\uc218>><\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n** \uc0ac\uc6a9\ubc95 : SQL> @dic_find [\ud0a4\uc6cc\ub4dc(\ub300\uc18c\ubb38\uc790\uac00\ub9bc)]<\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n*\/<\/span>
\n<\/span>\ncol TABLE_NAME format a15<\/span>
\n<\/span>\ncol COMMENTS format a100<\/span>
\n<\/span>
\n<\/span>\nselect * from dictionary<\/span>
\n<\/span>\nwhere COMMENTS like ('%&1%')<\/span>
\n<\/span>\n\/<\/span>
\n<\/span>
\n<\/span>\uceec\ub7fc\uba85\ub9cc \uac00\uc9c0\uace0 \ud14c\uc774\ube14\uacfc \uc124\uc815\uc0c1\ud0dc\ub97c \ucc3e\uc544\uc8fc\ub294 SQL<\/span><\/strong>
\n<\/span>\n\/*<\/span>
\n<\/span>\n** \uceec\ub7fc\uc758 \uc2a4\ud399\uacfc, \uc18c\uc18d \ud14c\uc774\ube14\uc744 \ucc3e\ub294\ub2e4. <<\uc720\uc5f0\uc218>><\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n** \uc0ac\uc6a9\ubc95 : SQL> @col_find [\uceec\ub7fc\uba85]<\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n*\/<\/span>
\n<\/span>\ncol CNAME format a20<\/span>
\n<\/span>\ncol COLTYPE format a10<\/span>
\n<\/span>\ncol NULLS format a5<\/span>
\n<\/span>\ncol DEFAULTVAL format a10<\/span>
\n<\/span>
\n<\/span>\nselect TNAME, COLNO, CNAME, COLTYPE, WIDTH, NULLS, DEFAULTVAL<\/span>
\n<\/span>\nfrom col<\/span>
\n<\/span>\nwhere CNAME = UPPER('&1')<\/span>
\n<\/span>\n\/<\/span>
\n<\/span>
\n<\/span>Constraint \uc774\ub984\uc73c\ub85c \ud574\ub2f9 \ud14c\uc774\ube14\uacfc \uceec\ub7fc\ucc3e\ub294 SQL<\/span><\/strong>
\n<\/span>\n\/*<\/span>
\n<\/span>\n**=============================================<\/span>
\n<\/span>\n** CONSTRAINT \uc774\ub984\uc73c\ub85c \uc0ac\uc6a9 \ud14c\uc774\ube14 \ucc3e\uae30 <\/span>
\n<\/span>\n**=============================================<\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n** Usage : @Show_Columns Constraint_Name<\/span>
\n<\/span>\n** Description : Shows The Columns Bound By A Constraint<\/span>
\n<\/span>\n** \uc0ac\uc6a9\uc608 : SQL> @show_Columns PK_EMPNO<\/span>
\n<\/span>\n*\/<\/span>
\n<\/span>\nSET VERIFY OFF<\/span>
\n<\/span>\nCLEAR BREAK<\/span>
\n<\/span>\nBREAK ON CONSTRAINT_NAME ON TABLES<\/span>
\n<\/span>
\n<\/span>\nSELECT SUBSTR(CONSTRAINT_NAME,1,25) CONSTRAINT_NAME,<\/span>
\n<\/span>\nSUBSTR(TABLE_NAME,1,15) TABLES,<\/span>
\n<\/span>\nSUBSTR(COLUMN_NAME,1,15) COL_NAME<\/span>
\n<\/span>\nFROM ALL_CONS_COLUMNS<\/span>
\n<\/span>\nWHERE CONSTRAINT_NAME = UPPER('&1');<\/span>
\n<\/span>
\n<\/span>\n[b][color=BLUE]\uceec\ub7fc\uc5d0 \uac78\ub824\uc788\ub294 constraint \ub97c \ubcf4\uc5ec\uc8fc\ub294 SQL[\/color][\/b]<\/span>
\n<\/span>
\n<\/span>\n\/*<\/span>
\n<\/span>\n**=======================================<\/span>
\n<\/span>\n** \ud574\ub2f9 COLUMN\uc5d0 \uac78\ub824 \uc788\ub294 CONSTRAINT\ud655\uc778<\/span>
\n<\/span>\n**=======================================<\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n** Usage : @Show_Constraints Table_Name Column_Name<\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n** Description : \ud574\ub2f9 Table\uc758 Column\uc5d0 \uac78\ub824 \uc788\ub294 Constraint\ub97c \ubcf4\uc5ec\uc900\ub2e4.<\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n** < \uc2e4\ud589 \uc608 ><\/span>
\n<\/span>\n** SQL> @SHOW_CONSTRAINTS WIDGETS LENGTH<\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n*\/<\/span>
\n<\/span>
\n<\/span>\nSET VERIFY OFF<\/span>
\n<\/span>\nCLEAR BREAK<\/span>
\n<\/span>\nBREAK ON TABLES ON COL_NAME<\/span>
\n<\/span>\nSELECT SUBSTR(TABLE_NAME,1,15) TABLES,<\/span>
\n<\/span>\nSUBSTR(COLUMN_NAME,1,15) COL_NAME,<\/span>
\n<\/span>\nSUBSTR(CONSTRAINT_NAME,1,25) CONSTRAINT_NAME<\/span>
\n<\/span>\nFROM USER_CONS_COLUMNS<\/span>
\n<\/span>\nWHERE TABLE_NAME = UPPER(''&1'')<\/span>
\n<\/span>\nAND COLUMN_NAME = UPPER(''&2'');<\/span>
\n<\/span>
\n<\/span>PK\uc640 FK\uac04\uc758 \uc5f0\uad00\uad00\uacc4\ub97c \ucc3e\uc544 \ubcf4\uc5ec\uc8fc\ub294 SQL<\/span><\/strong>
\n<\/span>\n\/*\u3000\u3000 <\/span>
\n<\/span>\n**\u3000\u3000 <\/span>
\n<\/span>\n**\u3000 \uc0ac\uc6a9\ubc95\u3000\u3000 \u3000 :> @Show_Positions\u3000 Parent_Table\u3000 Child_Table\u3000\u3000 <\/span>
\n<\/span>\n**\u3000 Description\u3000 :\u3000 Shows Primary And Foreign Key Positions\u3000\u3000 <\/span>
\n<\/span>\n**\u3000\u3000 <\/span>
\n<\/span>\n**\u3000 WARNING\u3000\u3000 :\u3000 \uc774 \ubb38\uc7a5\uc740 \ud574\ub2f9 Table\uc758 Constraint\uc0dd\uc131\uc2dc Naming\u3000\u3000\u3000 <\/span>
\n<\/span>\n**\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000 Convention\uc744 \ub530\ub978 \uacbd\uc6b0\uc5d0 \uc801\uc6a9\ub418\ub3c4\ub85d \ub418\uc5b4 \uc788\ub2e4.\u3000\u3000 <\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n*\/<\/span>
\n<\/span>\nSET VERIFY OFF\u3000\u3000 <\/span>
\n<\/span>\nCLEAR BREAK\u3000\u3000 <\/span>
\n<\/span>\nBREAK ON CONSTRAINT_NAME ON TABLES<\/span>
\n<\/span>\nSELECT SUBSTR(CONSTRAINT_NAME,1,27) CONSTRAINT_NAME,<\/span>
\n<\/span>\nSUBSTR(TABLE_NAME,1,15) TABLES,<\/span>
\n<\/span>\nSUBSTR(COLUMN_NAME,1,15) COL_NAME,<\/span>
\n<\/span>\nSUBSTR(POSITION,1,3) POSITION,<\/span>
\n<\/span>\nSUBSTR(OWNER,1,7) OWNER<\/span>
\n<\/span>\nFROM USER_CONS_COLUMNS WHERE TABLE_NAME = UPPER(''&1'') AND CONSTRAINT_NAME LIKE ''PK%''<\/span>
\n<\/span>\nUNION<\/span>
\n<\/span>\nSELECT SUBSTR(CONSTRAINT_NAME,1,27) CONSTRAINT_NAME,<\/span>
\n<\/span>\nSUBSTR(TABLE_NAME,1,15) TABLES, <\/span>
\n<\/span>\nSUBSTR(COLUMN_NAME,1,25) COL_NAME,<\/span>
\n<\/span>\nSUBSTR(POSITION,1,3) POSITION,<\/span>
\n<\/span>\nSUBSTR(OWNER,1,7) OWNER<\/span>
\n<\/span>\nFROM USER_CONS_COLUMNS WHERE TABLE_NAME = UPPER(''&2'') AND CONSTRAINT_NAME LIKE ''FK%''<\/span>
\n<\/span>\nORDER BY 1 DESC,4 ASC;<\/span>
\n<\/span>
\n<\/span>\ud14c\uc774\ube14\uc758 \ud2b9\uc815 \uceec\ub7fc\uc5d0 \uc911\ubcf5\ub41c \uac12\uc744 \ucc3e\ub294 SQL<\/span>
\n<\/span><\/strong>\/*<\/span>
\n<\/span>\n**=============================================<\/span>
\n<\/span>\n** \uc911\ubcf5\ub41c \uac12 \uc788\ub294\uc9c0 \ucc3e\uae30<\/span>
\n<\/span>\n**=============================================<\/span>
\n<\/span>\n** Usage : @\uc911\ubcf5\ucc3e\uae30.sql [\ud14c\uc774\ube14\uba85] [\uc911\ubcf5\uc744\uc870\uc0ac\ud560\uceec\ub7fc\uba85]<\/span>
\n<\/span>\n**<\/span>
\n<\/span>\n** Warning : \ub611\uac19\uc740\uac12\uc774 2\uac1c \uc774\uc0c1\uc788\uc744\ub54c \ucc98\uc74c\uac12\uc740 \ucd9c\ub825 \uc54a\ub418\uace0 2\ubc88\uc9f8 \uac12\ubd80\ud130 \ucd9c\ub825\ub428. <><\/span>
\n<\/span>\n*\/<\/span>
\n<\/span>
\n<\/span>\nselect * from &1 A<\/span>
\n<\/span>\nwhere rowid > <\/span>
\n<\/span>\n(SELECT min(rowid) FROM &1 B<\/span>
\n<\/span>\nWHERE B.&2 = A.&2)<\/span>
\n<\/span>\norder by &2;<\/span><\/font><\/p>\n<\/span>

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

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


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

  <\/span><\/span> <\/span><\/span>\u261e<\/span><\/span>   <\/span><\/span>Dynamic Performance table <\/span><\/strong><\/span><\/p>\n<\/span>

\n<\/span><\/strong><\/span> <\/span><\/div>\n<\/span>\n<\/span>
\n<\/span>\u2013<\/span><\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 instance\ub97c \ubaa8\ub2c8\ud130\ud558\uace0 tuning \ud558\uae30 \uc704\ud574 DBA\uc5d0 \uc758\ud574 \uc0ac\uc6a9\ub418\ub294 \uc815\ubcf4\ub97c <\/span><\/font><\/span>\ud3ec\ud568<\/span><\/font> <\/span><\/span><\/div>\n<\/span>

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

Dynamic Performance table \ucd1d\uc815\ub9ac) <\/span><\/strong><\/p>\n<\/span>

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

V$ACCESS : \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 lock\uc774\uac78\ub9b0 object\uc640 \uadf8 object\ub97c access \ud558\ub824\ub294 session id. <\/span>
\n<\/span>\nV$ACTIVE_INSTANCES : \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 Mount\ub41c <\/span>
\n<\/span>\n\ubaa8\ub4e0 \uc778\uc2a4\ud134\uc2a4\uc5d0\ub300\ud558\uc5ec \uc778\uc2a4\ud134\uc2a4 \uc774\ub984\uacfc, \ubc88\ud638\ub97c \ub9e4\uce58. <\/span>
\n<\/span>\nV$AQ : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 Queue\uc5d0 \ub300\ud55c \ud1b5\uacc4. <\/span>
\n<\/span>\nV$ARCHIVE : Archive\uc5d0 \ud544\uc694\ud55c redo log file\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\n\uac01\uac01\uc758 \ud589\uc740 \ud558\ub098\uc758 thread\uc5d0 \ub300\ud55c \uc815\ubcf4\uc774\ub2e4. V$LOG\ub3c4 \ub3d9\uc77c\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nV$ARCHIVE_DEST : \ud604\uc7ac\uc758 instance\uc5d0\uc11c, \ubaa8\ub4e0 archive log destination, <\/span>
\n<\/span>\n\ud604\uc7ac\uac12, mode, status. <\/span>
\n<\/span>\nV$ARCHIVED_LOG : archive log \uc774\ub984\uc744 \ud3ec\ud568\ud558\ub294 controlfile\uc5d0 \ub300\ud55c archive log \uc815\ubcf4, <\/span>
\n<\/span>\narchive log \uae30\ub85d\uc740 online\uc911 redo log\uac00 \uc131\uacf5\uc801\uc73c\ub85c \uc800\uc7a5\ub418\uc5c8\uac70\ub098, <\/span>
\n<\/span>\nclear(log\uac00 clear\ub418\uba74, name\uce7c\ub7fc\uc740 null\uc774 \ub41c\ub2e4)\ub41c\ud6c4 insert\ub41c\ub2e4. <\/span>
\n<\/span>\nV$BACKUP : \ubaa8\ub4e0 online \ub370\uc774\ud130\ud30c\uc77c\uc758 backup \uc0c1\ud0dc\ub97c \ub098\ud0c0\ub0b8\ub2e4. <\/span>
\n<\/span>\nV$BACKUP_CORRUPTION : \ub370\uc774\ud130\ud30c\uc77c\uc758 backup \uc911 \uc5d0\ub7ec\uc815\ubcf4\ub97c \ub098\ud0c0\ub0b8\ub2e4. <\/span>
\n<\/span>\n\uc5d0\ub7ec\ub4e4\uc740 control \ud30c\uc77c\uacfc achived log backup \uc5d0 \ud3ec\ud568\ub418\uc9c0 \uc54a\ub294\ub2e4. <\/span>
\n<\/span>\nV$BACK_DATAFILE : control \ud30c\uc77c\uc5d0\uc11c datafile\uacfc controlfile \uc758 backup\uc815\ubcf4\ub97c \ubcf4\uc5ec\uc90c. <\/span>
\n<\/span>\nV$BACK_DEVICE : \uc9c0\uc6d0\ub418\ub294 backup \ub514\ubc14\uc774\uc2a4\uc815\ubcf4. <\/span>
\n<\/span>\nV$BACK_PIECE : controlfile\uc5d0\uc11c backup piece\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \ud3ec\ud568. <\/span>
\n<\/span>\n\uac01\uac01\uc758 backup set \uc740 \ud558\ub098 \ub610\ub294 \uadf8\uc774\uc0c1\uc758 backup piece\ub85c \uad6c\uc131\ub41c\ub2e4. <\/span>
\n<\/span>\nV$BACKUP_REDOLOG : controlfile\uc5d0\uc11c backup set\uc758 \uc800\uc7a5\ub41c log\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nOnline redo logs\ub294 \uace7\ubc14\ub85c backup \ub418\uc9c0 \uc54a\ub294\ub2e4: \uba3c\uc800 disk\uc5d0 \uc800\uc7a5\ub41c\ud6c4 backup <\/span>
\n<\/span>\n\ub41c\ub2e4. \uc800\uc7a5\ub41c log backup set \uc740 \ud558\ub098 \ub610\ub294 \uadf8\uc774\uc0c1\uc758 logs\ub4e4\ub85c \uad6c\uc131\ub41c\ub2e4. <\/span>
\n<\/span>\nV$BACKUP_SET : controlfile\uc5d0\uc11c backupset \uc815\ubcf4\ub97c \ubcf4\uc5ec\uc90c. <\/span>
\n<\/span>\nbackup set \ud589\uc740 backup set\uc774 \uc131\uacf5\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\uc744 \ub54c insert\ub41c\ub2e4. <\/span>
\n<\/span>\nV$BGPROCESS : \ubc31\uadf8\ub77c\uc6b4\ub4dc \ud504\ub85c\uc138\uc2a4 \uc815\ubcf4. <\/span>
\n<\/span>\nV$BH : \ubcd1\ub82c\uc11c\ubc84 view\uc774\ub2e4. <\/span>
\n<\/span>\nSGA\ub0b4\uc758 \ubaa8\ub4e0 \ubc84\ud37c\uc5d0 \ub300\ud55c ping\uc758 \uc0c1\ud0dc\uc640 \uc218\ub97c \ub098\ud0c0\ub0b8\ub2e4. <\/span>
\n<\/span>\nV$BUFFER_POOL : \uc778\uc2a4\ud134\uc2a4\ub0b4\uc5d0\uc11c \uc0ac\uc6a9\uac00\ub2a5\ud55c \ubaa8\ub4e0 \ubc84\ud37c\ud480\uc5d0 \ub300\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nV$CACHE : \ubcd1\ub82c\uc11c\ubc84 view\uc774\ub2e4. <\/span>
\n<\/span>\n\ud2b9\uc815\ub370\uc774\ud0c0\ubca0\uc774\uc2a4object\uc5d0 \uad00\ub828\ub41c \ud604\uc7ac\uc758 \uc778\uc2a4\ud134\uc2a4\uc758 <\/span>
\n<\/span>\nSGA\ub0b4\ubd80\uc758 \uac01\uac01\uc758 block\uc5d0 \ub300\ud55c block header\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nV$CACHE_LOCK : \ubcd1\ub82c\uc11c\ubc84view. platform-specific lock manager \uc2dd\ubcc4\uc790\ub97c \uc81c\uc678\ud558\uba74, <\/span>
\n<\/span>\nV$CACHE\uc640 \uc720\uc0ac\ud558\ub2e4. <\/span>
\n<\/span>\nV$CIRCUIT : \uac00\uc0c1 circuit\uc5d0 \uad00\ud55c \uc815\ubcf4\uc774\uba70, \uac00\uc0c1circuit\ub780 dispatcher\uc640 server\ub97c <\/span>
\n<\/span>\n\ud1b5\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 user \uc5f0\uacb0\uc744 \ub9d0\ud55c\ub2e4. <\/span>
\n<\/span>\nV$CLASS_PING : \uac01\uac01blockclass\ub9c8\ub2e4 ping\ub41c \ube14\ub85d\uc758 \uc218\ub97c\ub098\ud0c0\ub0b8\ub2e4. <\/span>
\n<\/span>\n\ub2e4\ub978class\ube14\ub85d\uc758 \ucda9\ub3cc\uc744 \ube44\uad50\ud558\uae30\uc704\ud574 \uc0ac\uc6a9. <\/span>
\n<\/span>\nV$COMPATIBILITY : \uc774\uc804\ubc84\uc804\uc73c\ub85c downgrade\ub97c \ubc29\uc9c0\ud558\uae30\uc704\ud574 <\/span>
\n<\/span>\n\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc778\uc2a4\ud134\uc2a4\uc5d0 \uc758\ud574 \uc0ac\uc6a9\ub41c\ud2b9\uc131\ub4e4\uc744 \uc124\uba85. <\/span>
\n<\/span>\n\ub2e4\ub978 \uc778\uc2a4\ud134\uc2a4\uac00 \uac16\uace0\uc788\ub294 \ud2b9\uc131\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\uc9c0 \uc54a\uc73c\uba70, <\/span>
\n<\/span>\n\ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc644\uc804\ud788 \uc815\uc9c0\ud55c\uc774\ud6c4\uc5d0\ub3c4 \uc874\uc7ac\ud558\uc9c0 \uc54a\ub294 \uc77c\uc2dc\uc801\uc778 <\/span>
\n<\/span>\n\ube44\ud638\ud658\uc131\ub4e4\uc744 \ud3ec\ud568\ud560\uc218\ub3c4 \uc788\ub2e4. <\/span>
\n<\/span>\nV$COMPATSEG : \uc774\uc804\ubc84\uc804\uc73c\ub85c \ub418\ub3cc\uc544\uac00\ub294 \uac83\uc744 \ub9c9\uae30\uc704\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c <\/span>
\n<\/span>\n\uc0ac\uc6a9\ub418\ub294 \uc601\uad6c\uc801\uc778 \ud2b9\uc131\ub4e4. <\/span>
\n<\/span>\nV$CONTROLFILE : \ucee8\ud2b8\ub864\ud30c\uc77c\uc758 \uc774\ub984\uacfc \uc0c1\ud0dc. <\/span>
\n<\/span>\nV$CONTROLFILE_RECORD_SECTION : \ucee8\ud2b8\ub864\ud30c\uc77c\uc758 record\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nV$COPY_CORRUPTION : \ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130 \ub370\uc774\ud130\ud30c\uc77c\uc758 \ubcf5\uc0ac\ubd88\ub7c9\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nV$CURRENT_BUCKET : \uce90\uc26c\ub0b4\uc758 \ubc84\ud37c\uc758 \uc218\uac00 \uac10\uc18c\ud560\ub54c \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \uce90\uc26c\uc190\uc2e4\uc758 \uacbd\uc6b0\uc218\ub97c \uc608\uc0c1\ud558\ub294\ub370 \uc720\uc6a9. <\/span>
\n<\/span>\nV$DATABASE : control file \ub85c\ubd80\ud130 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc815\ubcf4\ub97c \ud3ec\ud568. <\/span>
\n<\/span>\nV$DATAFILE : \ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130\ub370\uc774\ud0c0\ud30c\uc77c\uc5d0\ub300\ud55c \uc815\ubcf4\ub97c \ud3ec\ud568. <\/span>
\n<\/span>\nV$DATAFILE_COPY :\ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130 \ub370\uc774\ud130\ud30c\uc77c\uc758 \ubcf5\uc0ac\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c\ud3ec\ud568. <\/span>
\n<\/span>\nV$DATAFILE_HEADER : \ub370\uc774\ud130\ud30c\uc77c\ud5e4\ub354\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span><\/p>\n<\/span>

V$DBFILE : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uad6c\uc131\ud558\ub294 \ubaa8\ub4e0 \ub370\uc774\ud130\ud30c\uc77c. \ub300\uc2e0\uc5d0 V$DATAFILE \ucd94\ucc9c\ud55c\ub2e4. <\/span>
\n<\/span>\nV$DBLINK : \uc138\uc158\uc5d0 \uc758\ud574 open\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub9c1\ud06c\uc5d0 \ub300\ud55c \uc124\uba85. <\/span>
\n<\/span>\n\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub9c1\ud06c\ub4e4\uc740 \ub2eb\ud788\uae30\uc804\uc5d0 commit\ub418\uac70\ub098 rollback\ub418\uc5b4\uc57c\ub9cc \ud55c\ub2e4. <\/span><\/p>\n<\/span>

V$DB_OBJECT_CACHE : library cache\uc5d0 cach\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc624\ube0c\uc81d\ud2b8\ub97c \ub098\ud0c0\ub0c4. <\/span>
\n<\/span>\nV$DB_PIPES : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \ud604\uc7ac \uc6b4\uc601\uc911\uc778 pipe\uc5d0 \ub300\ud55c \uc124\uba85. <\/span>
\n<\/span>\nV$DELETED_OBJECT : \uc0ad\uc81c\ub41c archived \ub85c\uadf8, \ub370\uc774\ud130\ud30c\uc77c copy, <\/span>
\n<\/span>\n\ucee8\ud2b8\ub864\ud30c\uc77c\uc5d0\uc11c \ubc31\uc5c5piece \uc5d0 \ub300\ud55c \uc815\ubcf4. \uc774\ubdf0\uc758 \ubaa9\uc801\uc740 \ubcf5\uad6c\ubaa9\ub85d\uc758 <\/span>
\n<\/span>\n\uc7ac\ub3d9\uc870\uc791\uc5c5\uc744 \ucd5c\uc801\ud654\ud558\ub294 \uac83\uc774\ub2e4. archived \ub85c\uadf8\ub098, \ub370\uc774\ud130\ud30c\uc77c copy, <\/span>
\n<\/span>\n\ubc31\uc5c5piece \ub4f1\uc774 \uc0ad\uc81c\ub420\ub54c\ub294 \ud574\ub2f9\ud558\ub294 \ud589\uc774\uc0ad\uc81c\ub418\uc5c8\uc74c\uc774 \ud45c\uc2dc\ub41c\ub2e4. <\/span>
\n<\/span>\nV$DISPATCHER : dispatcher \ud504\ub85c\uc138\uc2a4\uc5d0 \uad00\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nV$DISPATCHER_RATE : dispatcher \ud504\ub85c\uc138\uc11c\uc5d0 \uad00\ub828\ub41c \ud655\ub960\ud1b5\uacc4. <\/span>
\n<\/span>\nV$DLM_CONVERT_LOCAL : lock \ubcc0\ud658\uc791\uc5c5\uc5d0 \ub300\ud55c \uacbd\uacfc\uc2dc\uac04. <\/span>
\n<\/span>\nV$DLM_CONVERT_REMOTE : \uc6d0\uaca9 lock\ubcc0\ud658\uc791\uc5c5\uc5d0 \ub300\ud55c \uacbd\uacfc\uc2dc\uac04. <\/span>
\n<\/span>\nV$DLM_LATCH : DLM \uc7a0\uae08\uc5d0 \ub300\ud55c \ud1b5\uacc4. <\/span>
\n<\/span>\n\uac01\uac01\uc758 \uc7a0\uae08\uc5d0 \ub300\ud55c \ud1b5\uacc4\ubcf4\ub2e4\ub294, \uac01 \ud0c0\uc785\uc5d0 \ub300\ud55c \ucd1d\uacc4\ub97c \ud3ec\ud568. <\/span>
\n<\/span>\n\uac1c\ub150\uc801\uc73c\ub85c IMM_GETS\/TTL_GETS \uac12\uc740 1\uc5d0 \uac00\uae5d\uac8c \ub41c\ub2e4. <\/span>
\n<\/span>\nV$DLM_LOCKS : \ubcd1\ub82c\uc11c\ubc84 view\uc774\ub2e4. \ube14\ub85d\ud654\ub418\uc5c8\uac70\ub098, \ub2e4\ub978 \uac83\uc744 \ube14\ub85d\ud654\ud558\uace0\uc788\ub294 lock manager\uc5d0 \uc54c\ub824\uc9c4 \ubaa8\ub4e0 lock\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nV$DML_MISC : \uc7a1\ub2e4\ud55c DLM \ud1b5\uacc4\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nV$ENABLEDPRIVS:\uc0ac\uc6a9\uac00\ub2a5\ud55c \uad8c\ud55c\uc5d0 \ub300\ud55c\uc815\ubcf4, \uc774\ub4e4\uad8c\ud55c\uc740 <\/span>
\n<\/span>\nSYS.SYSTEM_PRIVILEGES_MAP\ud14c\uc774\ube14\uc5d0 \uc874\uc7ac\ud574\uc57c\ub9cc \ud55c\ub2e4. <\/span>
\n<\/span>\nV$ENQUEUE_LOCK : \ud050\uc5d0 \ub300\uae30\uc0c1\ud0dc\uc778 \uc624\ube0c\uc81d\ud2b8\uc5d0\uc758\ud574 \uc18c\uc720\ub41c \ubaa8\ub4e0 lock\uc774 <\/span>
\n<\/span>\nview\uc758 \uce7c\ub7fc\uc740 V$LOCK\uc758 \uce7c\ub7fc\uacfc \ub3d9\uc77c\ud558\ub2e4. <\/span>
\n<\/span>\n\uc790\uc138\ud55c \uac83\uc740 V$LOCK\uc744 \ucc38\uace0. <\/span>
\n<\/span>\nV$EVENT_NAME : wait event \uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nV$EXECUTION : \ubcd1\ub82c \uc9c8\uc758 \uc2e4\ud589\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nV$EXECUTION_LOCATION : \ubcd1\ub82c \uc9c8\uc758 \uc2e4\ud589 \ud2b8\ub9ac\uc758 \uc704\uce58\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nV$FALSE_PING : \ubcd1\ub82c\uc11c\ubc84view. ping\uc5d0 \uc2e4\ud328\uc9c0\ub3c4 \ubaa8\ub974\ub294 \ubc84\ud37c\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\n\uc989, 10\ud68c\uc774\uc0c1ping\ub41c \ub2e4\ub978 \ubc84\ud37c\uc640 <\/span>
\n<\/span>\n\ub3d9\uc77c\ud55c lock\uc73c\ub85c \uc7a0\uaca8\uc788\ub294 \ubc84\ud37c\ub97c \ub9d0\ud55c\ub2e4. <\/span>
\n<\/span>\nping\uc774 \uc2e4\ud328\ub85c \ud310\uba85\ub41c \ubc84\ud37c\ub294 lock\ucda9\ub3cc\uc744 \uac10\uc18c\uc2dc\ud0a4\uae30\uc704\ud574 <\/span>
\n<\/span>\n1-44\ud398\uc774\uc9c0\uc758 \"GC_FILES_TO_LOCK\"\uc5d0 \ub2e4\uc2dc \ub9e4\ud551\ub41c\ub2e4. <\/span>
\n<\/span>\nV$FILE_PING : \ub370\uc774\ud130\ud30c\uc77c\ub9c8\ub2e4 ping\ub41c \ube14\ub85d\uc218\ub97c \ubcf4\uc5ec\uc90c. \uc774\uc815\ubcf4\ub294 \ud604\uc874\ud558\ub294 \ub370\uc774\ud130\ud30c\uc77c\uc5d0 \ub300\ud55c access\ud328\ud134\uc744 \uacb0\uc815\ud558\ub294\ub370 and, \ub370\uc774\ud130\ud30c\uc77c\ube14\ub85d\uc744 PCM lock\uc5d0 \uc0c8\ub85c \ub9e4\ud551\ud558\ub294\uac83\uc744 \uacb0\uc815\ud558\ub294\ub370 \uc0ac\uc6a9\ub41c\ub2e4. <\/span>
\n<\/span>\nV$FILESTAT : \ud30c\uc77c read\/write \ud1b5\uacc4. <\/span>
\n<\/span>\nV$FIXED_TABLE : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 \ub3d9\uc801\uc2e4\ud589\ud14c\uc774\ube14, views, \uc720\ub3c4\ud14c\uc774\ube14. \uc2e4\uc81c\ud14c\uc774\ube14\uc744 \ucc38\uc870\ud558\ub294 \uc57d\uac04\uc758 V$\ud14c\uc774\ube14\uc740 \ub9ac\uc2a4\ud2b8\uc5d0 \uc5c6\ub2e4. <\/span>
\n<\/span>\nV$FIXED_VIEW_DEFINITION : (V$\ub85c \uc2dc\uc791\ud558\ub294)\uace0\uc815view\uc5d0 \ub300\ud55c \uc124\uba85. \uc720\uc758\ud574\uc11c \uc0ac\uc6a9\ud574\uc57c\ud55c\ub2e4. <\/span>
\n<\/span>\nV$GLOBAL_TRANSACTION : \ud604\uc7ac \ud65c\ub3d9\uc911\uc778 \ud2b8\ub79c\uc7ad\uc158\uc5d0 \ub300\ud55c \uc124\uba85. <\/span>
\n<\/span>\nV$INDEXED_FIXED_COLUMN : index\ub41c \ub3d9\uc801\uc2e4\ud589\ud14c\uc774\ube14(X$ table)\uc758 \uce7c\ub7fc\uc5d0 \ub300\ud55c \uc124\uba85. X$ table\uc740 \uacbd\uace0\uc5c6\uc774 \ubcc0\uacbd\ud560\uc218\uc788\ub2e4. \uc774view\ub294 \ubcf4\ub2e4 \ud6a8\uacfc\uc801\uc73c\ub85c \uace0\uc815\ubdf0(V$view)\uc5d0 \ub300\ud55c <\/span>
\n<\/span>\nV$INSTANCE : \ud604\uc7ac\uc758 \uc778\uc2a4\ud134\uc2a4\uc758 \uc0c1\ud0dc\ub97c \ub098\ud0c0\ub0c4. <\/span>
\n<\/span>\nV$INSTANCE\uc758 \ubc84\uc804\uc740 V$INSTANCE\uc758 \ucd08\uae30\ubc84\uc804\uacfc \ud638\ud658\uc131\uc774 \uc5c6\ub2e4. <\/span>
\n<\/span>\nV$LATCH : \ud558\uc704 \uc7a0\uae08\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc640 \uc0c1\uc704 \uc7a0\uae08\uc5d0 \ub300\ud55c \uc694\uc57d\ud1b5\uacc4. \uc989, \uc0c1\uc704\uc7a0\uae08\uc5d0 \ub300\ud55c \ud1b5\uacc4\ub294 \uadf8 \ud558\uc704\uc7a0\uae08\uc5d0 \ub300\ud55c \uac01\uac01\uc758 \ud1b5\uacc4\ub97c \ud3ec\ud568\ud55c\ub2e4. <\/span>
\n<\/span>\nV$LATCHHOLDER : \ud604\uc7ac\uc7a0\uae08\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nV$LATCHNAME : V$LATCH \uc5d0 \uc788\ub294 \uc7a0\uae08\uc5d0 \ub300\ud55c \ub514\ucf54\ub4dc\ub41c \uc7a0\uae08\uc774\ub984\uc5d0 \ub300\ud55c \uc815\ubcf4. V$LATCHNAME\uc758 \ud589\ub4e4\uc740 V$LATCH\uc758 \ud589\ub4e4\uacfc 1:1\ub85c \ub300\uc751\ub41c\ub2e4. <\/span><\/p>\n<\/span>

V$LATCH_CHILDREN : \ud558\uc704\uc7a0\uae08\uc5d0 \ub300\ud55c \ud1b5\uacc4\ub97c \ud3ec\ud568. <\/span>
\n<\/span>\nV$LATCH\uc758 \uce7c\ub7fc\uc5d0 child# \uce7c\ub7fc\uc774\ucd94\uac00\ub418\uc5c8\ub2e4. LATCH#\uce7c\ub7fc\uc774 \uc11c\ub85c \ub3d9\uc77c\ud558\ub2e4\uba74, \ud558\uc704\uc7a0\uae08\uc774 \ub3d9\uc77c\ud55c \uc0c1\uc704\uc7a0\uae08\uc744 \uac16\ub294 \uac83\uc774\ub2e4. <\/span>
\n<\/span>\nV$LATCH_MISSES : \uc7a0\uae08\uc744 \ud68d\ub4dd\ud558\ub294\ub370 \uc2e4\ud328\ud55c \uc2dc\ub3c4\uc5d0 \ub300\ud55c \ud1b5\uacc4. <\/span>
\n<\/span>\nV$LATCH_PARENT : \uc0c1\uc704\uc7a0\uae08\uc5d0 \ub300\ud55c \ud1b5\uacc4. <\/span>
\n<\/span>\nV$LATCH_PARENT \uce7c\ub7fc\uc740 V$LATCH\uce7c\ub7fc\uacfc \ub3d9\uc77c\ud558\ub2e4. <\/span>
\n<\/span>\nV$LIBRARYCACHE : library cache\uc758 \uc2e4\ud589\uacfc \ud65c\ub3d9\ud1b5\uacc4. <\/span>
\n<\/span>\nV$LICENSE : license \ud55c\uacc4\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nV$LOADCSTAT : \uc9c1\uc811\uc801\uc7ac\ud558\ub294\ub3d9\uc548 \ucef4\ud30c\uc77c\ub41c SQL*loader \ud1b5\uacc4\uc815\ubcf4. \uc774\ud14c\uc774\ube14\uc5d0\ub300\ud55c \uc5b4\ub5a4 Select \ubb38\ub3c4 \"no rows returned\" \uacb0\uacfc\uac00 \ub098\uc624\ub294\ub370, <\/span>
\n<\/span>\n\uc65c\ub0d0\uba74, \ub3d9\uc77c\ud55c \uc2dc\uac04\uc5d0 \ub370\uc774\ud130\ub97c \uc801\uc7ac\ud558\uba74\uc11c, \ucffc\ub9ac\ub97c \ub0a0\ub9b4\uc218 \uc5c6\uae30 \ub54c\ubb38\uc774\ub2e4. <\/span><\/p>\n<\/span>

V$LOCK : \ud604\uc7ac Oracle \uc11c\ubc84\uc5d0 \uc758\ud574 \ud655\ub9bd\ub41c \uc7a0\uae08\uc5d0 \ub300\ud55c \uc815\ubcf4\ub098 lock\ub610\ub294 latch\uc5d0 \ub300\ud55c \ub450\ub4dc\ub7ec\uc9c4\uc694\uccad <\/span>
\n<\/span>\nV$LOCK_ACTIVITY : \ubcd1\ub82c\uc11c\ubc84view\uc774\ub2e4. V$LOCK_ACTIVITY\ub294 \ud604\uc7ac\uc758 \uc778\uc2a4\ud134\uc2a4\uc758 DLM\uc7a0\uae08\ub3d9\uc791\uc744 \ub098\ud0c0\ub0b8\ub2e4. \uac01\uac01\uc758 \ud589\uc740 \uc7a0\uae08\ub3d9\uc791\uc758 \ud0c0\uc785\uacfc \uc77c\uce58\ub41c\ub2e4. <\/span>
\n<\/span>\nV$LOCK_ELEMENT : \ubcd1\ub82c\uc11c\ubc84view\uc774\ub2e4. \ubc84\ud37c\uce90\uc26c\uc5d0 \uc758\ud574\uc0ac\uc6a9\ub41c \uac01\uac01\uc758 PCM\uc7a0\uae08\uc5d0 \ub300\ud574 v$LOCK_ELEMENT \uc5d0 \ud55c\ud589\uc774\ub2e4. <\/span>
\n<\/span>\n\uc7a0\uae08\uc694\uc18c\uc5d0 \ub300\uc751\ub418\ub294 PCM\uc7a0\uae08\uc758 \uc774\ub984\uc740 'BL',indx,class\ub4f1\uc774\ub2e4. <\/span>
\n<\/span>\nV$LOCKED_OBJECT : \uc2dc\uc2a4\ud15c\uc548\uc758 \ubaa8\ub4e0 \ud2b8\ub79c\uc7ad\uc158\uc5d0 \uac78\ub9b0 \uc7a0\uae08\uc744 \ub098\ud0c0\ub0b8\ub2e4. <\/span>
\n<\/span>\nV$LOCKED_WITH_COLLISIONS : \ubcd1\ub82c\uc11c\ubc84view\uc774\ub2e4. <\/span>
\n<\/span>\n\uc5ec\ub7ec\ubc84\ud37c\ub97c \ubcf4\ud638\ud558\ub294 lock\uc744 \ucc3e\ub294\ub370 \uc0ac\uc6a9\ub418\uba70, \uadf8 \ubc84\ud37c\ub4e4\uc740 \ucd5c\uc18c\ud55c <\/span>
\n<\/span>\n10\ud68c\uc774\uc0c1 \uac01\uac01 \uac15\uc81c\ub85c \uc4f0\uc5ec\uc9c0\uac70\ub098, \uac15\uc81c\ub85c \uc77d\ud600\uc9c4 \ubc84\ud37c\ub4e4\uc774\ub2e4. <\/span>
\n<\/span>\nV$LOG : \ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130 log \ud30c\uc77c\uc815\ubcf4\ub97c \ud3ec\ud568\ud55c\ub2e4. <\/span>
\n<\/span>\nV$LOGFILE : redo log \ud30c\uc77c\uc815\ubcf4. redo log \uadf8\ub8f9\uacfc \uba64\ubc84 \ud30c\uc77c\uba85. <\/span>
\n<\/span>\nV$LOGHIST : \ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130 log history\uc815\ubcf4\ub97c \ud3ec\ud568. \uc9c0\uc18d\uc801\uc778 \ud638\ud658\uc131\uc744 \ud3ec\ud568\ud558\uace0 \uc788\ub2e4. \ub300\uc2e0\uc5d0 V$LOG_HISTORY\uc758 \uc0ac\uc6a9\uc744 \uad8c\uc7a5\ud55c\ub2e4. <\/span>
\n<\/span>\nV$LOG_HISTORY : \ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130 log history \uc815\ubcf4\ub97c \ud3ec\ud568\ud55c\ub2e4. <\/span>
\n<\/span>\nV$MLS_PARAMETERS : Oracle Server\uc758 \ud655\uc815\ub41c \ucd08\uae30\ud654\ud30c\ub77c\ubbf8\ud130\ub97c \ub098\ud0c0\ub0c4. <\/span>
\n<\/span>\nV$MTS : multi-threaded server\uc758 \uc131\ub2a5\ud5a5\uc0c1\uc744\uc704\ud55c \uc815\ubcf4\ub97c \ud3ec\ud568. <\/span>
\n<\/span>\nV$MYSTAT : \ud604\uc7ac \uc138\uc158\uc5d0 \ub300\ud55c \ud1b5\uacc4\uac12\ud3ec\ud568. <\/span>
\n<\/span>\nV$NLS_PARAMETERS : \ud604\uc7ac\uc758 NLS \ub9e4\uac1c\ubcc0\uc218\uc758 \uac12\ub4e4\uc744 \ud3ec\ud568. <\/span>
\n<\/span>\nV$NLS_VALID_VALUES : \uc720\ud6a8\ud55c NLS \ub9e4\uac1c\ubcc0\uc218\uac12. <\/span>
\n<\/span>\nV$OBJECT_DEPENDENCY : \ud604\uc7ac \uacf5\uc720\ud480\uc5d0 \uc801\uc7ac\ub418\uc5b4\uc788\ub294 package, procedure, <\/span>
\n<\/span>\ncursor\ub4f1\uc5d0 \uad00\ub828\ub418\uc5b4\uc788\ub294 object\ub97c \uacb0\uc815\ud558\ub294\ub370 \uc0ac\uc6a9\ub41c\ub2e4. <\/span>
\n<\/span>\n\uc608\ub97c\ub4e4\uba74, V$SESSION, V$SQL\ub4f1\uacfc \uc870\uc778\ud558\uba74, \ud604\uc7ac \uc5b4\ub5a4 user\uac00 <\/span>
\n<\/span>\n\uc2e4\ud589\uc911\uc778 SQL\ubb38\uc5d0\uc11c \uc5b4\ub5a4 \ud14c\uc774\ube14\uc774 \uc0ac\uc6a9\ub418\uc5c8\ub294\uc9c0\ub97c \uc54c\uc544\ub0bc\uc218\uac00 \uc788\ub2e4. <\/span>
\n<\/span>\nV$OFFLINE_RANGE : \ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130 offline\ub41c datafile\uc744 \ubcf4\uc5ec\uc900\ub2e4. <\/span>
\n<\/span>\nDATAFILE\ud589\uc5d0 \uc800\uc7a5\ub418\uc5b4\uc788\ub294 \uac01\uac01\uc758 \ub370\uc774\ud130\ud30c\uc77c\uc758 \ucd5c\uc885offline \uac04\uaca9\uc744 <\/span>
\n<\/span>\n\ubcf4\uc5ec\uc90c. offline \uac04\uaca9\uc740 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uac00 \ucc98\uc74c offline normal, <\/span>
\n<\/span>\n\ub610\ub294 Read Only\ub85c \ubcc0\uacbd\ub418\uace0\ub09c\uc774\ud6c4 \ub2e4\uc2dc online \ub610\ub294 read-write\ub85c <\/span>
\n<\/span>\n\ubcc0\uacbd\ub41c\ub2e4\uc74c\uc5d0 \ud655\uc815\ub41c\ub2e4. <\/span>
\n<\/span>\n\ub370\uc774\ud130\ud30c\uc77c\uc774 \uc2a4\uc2a4\ub85c Offline\ub85c \ubcc0\uacbd\ub418\uac70\ub098 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uac00 <\/span>
\n<\/span>\nOFFLINE IMMEDIATE\ub85c \ubcc0\uacbd\ub418\uba74, offline\uac04\uaca9\uc740 \ud655\uc815\ub418\uc9c0 \uc54a\ub294\ub2e4. <\/span><\/p>\n<\/span>

V$OPEN_CURSOR : \uac01\uac01 user \uc138\uc158\uc774 \uc5f4\ub838\uc788\uac70\ub098, \uc815\uc9c0\ub418\uc5b4\uc788\ub294 cursor\ub97c \ubcf4\uc5ec\uc900\ub2e4. <\/span>
\n<\/span>\nV$OPTION : Oracle Server\uc640 \uac19\uc774 \uc124\uce58\ub41c \uc120\ud0dd\uc0ac\ud56d\ub4e4. <\/span>
\n<\/span>\nV$PARAMETER : \ucd08\uae30\ud654 \ud30c\ub77c\ubbf8\ud130\uc5d0 \ub300\ud55c \uc124\uba85\uc774\ub2e4. <\/span>
\n<\/span>\nV$PING\n: \ubcd1\ub82c\uc11c\ubc84view\uc774\ub2e4. \ucd5c\uc18c\ud55c 1\ubc88\uc774\uc0c1 ping\ub41c \ube14\ub85d\ub9cc\uc744 \ubcf4\uc5ec\uc900\ub2e4\ub294 \uac83\uc744 \uc81c\uc678\ud558\uace0 V$CACHE view\uc640 \ub3d9\uc77c\ud558\ub2e4.\ud2b9\uc815\n\ub370\uc774\ud130\ubca0\uc774\uc2a4 object\uc640 \uad00\ub828\ub41c \ud604\uc7ac\uc758 \uc778\uc2a4\ud134\uc2a4\ub0b4\uc758 SGA\uc5d0 \uc788\ub294 \uac01\uac01\uc758 \ube14\ub85d\uc5d0\ub300\ud55c block header\uc815\ubcf4\ub97c \ud3ec\ud568\ud558\uace0\n\uc788\ub2e4. <\/span>
\n<\/span>\nV$PQ_SESSTAT : \ubcd1\ub82c\ucffc\ub9ac\uc5d0 \ub300\ud55c session \ud1b5\uacc4\ub97c \ud3ec\ud568. <\/span>
\n<\/span>\nV$PQ_SLAVE : \uc778\uc2a4\ud134\uc2a4\ub0b4\uc5d0 \uc2e4\ud589\uc911\uc778 parallel \ucffc\ub9ac\uc11c\ubc84\uc5d0 \ub300\ud55c \ud1b5\uacc4. <\/span>
\n<\/span>\nV$PQ_SYSSTAT : \ubcd1\ub82c\ucffc\ub9ac\uc5d0 \ub300\ud55c \uc2dc\uc2a4\ud15c\ud1b5\uacc4. <\/span><\/p>\n<\/span>


\n<\/span>\nV$PQ_TQSTAT : \ubcd1\ub82c\ucffc\ub9ac \ub3d9\uc791\uc758 \ud1b5\uacc4\ub97c \ud3ec\ud568. \ud1b5\uacc4\ub294 \uc9c8\uc758\uac00 \uc644\ub8cc\ub41c\ud6c4\uc5d0 \ucef4\ud30c\uc77c\ub418\uba70 \uc138\uc158\uc774 \uc0b4\uc544\uc788\ub294\ub3d9\uc548 \uacc4\uc18d \ub0a8\uc544\uc788\ub294\ub2e4. <\/span>
\n<\/span>\nV$PROCESS : \ud604\uc7ac \uc791\uc5c5\uc911\uc778 \ud504\ub85c\uc138\uc2a4\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nLATCHWAIT \uce7c\ub7fc\uc740 \ud504\ub85c\uc138\uc2a4\uc7a0\uae08\uc774 \ubb34\uc5c7\uc744 \uae30\ub2e4\ub824\uc57c\ud558\ub294\uac00\ub97c \ub098\ud0c0\ub0b4\uba70, <\/span>
\n<\/span>\nLATCHSPIN \uce7c\ub7fc\uc740 \ud504\ub85c\uc138\uc2a4\uc7a0\uae08\uc774 \ub3d9\uc791\ub418\ub294 \uac83\uc744 \ub098\ud0c0\ub0b8\ub2e4. <\/span>
\n<\/span>\n\uba40\ud2f0\ud504\ub85c\uc138\uc11c\uc758 \uacbd\uc6b0 Oracle \ud504\ub85c\uc138\uc2a4\ub294 \uc7a0\uae08\uc744 \uae30\ub2e4\ub9ac\uae30\uc804\uc5d0 \uc2e4\uc2dc\ud55c\ub2e4. <\/span>
\n<\/span>\nV$PWFILE_USERS : password \ud30c\uc77c\ub85c\ubd80\ud130 \uc720\ub3c4\ud574\ub0b8 SYSDBA, SYSOPER \uad8c\ud55c\uc744 \ubd80\uc5ec\ubc1b\uc740 user. <\/span>
\n<\/span>\nV$QUEUE : \uba40\ud2f0\uc4f0\ub808\ub4dc \uba54\uc2dc\uc9c0\ud050\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nV$RECENT_BUCKET : \ub300\uc6a9\ub7c9 \uce90\uc26c\uc2e4\ud589\uc744 \ud3c9\uac00\ud558\uae30\uc5d0 \uc720\uc6a9\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nV$RECOVER_FILE : media \ubcf5\uad6c\uc5d0\ud544\uc694\ud55c \ud30c\uc77c\uc758 \uc0c1\ud0dc\ub97c \ub098\ud0c0\ub0c4. <\/span>
\n<\/span>\nV$RECOVERY_FILE_STATUS : \uac01\uac01\uc758 RECOVER\uba85\ub839\uc5d0 \ub300\ud55c \uac01 \ub370\uc774\ud130\ud30c\uc77c\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \ud55c\ud589\uc529 \ud3ec\ud568. Oracle\ud504\ub85c\uc138\uc2a4\uac00 \ubcf5\uad6c\ub97c \uc218\ud589\ud558\ub294\ub370 \uc720\uc6a9\ud55c \uc815\ubcf4\uc784. <\/span>
\n<\/span>\nrecover manager\ub294 \uc11c\ubc84\ud504\ub85c\uc138\uc2a4\uc5d0 \uc9c1\uc811 \ubcf5\uad6c\ub97c\uc218\ud589\ud558\ub3c4\ub85d \ud588\uc744 \ub54c, <\/span>
\n<\/span>\nrecovery manager\uac00 \uc774 view\uc5d0\uc11c \uad00\ub828\ub41c\uc815\ubcf4\ub97c \ucc38\uace0\ud560 \uc218 \uc788\ub2e4. <\/span>
\n<\/span>\n\ub2e4\ub978user\ub4e4\uc5d0\uac8c\ub294 \uc720\uc6a9\ud558\uc9c0 \uc54a\ub2e4. <\/span>
\n<\/span>\nV$RECOVERY_LOG : \uc644\ubcbd\ud55c media\ubcf5\uad6c\uc5d0 \ud544\uc694\ud55c archived logs\uc5d0 \uad00\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\n\uc774\uc815\ubcf4\ub294 log history view\uc778 V$LOG_HISTORY\uc5d0\uc11c \uc720\ub3c4\ub41c \uac83\uc774\ub2e4. <\/span>
\n<\/span>\nV$RECOVERY_PROGRESS : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ubcf5\uad6c\uc791\uc5c5\uc774 \uc911\uac04\uc5d0 \uba48\ucd94\uc9c0\uc54a\ub3c4\ub85d\ud558\ub294\ub370 <\/span>
\n<\/span>\n\uc0ac\uc6a9\ub418\uba70, \ubcf5\uad6c\uc791\uc5c5\uc744 \uc644\ub8cc\ud558\ub294\ub370 \uc694\uad6c\ub418\ub294 \uc2dc\uac04\uc744 \uce21\uc815\ud558\ub294\ub370 \uc0ac\uc6a9\ub41c\ub2e4. <\/span>
\n<\/span>\nV$RECOVERY_STATUS : \ud604\uc7ac\uc758 \ubcf5\uad6c\uc9c4\ud589\uc0c1\ud0dc\ub97c \ub098\ud0c0\ub0b8\ub2e4. \ub2e8\uc9c0 \ubcf5\uad6c\ub97c \uc218\ud589\ud558\ub294 <\/span>
\n<\/span>\nProcess \uc5d0\ub300\ud55c \uc815\ubcf4\ub9cc\uc774\uc720\uc6a9\ud558\ub2e4. \ubcf5\uad6c\uad00\ub9ac\uc790\uac00 \uc11c\ubc84\ud504\ub85c\uc138\uc2a4\uc5d0\uac8c \ubcf5\uad6c\ub97c <\/span>
\n<\/span>\n\uc218\ud589\ud558\ub77c\uace0 \uc9c0\uc2dc\ud560\ub54c\uc5d0, \ubcf5\uad6c\uad00\ub9ac\uc790\ub294 \uc774view\uc5d0\uc11c <\/span>
\n<\/span>\n\uad00\ub828\uc815\ubcf4\ub97c \ucc38\uc870\ud560 \uc218 \uc788\ub2e4. \ub2e4\ub978 user\uc5d0\uac8c\ub294 \ubd88\ud544\uc694\ud558\ub2e4. <\/span>
\n<\/span>\nV$REQDIST : MTS dispatcher\uc758 \uc751\ub2f5\uc2dc\uac04\uc5d0 \ub300\ud55c \uadf8\ub798\ud504\ud1b5\uacc4\ub97c \ub098\ud0c0\ub0b4\uba70, time range\ub294 \ubc84\ud0b7 number\uc758 \uc9c0\uc218\ud568\uc218\ub85c \uc99d\uac00\ud55c\ub2e4. <\/span>
\n<\/span>\nV$RESOURCE : \uc790\uc6d0(resource)\uc758 \uc774\ub984\uacfc \uc8fc\uc18c\uc815\ubcf4\ub97c \ud3ec\ud568. <\/span>
\n<\/span>\nV$RESOURCE_LIMIT : System \uc790\uc6d0\uc758 \ubd80\ubd84\uc801\uc778 \uc0ac\uc6a9\uc5d0 \ub300\ud55c \uc815\ubcf4. \uc790\uc6d0\uc758 \uc18c\ube44\ub97c \ubaa8\ub2c8\ud130\ub9c1\ud568\uc73c\ub85c\uc11c \ub0ad\ube44\ub97c \ubc29\uc9c0\ud558\ub294\ub370 \uc0ac\uc6a9\ub41c\ub2e4. <\/span><\/p>\n<\/span>

V$ROLLNAME : \ubaa8\ub4e0 online\uc911\uc778 rollback segments\uc758 \uc774\ub984. \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 open\uc2dc\uc5d0\ub9cc \uc870\ud68c\uac00\ub2a5. <\/span>
\n<\/span>\nV$ROLLSTAT : \ub864\ubc31\uc138\uadf8\uba3c\ud2b8\ud1b5\uacc4\uc815\ubcf4. <\/span>
\n<\/span>\nV$ROWCACHE : \uc790\ub8cc\uc0ac\uc804\ud65c\ub3d9\uc5d0 \ub300\ud55c \ud1b5\uacc4. \uac01\uac01\uc758 \ud589\uc740 \ud558\ub098\uc758 \uc790\ub8cc\uc0ac\uc804cache \ud1b5\uacc4\ub97c \ud3ec\ud568. <\/span>
\n<\/span>\nV$SESSION : \ud604\uc7ac open\ub41c \uc138\uc158\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nV$SESSION_CONNECT_INFO : \ud604\uc7ac\uc758 \uc138\uc158\uc5d0 \ub300\ud55c network \uc5f0\uacb0\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nV$SESSION_CURSOR_CACHE : \ud604\uc7ac\uc758 \uc138\uc158\uc5d0 \ub300\ud55c cursor \uc0ac\uc6a9\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nSESSION_CACHED_CURSORS \ucd08\uae30\ud654\ud30c\ub77c\ubbf8\ud130\uc5d0 \ub300\ud55c \ud6a8\uc728\uc744 \uce21\uc815\ud558\uc9c0\ub294 \uc54a\ub294\ub2e4. <\/span>
\n<\/span>\nV$SESSION_EVENT : \uc138\uc158\uc758 event \ub300\uae30\uc5d0 \uad00\ud55c\uc815\ubcf4. <\/span>
\n<\/span>\nV$SESSION_LONGOPS\n: \uc7a5\uc2dc\uac04\uc2e4\ud589\ub418\ub294 \uc791\uc5c5\uc5d0 \ub300\ud55c \uc0c1\ud0dc. SOFAR, TOTALWORK\uce7c\ub7fc\uc740 \uc9c4\ud589\uc0c1\ud0dc\ub97c \uc81c\uacf5\ud55c\ub2e4. \uc608\ub97c\ub4e4\uc5b4 \ub2e4\uc74c\uc694\uc18c(hach\ncluster creations, backup, recovery) \uc5d0 \ub300\ud55c \uc791\ub3d9\uc0c1\ud0dc\ub97c \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\ub2e4. <\/span>
\n<\/span>\nV$SESSION_OBJECT_CACHE : \ub85c\uce7c\uc11c\ubc84\uc758 \ud604\uc7ac\uc0ac\uc6a9\uc911\uc778 user\uc138\uc158\uc758 object, cache\ud1b5\uacc4\uc815\ubcf4. <\/span>
\n<\/span>\nV$SESSION_WAIT : \ud65c\ub3d9\uc911\uc778 \uc138\uc158\uc774 \ub300\uae30\ud558\uace0\uc788\ub294 \uc790\uc6d0\ub610\ub294 \uc774\ubca4\ud2b8\uc774\ub2e4. <\/span>
\n<\/span>\nV$SESSTAT : user\uc138\uc158 \ud1b5\uacc4\uc774\ub2e4. \ud1b5\uacc4number(statistic#)\uc5d0 \ud574\ub2f9\ud558\ub294 \ud1b5\uacc4name\uc744 \ucc3e\uc73c\ub824\uba74, V$STATNAME\ub97c \ucc38\uace0\ud558\uba74 \ub41c\ub2e4. <\/span>
\n<\/span>\nV$SESS_IO : \uac01\uac01\uc758 user\uc138\uc158\uc5d0 \ub300\ud55c I\/O \ud1b5\uacc4\uc774\ub2e4. <\/span>
\n<\/span>\nV$SGA : System Global Area \uc5d0\ub300\ud55c \uac04\ub7b5\ud55c \uc815\ubcf4.(name, size) <\/span>
\n<\/span>\nV$SGASTAT : System Global Area\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \uc815\ubcf4.(name, bytes, pool) <\/span><\/p>\n<\/span>

V$SHARED_POOL_RESERVED : Shared Pool\ub0b4\uc5d0 \uc608\uc57d\ud480\uacfc \uacf5\uac04\uc744 \ubc14\uafb8\uace0\uc790\ud560 \ub54c \ub3c4\uc6c0\uc774 \ub418\ub294\ud1b5\uacc4. <\/span>
\n<\/span>\nV$SHARED_SERVER : Shared Server processes \uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \ud3ec\ud568. <\/span>
\n<\/span>\nV$SORT_SEGMENT : \uc8fc\uc5b4\uc9c4 \uc778\uc2a4\ud134\uc2a4\ub0b4\uc758 \uac01 sort\uc138\uadf8\uba3c\ud2b8\uc5d0 \ub300\ud55c \uc815\ubcf4. \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uac00 Temporary \ud0c0\uc785\uc77c\ub54c\ub9cc update\ub41c\ub2e4. <\/span><\/p>\n<\/span>

V$SORT_USAGE : sort \uc0ac\uc6a9\uc5d0 \ub300\ud574 \uae30\uc220\ud55c\ub2e4. <\/span>
\n<\/span>\nV$SQL : Group by\uc808\uc774\uc5c6\ub294 \uacf5\uc720sql\uc601\uc5ed\uc5d0\ub300\ud55c \ud1b5\uacc4\uc774\uba70 \uc785\ub825\ub41c \uc6d0\ub798 sql\ubb38\uc7a5\uc758 \uac01 child\uc758 row\ub97c \ud3ec\ud568. <\/span>
\n<\/span>\nV$SQL_BIND_DATA : \ub370\uc774\ud130\uac00 \uc774 \uc11c\ubc84\uc5d0\uc11c \ucd94\ucd9c\uac00\ub2a5\ud558\ub2e4\uba74 \uc774 view\ub97c \uc870\ud68c\ud558\ub294 \uc138\uc158\uc5d0 \uc18c\uc720\ub41c \uac01 \ucee4\uc11c\uc548\uc5d0 \uc788\ub294 \uac01\uac01\uc758 \uc6d0\uaca9bind\ubcc0\uc218\uc5d0 \ub300\ud55c \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0 \uc758\ud574 \ubcf4\ub0b4\uc9c4 \ub370\uc774\ud130. <\/span>
\n<\/span>\nV$SQL_BIND_METADATA : \uc774view\ub97c \uc870\ud68c\ud558\ub294 \uc138\uc158\uc5d0 \uc18c\uc720\ub41c \uac01\ucee4\uc11c\uc548\uc5d0 \uc788\ub294 \uac01\uac01\uc758 \uc6d0\uaca9bind\ubcc0\uc218\uc5d0 \ub300\ud574 \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uc758\ud574 \uc81c\uacf5\ub418\ub294 bind metadata. <\/span><\/p>\n<\/span>

V$SQL_CURSOR : \uc774 view\ub97c \uc870\ud68c\ud558\ub294 \uc138\uc158\uacfc \uad00\ub828\ub41c \uac01 cursor\uc5d0 \ub300\ud55c \ub514\ubc84\uae45\uc815\ubcf4. <\/span>
\n<\/span>\nV$SQL_SHARED_MEMORY : \uba54\ubaa8\ub9ac \uc2a4\ub0c5\uc0f7\uc5d0 \uacf5\uc720\ub41c \ucee4\uc11c\uc5d0 \ub300\ud55c \uc815\ubcf4. \uacf5\uc720\ud480\uc5d0 \uc800\uc7a5\ub41c \uac01SQL\ubb38\uc740 \uad00\ub828\ub41c \ud558\ub098\ub610\ub294 \uadf8\uc774\uc0c1\uc758 \ud558\uc704object\ub97c \uac00\uc9c0\uace0 \uc788\ub2e4. <\/span>
\n<\/span>\nV$SQLAREA : \uacf5\uc720SQL\uc601\uc5ed\uc5d0 \ub300\ud55c \ud1b5\uacc4\ub97c \uac00\uc9c0\uace0\uc788\uc73c\uba70, Sql \ubb38\uc790\uc5f4\ub9c8\ub2e4 \ud55c\ud589\uc744 \ud3ec\ud568\ud55c\ub2e4. \uba54\ubaa8\ub9ac\ub0b4\uc5d0 \uc874\uc7ac\ud558\ub294, parse\ub41c, \uc2e4\ud589\uc744 \ub300\uae30\ud558\uace0\uc788\ub294 SQL\ubb38\uc7a5\uc5d0 \ub300\ud55c \ud1b5\uacc4\ub97c \uc81c\uacf5\ud55c\ub2e4. <\/span>
\n<\/span>\nV$SQLTEXT : SGA\ub0b4\ubd80\uc758 \uacf5\uc720SQL \ucee4\uc11c\uc5d0 \uc18d\ud574\uc788\ub294 SQL\ubb38\uc7a5\uc744 \ud3ec\ud568. <\/span>
\n<\/span>\nV$SQLTEXT_WITH_NEWLINES : \uac00\ub3c5\uc131\uc774 \uc99d\uac00\ub418\uace0, \uacf5\ubc31\uc744 \ud3ec\ud568\ud55c SQL\ubb38\uc7a5\uc548\uc5d0 <\/span>
\n<\/span>\nnewline\uacfc tabs\uc744 \ub300\uccb4\ud558\uc9c0 \uc54a\ub294\ub2e4\ub294 \uac83\uc744 \uc81c\uc678\ud558\uace0\ub294 V$SQLTEXT view\uc640 \ub3d9\uc77c\ud558\ub2e4. <\/span>
\n<\/span>\nV$STATNAME : V$SESSTAT\uc640 V$SYSSTAT\ud14c\uc774\ube14\uc5d0\uc11c \ub098\ud0c0\ub09c statistics\uc5d0 \ub300\ud55c \uc774\ub984. <\/span>
\n<\/span>\nV$SUBCACHE : \ud604\uc7ac \ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc26c\uba54\ubaa8\ub9ac\uc5d0 \uc801\uc7ac\ub41c \ud558\uc704 \uce90\uc26c\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\n\ubaa8\ub4e0 \ub77c\uc774\ube0c\ub7ec\ub9ac\uce90\uc26c\uc5d0 \ub300\ud574 \uc5b8\uae09\ud558\uace0\uc788\uc73c\uba70, \uac01 \ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc26cobject\ub9c8\ub2e4 <\/span>
\n<\/span>\n\uac01 \uc801\uc7ac\ub41c \ud558\uc704 \uce90\uc26c\uc5d0 \ub300\ud574 \ud55c\ud589\uc744 \ub098\ud0c0\ub0b8\ub2e4. <\/span>
\n<\/span>\nV$SYSSTAT : \uc2dc\uc2a4\ud15c \ud1b5\uacc4\uc774\ub2e4. \uac01 statistic number(statistic#)\uc640 \uad00\ub828\ub41c statistic\uc758 \uc774\ub984\uc744 \ucc3e\uae30\uc704\ud574\uc11c\ub294, \"V$STATNAME\"\ub97c \ubcf4\uc2dc\uc624. <\/span>
\n<\/span>\nV$SYSTEM_CURSOR_CACHE : \uc2dc\uc2a4\ud15c \uc804\ubc18\uc801\uc778\uc815\ubcf4\ub77c\ub294 \uac83\uc744 \uc81c\uc678\ud558\uace0, <\/span>
\n<\/span>\nV$SESSION_CURSOR_CACHE\uc640 \uc720\uc0ac\ud55c \uc815\ubcf4\ub97c \ub098\ud0c0\ub0b8\ub2e4. <\/span>
\n<\/span>\nV$SYSTEM_EVENT : \uc774\ubca4\ud2b8\uc5d0 \ub300\ud55c \ucd1d wait\uc815\ubcf4. TIME_WAITED, <\/span>
\n<\/span>\nAVERAGE_WAIT\uce7c\ub7fc\uc740 \uae09\uc18d\uba54\ucee4\ub2c8\uc998\uc744 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294 \ud50c\ub7ab\ud3fc\uc5d0\uc11c 0\uac12\uc744 \ud3ec\ud568\ud560 \uac83\uc774\ub2e4. \uc774\ub7f0 \ud50c\ub7ab\ud3fc\uc5d0\uc11c DB\ub97c \uc6b4\uc601\uc911\uc774\uace0, <\/span>
\n<\/span>\n\uc774\uce7c\ub7fc\uc774 wait time\uc744 \uc904\uc5ec\uc8fc\uae30\ub97c \uc6d0\ud55c\ub2e4\uba74, \ud30c\ub77c\ubbf8\ud130\ud30c\uc77c\uc758 TIMED_STATISTICS\ub97c TRUE\ub85c \uc138\ud305\ud558\uba74\ub41c\ub2e4. <\/span>
\n<\/span>\n\ub2e8\uc9c0 \uc774\ub807\uac8c \ud558\uba74, \uc2dc\uc2a4\ud15c \uc131\ub2a5\uc5d0 \uc57d\uac04\uc758 \ub9c8\uc774\ub108\uc2a4\ud6a8\uacfc\ub97c \uac00\uc838\uc62c \uac83\uc774\ub2e4. <\/span>
\n<\/span>\nV$SYSTEM_PARAMETER : System parameter\uc5d0 \ub300\ud55c \uc815\ubcf4. <\/span>
\n<\/span>\nV$TABLESPACE : \ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc815\ubcf4\ub97c \ub098\ud0c0\ub0b4\uc900\ub2e4. <\/span>
\n<\/span>\nV$THREAD : \ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130 thread \uc815\ubcf4\ub97c \uac00\uc838\uc628\ub2e4. <\/span>
\n<\/span>\nV$TIMER : 1\/100 \ucd08\ub85c \ub098\ud0c0\ub0b8 \uacbd\uacfc\uc2dc\uac04. \uc2dc\uac04\uc740 epoch\uac00 \uc2dc\uc791\ub41c\uc774\ud6c4\ubd80\ud130 \uce21\uc815\ub418\uba70, epoch\ub294 OS\uc758 \ud2b9\uc131\uc774\uba70, \uac12\uc774 4bytes(\uc57d 497\uc77c)\ub97c \ub118\uc744\ub54c\ub9c8\ub2e4 0\uadfc\ucc98\uc758 \uac12\uc774 \ub41c\ub2e4. <\/span>
\n<\/span>\nV$TRANSACTION : \uc2dc\uc2a4\ud15c\ub0b4\uc758 \ud65c\ub3d9\uc911\uc778 \ud2b8\ub79c\uc7ad\uc158. <\/span>
\n<\/span>\nV$TRANSACTION_ENQUEUE : \ud2b8\ub79c\uc7ad\uc158 \uc624\ube0c\uc81d\ud2b8\uc5d0 \uc758\ud574 \uc18c\uc720\ub41c lock\ub97c \ub098\ud0c0\ub0c4. <\/span>
\n<\/span>\nV$TYPE_SIZE : \ub370\uc774\ud130\ube14\ub85d\uc6a9\ub7c9\uc744 \uce21\uc815\ud558\ub294\ub370 \uc0ac\uc6a9\ub418\ub294 \uc5ec\ub7ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\ucef4\ud3ec\ub10c\ud2b8\ub4e4\uc758 SiZe. <\/span>
\n<\/span>\nV$VERSION : Oracle Server\uc758 core \ub77c\uc774\ube0c\ub7ec\ub9ac \ucef4\ud3ec\ub10c\ud2b8\uc758 Version\uc218\uc774\ub2e4. \uac01 \ucef4\ud3ec\ub10c\ud2b8\uc5d0 \ud55c row\uac00 \uc788\ub2e4. <\/span>
\n<\/span>\nV$WAITSTAT : \ube14\ub85d\uc810\uc720\uc5d0 \ub300\ud55c \ud1b5\uacc4. \ud1b5\uacc4\uac00 \uc0ac\uc6a9\uac00\ub2a5\ud55c \uc2dc\uac04\uc5d0\ub9cc \uac31\uc2e0\ub41c\ub2e4. <\/span><\/p>\n<\/span>

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

\uc2e4\uc2b5)<\/span><\/strong> <\/span><\/p>\n<\/span>

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

  \uc2e4\ud589\uc911\uc778 SQL \ubb38\uc7a5 \ubcf4\uae30<\/span><\/strong> <\/span><\/p>\n<\/span>

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

\ub2e4\ub978\ucc3d\uc5d0\uc11c all_objects \ub97c \uc870\ud68c\ud558\ub77c !<\/span><\/p>\n<\/span>

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

 select s.sid, s.username username, s.osuser, s.program, a.sql_text SQL<\/span>
\n<\/span>\n from v$sqltext a, v$session s<\/span>
\n<\/span>\n where  a.address = s.sql_address<\/span>
\n<\/span>\n and a.hash_value = s.sql_hash_value<\/span>
\n<\/span>\n and sql_text like '%&objectname%';  <\/span><\/p>\n<\/span>


\n<\/span>\n <\/span>
\n<\/span>  \uad8c\ud55c \ud655\uc778 <\/span><\/strong><\/p>\n\n<\/span>

<\/strong> SELECT USERNAME, ROLENAME, PRIVILEGE<\/span>
\n<\/span>\nFROM (SELECT DECODE(SA1.GRANTEE#, 1, 'PUBLIC', U1.NAME) username,<\/span>
\n<\/span>\nSUBSTR(U2.NAME,1,20) rolename,<\/span>
\n<\/span>\nSUBSTR(SPM.NAME,1,27) PRIVILEGE<\/span>
\n<\/span>\nFROM SYS.SYSAUTH$ SA1,<\/span>
\n<\/span>\nSYS.SYSAUTH$ SA2,<\/span>
\n<\/span>\nSYS.USER$ U1,<\/span>
\n<\/span>\nSYS.USER$ U2,<\/span>
\n<\/span>\nSYS.SYSTEM_PRIVILEGE_MAP SPM<\/span>
\n<\/span>\nWHERE SA1.GRANTEE# = U1.USER#<\/span>
\n<\/span>\nAND SA1.PRIVILEGE# = U2.USER#<\/span>
\n<\/span>\nAND U2.USER# = SA2.GRANTEE#<\/span>
\n<\/span>\nAND SA2.PRIVILEGE# = SPM.PRIVILEGE<\/span>
\n<\/span>\nUNION<\/span>
\n<\/span>\nSELECT U.NAME username, NULL rolename, SUBSTR(SPM.NAME,1,27) privilege<\/span>
\n<\/span>\nFROM SYS.SYSTEM_PRIVILEGE_MAP SPM, SYS.SYSAUTH$ SA, SYS.USER$ U<\/span>
\n<\/span>\nWHERE SA.GRANTEE#=U.USER#<\/span>
\n<\/span>\nAND SA.PRIVILEGE#=SPM.PRIVILEGE)<\/span>
\n<\/span>\nWHERE USERNAME = '&USERNAME';<\/span><\/p>\n<\/span>


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

\ucd9c\uc800 : <\/span>http:\/\/cafe.naver.com\/itlicensecafe.cafe?iframe_url=\/ArticleRead.nhn%3Farticleid=6413<\/span><\/a><\/p><\/span><\/span><\/span>


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

\u261e  Data Dictionary    Oracle database\uc758 \uac00\uc7a5 \uc911\uc694\ud55c \ubd80\ubd84 \uc911 \ud558\ub098\ub294 data dictionary\uc774\ub2e4. Data dictionary\ub294 \uc5f0\uad00\ub41c database\uc5d0 \uad00\ud55c \uc815\ubcf4\ub97c \uc81c\uacf5\ud558\ub294 read-only table\ub4e4\uc758 \uc9d1\ud569\uc774\ub2e4. \uc608\ub97c \ub4e4\uba74, data dictionary\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc815\ubcf4\ub97c \uc81c\uacf5\ud55c\ub2e4.   l        Oracle user\ub4e4\uc758 \uc774\ub984\ub4e4 l        \uac01\uac01\uc758 user\ub4e4\uc5d0\uac8c \ubd80\uc5ec\ub41c privilege\ub4e4\uacfc role\ub4e4 l        schema object\ub4e4\uc758 \uc774\ub984\ub4e4(table, view, snapshot, index, cluster, synonym, sequence, procedure, function, package, […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-432","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/432","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=432"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/432\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}