<\/p>\n
\uc624\ub77c\ud074 DB\uc0ac\uc804 \uc815\ub9ac<\/p>\n
All_all_tables \u00a0 \u00a0\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 Table
\nAll_catalog \u00a0 \u00a0 \u00a0\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 Table, Views, synonyms, sequence
\nAll_clusters \u00a0 \u00a0 \u00a0\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 clusters
\nAll_col_comments : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 Table,Views\uc5d0 \ub300\ud55c \uce7c\ub7fccomments
\nAll_col_privs \u00a0 \u00a0\u00a0 : user\uc5d0\uac8c \ub610\ub294 Public\uc5d0\uac8c \ud5c8\uc6a9\ub41c \ubaa8\ub4e0 \uce7c\ub7fc\uc5d0 \ub300\ud55c \uad8c\ud55c.
\nAll_col_privs_made : user\uac00 \ubd80\uc5ec\ud55c \uce7c\ub7fc\uc5d0 \ub300\ud55c \uad8c\ud55c.
\nAll_col_privs_recd : user\uc5d0\uac8c \ub610\ub294 Public\uc5d0\uac8c \ud5c8\uc6a9\ub41c \ubaa8\ub4e0 \uce7c\ub7fc\uc5d0 \ub300\ud55c \uad8c\ud55c.
\nAll_coll_types \u00a0 \u00a0 : user\uac00 access \ud560\uc218 \uc788\ub294 \ubaa8\ub4e0 collection type
\nAll_cons_columns : \uc81c\uc57d\uc870\uac74\uc5d0 \uad00\ub828\ub41c \uce7c\ub7fc, access\ud560\uc218 \uc788\ub294 \ub300\ud55c \uc815\ubcf4
\nAll_constraints \u00a0\u00a0 : access\ud560\uc218 \uc788\ub294 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uc81c\uc57d\uc870\uac74.
\nAll_db_links \u00a0 \u00a0 \u00a0 : user\uac00 access \ud560\uc218 \uc788\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 link
\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.
\nAll_dependencies\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294 \uc624\ube0c\uc81d\ud2b8\uac04\uc758 dependencies(\ucc38\uc870,link)
\nAll_directories \u00a0 \u00a0 : user\uac00 access\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0 directories (owner \ub294 \ud56d\uc0c1 sys)
\nAll_errors \u00a0 \u00a0 \u00a0\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 objects(view,procedure,package, function,
\npackagebody) \uc5d0 \ub300\ud55c \uc5d0\ub7ec.
\nAll_ind_columns\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uc778\ub371\uc2a4\uc758 \uce7c\ub7fc.
\nAll_ind_partitions : user\uac00 access\ud560\uc218\uc788\ub294 \uc778\ub371\uc2a4partition, partition\uc5d0 \ub300\ud55c
\nstorage\ub9e4\uac1c\ubcc0\uc218, Analyze\uba85\ub839\uc5d0 \uc758\ud574 \uacb0\uc815\ub41c partition\ud1b5\uacc4.
\nAll_indexes \u00a0 \u00a0 \u00a0 : user\uac00 access\ud560\uc218\uc788\ub294 \ud14c\uc774\ube14\uc758 \uc778\ub371\uc2a4.
\n\uc774 view\uc758 \ud1b5\uacc4\ub97c \uc218\uc9d1\ud558\uae30\uc704\ud574, Analyze\uba85\ub839\uc744 \uc0ac\uc6a9\ud55c\ub2e4.
\n\ubcd1\ub82cpartition\uc778\ud14d\uc2a4\ud0d0\uc0c9\uc744 \uc9c0\uc6d0\ud55c\ub2e4.
\nAll_labels \u00a0 \u00a0 \u00a0 \u00a0 : system labels \uc5d0 \ub300\ud55c Oracle server view.
\nAll_libraries \u00a0 \u00a0 \u00a0 : user\uac00 access\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0 libraries.
\nAll_lobs \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : user\uac00 access\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0\ud14c\uc774\ube14\uc5d0 \ud3ec\ud568\ub41c LOBs.
\nAll_method_params : user\uac00 access\ud560 \uc218 \uc788\ub294 method\uc640 \uadf8method\uc758 parameter.
\nAll_method_results :
\nAll_nested_tables\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294\ud14c\uc774\ube14\ub0b4\uc758 Nested Table
\nAll_object_tables\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294\ud14c\uc774\ube14\uc758\ubaa8\ub4e0\uc815\ubcf4.
\nAll_objects : user\uac00 access\ud560\uc218\uc788\ub294objects(index partition,table partition,package,
\npackage body, trigger)
\nAll_part_col_statistics : user\uac00 access\ud560 \uc218 \uc788\ub294 \ud14c\uc774\ube14partition\uc5d0 \ub300\ud55c \uce7c\ub7fc\ud1b5\uacc4\uc640
\n\ub9c9\ub300\uadf8\ub798\ud504\ud654\ub41c \uc815\ubcf4.
\nAll_part_histograms \u00a0 : user\uac00 access\ud560\uc218\uc788\ub294 \ud14c\uc774\ube14partition\uc758 histograms\uc5d0 \ub300\ud55c
\nhistogram\uc815\ubcf4.
\nAll_part_indexes \u00a0 \u00a0\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0partition\ub41c index\uc758 partition\uc815\ubcf4.
\nAll_part_key_columns :user\uac00 access\ud560\uc218\uc788\ub294 partition\ub41c objects\uc758 partition key
\n\uce7c\ub7fc\uc5d0 \ub300\ud55c\uc815\ubcf4
\nAll_part_tables \u00a0 \u00a0 \u00a0\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294partition\ub41c Table\uc5d0 \ub300\ud55c partition\uc815\ubcf4.
\nAll_refresh \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294\ubaa8\ub4e0 refresh groups.
\nAll_refresh_children \u00a0 : user\uac00 access\ud560 \uc218 \uc788\ub294 refresh groups \uc548\uc758 \ubaa8\ub4e0objects
\nAll_refs \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : user\uac00 access\ud560 \uc218 \uc788\ub294 \uce7c\ub7fc\uc911 REF\uce7c\ub7fc\uacfc, REF\uc18d\uc131.
\nAll_registered_snapshots : \ubaa8\ub4e0 \ub4f1\ub85d\ub41c snapshots.
\nAll_sequences \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294 sequences.
\nAll_snapshot_logs \u00a0 \u00a0\u00a0 : \ubaa8\ub4e0 snapshot logs.
\nAll_snapshot_refresh_times : \ubaa8\ub4e0 snapshot refresh times.
\nAll_snapshots \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : user\uac00 acces\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 snapshots.
\nAll_source \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 stored objects\uc758 text source.
\nAll_synonyms \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 synonyms.
\nAll_tab_col_statistics \u00a0 : ‘User_tab_columns’ view\uc548\uc758 \uc815\ubcf4\uc5d0\ub300\ud55c \uce7c\ub7fc\ud1b5\uacc4\uc640 \uadf8\ub798\ud504\uc815\ubcf4
\nAll_tab_columns \u00a0 \u00a0 \u00a0\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294\ubaa8\ub4e0 table, views, clusters\uc5d0 \ub300\ud55c \uce7c\ub7fc.
\n\uc774view\ub97c \ud65c\uc6a9\ud558\uae30\uc704\ud574\uc11c\ub294 Analyze\uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud55c\ub2e4.
\nAll_tab_comments \u00a0 \u00a0\u00a0 : user\uac00 access\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0 table, views\uc5d0 \ub300\ud55c comments.
\nAll_tab_histograms \u00a0 \u00a0 : user\uac00 access\ud560\uc218\uc788\ub294table, views\uc5d0 \ub300\ud55c histograms.
\nAll_tab_partitions : user\uac00 access\ud560\uc218 \uc788\ub294 \uac01\uac01\uc758 \ud14c\uc774\ube14partition\uc5d0 \ub300\ud55c
\npartition\uc815\ubcf4, storage parameter, Analyze\uba85\ub839\uc5d0 \uc758\ud55c \ud1b5\uacc4\uc815\ubcf4\ub4f1\uc744 \uc11c\uc220\ud55c\ub2e4.
\nAll_tab_privs \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : user\ud639\uc740 PUBLIC\uac00 \ubd80\uc5ec\ubc1b\uc740 \uc624\ube0c\uc81d\ud2b8\uad8c\ud55c.
\nAll_tab_privs_made \u00a0\u00a0 : user\uac00 \ubd80\uc5ec\ud55c user\uad8c\ud55c\uacfc \uc624\ube0c\uc81d\ud2b8\uad8c\ud55c.
\nAll_tab_privs_recd \u00a0 \u00a0 : user \ub610\ub294 PUBLIC\uc774 \ubd80\uc5ec\ubc1b\uc740 \uc624\ube0c\uc81d\ud2b8\uad8c\ud55c.
\nAll_tables \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : user\uac00 access\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0 \ud14c\uc774\ube14.
\nAnalyze\uba85\ub839\uc73c\ub85c \uc774 view\uc758 \ud1b5\uacc4\ub97c \uc5bb\uc744 \uc218 \uc788\ub2e4.
\nAll_triggers : user\uc18c\uc720\uc758 trigger, user\uc18c\uc720\ud14c\uc774\ube14\uc758 trigger, \ub610\ub294 user\uac00
\nCREATE ANY TRIGGER \uad8c\ud55c\uc744 \uac16\uace0\uc788\ub2e4\uba74, \ubaa8\ub4e0 \ud2b8\ub9ac\uac70\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nAll_trigger_cols : user\uc18c\uc720\uc758 trigger, user\uc18c\uc720\ud14c\uc774\ube14\uc758 trigger, \ub610\ub294 user\uac00
\nCREATE ANY TRIGGER \uad8c\ud55c\uc744 \uac16\uace0\uc788\ub2e4\uba74, \ubaa8\ub4e0 \ud2b8\ub9ac\uac70\uc5d0 \ub300\ud55c \uce7c\ub7fc\uc815\ubcf4.
\nAll_type_attrs : user\uac00 access\ud560 \uc218 \uc788\ub294 type\uc758 attributes.
\nAll_type_methods : user\uac00 access\ud560\uc218\uc788\ub294type\uc758 methods.
\nAll_types \u00a0 \u00a0 \u00a0 : user\uac00 access\ud560 \uc218 \uc788\ub294 type.
\nAll_updatable_columns : join view\uc5d0\uc11c update\uac00\ub2a5\ud55c \uce7c\ub7fc\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nAll_users \u00a0 \u00a0 \u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubaa8\ub4e0 user\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nAll_views \u00a0 \u00a0\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294view\uc758 \ud14d\uc2a4\ud2b8.
\nAudit_actions\u00a0 : \uac10\uc0ac\ucd94\uc801type\ucf54\ub4dc \uc815\ubcf4.
\ncatalog \u00a0 \u00a0 \u00a0 \u00a0 : Oracle 5.0 version\uacfc\uc758 \ud638\ud658\uc815\ubcf4\ub97c \ud3ec\ud568\ud55c\ub2e4.
\n\uc774view\uc758 \uc0ac\uc6a9\uc740 \ucd94\ucc9c\ud560\ub9cc\ud558\uc9c0 \ubabb\ud558\ub2e4.
\ncat \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : user_catalog \uc5d0 \ub300\ud55c synonym.
\nchained_rows\u00a0 : ANALYZE LIST CHAINED ROWS \uba85\ub839\uc5d0 \ub300\ud55c default table.
\nclu \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : user_clusters \ud14c\uc774\ube14\uc758 synonym.
\ncode_pieces \u00a0\u00a0 : dba_object_size \uc640 user_object_size view\ub97c create \uc2dc\uc5d0 \uc0ac\uc6a9\ub428.<\/p>\n
code_size \u00a0 \u00a0\u00a0 : dba_object_size \uc640 user_object_size view\ub97c create \uc2dc\uc5d0 \uc0ac\uc6a9\ub428.
\ncol \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : Oracle 5.0version \ud638\ud658\uc815\ubcf4\ub97c \ud3ec\ud568\ud558\uace0 \uc788\ub2e4.
\ncols \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : user_tab_columns view \uc758 synonym.
\ncolumn_privileges : user\uac00 \ubd80\uc5ec\ud55c\uad8c\ud55c,\ubd80\uc5ec\ubc1b\uc740\uad8c\ud55c, owner\uc778\uad8c\ud55c,
\n\ub610\ub294 PUBLIC\uc5d0\uac8c \ubd80\uc5ec\ubc1b\uc740 \uad8c\ud55c\uc5d0 \ub300\ud55c \uce7c\ub7fc\uc815\ubcf4.
\nDba_2pc_neighbors : \uc9c4\ud589\uc911\uc778 \ud2b8\ub79c\uc7ad\uc158\uc5d0 \ub300\ud55c \uc5f0\uacb0 \ubc0f \uc885\ub8cc\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_2pc_pending \u00a0 : recovery\ub97c \uae30\ub2e4\ub9ac\ub294 \ubd84\uc0b0\ub41c\ud2b8\ub79c\uc7ad\uc158\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_all_tables \u00a0 \u00a0\u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0\ud14c\uc774\ube14(object table, relational table).
\nDba_audit_exists \u00a0 : “AUDIT NOT EXISTS” and “AUDIT EXISTS”\uc5d0 \uc758\ud574 \uc0dd\uc131\ub41c
\n\uac10\uc0ac\ucd94\uc801\uc694\uc18c.
\nDba_audit_object \u00a0 : \uc2dc\uc2a4\ud15c\ub0b4\uc758 \ubaa8\ub4e0 object\uc5d0 \ub300\ud55c \uac10\uc0ac\ucd94\uc801\uae30\ub85d.
\nDba_audit_session\u00a0 : \uc138\uc158\uc5f0\uacb0\uacfc \uc885\ub8cc\uc5d0 \uad00\ub828\ub41c \ubaa8\ub4e0 \uac10\uc0ac \ucd94\uc801\uae30\ub85d.
\nDba_audit_statement : GRANT, REVOKE, AUDIT, NOAUDIT, ALTER SYSTEM
\n\uad00\ub828\ub41c \uac10\uc0ac\ucd94\uc801\uae30\ub85d.
\nDba_audit_trail\u00a0 : \ubaa8\ub4e0 \uac10\uc0ac\ucd94\uc801\uc694\uc18c.
\nDba_blockers \u00a0 : \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.
\nDba_catalog \u00a0\u00a0 : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 table, views, synonyms \uacfc sequence\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_clu_columns : cluster\uce7c\ub7fc\uacfc table\uce7c\ub7fc\uc758 mapping\uc815\ubcf4.
\nDba_clusters \u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \uc788\ub294 \ubaa8\ub4e0 cluster.
\nDba_col_comments : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 table, views\uc758 \uce7c\ub7fc\uc5d0\ub300\ud55c comments.
\nDba_col_privs : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \uce7c\ub7fc\uc5d0 \ub300\ud55c \ubaa8\ub4e0\uad8c\ud55c.
\nDba_coll_types : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 collection type, VARRAYs, nested tables,
\nobject tables \ub4f1\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_constraints \u00a0\u00a0 : \ubaa8\ub4e0\ud14c\uc774\ube14\uc5d0 \ub300\ud55c constraint(primary, check, unique,
\nreferential integrity, 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.
\nDba_data_files \u00a0 \u00a0\u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ud30c\uc77c\uc5d0 \uad00\ud55c \uc815\ubcf4.
\nDba_db_links \u00a0 \u00a0 \u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 Link.
\nDba_Ddl_locks \u00a0 \u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 DDL lock\uacfc DDL lock\uc774 \ud604\uc800\ud558\uac8c
\n\uc694\uad6c\ub418\ub294 \uc0ac\ud56d\uc5d0 \uad00\ud55c\uc815\ubcf4.
\nDba_dependencies\u00a0 : object \uc5d0 \ub300\ud55c Dependence.(REF, HARD)
\nDba_directories \u00a0 \u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 directory objects.
\nDba_Dml_locks \u00a0 \u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \uad6c\uc131\ub41c\ubaa8\ub4e0 DML lock\uacfc DML lock\uc774
\n\ud604\uc800\ud558\uac8c \uc694\uad6c\ub418\ub294\uc0ac\ud56d\uc5d0 \uad00\ud55c\uc815\ubcf4.
\nDba_errors \u00a0 \u00a0\u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \uc800\uc7a5\ub41c object\uc5d0 \ub300\ud574 \uac00\uc7a5\ucd5c\uadfc\uc5d0 \ubc1c\uc0dd\ub41c error.
\nDba_exp_files \u00a0 : export\ud30c\uc77c\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_exp_objects : \uc810\uc9c4\uc801\uc73c\ub85c export \ub418\uace0\uc788\ub294 object\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_exp_version : \uac00\uc7a5\ucd5c\uadfc\uc5d0 export\ub41c session\uc5d0 \ub300\ud55c version \uc815\ubcf4.<\/p>\n
Dba_extents \u00a0 \u00a0\u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 \uc138\uadf8\uba3c\ud2b8\ub97c \uc774\ub8e8\ub294 extents\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_free_space\u00a0 : \ubaa8\ub4e0 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub0b4\uc758 free extents\uc758 \uc815\ubcf4.
\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.<\/p>\n
Dba_indexes \u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 index. \ud1b5\uacc4\uc815\ubcf4\ub97c \uc5bb\uae30\uc704\ud574 Analyze\ub97c \uc0ac\uc6a9.
\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.
\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
\nstorage \ub9e4\uac1c\ubcc0\uc218, Analyze\uc5d0 \uacb0\uc815\ub41c \ud30c\ud2f0\uc158\ud1b5\uacc4\uc790\ub8cc.
\nDba_jobs \u00a0 :\u00a0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc788\ub294 \ubaa8\ub4e0 Jobs.
\nDba_jobs_running\u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \ud604\uc7ac \uc2e4\ud589\uc911\uc778 \ubaa8\ub4e0 Jobs.
\nDba_libraries \u00a0 \u00a0 \u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 libraries.
\nDba_lobs \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : \ubaa8\ub4e0 \ud14c\uc774\ube14\uc5d0 \ud3ec\ud568\ub41c LOBs.
\nDba_locks \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \uc0dd\uc131\ub41c \ubaa8\ub4e0 lock, latch\uacfc lock,latch\uac00
\n\ud604\uc800\ud558\uac8c \uc694\uad6c\ub418\ub294 \uc0ac\ud56d\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_method_params\u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 type\uc5d0 \ub300\ud55c method \ub9e4\uac1c\ubcc0\uc218.
\nDba_method_results\u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 type\uc5d0 \ub300\ud55c method results.
\nDba_nested_tables \u00a0\u00a0 : \ubaa8\ub4e0\ud14c\uc774\ube14\ub0b4\uc5d0 \ud3ec\ud568\ub41c nested table\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_object_size \u00a0 \u00a0\u00a0 : PL\/SQL object\uc5d0 \ub300\ud55c size, bytes.
\nDba_object_tables : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \ubaa8\ub4e0 object tables.
\nDba_objects \u00a0 \u00a0 \u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \ubaa8\ub4e0 objects.(index partition, table partition,
\npackage,package_body,trigger)
\nDba_obj_audit_opts \u00a0 \u00a0 : \ubaa8\ub4e0 table, view\uc5d0 \ub300\ud55c \uac10\uc0ac option.
\nDba_part_col_statistics\u00a0 : \ubaa8\ub4e0 table \ud30c\ud2f0\uc158\uc5d0 \ub300\ud55c \uce7c\ub7fc\ud1b5\uacc4\uc640 \uadf8\ub798\ud504\uc815\ubcf4.
\nDba_part_histograms \u00a0\u00a0 : \ubaa8\ub4e0 table \ud30c\ud2f0\uc158\uc758 histogram\uc5d0 \ub300\ud55c \ub370\uc774\ud130(endpoint).
\nDba_part_indexes \u00a0 \u00a0 \u00a0 : \ubaa8\ub4e0 partition index\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_part_key_columns : \ubaa8\ub4e0 partition\ub41c object\uc5d0 \ub300\ud55c \ubd84\ud560\ud0a4\uce7c\ub7fc\uc815\ubcf4.
\nDba_part_tables \u00a0 \u00a0 \u00a0\u00a0 : \ubaa8\ub4e0 partition\ub41c table\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_priv_audit_opts \u00a0 : \uc2dc\uc2a4\ud15c\uacfc user\uc5d0 \uc758\ud574 \uac10\uc0ac\ub97c \ubc1b\uace0\uc788\ub294 \uc2dc\uc2a4\ud15c privileges.
\nDba_profiles \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : \ubaa8\ub4e0 profiles\uacfc \ud574\ub2f9 profile\uc758 limit\uc744 \ub098\ud0c0\ub0c4.
\nDba_queue_schedules\u00a0 : \uba54\uc2dc\uc9c0\ub97c \uc804\ub2ec\ud558\ub294 schedule.
\nDba_queue_tables \u00a0 \u00a0\u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \uc0dd\uc131\ub41c \ubaa8\ub4e0 queue\ud14c\uc774\ube14\uc758
\nqueue type\uc758 name\uacfc type.
\nDba_Queus \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 queue\uc5d0 \ub300\ud55c \ub3d9\uc791\ud2b9\uc131.
\nDba_rchild \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : refresh group \uc548\uc758 \ubaa8\ub4e0 children object.
\nDba_refresh \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : \ubaa8\ub4e0 refresh\u00a0 group \uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_refresh_children \u00a0\u00a0 : refresh group \uc548\uc758 \ubaa8\ub4e0 object\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_refs \u00a0 :\u00a0 \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.
\nDba_refistered_snapshot_groups : \ubaa8\ub4e0 snapshot \uc0ac\ubcf8 \uadf8\ub8f9.<\/p>\n
Dba_registered_snapshots \u00a0 : \uc9c0\uc5ed\ud14c\uc774\ube14\uc758 \uc6d0\uaca9snapshot \uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_rgroup \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : \ubaa8\ub4e0 refresh group.
\nDba_roles \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \uc874\uc7ac\ud558\ub294 roles.
\nDba_role_privs \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : user\uc640 role\uc5d0 \ubd80\uc5ec\ub41c role\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_rollback_segs \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : rollback segments \uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_segments \u00a0 : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 segment\uc5d0 \ub300\ud55c \ud560\ub2f9\ub41c storage\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_sequences\u00a0 : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 sequences \uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_snapshot_logs \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 snapshot_logs.
\nDba_snapshot_refresh_times : snapshot refresh \ud55c \uc2dc\uac04.
\nDba_snapshots \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 snapshots.
\nDba_source \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \uc800\uc7a5object \uc758 source\ub97c\ud3ec\ud568.
\nDba_stmt_audit_opts \u00a0 \u00a0 \u00a0 \u00a0 : system, user\uc5d0 \uc758\ud55c \ud604\uc7ac\uc758 \uac10\uc0acoption\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDba_synonyms \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 synonyms
\nDba_sys_privs \u00a0 \u00a0 \u00a0 \u00a0 : user\uc5d0\uac8c \ubd80\uc5ec\ub41c system privilege\uc640 role.
\nDba_tab_col_statistics : Dba_tab_columns view\uc5d0 \uc788\ub294\uc815\ubcf4\uc5d0 \ub300\ud55c \uce7c\ub7fc\ud1b5\uacc4\uc640
\n\uadf8\ub798\ud504\uc815\ubcf4
\nDba_tab_columns \u00a0\u00a0 : \ubaa8\ub4e0 table, view, cluster\uc5d0 \ub300\ud55c \uce7c\ub7fc\uc815\ubcf4. Analyze\uba85\ub839\uc5b4\uc0ac\uc6a9.
\nDba_tab_comments\u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 table, view\uc5d0 \ub300\ud55c \uc8fc\uc11d.
\nDba_tab_histograms\u00a0 : \ubaa8\ub4e0 table\uc758 \uce7c\ub7fc\uc5d0 \ub300\ud55c histogram.
\nDba_tab_partitions \u00a0\u00a0 : \uac01\uac01\uc758 table partition\uc5d0 \ub300\ud574\uc11c, partition level\uc758 partition\uc815\ubcf4\uc640,
\npartition\uc758 storage\ub9e4\uac1c\ubcc0\uc218 ,Analyze \uc5d0\uc758\ud574 \uacb0\uc815\ub41c \uc5ec\ub7ec partition\ud1b5\uacc4\uc815\ubcf4.
\nDba_tab_privs \u00a0 : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 object\uc5d0 \ubd80\uc5ec\ub41c \uad8c\ud55c.
\nDba_tables \u00a0 \u00a0\u00a0 : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \uad00\uacc4\ud615\ud14c\uc774\ube14\uc5d0 \uad00\ud55c\uc815\ubcf4.Analyze\ub85c
\n\ud1b5\uacc4\uc815\ubcf4\ub97c\u00a0 \uc5bb\uc744\uc218 \uc788\ub2e4.
\nDba_tablespaces : \ubaa8\ub4e0 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \uad00\ud55c\uc815\ubcf4.
\nDba_triggers \u00a0 \u00a0 : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 trigger \uc815\ubcf4.
\nDba_trigger_cols : \ubaa8\ub4e0 trigger\uc5d0\uc11c \uc0ac\uc6a9\ub41c \uce7c\ub7fc\uc815\ubcf4.
\nDba_ts_quotas \u00a0 : \ubaa8\ub4e0 user\uc5d0\uac8c \ud560\ub2f9\ub41c tablespace.
\nDba_type_attrs \u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 type\uc5d0 \ub300\ud55c \uc18d\uc131.
\nDba_type_methods : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 type\uc5d0 \ub300\ud55c methods.
\nDba_types \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 \ucd94\uc0c1\uc801\ub370\uc774\ud130type.
\nDba_updatable_columns : join view\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uad00\ub9ac\uc790\uac00
\nupdate\ud560\uc218\uc788\ub294\uce7c\ub7fc\uc815\ubcf4.
\nDba_users\u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 user\uc815\ubcf4.
\nDba_views\u00a0 : \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 view\uc758 text.
\nDbms_alert_info \u00a0 \u00a0\u00a0 : \ub4f1\ub85d\ub41c alert\uc815\ubcf4.
\nDbms_lock_allocated : \uc0ac\uc6a9\uc790\uc5d0\uac8c \ud560\ub2f9\ub41c lock\uc815\ubcf4.
\nDeptree \u00a0 \u00a0 :\u00a0 utldtree.sql \uc5d0\uc758\ud574 \uc0dd\uc131\ub418\uba70, object\uc758 dependency tree\uc815\ubcf4\ub97c \ud3ec\ud568\ud568.
\n‘Sys’ user\uc778 \uacbd\uc6b0. \uc774 object\uc5d0 \uad00\ub828\ub41c \uacf5\uc720\ucee4\uc11c\ub97c \ub098\ud0c0\ub0b4\uace0,
\n\ub2e4\ub978 user\uc778 \uacbd\uc6b0\uacf5\uc720\ucee4\uc11c\uc774\uc678\uc758 object\ub97c \ub098\ud0c0\ub0b8\ub2e4.
\n\ub2e4\ub978 user\ub294 \uacf5\uc720\ucee4\uc11c\uc815\ubcf4\ub97c \uc5bb\uae30\uc704\ud574, Sys.deptree\ub97c access\ud560\uc218\uc788\ub2e4.<\/p>\n
Dictionary \u00a0 \u00a0 \u00a0 : \u00a0 data dictionary table, view\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nDict_columns \u00a0\u00a0 : \u00a0 data dictionary table, view\uc5d0 \ub300\ud55c \uce7c\ub7fc.
\nError_size \u00a0 \u00a0 \u00a0 : \u00a0\u00a0 Dba_obejct_size \uc640 user_obejct_size view\ub97c create \ud560\ub54c \uc0ac\uc6a9\ub41c\ub2e4.
\nExceptions \u00a0 \u00a0\u00a0 : \u00a0\u00a0 \ubb34\uacb0\uc131\uc81c\uc57d\uc870\uac74\uc5d0 \uc704\ubc30\ub418\ub294 \uc815\ubcf4\ub97c \ud3ec\ud568. utlexcpt.sql \ub85c \uc0dd\uc131.
\nFile_lock \u00a0 \u00a0 \u00a0\u00a0 : \u00a0 \ubcd1\ub82c\uc11c\ubc84view. \ucd08\uae30\ud654\ud30c\ub77c\ubbf8\ud130 GC_FILE_TO_LOCKS \uc5d0 \uba85\uc2dc\ub41c,
\n\ub370\uc774\ud130\ud30c\uc77c\uc5d0 PCM lock\uc758 mapping\uc815\ubcf4.
\nFile_ping : \ubcd1\ub82c\uc11c\ubc84view.\uac01\ub370\uc774\ud0c0\ud30c\uc77c\uc5d0 \ud560\ub2f9\ub41c block\uc758 \uc218.
\nGC_FILES_TO_LOCKS \ucd5c\uc801\uac12\uc744 \uad6c\ud558\uae30 \uc704\ud574 \ud604\uc874\ud558\ub294 \ub370\uc774\ud130\ud30c\uc77c\uc758
\naccess\ubc29\ubc95\uc744 \uacb0\uc815\ud558\ub294\ub370 \uc774 \uc815\ubcf4\ub97c\uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.
\nFILEXT$\u00a0 :\u00a0 DBA_DATA_FILES \uc640 \ub3d9\uc77c. (DBA_DATA_FILES\uc758 \uc0ac\uc6a9\uc744 \ucd94\ucc9c)
\nGLOBAL_NAME : \ud604\uc81c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc720\uc77c\ud55c \uc774\ub984.
\nHS_ALL_CAPS \u00a0 : \ubaa8\ub4e0 \ube44 Oracle Data store (FDS) \uc640 \uad00\ub828\ub41c \ud2b9\uc131\uc5d0 \uad00\ud55c\uc815\ubcf4.
\nHS_ALL_DD \u00a0 \u00a0 : \ubaa8\ub4e0 \ube44 Oracle Data store(FDS)\uc5d0 \ub300\ud55c Data dictionary.
\nHS_ALL_INITS \u00a0 : \ube44 Oracle Data store(FDS)\uc5d0 \ub300\ud55c \ucd08\uae30\ud654 \ub9e4\uac1c\ubcc0\uc218.
\nHS_BASE_CAPS\u00a0 : \ube44 Oracle Data store(FDS)\uc5d0 \ub300\ud55c \uae30\ubcf8\ud2b9\uc131\uc5d0 \uad00\ud55c\uc815\ubcf4.
\nHS_BASE_DD \u00a0\u00a0 : \ube44 Oracle Data store(FDS)\uc5d0 \ub300\ud55c Data dictionary.
\nHS_CLASS_CAPS : \ube44 Oracle Data store(FDS)\uc5d0 \ud3ec\ud568\ub41c class-specific \ud2b9\uc131\uc815\ubcf4.
\nHS_CLASS_DD \u00a0 : \ube44 Oracle Data store(FDS) class_specific data dictionary.
\nHS_CLASS_INIT\u00a0 :\u00a0 \ube44 Oracle Data store(FDS) class-specific \ucd08\uae30\ud654 \ub9e4\uac1c\ubcc0\uc218.
\nHS_EXTERNAL_OBJECT_PRIVILEGES : user\uc5d0\uac8c \ubd80\uc5ec\ub41c object\uad8c\ud55c.
\nHS_EXTERNAL_OBJECTS : oracle server\uc5d0\uc11c access\uac00\ub2a5\ud55c external obejct.
\nHS_EXTERNAL_USER_PRIVILEGES : \uc5b4\ub290 \ud2b9\uc815object\uc5d0 \uad6d\ud55c\ub418\uc9c0\uc54a\uc740 \ubaa8\ub4e0
\n\ubd80\uc5ec\ub41c\uad8c\ud55c
\nHS_FDS_CLASS\u00a0 : \ube44 oracle (FDS) class \uc5d0 \uad00\ud55c \uc815\ubcf4.
\nHS_FDS_INST \u00a0\u00a0 : \ube44 oracle (FDS) instance\uc5d0 \uad00\ud55c\uc815\ubcf4.
\nHS_INST_CAPS \u00a0 : instance-specific \ud2b9\uc131\uc815\ubcf4.
\nHS_INST_DD \u00a0 \u00a0 : \ube44 oracle (FDS) instance-specific data dictionary \ubcc0\uacbd\uc815\ubcf4.
\nHS_INST_INIT \u00a0\u00a0 : \ube44 oracle (FDS) instance-specific \ucd08\uae30\ud654 \ub9e4\uac1c\ubcc0\uc218\uc815\ubcf4.
\nIDEPTREE\u00a0 : UTLDTREE.sql \ub85c \uc0dd\uc131\ud558\uace0, \uad00\ub828tree\ub97c \ub098\ud0c0\ub0c4.
\nDeptree\uc758 \uc790\ub3d9\uc815\ub82c\ubc84\uc83c.
\nINDEX_HISTOGRAM\u00a0 :\u00a0 Analyze index…validate structure \uba85\ub839\uc5d0 \ub300\ud55c\uc815\ubcf4.
\nINDEX_STATS \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : \ub9c8\uc9c0\ub9c9 Analyze index..validate structure \uba85\ub839\uc5d0 \ub300\ud55c\uc815\ubcf4.
\nNLS_DATABASE_PARAMETERS : \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 NLS \ub9e4\uac1c\ubcc0\uc218.
\nNLS_INSTANCE_PARAMETERS\u00a0 : instance\uc758 NLS \ub9e4\uac1c\ubcc0\uc218.
\nNLS_SESSION_PARAMETERS \u00a0 \u00a0 : user session\uc758 NLS \ub9e4\uac1c\ubcc0\uc218.<\/p>\n
OBJ \u00a0 :\u00a0 user_objects \uc758 synonym.
\nPARSED_PIECES\u00a0 :\u00a0 Dba_object_size, User_object_size view\ub97c \uc0dd\uc131\uc2dc\uc5d0 \ud544\uc694.
\nPARSED_SIZE \u00a0 \u00a0 :\u00a0 Dba_obejct_size, User_object_size view\ub97c \uc0dd\uc131\uc2dc\uc5d0 \ud544\uc694.
\nPlan_table \u00a0 : \u00a0 explain plan\uc758 \uacb0\uacfc\uc5d0 \ub300\ud55c table. utlxplan.sql\ub85c \uc0dd\uc131.
\nProduct_component_version\u00a0 :\u00a0 Oracle \uc81c\ud488\uad70\uc758 \ubc84\uc804\uacfc \uc0c1\ud0dc\uc124\uba85.<\/p>\n
Pstubtbl \u00a0 : \u00a0 Pstub utility\uc5d0 \uc758\ud574 \uc0dd\uc131\ub41c stub\uc5d0 \uad00\ud55c\uc815\ubcf4.
\nPublicsyn \u00a0 : \u00a0 public synonym \uc5d0 \uad00\ud55c \uc815\ubcf4.
\nPublic_dependency \u00a0 : \u00a0 object\uc640 \uad00\ub828\ub41c dependencies.(parent object)
\nResource_cost \u00a0 :\u00a0 \uac01\uac01\uc758 resource\uc5d0 \ub300\ud55c cost.
\nResource_map \u00a0 :\u00a0 \uac01\uac01\uc758 resource\uc5d0 \ub300\ud55c \uc815\ubcf4.(resource name, resource number)
\nRole_role_privs\u00a0 :\u00a0 \ub2e4\ub978 role\uc5d0 \ubd80\uc5ec\ub41c role\uc815\ubcf4.(user\uac00 access\uac00\ub2a5\ud55c role\uc5d0 \ud55c\ud574)
\nRole_sys_privs\u00a0 : \ub2e4\ub978 role\uc5d0 \ubd80\uc5ec\ub41c system role\uc815\ubcf4(user\uac00 access\uac00\ub2a5\ud55crole\uc5d0 \ud55c\ud574)
\nRole_tab_privs\u00a0 : \ub2e4\ub978 role\uc5d0 \ubd80\uc5ec\ub41c table privileges\uc815\ubcf4.
\n(user\uac00 access\uac00\ub2a5\ud55crole\uc5d0 \ud55c\ud574)<\/p>\n
SEQ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 :\u00a0 user_sequences \uc758 synonym.
\nSession_privs \u00a0\u00a0 : \ud604\uc7ac user\uc5d0\uac8c \uc0ac\uc6a9\uac00\ub2a5\ud55c \uad8c\ud55c.
\nSession_roles \u00a0\u00a0 : \ud604\uc7ac user\uc5d0\uac8c \uc0ac\uc6a9\uac00\ub2a5\ud55c roles.
\nSource_size \u00a0 \u00a0 :\u00a0 Dba_object_size, User_object_size view\ub97c \uc0dd\uc131\uc2dc \ud544\uc694.
\nStmt_audit_option_map \u00a0 : \uac10\uc0ac option type code\uc815\ubcf4.
\nSyn \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : user_synonyms \uc5d0 \ub300\ud55c synonym.
\nSynonyms \u00a0 \u00a0\u00a0 : Oracle ver 5.\uc640 \ud638\ud658\uc131\uc744 \ud3ec\ud568. not recommend
\nSyscatalog \u00a0 \u00a0\u00a0 : Oracle ver 5.\uc640 \ud638\ud658\uc131\uc744 \ud3ec\ud568. not recommend
\nSysfiles \u00a0 \u00a0 \u00a0 \u00a0 :\u00a0 Oracle ver 5.\uc640 \ud638\ud658\uc131\uc744 \ud3ec\ud568. not recommend
\nSyssegobj \u00a0 \u00a0 \u00a0 : Oracle ver 5.\uc640 \ud638\ud658\uc131\uc744 \ud3ec\ud568. not recommend
\nSystem_privilege_map\u00a0 :\u00a0 system privilege code\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nSys_objects \u00a0 : object ID\uc640 object type \uadf8\ub9ac\uace0 segment data block\uc8fc\uc18c\ub97c \ub9e4\ud551\ud558\ub294\uc815\ubcf4.
\nTab \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : Oracle ver 5.\uc640 \ud638\ud658\uc131\uc744 \ud3ec\ud568. not recommend
\nTable_privileges : user\uac00 \ubd80\uc5ec\ud55c, \ubd80\uc5ec\ubc1b\uc740, \uc18c\uc720\ud55c, \uadf8\ub9ac\uace0 PUBLIC\uc73c\ub85c
\n\ubd80\uc5ec\ub41c object \uad8c\ud55c\uc815\ubcf4. Oracle ver 6.\uacfc \ud638\ud658\uc131\uc744 \ud3ec\ud568. \u00a0\u00a0 not recommend.
\nTable_privilege_map\u00a0 :\u00a0 access \uac00\ub2a5\ud55c \uad8c\ud55ccode\/\uad8c\ud55c\uba85\uce6d \uc815\ubcf4.
\nTabs \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 :\u00a0 User_tables \uc758 synonym.
\nTabquotas \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : Oracle ver 5.\uc640 \ud638\ud658\uc131\uc744 \ud3ec\ud568. not recommend
\nTrusted_servers \u00a0 \u00a0 \u00a0 : \ubd84\uc0b0\ud658\uacbd\uc5d0\uc11c \uc11c\ubc84\uac00 \uc2e0\ub8b0\ud560\ub9cc\ud55c\uc9c0\ub97c \ub098\ud0c0\ub0c4.
\nTp_pitr_check \u00a0 \u00a0 \u00a0\u00a0 : catpitr.sql \uc5d0 \uc758\ud574 \uc0dd\uc131. \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 point-in-time\ubcf5\uad6c\ub97c
\n\ubc29\ud574\ud560\uc9c0\ub3c4 \ubaa8\ub974\ub294 dependencies\ud639\uc740 restriction\uc5d0 \uad00\ud55c \uc815\ubcf4\uc81c\uacf5.
\nTs_pitr_objects_to_be_dropped\u00a0 : \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 point-in-time\ubcf5\uad6c\uc218\ud589\uc758 \uacb0\uacfc
\n\uc190\uc2e4\ub41c object\uc5d0 \ub300\ud55c \uc815\ubcf4. (point-in-time recovery\uc758 \uacbd\uc6b0\ub9cc \ud574\ub2f9).
\nUser_all_tables \u00a0 \u00a0 \u00a0\u00a0 : user\uac00 \uc0ac\uc6a9\uac00\ub2a5\ud55c \ud14c\uc774\ube14(object table, relational table)\uc815\ubcf4.
\nUser_arguments \u00a0 \u00a0 \u00a0 : user\uac00 access\uac00\ub2a5\ud55c object\uc758 \ub9e4\uac1c\ubcc0\uc218\uc815\ubcf4.
\nUser_Audit_object \u00a0\u00a0 : cataudit.sql\ub85c \uc0dd\uc131. object\uc5d0 \uad00\ub828\ub41c \uac10\uc0ac\ucd94\uc801\uae30\ub85d.
\nUser_Audit_session \u00a0 : cataudit.sql\ub85c \uc0dd\uc131. user\uc758 \uc5f0\uacb0\/\uc885\ub8cc\uc5d0 \uad00\ub828\ub41c \uac10\uc0ac\ucd94\uc801\uae30\ub85d.
\nUser_Audit_statement : cataudit.sql\ub85c \uc0dd\uc131. user\uc5d0 \uc758\ud574 \uc2e4\ud589\ub41c GRANT,REVOKE,
\nAUDIT, NOAUDIT, ALTER SYSTEM \uba85\ub839\uc5d0 \ub300\ud55c \uac10\uc0ac\ucd94\uc801\uae30\ub85d.<\/p>\n
User_Audit_trail \u00a0 \u00a0\u00a0 : user\uc640 \uad00\ub828\ub41c \uc804\ubc18\uc801\uc778 \uc0ac\ud56d\uc758 \uac10\uc0ac\ucd94\uc801\uae30\ub85d.
\nUser_catalog \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : user \uc18c\uc720\uc758 table, views, synonyms, sequences \uc758 \uc774\ub984\uacfc type.
\nUser_clusters \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : user\uc18c\uc720\uc758 cluster.
\nUser_clu_columns \u00a0 \u00a0 : user table \uc758 \uce7c\ub7fc\uacfc cluster\uce7c\ub7fc\uacfc\uc758 \ub9e4\ud551\ud14c\uc774\ube14.
\nUser_col_comments \u00a0 : user \uc758 table, view\uc758 \uce7c\ub7fc\uc5d0 \ub300\ud55c \uc8fc\uc11d.
\nUser_col_privs \u00a0 \u00a0 \u00a0\u00a0 : user \uac00 \uc18c\uc720\ud55c, \ubd80\uc5ec\ud55c, \ubd80\uc5ec\ubc1b\uc740 \uce7c\ub7fc\uc5d0 \ub300\ud55c \uad8c\ud55c.
\nUser_col_privs_made : user \uc18c\uc720 object\uc758 \uce7c\ub7fc\uc5d0 \ub300\ud55c \uad8c\ud55c.
\nUser_col_privs_recd\u00a0 : user\uac00 \ubd80\uc5ec\ubc1b\uc740 \uce7c\ub7fc\uc5d0 \ub300\ud55c \uad8c\ud55c.
\nUser_coll_types \u00a0 \u00a0 \u00a0 : user\uac00 \uba85\uba85\ud55c collection type\uc815\ubcf4.
\nUser_constraints \u00a0 \u00a0\u00a0 : user\uc18c\uc720 \ud14c\uc774\ube14\uc758 \uc81c\uc57d\uc870\uac74\uc815\uc758.
\nUser_cons_columns\u00a0 : user\uc18c\uc720 \uc81c\uc57d\uc870\uac74\uc5d0 \uc815\uc758\ub41c \uce7c\ub7fc\uc5d0 \ub300\ud55c\uc815\ubcf4.
\nUser_db_links \u00a0 \u00a0 \u00a0\u00a0 : user\uc18c\uc720 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub9c1\ud06c\uc5d0 \ub300\ud55c\uc815\ubcf4.
\nUser_dependencies \u00a0 : user\uc18c\uc720 object\uc5d0 \ub300\ud55c dependencies.
\nUser_errors \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : user\uc18c\uc720 \uc800\uc7a5 object\uc5d0 \ub300\ud55c \ud604\uc7ac\uc758 \uc5d0\ub7ec.
\nUser_extents \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : user\uc18c\uc720 object\uc5d0 \uc18d\ud558\ub294 \uc138\uadf8\uba3c\ud2b8\uc758 extent \uc815\ubcf4.
\nUser_free_space \u00a0 \u00a0\u00a0 : user\uac00 access\uac00\ub2a5\ud55c \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub0b4\uc758 free extent \uc815\ubcf4.
\nUser_indexes \u00a0 \u00a0 : user \uc18c\uc720\uc758 indexes. Analyze\uba85\ub839\uc744 \uc0ac\uc6a9\ud574\uc57c\ud568. \ubcd1\ub82c\uc11c\ubc84\ub97c \uc9c0\uc6d0.
\nUser_ind_columns \u00a0 : user\uc18c\uc720 index \ub610\ub294 user\uc18c\uc720 table \uc758 \uce7c\ub7fc\uc815\ubcf4.
\nUser_ind_partitions\u00a0 : user\uc18c\uc720\uc758 index partition\uac01\uac01\uc5d0 \ub300\ud55c\uc124\uba85\uacfc, partition\uc815\ubcf4,
\npartition\uc758 storage \ub9e4\uac1c\ubcc0\uc218, Analyze\uba85\ub839\uc73c\ub85c \uacb0\uc815\ub41c \uc5ec\ub7ecpartition\ud1b5\uacc4
\nUser_jobs \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : user\uc18c\uc720\uc758 \ubaa8\ub4e0 job.(export\/import, execution)
\nUser_libraries \u00a0 \u00a0 \u00a0 : user\uc18c\uc720\uc758 \ubaa8\ub4e0 libraries .
\nUser_lobs \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : user\uc18c\uc720\uc758 table\uc5d0\ud3ec\ud568\ub41c LOBs\uc815\ubcf4.
\ninternal LOBs( BLOBs, NCLOBs) \ub9cc\ud574\ub2f9, external LOBs(i.e, BFILES)\uc740 \uc544\ub2d8.
\nUser_method_params\u00a0 : user type\uc758 method \ub9e4\uac1c\ubcc0\uc218.
\nUser_method_results \u00a0 : user type\uc758 method \uc758 results.
\nUser_nested_tables \u00a0 \u00a0 : user\uc18c\uc720 \ud14c\uc774\ube14\uc5d0 \ud3ec\ud568\ub41c nested tables.
\nUser_object_tables \u00a0 \u00a0\u00a0 : user\uac00 \uc0ac\uc6a9\uac00\ub2a5\ud55c object table.
\nUser_objects \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : user\uc18c\uc720\uc758 object.(index partition, table partition, package,
\npackagebody, trigger)
\nUser_object_size \u00a0 \u00a0 \u00a0 \u00a0 : user\uc18c\uc720\uc758 PL\/SQL object.
\nUser_obj_audit_opts \u00a0 \u00a0\u00a0 : cataudit.sql\ub85c \uc0dd\uc131. user\uc18c\uc720\uc758 table,view\uc5d0 \ub300\ud55c \uac10\uc0acoption
\nUser_part_col_statistics : user\uc18c\uc720\uc758 tablepartition\uc815\ubcf4\uc5d0 \ub300\ud55c \uce7c\ub7fc\ud1b5\uacc4\uc640 \uadf8\ub798\ud504\uc815\ubcf4.
\nUser_part_histograms\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294 table partition\uc758 histogram\uc5d0 \ub300\ud55c
\n\uadf8\ub798\ud504\ub370\uc774\ud130(end-pointer).
\nUser_part_key_columns : user\uc18c\uc720\uc758 partition object\uc758 partition key\uce7c\ub7fc\uc5d0 \ub300\ud55c\uc815\ubcf4.
\nUser_part_indexes \u00a0 \u00a0 \u00a0 : \ubaa8\ub4e0 user\uc18c\uc720\uc758 partition index\uc758 partition\uc815\ubcf4.
\nUser_part_tables \u00a0 \u00a0 \u00a0 \u00a0 : user\uc18c\uc720\uc758 partition table\uc5d0 \ub300\ud55c object \ub808\ubca8\uc758 partition\uc815\ubcf4.<\/p>\n
User_password_limits \u00a0 : user\uc5d0\uac8c \uc801\uc6a9\ub41c password profile parameter.
\nUser_queue_tables \u00a0 \u00a0\u00a0 : user\uc18c\uc720 \uc2a4\ud0a4\ub9c8\uc5d0 \uc0dd\uc131\ub41c queue table\ub0b4\ubd80\uc758 queues\uc815\ubcf4.
\nUser_Queues \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : user\uc2a4\ud0a4\ub9c8\uc758 \ubaa8\ub4e0 queue\uc5d0 \ub300\ud55c \ub3d9\uc791 \ud2b9\uc131\uc744 \ub098\ud0c0\ub0c4.
\nUser_refresh \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : \ubaa8\ub4e0 refresh group.
\nUser_refresh_children \u00a0\u00a0 : user\uac00 \uc18c\uc720\ud55c refresh group \ub0b4\ubd80\uc758 object\uc5d0 \uad00\ud55c\uc815\ubcf4.
\nUser_refs \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : user\uc18c\uc720\ud14c\uc774\ube14\uc758 object type\uce7c\ub7fc\uc911 REF\uce7c\ub7fc, REF\uc18d\uc131.
\nUser_resource_limits \u00a0 \u00a0 : \ud604\uc7ac user\uc758 resource \ud55c\uacc4.
\nUser_role_privs \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : user\uc5d0\uac8c \ubd80\uc5ec\ub41c roles.
\nUser_segments\u00a0 : user\uc624\ube0c\uc81d\ud2b8\uc5d0 \ud3ec\ud568\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4 segments\uc758 storage\ud560\ub2f9\uc815\ubcf4.
\nUser_sequences\u00a0 : user \uc18c\uc720\uc758 sequences.
\nUser_snapshots \u00a0 : user \uac00 \ubcfc\uc218\uc788\ub294 snapshots.
\nUser_snapshot_logs : user \uc18c\uc720\uc758 \ubaa8\ub4e0 snapshot logs.
\nUser_source \u00a0 \u00a0 \u00a0 \u00a0 : user\uc18c\uc720 \uc800\uc7a5 objects \uc758 \ubaa8\ub4e0 text source.
\nUser_snapshot_refresh_times \u00a0\u00a0 : snapshot refresh time.
\nUser_synonyms \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : user\uc18c\uc720\uc758 synonym.
\nUser_sys_privs \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : user\uc5d0\uac8c \ubd80\uc5ec\ub41c system \uad8c\ud55c.
\nUser_tab_col_statistics \u00a0 \u00a0 \u00a0\u00a0 : user_tab_columns view\uc5d0 \ub300\ud55c \uce7c\ub7fc\ud1b5\uacc4\uc640
\n\uadf8\ub798\ud504\uc815\ubcf4\ub97c\u00a0 \ub098\ud0c0\ub0c4.
\nUser_tab_columns \u00a0 : user\uc18c\uc720\uc758 table, view, cluster\uc758 \uce7c\ub7fc\uc815\ubcf4.(Analyze\uba85\ub839\uc0ac\uc6a9)
\nUser_tab_comments\u00a0 : user\uc18c\uc720\uc758 table, view\uc5d0 \ub300\ud55c \uc8fc\uc11d.
\nUser_tab_histograms\u00a0 : user\uc18c\uc720 table\uc758 \uce7c\ub7fc\uc5d0 \ub300\ud55c histogram.
\nUser_tab_partitions \u00a0 : user\uc18c\uc720 table partition\uc5d0 \ub300\ud55c, partition \ub808\ubca8\uc758 \ubd84\ud560\uc815\ubcf4\uc640,
\npartition\uc758 storage\ub9e4\uac1c\ubcc0\uc218, Analyze\uc5d0 \uc758\ud574 \uc9d1\uacc4\ub41c \uc5ec\ub7ec\ud1b5\uacc4\uc815\ubcf4.
\nUser_tab_privs \u00a0 \u00a0 \u00a0 : user\uac00 \uc18c\uc720\ud55c, \ubd80\uc5ec\ud55c, \ubd80\uc5ec\ubc1b\uc740 object\uc5d0 \ub300\ud55c \uad8c\ud55c \uc815\ubcf4.
\nUser_tab_privs_made : user\uac00 \uc18c\uc720\ud55c object\uc5d0 \uad00\ud55c \ubaa8\ub4e0 \uad8c\ud55c.
\nUser_tab_privs_recd\u00a0 : user\uac00 \ubd80\uc5ec\ubc1b\uc740 object \uad8c\ud55c\uc815\ubcf4.
\nUser_tables \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : user\uc18c\uc720\uc758 relational table\uc5d0 \ub300\ud55c \uc815\ubcf4. (Analyze\uba85\ub839\uc0ac\uc6a9)
\nUser_tablespaces \u00a0 \u00a0 : user\uac00 access \uac00\ub2a5\ud55c tablespaces\uc5d0 \ub300\ud55c \uc124\uba85.
\nUser_triggers \u00a0 \u00a0 \u00a0 \u00a0 : user\uac00 \uc18c\uc720\ud55c triggers \uc815\ubcf4.
\nUser_trigger_cols \u00a0\u00a0 : user\uac00 \uc18c\uc720\ud55c \ub610\ub294 user\ud14c\uc774\ube14\uc5d0 \uc788\ub294 trigger\uc548\uc758 column \uc815\ubcf4.
\nUser_ts_quotas \u00a0 \u00a0 \u00a0 : user\uc5d0\uac8c \ud560\ub2f9\ub41c tablespace quotas \uc815\ubcf4.
\nUser_types \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : \ud14c\uc774\ube14\uc548\uc758 user\uc18c\uc720\uc758 type.
\nUser_type_attrs \u00a0 \u00a0\u00a0 : user type\uc758 \uc18d\uc131\uc744 \ub098\ud0c0\ub0c4.
\nUser_type_methods\u00a0 : user type\uc758 methods\ub97c \ub098\ud0c0\ub0c4.
\nUser_updatable_columns : join view\uc5d0\uc11c \uc0ac\uc6a9\uc790\uc5d0\uac8c update\uac00 \ud5c8\uc6a9\ub41c \uce7c\ub7fc\uc815\ubcf4.
\nUser_users \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : \ud604\uc7ac user\uc5d0 \uad00\ud55c \uc815\ubcf4.
\nUser_views \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : user \uc18c\uc720\uc758 view\uc5d0 \ub300\ud55c text.
\nFILEXT$ \u00a0 \u00a0 : \ub370\uc774\ud130\ud30c\uc77c\uc758 AUTOEXTEND\ub97c ON\uc73c\ub85c \ubcc0\uacbd\ud588\uc744 \ub54c \ucc98\uc74c \uc0dd\uc131.
\nV$ACCESS\u00a0 : \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 lock\uc774\uac78\ub9b0 object\uc640\u00a0 \uadf8 object\ub97c
\naccess \ud558\ub824\ub294 session id.
\nV$ACTIVE_INSTANCES : \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 Mount\ub41c
\n\ubaa8\ub4e0 \uc778\uc2a4\ud134\uc2a4\uc5d0\ub300\ud558\uc5ec \uc778\uc2a4\ud134\uc2a4 \uc774\ub984\uacfc, \ubc88\ud638\ub97c \ub9e4\uce58.
\nV$AQ \u00a0 \u00a0 \u00a0\u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 Queue\uc5d0 \ub300\ud55c \ud1b5\uacc4.
\nV$ARCHIVE : Archive\uc5d0 \ud544\uc694\ud55c redo log file\uc5d0 \ub300\ud55c \uc815\ubcf4.
\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.
\nV$ARCHIVE_DEST : \ud604\uc7ac\uc758 instance\uc5d0\uc11c, \ubaa8\ub4e0 archive log destination,
\n\ud604\uc7ac\uac12, mode, status.
\nV$ARCHIVED_LOG : archive log \uc774\ub984\uc744 \ud3ec\ud568\ud558\ub294 controlfile\uc5d0 \ub300\ud55c archive log \uc815\ubcf4,
\narchive log \uae30\ub85d\uc740 online\uc911 redo log\uac00 \uc131\uacf5\uc801\uc73c\ub85c \uc800\uc7a5\ub418\uc5c8\uac70\ub098,
\nclear(log\uac00 clear\ub418\uba74, name\uce7c\ub7fc\uc740 null\uc774 \ub41c\ub2e4)\ub41c\ud6c4 insert\ub41c\ub2e4.
\nV$BACKUP\u00a0 : \ubaa8\ub4e0 online \ub370\uc774\ud130\ud30c\uc77c\uc758 backup \uc0c1\ud0dc\ub97c \ub098\ud0c0\ub0b8\ub2e4.
\nV$BACKUP_CORRUPTION : \ub370\uc774\ud130\ud30c\uc77c\uc758 backup \uc911 \uc5d0\ub7ec\uc815\ubcf4\ub97c \ub098\ud0c0\ub0b8\ub2e4.
\n\uc5d0\ub7ec\ub4e4\uc740 control \ud30c\uc77c\uacfc achived log backup \uc5d0 \ud3ec\ud568\ub418\uc9c0 \uc54a\ub294\ub2e4.
\nV$BACK_DATAFILE : control \ud30c\uc77c\uc5d0\uc11c datafile\uacfc controlfile \uc758 backup\uc815\ubcf4\ub97c \ubcf4\uc5ec\uc90c.
\nV$BACK_DEVICE \u00a0 : \uc9c0\uc6d0\ub418\ub294 backup \ub514\ubc14\uc774\uc2a4\uc815\ubcf4.
\nV$BACK_PIECE \u00a0 \u00a0 : controlfile\uc5d0\uc11c backup piece\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \ud3ec\ud568.
\n\uac01\uac01\uc758 backup set \uc740 \ud558\ub098 \ub610\ub294 \uadf8\uc774\uc0c1\uc758 backup piece\ub85c \uad6c\uc131\ub41c\ub2e4.
\nV$BACKUP_REDOLOG : controlfile\uc5d0\uc11c backup set\uc758 \uc800\uc7a5\ub41c log\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nOnline redo logs\ub294 \uace7\ubc14\ub85c backup \ub418\uc9c0 \uc54a\ub294\ub2e4: \uba3c\uc800 disk\uc5d0 \uc800\uc7a5\ub41c\ud6c4 backup
\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.
\nV$BACKUP_SET \u00a0 \u00a0 : controlfile\uc5d0\uc11c backupset \uc815\ubcf4\ub97c \ubcf4\uc5ec\uc90c.
\nbackup set \ud589\uc740 backup set\uc774 \uc131\uacf5\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\uc744 \ub54c insert\ub41c\ub2e4.
\nV$BGPROCESS \u00a0 \u00a0 \u00a0 : \ubc31\uadf8\ub77c\uc6b4\ub4dc \ud504\ub85c\uc138\uc2a4 \uc815\ubcf4.
\nV$BH \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : \ubcd1\ub82c\uc11c\ubc84 view\uc774\ub2e4.
\nSGA\ub0b4\uc758 \ubaa8\ub4e0 \ubc84\ud37c\uc5d0 \ub300\ud55c ping\uc758 \uc0c1\ud0dc\uc640 \uc218\ub97c \ub098\ud0c0\ub0b8\ub2e4.
\nV$BUFFER_POOL \u00a0\u00a0 : \uc778\uc2a4\ud134\uc2a4\ub0b4\uc5d0\uc11c \uc0ac\uc6a9\uac00\ub2a5\ud55c \ubaa8\ub4e0 \ubc84\ud37c\ud480\uc5d0 \ub300\ud55c\uc815\ubcf4.
\nV$CACHE\u00a0 : \ubcd1\ub82c\uc11c\ubc84 view\uc774\ub2e4.
\n\ud2b9\uc815\ub370\uc774\ud0c0\ubca0\uc774\uc2a4object\uc5d0 \uad00\ub828\ub41c \ud604\uc7ac\uc758 \uc778\uc2a4\ud134\uc2a4\uc758
\nSGA\ub0b4\ubd80\uc758 \uac01\uac01\uc758 block\uc5d0 \ub300\ud55c block header\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nV$CACHE_LOCK : \ubcd1\ub82c\uc11c\ubc84view. platform-specific lock manager \uc2dd\ubcc4\uc790\ub97c \uc81c\uc678\ud558\uba74,
\nV$CACHE\uc640 \uc720\uc0ac\ud558\ub2e4.
\nV$CIRCUIT\u00a0 : \uac00\uc0c1 circuit\uc5d0 \uad00\ud55c \uc815\ubcf4\uc774\uba70, \uac00\uc0c1circuit\ub780 dispatcher\uc640 server\ub97c
\n\ud1b5\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 user \uc5f0\uacb0\uc744 \ub9d0\ud55c\ub2e4.
\nV$CLASS_PING : \uac01\uac01blockclass\ub9c8\ub2e4 ping\ub41c \ube14\ub85d\uc758 \uc218\ub97c\ub098\ud0c0\ub0b8\ub2e4.
\n\ub2e4\ub978class\ube14\ub85d\uc758 \ucda9\ub3cc\uc744 \ube44\uad50\ud558\uae30\uc704\ud574 \uc0ac\uc6a9.
\nV$COMPATIBILITY : \uc774\uc804\ubc84\uc804\uc73c\ub85c downgrade\ub97c \ubc29\uc9c0\ud558\uae30\uc704\ud574
\n\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc778\uc2a4\ud134\uc2a4\uc5d0 \uc758\ud574 \uc0ac\uc6a9\ub41c\ud2b9\uc131\ub4e4\uc744 \uc124\uba85.
\n\ub2e4\ub978 \uc778\uc2a4\ud134\uc2a4\uac00 \uac16\uace0\uc788\ub294 \ud2b9\uc131\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\uc9c0 \uc54a\uc73c\uba70,
\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
\n\ube44\ud638\ud658\uc131\ub4e4\uc744 \ud3ec\ud568\ud560\uc218\ub3c4 \uc788\ub2e4.
\nV$COMPATSEG \u00a0 : \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
\n\uc0ac\uc6a9\ub418\ub294 \uc601\uad6c\uc801\uc778 \ud2b9\uc131\ub4e4.
\nV$CONTROLFILE\u00a0 : \ucee8\ud2b8\ub864\ud30c\uc77c\uc758 \uc774\ub984\uacfc \uc0c1\ud0dc.
\nV$CONTROLFILE_RECORD_SECTION\u00a0 : \ucee8\ud2b8\ub864\ud30c\uc77c\uc758 record\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nV$COPY_CORRUPTION\u00a0 : \ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130 \ub370\uc774\ud130\ud30c\uc77c\uc758 \ubcf5\uc0ac\ubd88\ub7c9\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nV$CURRENT_BUCKET \u00a0 : \uce90\uc26c\ub0b4\uc758 \ubc84\ud37c\uc758 \uc218\uac00 \uac10\uc18c\ud560\ub54c \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294
\n\uce90\uc26c\uc190\uc2e4\uc758 \uacbd\uc6b0\uc218\ub97c \uc608\uc0c1\ud558\ub294\ub370 \uc720\uc6a9.
\nV$DATABASE \u00a0 \u00a0 \u00a0 \u00a0 : \u00a0\u00a0 control file \ub85c\ubd80\ud130 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc815\ubcf4\ub97c \ud3ec\ud568.
\nV$DATAFILE \u00a0\u00a0 : \ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130\ub370\uc774\ud0c0\ud30c\uc77c\uc5d0\ub300\ud55c \uc815\ubcf4\ub97c \ud3ec\ud568.
\nV$DATAFILE_COPY \u00a0\u00a0 :\ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130 \ub370\uc774\ud130\ud30c\uc77c\uc758 \ubcf5\uc0ac\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c\ud3ec\ud568.
\nV$DATAFILE_HEADER : \ub370\uc774\ud130\ud30c\uc77c\ud5e4\ub354\uc5d0 \ub300\ud55c \uc815\ubcf4.<\/p>\n
V$DBFILE : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uad6c\uc131\ud558\ub294 \ubaa8\ub4e0 \ub370\uc774\ud130\ud30c\uc77c.
\n\ub300\uc2e0\uc5d0 V$DATAFILE \ucd94\ucc9c\ud55c\ub2e4.
\nV$DBLINK : \uc138\uc158\uc5d0 \uc758\ud574 open\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub9c1\ud06c\uc5d0 \ub300\ud55c \uc124\uba85.
\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.<\/p>\n
V$DB_OBJECT_CACHE : library cache\uc5d0 cach\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc624\ube0c\uc81d\ud2b8\ub97c \ub098\ud0c0\ub0c4.
\nV$DB_PIPES \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub0b4\uc5d0 \ud604\uc7ac \uc6b4\uc601\uc911\uc778 pipe\uc5d0 \ub300\ud55c \uc124\uba85.
\nV$DELETED_OBJECT\u00a0 : \uc0ad\uc81c\ub41c archived \ub85c\uadf8, \ub370\uc774\ud130\ud30c\uc77c copy,
\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
\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,
\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.
\nV$DISPATCHER \u00a0 \u00a0 \u00a0 \u00a0 : dispatcher \ud504\ub85c\uc138\uc2a4\uc5d0 \uad00\ud55c \uc815\ubcf4.
\nV$DISPATCHER_RATE\u00a0 : dispatcher \ud504\ub85c\uc138\uc11c\uc5d0 \uad00\ub828\ub41c \ud655\ub960\ud1b5\uacc4.
\nV$DLM_CONVERT_LOCAL \u00a0 : lock \ubcc0\ud658\uc791\uc5c5\uc5d0 \ub300\ud55c \uacbd\uacfc\uc2dc\uac04.
\nV$DLM_CONVERT_REMOTE\u00a0 : \uc6d0\uaca9 lock\ubcc0\ud658\uc791\uc5c5\uc5d0 \ub300\ud55c \uacbd\uacfc\uc2dc\uac04.
\nV$DLM_LATCH \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : DLM \uc7a0\uae08\uc5d0 \ub300\ud55c \ud1b5\uacc4.
\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.
\n\uac1c\ub150\uc801\uc73c\ub85c IMM_GETS\/TTL_GETS \uac12\uc740 1\uc5d0 \uac00\uae5d\uac8c \ub41c\ub2e4.
\nV$DLM_LOCKS : \ubcd1\ub82c\uc11c\ubc84 view\uc774\ub2e4. \ube14\ub85d\ud654\ub418\uc5c8\uac70\ub098, \ub2e4\ub978 \uac83\uc744
\n\ube14\ub85d\ud654\ud558\uace0\uc788\ub294 lock manager\uc5d0 \uc54c\ub824\uc9c4 \ubaa8\ub4e0\u00a0 lock\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nV$DML_MISC \u00a0 \u00a0 \u00a0 \u00a0 : \uc7a1\ub2e4\ud55c DLM \ud1b5\uacc4\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nV$ENABLEDPRIVS:\uc0ac\uc6a9\uac00\ub2a5\ud55c \uad8c\ud55c\uc5d0 \ub300\ud55c\uc815\ubcf4, \uc774\ub4e4\uad8c\ud55c\uc740
\nSYS.SYSTEM_PRIVILEGES_MAP\ud14c\uc774\ube14\uc5d0 \uc874\uc7ac\ud574\uc57c\ub9cc \ud55c\ub2e4.
\nV$ENQUEUE_LOCK : \ud050\uc5d0 \ub300\uae30\uc0c1\ud0dc\uc778 \uc624\ube0c\uc81d\ud2b8\uc5d0\uc758\ud574 \uc18c\uc720\ub41c \ubaa8\ub4e0 lock\uc774
\nview\uc758 \uce7c\ub7fc\uc740 V$LOCK\uc758 \uce7c\ub7fc\uacfc \ub3d9\uc77c\ud558\ub2e4.
\n\uc790\uc138\ud55c \uac83\uc740 V$LOCK\uc744 \ucc38\uace0.
\nV$EVENT_NAME :\u00a0 wait event \uc5d0 \ub300\ud55c \uc815\ubcf4.
\nV$EXECUTION \u00a0 :\u00a0 \ubcd1\ub82c \uc9c8\uc758 \uc2e4\ud589\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nV$EXECUTION_LOCATION : \ubcd1\ub82c \uc9c8\uc758 \uc2e4\ud589 \ud2b8\ub9ac\uc758 \uc704\uce58\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \uc815\ubcf4.
\nV$FALSE_PING \u00a0 : \ubcd1\ub82c\uc11c\ubc84view. ping\uc5d0 \uc2e4\ud328\uc9c0\ub3c4 \ubaa8\ub974\ub294 \ubc84\ud37c\uc5d0 \ub300\ud55c \uc815\ubcf4.
\n\uc989, 10\ud68c\uc774\uc0c1ping\ub41c \ub2e4\ub978 \ubc84\ud37c\uc640
\n\ub3d9\uc77c\ud55c lock\uc73c\ub85c \uc7a0\uaca8\uc788\ub294 \ubc84\ud37c\ub97c \ub9d0\ud55c\ub2e4.
\nping\uc774 \uc2e4\ud328\ub85c \ud310\uba85\ub41c \ubc84\ud37c\ub294 lock\ucda9\ub3cc\uc744 \uac10\uc18c\uc2dc\ud0a4\uae30\uc704\ud574
\n1-44\ud398\uc774\uc9c0\uc758 “GC_FILES_TO_LOCK”\uc5d0 \ub2e4\uc2dc \ub9e4\ud551\ub41c\ub2e4.
\nV$FILE_PING\u00a0 : \ub370\uc774\ud130\ud30c\uc77c\ub9c8\ub2e4 ping\ub41c \ube14\ub85d\uc218\ub97c \ubcf4\uc5ec\uc90c. \uc774\uc815\ubcf4\ub294 \ud604\uc874\ud558\ub294
\n\ub370\uc774\ud130\ud30c\uc77c\uc5d0 \ub300\ud55c access\ud328\ud134\uc744 \uacb0\uc815\ud558\ub294\ub370 and,
\n\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.
\nV$FILESTAT \u00a0\u00a0 : \ud30c\uc77c read\/write \ud1b5\uacc4.
\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.
\n\uc2e4\uc81c\ud14c\uc774\ube14\uc744 \ucc38\uc870\ud558\ub294 \uc57d\uac04\uc758 V$\ud14c\uc774\ube14\uc740 \ub9ac\uc2a4\ud2b8\uc5d0 \uc5c6\ub2e4.
\nV$FIXED_VIEW_DEFINITION : (V$\ub85c \uc2dc\uc791\ud558\ub294)\uace0\uc815view\uc5d0 \ub300\ud55c \uc124\uba85.
\n\uc720\uc758\ud574\uc11c \uc0ac\uc6a9\ud574\uc57c\ud55c\ub2e4.
\nV$GLOBAL_TRANSACTION \u00a0\u00a0 : \ud604\uc7ac \ud65c\ub3d9\uc911\uc778 \ud2b8\ub79c\uc7ad\uc158\uc5d0 \ub300\ud55c \uc124\uba85.
\nV$INDEXED_FIXED_COLUMN : index\ub41c \ub3d9\uc801\uc2e4\ud589\ud14c\uc774\ube14(X$ table)\uc758 \uce7c\ub7fc\uc5d0
\n\ub300\ud55c \uc124\uba85.\u00a0 X$ table\uc740 \uacbd\uace0\uc5c6\uc774 \ubcc0\uacbd\ud560\uc218\uc788\ub2e4.
\n\uc774view\ub294 \ubcf4\ub2e4 \ud6a8\uacfc\uc801\uc73c\ub85c \uace0\uc815\ubdf0(V$view)\uc5d0 \ub300\ud55c
\nV$INSTANCE : \ud604\uc7ac\uc758 \uc778\uc2a4\ud134\uc2a4\uc758 \uc0c1\ud0dc\ub97c \ub098\ud0c0\ub0c4.
\nV$INSTANCE\uc758 \ubc84\uc804\uc740 V$INSTANCE\uc758 \ucd08\uae30\ubc84\uc804\uacfc \ud638\ud658\uc131\uc774 \uc5c6\ub2e4.
\nV$LATCH \u00a0 \u00a0 : \ud558\uc704 \uc7a0\uae08\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc640 \uc0c1\uc704 \uc7a0\uae08\uc5d0 \ub300\ud55c \uc694\uc57d\ud1b5\uacc4.
\n\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.
\nV$LATCHHOLDER : \ud604\uc7ac\uc7a0\uae08\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nV$LATCHNAME \u00a0 :\u00a0 V$LATCH \uc5d0 \uc788\ub294 \uc7a0\uae08\uc5d0 \ub300\ud55c \ub514\ucf54\ub4dc\ub41c \uc7a0\uae08\uc774\ub984\uc5d0 \ub300\ud55c
\n\uc815\ubcf4. V$LATCHNAME\uc758 \ud589\ub4e4\uc740 V$LATCH\uc758 \ud589\ub4e4\uacfc 1:1\ub85c \ub300\uc751\ub41c\ub2e4.<\/p>\n
V$LATCH_CHILDREN : \ud558\uc704\uc7a0\uae08\uc5d0 \ub300\ud55c \ud1b5\uacc4\ub97c \ud3ec\ud568.
\nV$LATCH\uc758 \uce7c\ub7fc\uc5d0 child#\u00a0 \uce7c\ub7fc\uc774\ucd94\uac00\ub418\uc5c8\ub2e4.\u00a0 LATCH#\uce7c\ub7fc\uc774 \uc11c\ub85c
\n\ub3d9\uc77c\ud558\ub2e4\uba74, \ud558\uc704\uc7a0\uae08\uc774 \ub3d9\uc77c\ud55c \uc0c1\uc704\uc7a0\uae08\uc744 \uac16\ub294 \uac83\uc774\ub2e4.
\nV$LATCH_MISSES\u00a0 : \uc7a0\uae08\uc744 \ud68d\ub4dd\ud558\ub294\ub370 \uc2e4\ud328\ud55c \uc2dc\ub3c4\uc5d0 \ub300\ud55c \ud1b5\uacc4.
\nV$LATCH_PARENT : \uc0c1\uc704\uc7a0\uae08\uc5d0 \ub300\ud55c \ud1b5\uacc4.
\nV$LATCH_PARENT \uce7c\ub7fc\uc740 V$LATCH\uce7c\ub7fc\uacfc \ub3d9\uc77c\ud558\ub2e4.
\nV$LIBRARYCACHE : library cache\uc758 \uc2e4\ud589\uacfc \ud65c\ub3d9\ud1b5\uacc4.
\nV$LICENSE \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : license \ud55c\uacc4\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nV$LOADCSTAT \u00a0 \u00a0\u00a0 : \uc9c1\uc811\uc801\uc7ac\ud558\ub294\ub3d9\uc548 \ucef4\ud30c\uc77c\ub41c SQL*loader \ud1b5\uacc4\uc815\ubcf4.
\n\uc774\ud14c\uc774\ube14\uc5d0\ub300\ud55c \uc5b4\ub5a4 Select \ubb38\ub3c4 “no rows returned” \uacb0\uacfc\uac00 \ub098\uc624\ub294\ub370,
\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.<\/p>\n
V$LOCK \u00a0 \u00a0 \u00a0 : \ud604\uc7ac Oracle \uc11c\ubc84\uc5d0 \uc758\ud574 \ud655\ub9bd\ub41c \uc7a0\uae08\uc5d0 \ub300\ud55c \uc815\ubcf4\ub098 lock\ub610\ub294
\nlatch\uc5d0 \ub300\ud55c \ub450\ub4dc\ub7ec\uc9c4\uc694\uccad
\nV$LOCK_ACTIVITY : \ubcd1\ub82c\uc11c\ubc84view\uc774\ub2e4. V$LOCK_ACTIVITY\ub294 \ud604\uc7ac\uc758
\n\uc778\uc2a4\ud134\uc2a4\uc758 DLM\uc7a0\uae08\ub3d9\uc791\uc744 \ub098\ud0c0\ub0b8\ub2e4.
\n\uac01\uac01\uc758 \ud589\uc740 \uc7a0\uae08\ub3d9\uc791\uc758 \ud0c0\uc785\uacfc \uc77c\uce58\ub41c\ub2e4.
\nV$LOCK_ELEMENT : \ubcd1\ub82c\uc11c\ubc84view\uc774\ub2e4. \ubc84\ud37c\uce90\uc26c\uc5d0 \uc758\ud574\uc0ac\uc6a9\ub41c \uac01\uac01\uc758
\nPCM\uc7a0\uae08\uc5d0 \ub300\ud574 v$LOCK_ELEMENT \uc5d0 \ud55c\ud589\uc774\ub2e4.
\n\uc7a0\uae08\uc694\uc18c\uc5d0 \ub300\uc751\ub418\ub294 PCM\uc7a0\uae08\uc758 \uc774\ub984\uc740 ‘BL’,indx,class\ub4f1\uc774\ub2e4.
\nV$LOCKED_OBJECT : \uc2dc\uc2a4\ud15c\uc548\uc758 \ubaa8\ub4e0 \ud2b8\ub79c\uc7ad\uc158\uc5d0 \uac78\ub9b0 \uc7a0\uae08\uc744 \ub098\ud0c0\ub0b8\ub2e4.
\nV$LOCKED_WITH_COLLISIONS : \ubcd1\ub82c\uc11c\ubc84view\uc774\ub2e4.
\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
\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.
\nV$LOG \u00a0 \u00a0 \u00a0 : \ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130 log \ud30c\uc77c\uc815\ubcf4\ub97c \ud3ec\ud568\ud55c\ub2e4.
\nV$LOGFILE\u00a0 :\u00a0 redo log \ud30c\uc77c\uc815\ubcf4. redo log \uadf8\ub8f9\uacfc \uba64\ubc84 \ud30c\uc77c\uba85.
\nV$LOGHIST\u00a0 : \ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130 log history\uc815\ubcf4\ub97c \ud3ec\ud568. \uc9c0\uc18d\uc801\uc778 \ud638\ud658\uc131\uc744
\n\ud3ec\ud568\ud558\uace0 \uc788\ub2e4. \ub300\uc2e0\uc5d0 V$LOG_HISTORY\uc758 \uc0ac\uc6a9\uc744 \uad8c\uc7a5\ud55c\ub2e4.
\nV$LOG_HISTORY \u00a0 \u00a0\u00a0 : \ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130 log history \uc815\ubcf4\ub97c \ud3ec\ud568\ud55c\ub2e4.
\nV$MLS_PARAMETERS : Oracle Server\uc758 \ud655\uc815\ub41c \ucd08\uae30\ud654\ud30c\ub77c\ubbf8\ud130\ub97c \ub098\ud0c0\ub0c4.
\nV$MTS \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : multi-threaded server\uc758 \uc131\ub2a5\ud5a5\uc0c1\uc744\uc704\ud55c \uc815\ubcf4\ub97c \ud3ec\ud568.
\nV$MYSTAT \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : \ud604\uc7ac \uc138\uc158\uc5d0 \ub300\ud55c \ud1b5\uacc4\uac12\ud3ec\ud568.
\nV$NLS_PARAMETERS \u00a0 : \ud604\uc7ac\uc758 NLS \ub9e4\uac1c\ubcc0\uc218\uc758 \uac12\ub4e4\uc744 \ud3ec\ud568.
\nV$NLS_VALID_VALUES\u00a0 : \uc720\ud6a8\ud55c NLS \ub9e4\uac1c\ubcc0\uc218\uac12.
\nV$OBJECT_DEPENDENCY : \ud604\uc7ac \uacf5\uc720\ud480\uc5d0 \uc801\uc7ac\ub418\uc5b4\uc788\ub294 package, procedure,
\ncursor\ub4f1\uc5d0 \uad00\ub828\ub418\uc5b4\uc788\ub294 object\ub97c \uacb0\uc815\ud558\ub294\ub370 \uc0ac\uc6a9\ub41c\ub2e4.
\n\uc608\ub97c\ub4e4\uba74, V$SESSION, V$SQL\ub4f1\uacfc \uc870\uc778\ud558\uba74, \ud604\uc7ac \uc5b4\ub5a4 user\uac00
\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.
\nV$OFFLINE_RANGE : \ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130 offline\ub41c datafile\uc744 \ubcf4\uc5ec\uc900\ub2e4.
\nDATAFILE\ud589\uc5d0 \uc800\uc7a5\ub418\uc5b4\uc788\ub294 \uac01\uac01\uc758 \ub370\uc774\ud130\ud30c\uc77c\uc758 \ucd5c\uc885offline \uac04\uaca9\uc744
\n\ubcf4\uc5ec\uc90c. offline \uac04\uaca9\uc740 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uac00 \ucc98\uc74c offline normal,
\n\ub610\ub294 Read Only\ub85c \ubcc0\uacbd\ub418\uace0\ub09c\uc774\ud6c4 \ub2e4\uc2dc online \ub610\ub294 read-write\ub85c
\n\ubcc0\uacbd\ub41c\ub2e4\uc74c\uc5d0 \ud655\uc815\ub41c\ub2e4.
\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
\nOFFLINE IMMEDIATE\ub85c \ubcc0\uacbd\ub418\uba74, offline\uac04\uaca9\uc740 \ud655\uc815\ub418\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n
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.
\nV$OPTION \u00a0 \u00a0 \u00a0\u00a0 : Oracle Server\uc640 \uac19\uc774 \uc124\uce58\ub41c \uc120\ud0dd\uc0ac\ud56d\ub4e4.
\nV$PARAMETER\u00a0 : \ucd08\uae30\ud654 \ud30c\ub77c\ubbf8\ud130\uc5d0 \ub300\ud55c \uc124\uba85\uc774\ub2e4.
\nV$PING \u00a0 \u00a0 : \ubcd1\ub82c\uc11c\ubc84view\uc774\ub2e4.
\n\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
\n\ub3d9\uc77c\ud558\ub2e4.\ud2b9\uc815 \ub370\uc774\ud130\ubca0\uc774\uc2a4 object\uc640 \uad00\ub828\ub41c \ud604\uc7ac\uc758 \uc778\uc2a4\ud134\uc2a4\ub0b4\uc758 SGA\uc5d0
\n\uc788\ub294 \uac01\uac01\uc758 \ube14\ub85d\uc5d0\ub300\ud55c block header\uc815\ubcf4\ub97c \ud3ec\ud568\ud558\uace0 \uc788\ub2e4.
\nV$PQ_SESSTAT\u00a0 : \ubcd1\ub82c\ucffc\ub9ac\uc5d0 \ub300\ud55c session \ud1b5\uacc4\ub97c \ud3ec\ud568.
\nV$PQ_SLAVE \u00a0\u00a0 : \uc778\uc2a4\ud134\uc2a4\ub0b4\uc5d0 \uc2e4\ud589\uc911\uc778 parallel \ucffc\ub9ac\uc11c\ubc84\uc5d0 \ub300\ud55c \ud1b5\uacc4.
\nV$PQ_SYSSTAT\u00a0 : \ubcd1\ub82c\ucffc\ub9ac\uc5d0 \ub300\ud55c \uc2dc\uc2a4\ud15c\ud1b5\uacc4.<\/p>\n
V$PQ_TQSTAT\u00a0 : \ubcd1\ub82c\ucffc\ub9ac \ub3d9\uc791\uc758 \ud1b5\uacc4\ub97c \ud3ec\ud568. \ud1b5\uacc4\ub294 \uc9c8\uc758\uac00 \uc644\ub8cc\ub41c\ud6c4\uc5d0
\n\ucef4\ud30c\uc77c\ub418\uba70 \uc138\uc158\uc774 \uc0b4\uc544\uc788\ub294\ub3d9\uc548\u00a0 \uacc4\uc18d \ub0a8\uc544\uc788\ub294\ub2e4.
\nV$PROCESS \u00a0\u00a0 : \ud604\uc7ac \uc791\uc5c5\uc911\uc778 \ud504\ub85c\uc138\uc2a4\uc5d0 \ub300\ud55c \uc815\ubcf4.
\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,
\nLATCHSPIN \uce7c\ub7fc\uc740 \ud504\ub85c\uc138\uc2a4\uc7a0\uae08\uc774 \ub3d9\uc791\ub418\ub294 \uac83\uc744 \ub098\ud0c0\ub0b8\ub2e4.
\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.
\nV$PWFILE_USERS\u00a0 :\u00a0 password \ud30c\uc77c\ub85c\ubd80\ud130 \uc720\ub3c4\ud574\ub0b8
\nSYSDBA, SYSOPER \uad8c\ud55c\uc744 \ubd80\uc5ec\ubc1b\uc740 user.
\nV$QUEUE\u00a0 :\u00a0 \uba40\ud2f0\uc4f0\ub808\ub4dc \uba54\uc2dc\uc9c0\ud050\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nV$RECENT_BUCKET\u00a0 :\u00a0 \ub300\uc6a9\ub7c9 \uce90\uc26c\uc2e4\ud589\uc744 \ud3c9\uac00\ud558\uae30\uc5d0 \uc720\uc6a9\ud55c \uc815\ubcf4.
\nV$RECOVER_FILE \u00a0 \u00a0 :\u00a0 media \ubcf5\uad6c\uc5d0\ud544\uc694\ud55c \ud30c\uc77c\uc758 \uc0c1\ud0dc\ub97c \ub098\ud0c0\ub0c4.
\nV$RECOVERY_FILE_STATUS : \uac01\uac01\uc758 RECOVER\uba85\ub839\uc5d0 \ub300\ud55c \uac01 \ub370\uc774\ud130\ud30c\uc77c\uc5d0
\n\ub300\ud55c \uc815\ubcf4\ub97c \ud55c\ud589\uc529 \ud3ec\ud568.
\nOracle\ud504\ub85c\uc138\uc2a4\uac00 \ubcf5\uad6c\ub97c \uc218\ud589\ud558\ub294\ub370 \uc720\uc6a9\ud55c \uc815\ubcf4\uc784.
\nrecover manager\ub294 \uc11c\ubc84\ud504\ub85c\uc138\uc2a4\uc5d0 \uc9c1\uc811 \ubcf5\uad6c\ub97c\uc218\ud589\ud558\ub3c4\ub85d \ud588\uc744 \ub54c,
\nrecovery manager\uac00 \uc774 view\uc5d0\uc11c \uad00\ub828\ub41c\uc815\ubcf4\ub97c \ucc38\uace0\ud560 \uc218 \uc788\ub2e4.
\n\ub2e4\ub978user\ub4e4\uc5d0\uac8c\ub294 \uc720\uc6a9\ud558\uc9c0 \uc54a\ub2e4.
\nV$RECOVERY_LOG : \uc644\ubcbd\ud55c media\ubcf5\uad6c\uc5d0 \ud544\uc694\ud55c archived logs\uc5d0 \uad00\ud55c \uc815\ubcf4.
\n\uc774\uc815\ubcf4\ub294 log history view\uc778 V$LOG_HISTORY\uc5d0\uc11c \uc720\ub3c4\ub41c \uac83\uc774\ub2e4.
\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
\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.
\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
\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
\n\uc218\ud589\ud558\ub77c\uace0 \uc9c0\uc2dc\ud560\ub54c\uc5d0, \ubcf5\uad6c\uad00\ub9ac\uc790\ub294 \uc774view\uc5d0\uc11c
\n\uad00\ub828\uc815\ubcf4\ub97c \ucc38\uc870\ud560 \uc218 \uc788\ub2e4. \ub2e4\ub978 user\uc5d0\uac8c\ub294 \ubd88\ud544\uc694\ud558\ub2e4.
\nV$REQDIST\u00a0 :\u00a0 MTS dispatcher\uc758 \uc751\ub2f5\uc2dc\uac04\uc5d0 \ub300\ud55c \uadf8\ub798\ud504\ud1b5\uacc4\ub97c \ub098\ud0c0\ub0b4\uba70,
\ntime range\ub294 \ubc84\ud0b7 number\uc758 \uc9c0\uc218\ud568\uc218\ub85c \uc99d\uac00\ud55c\ub2e4.
\nV$RESOURCE\u00a0 : \uc790\uc6d0(resource)\uc758 \uc774\ub984\uacfc \uc8fc\uc18c\uc815\ubcf4\ub97c \ud3ec\ud568.
\nV$RESOURCE_LIMIT : System \uc790\uc6d0\uc758 \ubd80\ubd84\uc801\uc778 \uc0ac\uc6a9\uc5d0 \ub300\ud55c \uc815\ubcf4. \uc790\uc6d0\uc758
\n\uc18c\ube44\ub97c \ubaa8\ub2c8\ud130\ub9c1\ud568\uc73c\ub85c\uc11c \ub0ad\ube44\ub97c \ubc29\uc9c0\ud558\ub294\ub370 \uc0ac\uc6a9\ub41c\ub2e4.<\/p>\n
V$ROLLNAME : \ubaa8\ub4e0 online\uc911\uc778 rollback segments\uc758 \uc774\ub984.
\n\ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 open\uc2dc\uc5d0\ub9cc \uc870\ud68c\uac00\ub2a5.
\nV$ROLLSTAT \u00a0 : \ub864\ubc31\uc138\uadf8\uba3c\ud2b8\ud1b5\uacc4\uc815\ubcf4.
\nV$ROWCACHE : \uc790\ub8cc\uc0ac\uc804\ud65c\ub3d9\uc5d0 \ub300\ud55c \ud1b5\uacc4.
\n\uac01\uac01\uc758 \ud589\uc740 \ud558\ub098\uc758 \uc790\ub8cc\uc0ac\uc804cache \ud1b5\uacc4\ub97c \ud3ec\ud568.
\nV$SESSION \u00a0 \u00a0 : \ud604\uc7ac open\ub41c \uc138\uc158\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nV$SESSION_CONNECT_INFO\u00a0 : \ud604\uc7ac\uc758 \uc138\uc158\uc5d0 \ub300\ud55c network \uc5f0\uacb0\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nV$SESSION_CURSOR_CACHE\u00a0 : \ud604\uc7ac\uc758 \uc138\uc158\uc5d0 \ub300\ud55c cursor \uc0ac\uc6a9\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nSESSION_CACHED_CURSORS \ucd08\uae30\ud654\ud30c\ub77c\ubbf8\ud130\uc5d0 \ub300\ud55c \ud6a8\uc728\uc744 \uce21\uc815\ud558\uc9c0\ub294
\n\uc54a\ub294\ub2e4.
\nV$SESSION_EVENT \u00a0\u00a0 : \uc138\uc158\uc758 event \ub300\uae30\uc5d0 \uad00\ud55c\uc815\ubcf4.
\nV$SESSION_LONGOPS : \uc7a5\uc2dc\uac04\uc2e4\ud589\ub418\ub294 \uc791\uc5c5\uc5d0 \ub300\ud55c \uc0c1\ud0dc. SOFAR,
\nTOTALWORK\uce7c\ub7fc\uc740 \uc9c4\ud589\uc0c1\ud0dc\ub97c \uc81c\uacf5\ud55c\ub2e4. \uc608\ub97c\ub4e4\uc5b4
\n\ub2e4\uc74c\uc694\uc18c(hach cluster creations, backup, recovery) \uc5d0 \ub300\ud55c
\n\uc791\ub3d9\uc0c1\ud0dc\ub97c \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\ub2e4.
\nV$SESSION_OBJECT_CACHE : \ub85c\uce7c\uc11c\ubc84\uc758 \ud604\uc7ac\uc0ac\uc6a9\uc911\uc778
\nuser\uc138\uc158\uc758 object, cache\ud1b5\uacc4\uc815\ubcf4.
\nV$SESSION_WAIT\u00a0 : \ud65c\ub3d9\uc911\uc778 \uc138\uc158\uc774 \ub300\uae30\ud558\uace0\uc788\ub294 \uc790\uc6d0\ub610\ub294 \uc774\ubca4\ud2b8\uc774\ub2e4.
\nV$SESSTAT \u00a0 \u00a0 \u00a0 \u00a0 : user\uc138\uc158 \ud1b5\uacc4\uc774\ub2e4. \ud1b5\uacc4number(statistic#)\uc5d0 \ud574\ub2f9\ud558\ub294
\n\ud1b5\uacc4name\uc744 \ucc3e\uc73c\ub824\uba74, V$STATNAME\ub97c \ucc38\uace0\ud558\uba74 \ub41c\ub2e4.
\nV$SESS_IO \u00a0 \u00a0 \u00a0 \u00a0 : \uac01\uac01\uc758 user\uc138\uc158\uc5d0 \ub300\ud55c I\/O \ud1b5\uacc4\uc774\ub2e4.
\nV$SGA \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : System Global Area \uc5d0\ub300\ud55c \uac04\ub7b5\ud55c \uc815\ubcf4.(name, size)
\nV$SGASTAT \u00a0 \u00a0 \u00a0 : System Global Area\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \uc815\ubcf4.(name, bytes, pool)<\/p>\n
V$SHARED_POOL_RESERVED : Shared Pool\ub0b4\uc5d0 \uc608\uc57d\ud480\uacfc \uacf5\uac04\uc744
\n\ubc14\uafb8\uace0\uc790\ud560 \ub54c \ub3c4\uc6c0\uc774 \ub418\ub294\ud1b5\uacc4.
\nV$SHARED_SERVER\u00a0 :\u00a0 Shared Server processes \uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \ud3ec\ud568.
\nV$SORT_SEGMENT \u00a0 : \uc8fc\uc5b4\uc9c4 \uc778\uc2a4\ud134\uc2a4\ub0b4\uc758 \uac01 sort\uc138\uadf8\uba3c\ud2b8\uc5d0 \ub300\ud55c \uc815\ubcf4.
\n\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uac00 Temporary \ud0c0\uc785\uc77c\ub54c\ub9cc update\ub41c\ub2e4.<\/p>\n
V$SORT_USAGE\u00a0 :\u00a0 sort \uc0ac\uc6a9\uc5d0 \ub300\ud574 \uae30\uc220\ud55c\ub2e4.
\nV$SQL\u00a0 :\u00a0 Group by\uc808\uc774\uc5c6\ub294 \uacf5\uc720sql\uc601\uc5ed\uc5d0\ub300\ud55c \ud1b5\uacc4\uc774\uba70 \uc785\ub825\ub41c
\n\uc6d0\ub798 sql\ubb38\uc7a5\uc758 \uac01 child\uc758 row\ub97c \ud3ec\ud568.
\nV$SQL_BIND_DATA : \ub370\uc774\ud130\uac00 \uc774 \uc11c\ubc84\uc5d0\uc11c \ucd94\ucd9c\uac00\ub2a5\ud558\ub2e4\uba74 \uc774 view\ub97c
\n\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
\n\ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0 \uc758\ud574 \ubcf4\ub0b4\uc9c4 \ub370\uc774\ud130.
\nV$SQL_BIND_METADATA : \uc774view\ub97c \uc870\ud68c\ud558\ub294 \uc138\uc158\uc5d0 \uc18c\uc720\ub41c \uac01\ucee4\uc11c\uc548\uc5d0 \uc788\ub294
\n\uac01\uac01\uc758 \uc6d0\uaca9bind\ubcc0\uc218\uc5d0 \ub300\ud574 \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uc758\ud574 \uc81c\uacf5\ub418\ub294 bind metadata.<\/p>\n
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><\/p>\n","protected":false},"excerpt":{"rendered":" \uc624\ub77c\ud074 DB\uc0ac\uc804 \uc815\ub9ac All_all_tables \u00a0 \u00a0\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 Table All_catalog \u00a0 \u00a0 \u00a0\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 Table, Views, synonyms, sequence All_clusters \u00a0 \u00a0 \u00a0\u00a0 : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 clusters All_col_comments : user\uac00 access\ud560\uc218\uc788\ub294 \ubaa8\ub4e0 Table,Views\uc5d0 \ub300\ud55c … Continue reading
\nV$SQL_SHARED_MEMORY : \uba54\ubaa8\ub9ac \uc2a4\ub0c5\uc0f7\uc5d0 \uacf5\uc720\ub41c \ucee4\uc11c\uc5d0 \ub300\ud55c \uc815\ubcf4.
\n\uacf5\uc720\ud480\uc5d0 \uc800\uc7a5\ub41c \uac01SQL\ubb38\uc740 \uad00\ub828\ub41c \ud558\ub098\ub610\ub294 \uadf8\uc774\uc0c1\uc758 \ud558\uc704object\ub97c
\n\uac00\uc9c0\uace0 \uc788\ub2e4.
\nV$SQLAREA : \uacf5\uc720SQL\uc601\uc5ed\uc5d0 \ub300\ud55c \ud1b5\uacc4\ub97c \uac00\uc9c0\uace0\uc788\uc73c\uba70, Sql \ubb38\uc790\uc5f4\ub9c8\ub2e4
\n\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
\nSQL\ubb38\uc7a5\uc5d0 \ub300\ud55c \ud1b5\uacc4\ub97c \uc81c\uacf5\ud55c\ub2e4.
\nV$SQLTEXT : SGA\ub0b4\ubd80\uc758 \uacf5\uc720SQL \ucee4\uc11c\uc5d0 \uc18d\ud574\uc788\ub294 SQL\ubb38\uc7a5\uc744 \ud3ec\ud568.
\nV$SQLTEXT_WITH_NEWLINES : \uac00\ub3c5\uc131\uc774 \uc99d\uac00\ub418\uace0, \uacf5\ubc31\uc744 \ud3ec\ud568\ud55c SQL\ubb38\uc7a5\uc548\uc5d0
\nnewline\uacfc tabs\uc744 \ub300\uccb4\ud558\uc9c0 \uc54a\ub294\ub2e4\ub294 \uac83\uc744 \uc81c\uc678\ud558\uace0\ub294 V$SQLTEXT view\uc640
\n\ub3d9\uc77c\ud558\ub2e4.
\nV$STATNAME : V$SESSTAT\uc640 V$SYSSTAT\ud14c\uc774\ube14\uc5d0\uc11c \ub098\ud0c0\ub09c statistics\uc5d0 \ub300\ud55c \uc774\ub984.
\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.
\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
\n\uac01 \uc801\uc7ac\ub41c \ud558\uc704 \uce90\uc26c\uc5d0 \ub300\ud574 \ud55c\ud589\uc744 \ub098\ud0c0\ub0b8\ub2e4.
\nV$SYSSTAT : \uc2dc\uc2a4\ud15c \ud1b5\uacc4\uc774\ub2e4. \uac01 statistic number(statistic#)\uc640 \uad00\ub828\ub41c statistic\uc758
\n\uc774\ub984\uc744 \ucc3e\uae30\uc704\ud574\uc11c\ub294,\u00a0 “V$STATNAME”\ub97c \ubcf4\uc2dc\uc624.
\nV$SYSTEM_CURSOR_CACHE : \uc2dc\uc2a4\ud15c\u00a0 \uc804\ubc18\uc801\uc778\uc815\ubcf4\ub77c\ub294 \uac83\uc744 \uc81c\uc678\ud558\uace0,
\nV$SESSION_CURSOR_CACHE\uc640 \uc720\uc0ac\ud55c \uc815\ubcf4\ub97c \ub098\ud0c0\ub0b8\ub2e4.
\nV$SYSTEM_EVENT : \uc774\ubca4\ud2b8\uc5d0 \ub300\ud55c \ucd1d wait\uc815\ubcf4. TIME_WAITED,
\nAVERAGE_WAIT\uce7c\ub7fc\uc740 \uae09\uc18d\uba54\ucee4\ub2c8\uc998\uc744 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294 \ud50c\ub7ab\ud3fc\uc5d0\uc11c
\n0\uac12\uc744 \ud3ec\ud568\ud560 \uac83\uc774\ub2e4. \uc774\ub7f0 \ud50c\ub7ab\ud3fc\uc5d0\uc11c DB\ub97c \uc6b4\uc601\uc911\uc774\uace0,
\n\uc774\uce7c\ub7fc\uc774 wait time\uc744 \uc904\uc5ec\uc8fc\uae30\ub97c \uc6d0\ud55c\ub2e4\uba74, \ud30c\ub77c\ubbf8\ud130\ud30c\uc77c\uc758
\nTIMED_STATISTICS\ub97c TRUE\ub85c \uc138\ud305\ud558\uba74\ub41c\ub2e4.
\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.
\nV$SYSTEM_PARAMETER\u00a0 :\u00a0 System parameter\uc5d0 \ub300\ud55c \uc815\ubcf4.
\nV$TABLESPACE \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : \ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc815\ubcf4\ub97c \ub098\ud0c0\ub0b4\uc900\ub2e4.
\nV$THREAD \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 : \ucee8\ud2b8\ub864\ud30c\uc77c\ub85c\ubd80\ud130 thread \uc815\ubcf4\ub97c \uac00\uc838\uc628\ub2e4.
\nV$TIMER \u00a0 \u00a0 : \u00a0\u00a0 1\/100 \ucd08\ub85c \ub098\ud0c0\ub0b8 \uacbd\uacfc\uc2dc\uac04. \uc2dc\uac04\uc740 epoch\uac00 \uc2dc\uc791\ub41c\uc774\ud6c4\ubd80\ud130
\n\uce21\uc815\ub418\uba70, epoch\ub294 OS\uc758 \ud2b9\uc131\uc774\uba70, \uac12\uc774 4bytes(\uc57d 497\uc77c)\ub97c \ub118\uc744\ub54c\ub9c8\ub2e4
\n0\uadfc\ucc98\uc758 \uac12\uc774 \ub41c\ub2e4.
\nV$TRANSACTION\u00a0 :\u00a0 \uc2dc\uc2a4\ud15c\ub0b4\uc758 \ud65c\ub3d9\uc911\uc778 \ud2b8\ub79c\uc7ad\uc158.
\nV$TRANSACTION_ENQUEUE : \ud2b8\ub79c\uc7ad\uc158 \uc624\ube0c\uc81d\ud2b8\uc5d0 \uc758\ud574 \uc18c\uc720\ub41c lock\ub97c \ub098\ud0c0\ub0c4.
\nV$TYPE_SIZE : \ub370\uc774\ud130\ube14\ub85d\uc6a9\ub7c9\uc744 \uce21\uc815\ud558\ub294\ub370 \uc0ac\uc6a9\ub418\ub294 \uc5ec\ub7ec
\n\ub370\uc774\ud130\ubca0\uc774\uc2a4\ucef4\ud3ec\ub10c\ud2b8\ub4e4\uc758 SiZe.
\nV$VERSION\u00a0 :\u00a0 Oracle Server\uc758 core \ub77c\uc774\ube0c\ub7ec\ub9ac \ucef4\ud3ec\ub10c\ud2b8\uc758 Version\uc218\uc774\ub2e4.
\n\uac01 \ucef4\ud3ec\ub10c\ud2b8\uc5d0 \ud55c row\uac00 \uc788\ub2e4.
\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.<\/p>\n