


      D       INIT.ORA

     ⮬  ਫ  ᮤন  ⠫쭮 ᠭ ࠬ஢  
.   ࠬ 室    䠩  INIT.ORA.   䠩   
㯥      .

    砭: ᬮ  ,    㪮⢮  뫠
 䠩  ࠬ஢ INIT.ORA,   ⢨⥫쭮  ⮣ 䠩
  ᨬ    樮  ⥬.(  ਬ,
ᨬ      ॣ  ᬥ蠭,   
᪮   ਠ樨   INIT.ORA).    
 ,    ⠪  㣮  䠩 ( ⥬ 
ᮤঠ  ଠ⮬).     㪮⢥ ਭ-
  䠩 INIT.ORA    ࠬ 䠩 INIT.ORA.

     ⠪,    ⮯ ( RDBMS -
  䠩  ६ ) 뢠  "㪮⢥ -
⥫  ⠫樨"  襩 樮 ⥬.

    饥 ᠭ   ਬ 䠩 ࠬ஢ INIT.ORA ᮤঠ
  14.  ਬ 䠩 INIT.ORA ⠢  ਡ⨢
⥫    樮 ⥬;   ਬ  
砩 筮 .

DBA   ᯮ짮  ࠬ  䠩  INIT.ORA  ⮣, ⮡:
    * ⨬஢ ந⥫쭮 ⥬  ன 
       (ਬ - 㢥 ᫮ ஢   )
    * ⠭  ⥬ 㬮砭 (ਬ -
      ᪮쪮     ࢮ砫쭮  ।  
      ⥪   ᮧ)
    * ᯥ஢  䠩.

     ࠬ     "⮭ ஥"  襭 ந
⥫쭮  .  ࠬ    
          㤭 Oracle Corporation.

        ஢ ࠬ஢  䠩 INIT.ORA

    INIT.ORA -  ⪨ ⥪⮢ 䠩, ᮤঠ騩 ᯨ᮪ -
ࠬ஢   祭ﬨ  ࠬ஢, ਬ:
    SAVEPOINTS = 5
    PROCESSES = 100

஢ ࠬ஢  䠩 INIT.ORA 稭 ᫥騬 ࠢ:
    *  ࠬ 易⥫.
    *  INIT.ORA  ᮤঠ ⮫쪮 ࠬ   ਨ.
    * ᫨ ࠬ  祭  䠩 INIT.ORA, 㤥 ᯮ짮 
      㬠稢 祭.
    * ࠬ  㪠뢠   浪.
    *  (孨  )  祭 (  䠩), ᫨ 
 祭  樮  ⥬,    ࠢ ன ࠡ⠥
ORACLE.  ᫨  室 ⥫쭠 ଠ,   ᢮
"㪮 짮⥫  ⠫樨".
    *   ᪮쪨 ࠬ஢   ப  ᯮ ஡
       ⢥ ࠧ⥫, ਬ:

    PROCESSES = 100 SAVEPOINTS = 5 OPEN_CURSORS = 10


                                    -- 1 --



    *   ࠬ஢ (ਬ -  䠩) ᪮쪮 祭
        १ , 稢   㣫 ᪮:

    INIT_SQL_FILES = (SQL.BSQ, CATALOG.SQL, ENROLL_USERS.SQL)

    *  ᫥ (\) ᯮ    樨  த
      ࠬ  ᫥饩 ப.
    * 祢 ᫮ IFILE  ᯮ짮  㪠  䠩
       ଠ,  筮 INIT.ORA. ⨬   ஢ .
      祭 ᫥ 㪠 ࠬ ४뢠 ।騥.
    *   (#) ᯮ  㪠  ;
      ⠢  ப  ⮬ 砥 .

      祭 ࠬ । 䠩 INIT.ORA  
  ⠭ .  ।   㤥
ᯮ짮  祭  ஢ 䠩 INIT.ORA.

  ᬮ ⥪ 祭 ࠬ஢

⮡ ᬮ ⥪騥 祭  ࠬ஢, ᯮ  ⨫
SQL*DBA:

    SQLDBA> SHOW PARAMETERS

     ⮩     뤠  䠢⭮ 浪  ࠬ  
 ⥪騬 祭ﬨ.  ᫨     ⠪ ப:

    SQLDBA> SHOW PARAMETERS BLOCK

        뤠  ࠬ,  騥    ᥡ  ப "BLOCK". ᫨
 뤠  ࠬ,  ᯮ짮  SPOOL  
࠭  䠩.

    ஬ ⮣,        䠩 INIT.ORA 祢 ᫮ LIST.  ⮬
砥      ࠭    뤠 ⥪騥 祭 
ࠬ஢.

  㯯 ࠬ஢

ࠬ 䠩  INIT.ORA   㯯஢ ࠧ묨 ᯮᮡ,
ਬ:
    * ࠬ, ⠭騥 ⥬ ࠭祭
    * ࠬ, ⠭騥 ࠭祭  ᮢ
    *  䠩  ⠫, 室  ⥬  
    * ࠬ, ⠭騥 ࠭祭    
    * ࠬ,  騥  ந⥫쭮 (  뢠 "६묨
      ࠬࠬ").

    ⭥ ᥣ,      㣨 
ᮢ  ࠬ,  㢥稢騥  ந⥫쭮  .

  ࠬ       ᯮ.    ⭮:
*   ࠬ,       , ஬  
  ᯥ樠  Oracle Corporation    楫 ࠧ襭 
  ஡.
* ᨬ ࠬ    ⠪    祭 ⮬᪨
 ⥬ ORACLE.


                                    -- 2 --



          ६ ࠬ

      ࠬ஢ 䠩 INIT.ORA ६ ࠬ ।-
⠢  稬묨  襭 ந⥫쭮. -
 ६  ࠬ  ⠭  ࠭祭    "-
" ⥬.  ਬ  -  ᫨ ࠬ PROCESSES ⠭ 
10,    짮⥫      ᬮ.

     ६  ࠬ       ந-
⥫쭮,    ।⠢  ᮫⭮  ;  ਬ  -
襥 祭  DB_BLOCK_BUFFERS  筮 㢥稢 ந-
⥫쭮,  襥 祭  ४頥 ࠡ,     -
 .

    祭   ६  ࠬ஢   
ந⥫쭮 ⥬,   ⠪  㢥 ࠧ SGA. -
祭 SGA  蠥  ந⥫쭮  ⮫쪮  ।
窨.  㠫 樮 ⥬  ᫨誮    SGA
㤥 ᭨ ந⥫쭮 - ࠭筮 . -
⥫쭮,  ࠬ஢ 樮  ⥬  ࠢ
㠫쭮   ,     SGA.

     묨   窨 ७ ன ந⥫쭮
 ࠬ DB_BLOCK_BUFFERS  LOG_BUFFER. ஥ -
ﭨ   ந⥫쭮  ⠪  ࠬ  ᫮.

          ࠬ  ᫮

    ࠬ   ᫮     䨪   "DC".   (ਬ-
DC_TABLES).   ࠬ  易   ६ প  
SGA ⮢ ⠡ ᫮ .   ন 
   祭 ⪮ ६  ᯮ짮 ᫮  -
䨪樨  ࠧ SQL - ஢.  ᫥ ⮣   
,    ॡ  㣨 ⮢.

    ࠬ ⠭  ᨬ쭮  ⢮  ⮢,
  ਭ   SGA.  ࠧ,  -
 ⠭ १묨  .   ⠭ -
ᨬ ॢ襭,     ᯮ㥬  
  (  㯥,  室  ᪥).

    ਬ, ᫨  䠩 INIT.ORA ࠬ DC_TABLES ⠭
 10,  SGA  ࠭   । ⠡.  ⮫쪮
ந室 饭  ⮩ ⠡,   ஥ -
। ⠡   । ⮩ ⠡.

     ࠬ  ࠧ   ந⥫쭮.
  易⥫쭮  筮 ⮢   -
 ࠡ 짮⥫, ࠧ    -
  饭 ࠡ ⮢ ꥪ⮢,  饭  
ந室  ,  ⠪, ⮡    -
.  ࠧ  㢥稢 ᪮ ࠧ SQL- ஢.

           ࠬ .

    ࠬ  䨪ᮬ "GC" ᯮ  ᭮    -
⥬, ࠧ  ᪨.  ਬ  ⠪ ࠬ - GC_SEGMENTS.
䨪 "GC" (Global Cache) 砥  .  ࠬ-

                                    -- 3 --



 ।  ࠧ 쭮  ஢,  
     ஢  ORACLE.  ࠭  
祭    ᯮ짮 । ᮢ -
樮 ⥬; ⥫ ଠ  ⮬  -
    ᮮ⢥饬 "㪮⢥ 짮⥫  ⠫樨".

          ⥬ᨬ ࠬ

    祭         ࠬ஢  
樮 ⥬;    ᫥  ⠡    ⬥祭  
⮫ 㬠稢 祭  "⥬ᨬ". ਬ, -
ࠬ DB_BLOCK_BUFFERS 㪠뢠 ⢮ ஢   
⨢ ,   ࠧ  ஢ - ⥬ᨬ.
  "㪮 짮⥫  ⠫樨"    襩
樮 ⥬  ⥫쭮 ଠ樥  ⥬-
ᨬ ࠬ 䠩 INIT.ORA.

          ᨬ ࠬ

     ࠬ  ⬥祭  "ᨬ".   砥,
    㣨 ࠬ஢. ᨬ ࠬ  -
 㬮砭, ஬ , ந  㬠稢 祭
㣨 ࠬ஢. 筮     祭  -
஢,   ᫨  ᤥ ,   ४஥ ⠭
 㬮砭 祭.

           ࠬ ⠭ ࠢ쭮

     ࠬ     祭,  㬥襭
  ਢ  ⮬,    ;  -
 ࠬ஢ -  ,  㤥 ࠡ .

    ᫨  ⠭ 祭 ண ࠬ ᫨誮 -
  ॢᨫ ᨬ ண ,    ᮮ-
饥 ᮮ饭.

     ᥣ   ᫥   讣     ⥬  
ॡ㥬 ⢨ (᫨  祭 ).  ᫨  ᮮ饭 -
ਮ᪨ ,  室 ⠭ , -
 ᮮ⢥騩 ࠬ  ⮢ .

                ᠭ ⤥ ࠬ஢

    ᠭ ⤥ ࠬ஢ 䠩 INIT.ORA ਢ  -
䠢⭮ 浪.  ⠡쭮  ⮬ 㪮⢥  ਫ-
 ࠬ  ਢ   ᨬ 孥 ॣ.   "㪮-
⢥ 짮⥫    ⠫樨"   뢠,      
樮 ⥬  ਭ    ࠬ஢    䠩.

    設⢮ ࠬ஢  䠩 INIT.ORA   ⥬
祭; 砨,    ⭮  짮⥫, 뤥
ᯥ樠쭮.  ਬ  祭 ࠬ஢  ⭮  
⥬ VAX/VMS.

              砭         ?   祭

#              ᯮ  祭 ਥ
\              ᯮ   祭 ⮣,   ᫥

                                    -- 4 --



               ப 㤥 த 
LIST           ᫨ , ⥪騥 祭 ࠬ஢ -
                 ࠭    ⥬.
AUDIT_TRAIL    false                          false/true
               蠥  頥   ୠ  ॣ-
               樨 㯠.   ⪫祭, ᫨ ࠬ
               ⠭  FALSE    .  
               祭, ᫨ 祭 ࠬ TRUE. SQL - -
                AUDIT  ᯮ짮 ᨬ  -
               祭 ⮣ ࠬ.   ஡ ଠ
                ॣ樮  ஫    ௭  
                17  18.

BACKGROUND_DUMP_DEST
               ⥬ᨬ                 祭 쭮
                                                , ⠫  
               ⮭宦 (⠫,  , 䠩), 㤠 㤥
               뢠 ⫠筠  ࠡ 䮭 -
               ᮢ (LGWR, DBWR, DBRD, ARCH, SMON, PMON)  -
                ࠡ ⥬ ORACLE.  ⭮  ⮫쪮  
               짮⥫᪨ ⥬.

CALLS          51                
               ⢮ ४ᨢ ⥬ 맮.  -
               ⨢ 祭 筮    .

CLEANUP_ROLLBACK_ENTRIES
               20 ⮢      
               ⢮ ⮢ ⪠  믮 -
                ⪨  ⪥ ࠭樨.    ଠ쭮
               ०  ॡ 䨪樨.

CONTEXT_AREA   4096 ⮢                    1024-131072
               砫 ࠧ   ⥪,    ன
               ࠧ   㪠.  ᨬ쭮 祭 
               ஢   ⥬  ⥬.

CONTEXT_INCR   4096 ⮢                    1024-32768
               ⢮ ⮢,    㤥 㢥稢
                ⥪  ࠧ,      
               ௠. ᨬ쭮  祭    -
                 ᨬ    ⭮  樮
               ⥬.  ⥪ ᠭ   8.

CONTROL_FILES  ⥬ᨬ                 1-8
                   ࠢ 䠩,  ࠧ-
                묨.  Oracle  Corporation ४ -
               짮 ᪮쪨 䠩    ࠧ  -
               ன⢠. ࠢ騥 䠩 뢠   3.

CPU_COUNT      0                 
               ⢮ ஢   . 
               ᫮    樮 ⥬  -
               ⮬᪨ .    -
               ⥬ ᯮ 祭 0.




                                    -- 5 --



DB_BLOCK BUFFERS
               32                       4-65535
               ⢮  , 㥬   SGA
               (  ⥭  ).  -
                 ᨫ쭮 । ࠧ  SGA
                ந⥫쭮    .   २⢮
               讣 祭  ⮣  ࠬ  砥 
               ᫥饬: ᫨ 짮⥫ 室    
                ६  室  ᭮ ,  ᭨
               /뢮.     ࠢ  祭
               ࠬ DB_BLOCK_SIZE.

DB_BLOCK_CACHE_PROTECT
               false             
                ⫠筮 ०,   ஬   -
                饭.   ࠬ    
               ᪫祭 㪠 㤭 Oracle Corporation.

DB_BLOCK_HASH_BUCKETS
               ᨬ                     1-65521
                -⠡,  ᯮ㥬    宦
               ஢  ୮ 㫥.    ᭮
               DB_BLOCK_BUFFERS. 䨪樨  ॡ. ᫨ -
               ⠭,     ᫮  ࠢ 2.

                33 %                          1 % - 100 %
                砭:   ࠬ  ५      ᨨ
               6.0.27  .
               業 ,   㤥 "" (᢮-
                ஢)     室  ᮬ
               DBWR    짮⥫ ( -
               ,    砫쭮 室 DBWR).
               襥 祭 ਢ  ⪥ 襣 -
               ⢠ ஢      । 믮 ⮩
               樨 (  室 頥 襥 -
               ⢮ ஢).    ॡ  
               室,  㢥稢     -
               ஢,   ॡ  襬 -
               饬.  祭 室 㢥稢  -
               䨪樨 讣   ⢠   .  ᫨  
               祭 ᫨誮 ,  १୮ 㢥稢
               /뢮. 祭  ⮣ ࠬ ਢ 
               ᭨ ⨪ free  buffer  waits  (
               ᢮ ஢)   free needed (室 ᢮-
               ).
               襭 祭  ⮣  ࠬ  ਢ  
               ⪥ 襣 ⢠  ஢  १  
               ⪨ ࢠ ६  㬥蠥 ⭮
                  筮  ஢.
                    DB_BLOCK_MAX_CLEAN_PCT  祬
               DB_BLOCK_MAX_MOD_PCT;  ⮬ 砥  짮⥫-
               ᪨   㤥    ६  ।
               ⮣,   ,  ᫥ 㦥 -
                 DBWR   㤥   .

DB_BLOCK_MAX_MOD_PCT
               30 %                           1 % - 100 %
                砭:   ࠬ  ५      ᨨ

                                    -- 6 --



               6.0.27  .
               業   ஢    ஬ -
               室     ஢    ,  ⮡
                    ᯮ짮  㣨 짮-
               ⥫᪨ ᠬ.  ᫨  ᪥  ᢮
                  짮⥫ ।,   
               業 ( ) ஢  ஢,  
               ᮮ頥   ⮬  DBWR  砫  ஢.
                祭    DB_BLOCK_MAX_CLEAN_PCT
               祭 祭 ⮣ ࠬ ਢ  -
                । 饭 DBWR,     ᯨ᪥ LRU
               ॡ    ୮  ६,  
               ⠪  ⭮,     ०-
                ९ᠭ. 祭 ⮣ 祭 ਢ-
                 㢥祭 ⨪ free buffers inspected
               (ᬮ७ ᢮ ஢)  ᭨  - DBWR
               buffers scanned  (᪠஢ ஢ ᮬ
               DBWR).
               訥 祭 ਢ   ⮬ -
                DBWR,   㬥   ᯨ᪥ LRU. ஬
               ⮣,   ⮬  㬥蠥 ⥫ ⨪
               free buffers inspected (ᬮ७ ᢮  - ஢).

DB_BLOCK_MAX_SCAN_PCT
               35 %                           1 % - 100 %
               砭:   ࠬ  ५      ᨨ
               6.0.27  .
               ᨬ 業  ,    짮⥫
               ᪠  ᪠ ᢮  .  ଠ쭮
                祭        ,  祬  ࠬ
               DB_BLOCK_MAX_MOD_PCT.
                 ࠬ,  ᫨    -
                 筮 .  ᫨    ᤥ
                ᫨誮 訬,  짮⥫᪨  -
                ஢ DBWR.
                 祭, ᫨ ⥫ ⨪
               free buffers inspected (ᬮ७ ᢮  -
               ஢) ᫨誮  .  ᫨   祭 ᫨誮
               ,  㤥   .

DB_BLOCK_MULTIPLE_HASHCHAIN_LATCHES
               true                          false/true
               ᫨ ࠬ ⠭   TRUE,    -楯
               ᯮ   饫;  ᫨  祭 ࠬ
               - FALSE,   饫 ᯮ   .

DB_BLOCK_SIZE  ⥬ᨬ               512-8096
                                                ⥬ᨬ
                      ORACLE. 筮
                祭 2048  4096. 祭 DB_BLOCK_SIZE
                  ࠡ  CREATE DATABASE -
                ࠧ ;  ⠫쭮 ६  -
               ࠬ    ⠭    祭. 
               㦤 롮 ࠧ  ਢ  
               3,   㬠稢 祭  襩 樮
               ⥬    "㪮⢥ 짮⥫  ⠫樨".



                                    -- 7 --



DB_BLOCK_TIMEOUT_WRITE_PCT
               20 %                           0 % - 100 %
               砭:   ࠬ  ५      ᨨ
               6.0.27  .
                ⮫쪮 DBWR 頥  ⠩,   頥
               ਬ୮ ⠪ 業  (ᨬ    ⮣,
               㤮⢮७                        ᫮
               DB_BLOCK_MAX_CLN_PCT).
               ᮪ 祭  ਢ    ன 
               ஢, ᫨ ⥬  㦥, , , 
                ன  롮થ ,    蠥 蠭
                 ࠭ 室.
               襭 祭 ⮣ ࠬ ਢ  -
                   ⥫쭮,  ᯮ짮-
                ⥬ ᮢ   ஢-
                (ࠦ  १   ६   ॠ樨).   
               祭   ਥ  ⠪   砥,  
               設⢮ ࠭権  ,    -
                .
                  ਥ  祭    
               ।⢮ ⠩.

DB_BLOCK_WRITE_BATCH
               8                        1-128 
               ᯮ  筮 /뢮; -
               ⢮ , । DBWR 樮 -
               ⥬  .
               訥 祭       樮
               ⥬ ࠫ쭮    ࠧ -
               ன⢠, ᯮ २⢠ ⬮ -
                ᪮  ࠡ   ᪠    -
               ᥤ           /뢮.
                     , -
                  饭 , ᫥⥫쭮, 㢥稢-
                蠭 짮⥫  砭  -
                  䨪樨  .    ࠬ  
               㢥稢,     襭 -
               ⨪ write complete waits ( 襭 -
               )  write wait time (६  ).
               ᫨ 樮 ⥬ ন ⮫쪮 
                     ,  祭 ⮣
               ࠬ   室    ।  2-8  (
               楫 ன      ⨨  ⨨
               饫  㣨  室).

DB_FILE_MULTIBLOCK_READ_COUNT
               ⥬ᨬ               ⥬ᨬ

               ᯮ   ⨡筮 /뢮;  
               ᨬ쭮 ⢮ ⠭   -
                /뢮    ६  ᫥⥫쭮
               ᪠஢.   㬮砭 -  㭪  -
               ஢ DB_BLOCK_BUFFERS  PROCESSES.  㬭 -
               祭  4  16   -  32; ॠ쭮 祭
                 樮 ⥬:  VMS ࠭稢
                65  ⠬  31 媨⮢  
                ⥭.


                                    -- 8 --



DB_FILE_SIMULTANEOUS_WRITES
               4                              24
               ⢮ ६ ᥩ  ("⮢")  
                䠩   ࠡ DBWR.
               ᫨ 樮 ⥬ ন ⮫쪮 
                  ன⢮    ᮢ
                ᥤ ,   祭   
               1.  ᫨   ⥬  訩 "騩 -
               " /  ணࠬ,    㢥
                   祭.  祭  5 筮
                 ਭ.
                 DBWR  㯯  DB_BLOCK_WRITE_BATCH
               , ᯮ ᯮ짮 祭   祬
               DB_BLOCK_WRITE_BATCH.

DB_FILES       32 䠩                       1-MAXDATAFILES
               ᨬ쭮 ⢮ 䠩,   -
                        ࠡ.  
               㬥, ᫨  ॡ    SGA
                  ᠬ  襥 ⢮ 䠩.
               쭮 㢥稢  祭  ⠭ 
               ⮢  .  訥 祭  ᫥
               㢥稢 ࠧ ࠢ 䠩.
               ࠬ DB_FILES  㬥 MAXDATAFILES 
                CREATE  DATABASE ᯮ  㪠-
                ᮫⭮ ᫠ 䠩     ᮧ
                .

DB_HANDLES     ᨬ         
               ᨬ쭮 ⢮ ஢,    -
               ६    짮⥫᪨ .
               뢠  ⭮ 祭 ࠬ-
                PROCESSES.

DB_HANDLES_CACHED
               2                 
               ⢮ ஢, ࠡ뢠 ᮬ -
               ⥫.

DB_NAME        null              
               䨪    ࠧ஬  8 ᨬ.
                 ⮣ ࠬ  易⥫쭮, ४-
                  ⠭  뤠  CREATE
               DATABASE.  ᫨  ᯮ,     ᮮ-
               ⢮        CREATE
               DATABASE.  ᫨  - ,     -
                     ப  STARTUP,   ALTER
               DATABASE MOUNT.

DC_COLUMN_GRANTS
               50                             1 -  ࠭祭
               ⢮ ⮢    ਢ  ⮫殢.
               蠥       ⮫,  ᯮ騩
               ਢ (   ਢ).

DC_COLUMNS     300                           150-  ࠭祭
               ⢮ ⮢      ᠭ  ⮫殢.
               祭   ࠩ  - ࠢ -

                                    -- 9 --



               쭮    ⮫殢     ⤥쭮
               ⠡  .   襭 ந⥫-
                  ᯥ ⮫  ࠫ-
                ࠡ 짮⥫.

DC_CONSTRAINT_DEFS
               200                             ࠭祭
               ⢮ ⮢   ।  ࠭-
                楫⭮.

DC_CONSTRAINTS 150                             ࠭祭
               ⢮ ⮢   ࠭祭 楫⭮.

DC_FILES       25                             1- ࠭祭
               ⢮ ⮢   ᠭ  䠩. 
                    䠩  ᯮ㥬 ⠡筮 ࠭⢠.

DC_FREE_EXTENTS
               50                             5- ࠭祭
               ⢮ ⮢   ᠭ ᢮ -
               ⥭⮢ (    ᮤঠ  । ⤥
               ⥭⮢ ᢮ ,  ᨬ   ࠧ஢).

DC_INDEXES     50                             20- ࠭祭
               ⢮ ⮢   ᠭ ᮢ.

DC_OBJECT_IDS  50                             1- ࠭祭
               ⢮ ⮢     ᠭ ꥪ⮢ (
                ᮤঠ ᠭ ꥪ⮢ ,  ⠪  
               ⠡, ,   ,  ᫥⥫쭮,
               ᨭ  ).  祭 ⮣ ࠬ -
                  ந⥫쭮  ⠯ ࠧ -
               ஢.     १⮢     祭
                 ࠢ   ꥪ⮢ 짮-
               ⥫     ६.

DC_ROLLBACK_SEGMENTS
               25                             2- ࠭祭
               ⢮ ⮢   ᠭ ᥣ⮢ ⪠.

DC_SEGMENTS    50                             50- ࠭祭
               ⢮ ⮢     ᠭ  ᥣ⮢.
               室        -
               㥬    ⠡,  ,  -
                 ᥣ ⪠.

DC_SEQUENCE_GRANTS
               20                             2- ࠭祭
               ⢮ ਢ  ᫥⥫쭮⥩,  -
                 ஢.

DC_SEQUENCE    20                             2- ࠭祭
               ⢮ ⮢                 ᠭ
               ᫥⥫쭮⥩.

DC_SYNONYMS    50                             2- ࠭祭
               ⢮ ⮢   ᠭ ᨭ.


                                    -- 10 --



DC_TABLE_GRANTS
               50                             2- ࠭祭
               ⢮ ⮢      ਢ  ⠡.
               ॡ ⮫쪮      ⠡楩
                ਢﬨ (    ਢ).

DC_TABLES      100                            30- ࠭祭
               ⢮ ⮢   ᠭ  ⠡/-
               ஢/஢.

DC_TABLESPACE_QUOTAS
               25                             1- ࠭祭
               ⢮ ⮢    ᠭ  ⠡-
                ࠭,   ஬ ᮤঠ    -
                짮⥫    ⠡ ࠭.
               ᫨ 10 짮⥫ ६ ᮧ ⠡
                  ⠡  ࠭⢠,  ॡ  20 ⮢.

DC_TABLESPACES
               25                             2- ࠭祭
               ⢮ ⮢      ᠭ  ⠡ ࠭.

DC_USED_EXTENTS
               50                             50- ࠭祭
               ⢮ ⮢    ᠭ ᯮ㥬 ⥭⮢.

DC_USERNAMES   50                             1- ࠭祭
               ⢮ ⮢    짮⥫.

DC_USERS       50                             1- ࠭祭
               ⢮ ⮢   ᠭ 짮⥫.

DDL_LOCKS      5*(᫮ ᥠᮢ)              20- ࠭祭
               ᨬ쭮 ⢮ ஢  ᨭ⠪-
                 SQL - ஢, 믮塞 (-
               ஢) ६.  室     
                ⠡ ⭮⥫쭮     -
               ஢. 祭 ⮣ ࠬ - 쭮. -
               , ᫨ 3 짮⥫    -
                ⠡,   ॡ   3   .   ᫨  3
               짮⥫       2  ⠡,
               ॡ 6 ⮢. ᠭ DDL - ஢
               室   12.  㬮砭 ।,
                  ।  ᥠ 室 5  ஢.

DML_LOCKS      4*(᫮ ࠭権)         20- ࠭祭,0
               ᨬ쭮 ⢮ DML - ஢ -   -
                    ⠡,  㥬   ६
               ࠭樨. 祭  ࠢ 饬 -
                ஢,  믮塞 짮⥫ﬨ 
               䨪樨 ⠡. ਬ - ᫨ 3 짮⥫
                   ⠡, ॡ 3
               . ᫨  짮⥫   -
                   ⠡, ॡ 6 -
               ⮢. ᠭ DML - ஢ ਢ   
               12.   ।  ।,    ࠭
               室 4 ஢ ⠡.
               ᫨ ⠭ 祭 0, ⪫砥 ⠭

                                    -- 11 --



                ।  ந⥫쭮  蠥. 
                ⮬  믮  DROP TABLE 
               CREATE INDEX.

ENQUEUE_HASH   ᨬ         
                ⠡ ஢ ।.  祭 -
                ந  ENQUEUE_RESOURCE      .

ENQUEUE_LOCKS  ᨬ         
               ⢮ ஢, 믮 ᮬ -
                 DML    DDL.  祭  ந 
               ENQUEUE_RESOURCE    .

ENQUEUE_RESOURCES
               ᨬ         
               ⢮ ᮢ,    -
                ணࠬ     ஢.  室
                   (    ஢).  
               ᫮   ࠢ  㬬 DML_LOCKS  DDL_LOCKS
                ⥫쭮 20   室. -
                ࠬ   ந  PROCESSES 
                 .  ᫨  ᯮ  
               ⠡,  祭   㢥祭.

EVENT          null              
               ࠢ ᮡﬨ  ० ⫠.    -
                      ४権  ᮭ
               Oracle Corporation.

FIXED_DATE     null              
                  ⠭ ⠭  㭪樨
               SYSDATE. ᯮ  ᭮ -   ஢.

FREE_LIST_INST 1                              1-# ஢
               ⢮ ⮢  ᢮  ᯨ᪥    -
               ஢.  祭  ࠢ -
                ஢ ( 1 -  ⢥ )
               ⮢ ந ⮣ ࠬ  FREE_LIST
               _PROC     12.

FREE_LIST_PROC 4                              1 - 12
               ⢮ ⮢   ᢮ ᯨ᪥  -
               ᮢ.  ,    ⠡ 㤥 -
               ᮪ ⨢ 権 INSERT,  ᫮ 
                㢥祭. ⮢ ந ⮣ -
                 FREE_LIST_INST     12.

               砭: 騥   ᥬ  ࠬ஢  ਬ
               ⮫쪮  ⥬,  ࠧ  ᪨  (᪮쪮
               ஢ ORACLE  ࠧ     ).
               ⥬  ࠧ ᪮ 㦤     21.

GC_DB_LOCKS    ᨬ                      1- ࠭祭
               ⭮ ⮫쪮   ⥬,  ࠧ騬  ᪨.
               ᨬ쭮 ⢮  ஢  ,
               㥬   ஢.  砭 ਥ-
                  ⥬   - ࠬ;  
               襣 ⢠ 祭   .

                                    -- 12 --



               ਥ ᫥ 㫠   ⮣ -
               祭:
               (㬬 DB_BLOCK_BUFFERS  ᥬ ࠬ) / 2

GC_ROLLBACK_LOCKS
               20                
               ⭮ ⮫쪮    ⥬,  ࠧ騬 ᪨.
               ⢮     ࠫ쭮   㥬
               ᥣ ⪠  ᥬ ࠬ ORACLE. -
               稢 祭 ਥ    -  -
               ஢,   쭥襬  㢥祭 ॡ -
                10   ⥫ .

GC_ROLLBACK_SEGMENTS
               20                
               ⭮ ⮫쪮   ⥬,  ࠧ騬  ᪨.
               ⠭ ⥬ ᫮ ᥣ⮢ ⪠.

GC_SAVE_ROLLBACK_LOCKS
               20                
               ⭮ ⮫쪮    ⥬,  ࠧ騬 ᪨.
               ⢮      ࠫ쭮  㥬
               ᢥ  ᥣ  ⪠    ᥬ ࠬ
               ORACLE. 稢 祭 ਥ  
               - ஢,   쭥襬 㢥祭 -
                 10     ⥫  - .

GC_SEGMENTS    10                
               ⭮ ⮫쪮   ⥬,  ࠧ騬  ᪨.
               饥  ᥩ ⥬ ⢮ ᥣ⮢,   -
                ࠫ쭮 믮 樨  ࠢ-
                 .  稢 祭 ਥ 
                - ஢,   쭥襬 㢥-
                ॡ  10   ⥫ .

GC_SORT_LOCKS  ᨬ         
               ⭮ ⮫쪮   ⥬,  ࠧ騬  ᪨.
               饥 ᫮ ஢  ஢.

GC_TABLESPACES 5                 
               ⭮ ⮫쪮   ⥬,  ࠧ騬  ᪨.
               饥 ⢮  ⠡  ࠭,  
               ॢ ६   ﭨ  offline  
               online ( ).

IFILE          null              
               ᯮ       ⥪騩  INIT.ORA -
               䠩 - 㣮 䠩.  ᫥     ࠬ
                ᫥  䠩, ਬ:
               IFILE-TESTPARM.ORA
               ᨬ쭮 ⨬  ஢ .

INIT_SQL_FILES ⥬ᨬ  
                    䠩, -
               ঠ SQL - , 믮騥  
               ᮧ . ᮪   祭  ᪮-
               ,  ⤥ 䠩 - ࠧ 묨, -
               :

                                    -- 13 --



               INIT_SQL_FILES = (SQL.BSQ, CATALOG.ORA, SITEDD.SQL)
                ⮬ ࠬ  室 㪠뢠  䠩
               SQL.BSQ,  ⥬ -  ॡ㥬   -
                䠩. 砭   樮 -
                   ,  ᪫祭 
               ⥫ 䠩.

INSTANCES      16                             1 - 255
               ⭮ ⮫쪮    ⥬,  ࠧ騬 ᪨.
               饥 ᨬ쭮    ⢮     ஢
               ORACLE,   ६   .
                ࠬ     ⫨砥           ࠬ
               MAXINSTANCES, 㪠뢠          CREATE
               DATABASE; MAXINSTANCES । ᮫  -
               ᨬ. INSTANCES  ६ ४뢠 -
                ࠬ MAXINSTANCES,     ॢ-
               . 祭  ⮣ ࠬ   
               ⠬ .

LANGUAGE       'AMERICAN_AMERICA.US7ASCII'        
               쭠 ப, ।  樨 
               樮묨 몠.  ᠬ   ࠬ
               ।  㬥  ଠ:
               language_territory.char-set
               (_.-ᨬ)
               㬥 language ᯥ , ਬ騩-
                 ᮮ饭 ORACLE,  楢, ᯮ-
               㥬  㭪 TO_DATE   TO_CHAR,    ⠪  -
               㬠稢 ଠ . ਬࠬ ন
               몮  㦨:  American,  French,  German, Spanish.

               㬥 territory ᯥ  -
               ਨ,   ன 室 ᯮ짮 㬥
                 .  祭 ।,  ࠧ
                믮 ८ࠧ ஢   -
                 㭪樨 TO_CHAR (    
               ᥭ  쭨).  ন ᫥-
               騥 ਨ:  America,  France,  Germany   
               Spain.

               㬥 char-set ᯥ 㬠稢 
               ᨬ,  ᯮ㥬 ORACLE  ࠡ⪨  -
                 ᮮ饭 ( ᮡ -   㭪権
               UPPER,  LOWER, INITCAP  CONVERT),  ⠪ 㬠-
                 ᫥⥫쭮  ᫨ﭨ,  ᯮ㥬
                ࠧ ORDER BY. ন  ᨬ
               (  ஢  ᨬ  -
               樮 ⥬) ਢ  ᫥饩 ⠡.

  ᨬ           ᠭ

US7ASCII                           U.S. 7-bit ASCII
WE8HP                              ய᪨ (-
                                   ) 8-bit  HP
WE8DEC                             ய᪨ 8-bit  DEC
WE8IBMPC                           ய᪨ 8-bit 



                                    -- 14 --



                                   IBM PC  ᮢ⨬
F7DEC                              ࠭᪨ 7-bit  DEC
D7DEC                              檨 7-bit  DEC

 ⠫쭮 㦤 ⮣ ࠬ    -  প
樮 몮 ਢ  ਫ F.

                砭         ?   祭

LOG_ALLOCATION 200         
               ਬ  ᭮  ⥬, ࠧ ᪨.
               뢠 ⢮  䠩 ୠ  -
                믮  (ᨬ    ࠧ  ),
               ।塞    ࠧ,    
               ॡ ⥫쭠   ⥪饬 ⨢
               䠩 ୠ.   21 뢠 䠩 ୠ-
                 ⥬,  ࠧ  ᪨,   ⨬
               ࠧ । .
                ⥬,   ࠧ ᪨,   裡  ⥬,
                ୠ  ⮫쪮  , -
                ⨬쭮  㪠뢠   ࠧ ࠢ (
               ) ࠧ 䠩 ୠ.

               ⢮ ⠪ ।  ⤥쭮  -
                뢠  ⨪  chunk allocations.

LOG_ARCHIVE_DEST
               ⥬ᨬ  
               ਬ ⮫쪮  ࠡ  ०  ARCHIVELOG  
               ⮬᪮         娢樥        (ࠬ
               LOG_ARCHIVE_START = TRUE).  ।⠢    ᥡ
               ᨬ ப,  㪠뢠  ⮭宦
               䠩 ⭮⥫쭮 ୥  ⠫    
               ⭮   娢樨 䠩 ୠ.

LOG_ARCHIVE_START
               false                          false/true
               ਬ ⮫쪮    ࠡ  ० ARCHIVELOG 
               㪠뢠, 㤥  娢 䠩 ୠ -
               ᪮  筮.  TRUE 砥 ⮬-
                娢.  FALSE 砥,    娢஢
               䠩 ୠ  㤥 DBA.  筠  ⮬᪠
               娢 뢠   15.
               ᫨  ᮧ    ० ARCHIVELOG,
                室 ⠭    ࠬ    TRUE.
               (ଠ쭮        ᮧ      ०
               NOARCHIVELOG  㦥 ᫥  ᮧ  ॢ  
               ० ARCHIVELOG).

LOG_BUFFER     ⥬ᨬ               ⥬ᨬ -
                                                 ࠭祭
               ⢮ ⮢, ।  SGA  ஢
               䠩 ୠ ୮ 믮.   饬 -
               砥 -  㢥祭  ⮣  ࠬ ᭨ ⨢-
                /뢮  ୠ,  ᮡ  -  ᫨
               ࠭樨     .   ᨫ쭮 -
                ⥬ ਥ 㤥  祭  65536  
               .

                                    -- 15 --



                㬮砭  ࠬ   ࠢ  -
               ⭮ ࠧ     樮  ⥬
               ( VAX/VMS  ࠢ 8192 ⠬).

LOG_BUFFERS_DEBUG
               false                         true/false
               筮   ⠭  false.  ४-
               樨 ᮭ 㦡 প Oracle  
               ⠭  true.  ⮬ 砥  -
                묨 묨        樨
               ஡,   裡  LGWR.

LOG_CHECKPOINT_INTERVAL
               ⥬ᨬ                 20- ࠭祭
               ⢮       ୠ -
               ୮ 믮 (  樮 ⥬,
                 ORACLE),  ᫥  믮 ஫-
                窠. ᨬ  ⮣ 祭, ஫-
                窠  㤥 ᮧ  ४祭 䠩-
                ୠ    㣮.   ࠧ 
               ॢ ॠ  ࠧ 䠩 ୠ,   ⮬
               砥 ஫ 窨   ᮧ ⮫쪮
                ४祭 䠩 ୠ.

                ⢮  ஫  祪,  믮  
                ,   ᬮ    
               ⨪ dbwr checkpoints.

LOG_DEBUG_MULTI_INSTANCE
               false                         true/false
               筮   ⠭  false.  ४-
               樨 ᮭ 㦡 প Oracle  
               ⠭   true.    ⮬ 砥 ணࠬ 
               㤥 ࠡ  "୮" ०  -
               ᨬ   ⮣,   ⠢  ⥬ - .

LOG_ENTRY_PREBUILD_THRESHOLD
               0 ⮢                       0- ࠭祭
                ⨯ ⥬   뢠  -
                㢥祭 ⮣ ࠬ,  砥
               ⢮ ⮢,   । 뫪
                 ୠ.    ⥬ 
               ࠬ   ⠭  0.

                ⥬  让 ७樥 饫, 
               ஬  訬 ⬠ ஢ -
               - 㢥祭 ⮣ ࠬ    -
                ࠭ ந ⤥  ⮢
               ୠ,   ᮪  ࢠ ६
                饫    ஢.    ⥬ 
               让 ७樥    ࠬ  㢥-
               稢 .

LOG_FILES      16                             2 - 255
               ᨬ쭮 ⢮ 䠩 ୠ ୮
               믮,      ⮩ -
                   ࠡ.  蠥  ᭨
                祭,  ᫨    ॡ   SGA 

                                    -- 16 --



               ॠ쭮   襥 ᫮  䠩.  -
                 祭  ⠭  ⮬ -
               . 訥  祭     㢥稢
               ࠧ ࠢ 䠩.
               ⫨砥  㬥 MAXLOGFILES  CREATE
               DATABASE ⥬,  ᫥  ᮧ 㪠뢠
               ᮫ ᨬ 䠩 ୠ.

LOG_IO_SIZE    ⥬ᨬ (筮 ࠢ 0)   
               ᨬ쭮 ᫮ ,    -
                  䠩 ୠ.  祭 -
               뢠      ᭮    祭    ࠬ
               LOG_BUFFER  ࠧ   ୠ; -
                  䠩 ୠ.
                ⠭   ࠬ    0,    㤥
               ।  ᫥   䠩 ୠ.

LOG_SIMULTANEOUS_COPIES
               1  n                        1 - n
               ᨬ쭮 ⢮ 饫  ஢ -
                䠩  ୠ      ஢  
                 ६ ( n ࠢ  -
               ஢). ᫨  㪠,  㤥 । ࠢ
                ஢.    -
               ⥬ ⠭  0.  ᫨  ࠬ -
                 ,  ࠬ  LOG_SMALL_ENTRY_MAX_SIZE
               .

LOG_SMALL_ENTRY_MAX_SIZE
               ⥬ᨬ    
                    襣 ஢  
               ୠ, ஥  ⢨    ⮩
               "饫 ।  ୠ"  祭 -
               饫 "饫  ஢  ".  (  VMS  
               㬮砭  800 ⮢).
               ᫨ 祭  LOG_SIMULTANEOUS_COPIES ࠢ 0,
                ࠬ   (  
               "쪨"  믮   饫  ஢).

MAX_DUMP_FILE_SIZE
               500         
               ᨬ ࠧ  (  樮 -
               )  뢠 䠩  .  ⠭
                ।,     ⮣,   䠩
                 ᫨誮    ᪥.

....????       ᨬ쭮 ᫮ ᮢ ஢, -
p        塞  裡  짮⥫᪨  䮭-
               묨 ᠬ. 祭   ᭮
               ࠬ PROCESSES  筮  .

NLS_SORT       false                          false/true
               ᫨ 祭 ࠬ TRUE, ஢ (ਬ
               -  ࠧ ORDER BY)   ᨬ쭮 -
               , ।塞 祭 ࠬ LANGUAGE.
               ᫨ 祭 ࠬ FALSE,  ஢ -
                  ᫮   ᨬ (筠
               ஢ ॡ   室).

                                    -- 17 --



OPEN_CURSORS   50                             5 - 255
               ᨬ쭮 ᫮    ஢   
               짮⥫. ⮬       
                , ᯮ㥬 ᮬ 짮-
               . ।     祭  -
               讥, ⮫쪮  ਯ஢ .

OPEN_LINKS     4                              0 - 255
               ᨬ쭮 ᫮ ࠫ쭮   痢  
               㤠묨    짮⥫.  -
                     ࠢ    
               ,   뫠  ⢥ SQL -
                ⠪,  ⮡       
                  믮 .  祭 
                㢥祭,  ᫨  ந  饭   
               讬   ࠧ   ६.
                ࠧ, ᫨  頥 ୠ⨢-
                  A,  B  C,   ࠬ OPEN_LINKS -
                 2,  㤥  ६   -
               ४祭 痢.
                ࠬ   ⭮   ⮫쪮        ⥢
               ᮥ, 易   ।묨 -
               .  ᮥ  㤠 , 祭-
                 ਪ ணࠬ,   ᫮  室.
               ᫨ ⠭  0, ।  饭.

PRE_PAGE_SGA   false                          false/true
               ᫨ ⠭  TRUE,  ࠭ SGA ।-
                 ࠡ稩   짮⥫. 
               ࠬ ᯥ祭  樮 ⥬ VMS 
               ਬ  ᭮  楫 ⠫ ஢.

PROCESSES      20                             5-⥬ᨬ
               ਬ  ⨯ᮢ ࠡ⪥. -
               쭮 ⢮ 짮⥫᪨ ᮢ -
               樮 ⥬,    ᮥ 
               ORACLE.       ᥡ  5 -  䮭
               ᮢ   -  ॣ樨  짮-
               , ⠪   祭 20   ࠡ
               ࠫ쭮 14  15 짮⥫᪨ ᠬ.

ROLLBACK_SEGMENTS
               null              
                  ᥣ⮢ ⪠   -
               祭 ⭮  ORACLE.   -
                  ᥬ ᥣ⠬, 㪠  ⮬
               ࠬ,   ᫨  ⢮  ᥣ⮢ 㤥
               ॢ ᫥:
               TRANSACTIONS / TRANSACTIONS_PER_ROLLBACK_SEGMENT
                  ᮧ     ᯮ짮
               祢 ᫮ PUBLIC, ⠪   .
                㪠뢠  ⢥ ⮣  ࠬ  ᥣ
               ⪠ SYSTEM.

ROW_CACHE_BUFFER_SIZE
               200               
                  - ப.


                                    -- 18 --



ROW_CACHE_ENQUEUES
               100               
               ⢮ "ࠫ쭮  㦨   -
               ।".  믮 樨 CREATE TABLE, -
                ࠭祭 NOT NULL ॡ  .

ROW_CACHE_INSTANCE_LOCKS
               100               
               ⢮ ஢    ப .

ROW_CACHE_MULTI_INSTANCE
               true                          false/true
               ਬ ⮫쪮    ⥬,  ࠧ ᪨.
               ᫨ 祭 TRUE,   ப 㤥  ন
               ᪮쪮 ஢ ORACLE.

ROW_CACHE_PCT_FREE
               10                
               業 ᢮ த⥫᪨ ꥪ⮢   ப.

ROW_LOCKING    . ᠭ                   ALWAYS/INTENT
                ⥬  ORACLE   樥 ࠡ⪨ ࠭権
                㬮砭 ਭ ALWAYS,   砥  -
               ஢ ⮫쪮  ப  䨪樨 ⠡.

                ⥬  ORACLE  樨 ࠡ⪨ ࠭権
               㬠稢  ⢥ ࠢ쭮  祭 -
               INTENT, 饥   ஢    ஢  ப
               ⮫쪮  SELECT FOR UPDATE,    䨪-
               樨   ⠡.
               祭      -
               ஢, ࠧ  .

SAVEPOINTS     5                              0 - 255
               ᨬ쭮 ⢮ ࠫ 祪  -
                    짮⥫.  窨 ࠭
               뢠   11.

SCN_INCREMENT  2048              
                ࠬ  system  commit  number (-
               ⢮ commit  ⥬) 㢥稢   -
               祭, ᫨  ⥪騩    ॢ襭.  -
               쭮  祭   .

SCN_THRESHOLD  512               
                   system   commit   number  ⠥
               ௠, ᫨ ⠫ ⠪ ⢮ commit.
               ଠ쭮   .

SEQUENCE_CACHE_ENTRIES
               10                             10 - 32000
               ⢮ ᫥⥫쭮⥩ ஢,  
               ஢  SGA    㯠. 
                㦨  ᭮ LRU, ⠪  ᫨ -
                ᤥ  ᫥⥫쭮,   
                 ᢮ ⮢ ,  ३訩 
               㤠   .  ᨬ쭮 ᯠ-
               ࠫ ࠡ ⨣,    -

                                    -- 19 --



                ⠭ ࠢ 襬   -
               ६ ᯮ㥬 ᫥⥫쭮⥩.
                 ॡ  90 ⮢   SGA; 
               ⥬, ࠧ  ᪨      ॡ
                110 ⮢.
               ᫥⥫쭮, ᮧ   樥 NOCACHE 
               ࠭   ⠪      뢠  १
               ᫮   饣 짮.

SEQUENCE_CACHE_HASH_BUCKETS
               7                              1 - 32000
               ⢮  ( 8 ⮢  ), ᯮ-
                  ᪮७  ᬮ    襭
               ᫥⥫쭮⥩  ;  ஥  ਭ-
                -⠡   ⮫쪮  ᤥ 
                   ᫥⥫쭮,      ⮩
               ⠡.   ᫠  祭 ⮣ -
               ࠬ  ,  祬 SEQUENCE_CACHE_ENTRIES.  
               ᫮   ,  ⥬ ⮬-
               ᪨ ਬ 쭮 ⮥,  㪠-
                ᫠.

SERIALIZABE    false                          false/true
               ᫨ 㪠 TRUE,    ⠭
               ஢ ⥭  ।頥   -
                ⠥ ꥪ,  ࠭, ᮤঠ-
                    .  ᯥ稢  ன
               ⥯ ⨢稢     ࠫ-
               쭮.

SESSIONS       (1.1*PROCESSES)   
               饥 ⢮  ⥬  짮⥫᪨ -
               ᮢ. 稢 祭 ⨬   ४-
               ᨢ ᥠᮢ.

SINGLE_PROCESS false                          false/true
               ।, 㤥         ࠡ   
               짮⥫᪮ (  ,     ⢥
               )  짮⥫᪮  (-
               ) ०.  TRUE 砥  짮⥫, 
               FALSE -  ᪮쪨.  ᠭ  ᮢ  
               ᮢ ⥬  ORACLE ਢ  
               9. ⥬,  ࠧ騥 ᪨,   ⠭-
                 ࠬ  FALSE.

SORT_AREA_SIZE ⥬ᨬ    
                   ᭮  ,  
               ᪮॥ ᥣ 㤥 㯭  ஢. -
               ,  VAX c 8 ⠬ ᭮ : ᫨
                ⠥,  1/8  㤥 㯭  -
               ᮢ ஢  ,   ࠫ쭮 -
                믮 4 ஢;   ⮬ 砥 -
                  ⠭  ࠢ  8192/8/4=256.  
               ࠢ,     㤥 㢥稢 䥪-
               ⨢ "" ஢.




                                    -- 20 --



               筮 㬠稢 祭   室  
               設⢠ 権   . 쪮 ᮧ-
                祭   ᮢ    ⠢  
               㢥  ࠬ.  ᫨   믮-
                 饭   ,  ਬ -  
                   ,  㢥祭 祭 ⮣
               ࠬ  ᪮ , ᮡ  -
               ஢ CREATE INDEX.

SORT_READ_FAC  ⥬ᨬ    
               樥 ⨡筮 ⥭  ஢.

SORT_SPACEMAP_SIZE
               ⥬ᨬ    
                      ஢  -
                ⥪.  ࠨ  ࠬ -
                ⮫쪮  ᫨     祭 訥 .
                室 ஢ ⮬᪨  㢥-
               稢 ᢮   ,     ॡ,
               ᫨  㤥  ᯮ짮 ᪮ .
               ஢ 㤥  ⨬쭮 ᯮ짮 ᪮
               , ᫨ SORT_SPACEMAP_SIZE ⠭ :

               [(total-sort-bytes) / (sort-area-size)] + 64,

                total-sort-bytes (-ꥬ-㥬---):

               (⢮-ᥩ) *
               [㬬-।-ࠧ஢-⮫殢+(2*᫮ ⮫殢)]

                ⮫ - ,  祭  ᯨ᮪ SELECT
                ORDER BY,  GROUP BY  ᯨ᮪ 祩  CREATE
               INDEX. ஬ ⮣  10  ⮢    ROWID
                CREATE  INDEX  GROUP BY  ⮫ ORDER BY,
                㯮  ᮮ⢥饬 ᯨ᪥ SELECT.

TIMED_STATISTICS
               false                          false/true
                㬮砭 ( ⠭  FALSE) ⨪
               SQL*DBA 易    ६ ( ணࠬ "-
                ") ᥣ 㫥  RDBMS  -
                 室   ᡮ.  ⮡ -
                ⨪,   ⠭    祭    TRUE.
               ଠ쭮   ࠬ    ⠭  FALSE.

TRANSACTIONS   1.1*PROCESSES     
               ᨬ쭮 ⢮  ࠫ  ࠭権.
               稢 ࠧ SGA   । ᥣ⮢
               ⪠.   㬮砭   祭 ᪮쪮 
               ᫠ ᮢ (⮡  ४ᨢ ࠭-
               樨). ࠭樨   ᥣ ⪠ 㦤   15.

TRANSACTIONS_PER_ROLLBACK_SEGMENT
               20                
               ⢮ ࠫ ࠭権,  ⨬  
                ᥣ ⪠.  ⥫쭮,  ⢮
               ᥣ⮢ ⪠,  襭      㤥
               ࠢ ⭮     ࠬ TRANSACTIONS

                                    -- 21 --



                 ࠬ. ਬ, ᫨ TRANSACTIONS=101,
                  ࠬ ࠢ 10,   ⢮ -
               襭 ᥣ⮢ 㤥 㣫    -
               ஭ १⮬  101  10  (11).

USER_DUMP_DEST  ⥬ᨬ   
                (⠫,  䠩, ),  ஥ 뢠-
                ⫠ 䠩 짮⥫᪨ ᮢ.

USE_ROW_ENQUEUES
               true                           true/false
                㬮砭  ।     ।祭 
               ஢ ப,  ⮡ ᫥  믮﫨  
               ࠢ쭮 浪.  ࠬ ࠢ -
                 ப   ॡ 믮 
                ப,  묨 ⠢訬  ।. 
               ।० ⥫ ࠡ   
               ࠡ    ᫮  ᮪ ७樨 ப,  
               ⠪ ᭨ /뢮  ⥬   -
               ࠬ.

               ᫨ ७  ப     
               ⨣ 讣 먣 ந⥫쭮,
               ⠭  ࠬ  FALSE, ᪫ ।
                 .    த  ,  ᫨
               ᯮ짮 । ॡ ᫨誮  -
                  室.      稨
               ७樨 ப  祭 ࠬ - FALSE -
                ࠤ ࠪ⨪ /뢮.

               ⠭ ⮣ ࠬ     믮-
                ஢,   楫⭮   冷
               ;      冷,  -
               ஬ ஢  믮 ࠧ묨 -
               .  ࠬ    祭
                 ஢, ࠧ  .

USER_SESSIONS  1                             1
               ᨬ쭮 ⢮ ᥠᮢ   짮-
               ⥫.   饥 ६ ⨬   -
                 .

                   

 ਫ ᮤন ᠭ  ⠡    ஢  ᫮ . ⮡
ᬮ  ⥪騩  ᫮  襩 ⥬,   DICTIONARY.
 ਫ 祭 ᫥ ଠ:
    *   ᠭ ஢ ᫮ 
    *   ᠭ ⮫殢  ꥪ⮢
    *  ⠡ ᪮ ந⥫쭮   ⮫殢.

                 ᫮ 

            䠢⭮ 浪 ਢ ࠢ筨 ஢
          ᫮ , 㯭 짮⥫  -
          ࠬ   .   ଠ ⠪ 㯭 -
          ।⢥  ⮫ ᫮  COLUMNS.


                                    -- 22 --



ACCESSIBLE_COLUMNS  ⮫  ⠡, ஢  ஢

          DATA_DEFAULT        稢 祭  ⮫
          DEFAULT_LENGTH       㬠稢 祭
          COLUMN_ID           ᫥⥫  ⮫
          NULLBASE            ⨬  祭 NULL ?
          DATA_SCALE          ⢮   ஡  ᫠
          DATA_PRECISION      : ᫮  (NUMBER)  ᨬ-
                               (CHAR, RAW)
          DATA_LENGTH         ਭ ⮫  
          DATA_TYPE              ⮫
          COLUMN_NAME          ⮫
          TABLE_NAME           ⠡,   
          OWNER                ⠡,   

ACCESSIBLE_TABLES    , 㯭 짮⥫

          TABLE_TYPE           ꥪ
          TABLE_NAME           ꥪ
          OWNER                ꥪ

ALL_CATALOG    ⠡, ,   ᫥⥫쭮,
              㯭 짮⥫
          TABLE_TYPE           ꥪ
          TABLE_NAME           ꥪ
          OWNER                ꥪ

LL_COL_COMMENTS ਨ  ⮫栬 㯭 ⠡  p
          COMMENTS            ਩  ⮫
          COLUMN_NAME          ⮫
          TABLE_NAME           ꥪ
          OWNER                ꥪ

ALL_COL_GRANTS_MADE ࠢ 㯠  ⮫栬,   짮-
                    ⥫  楬

          CREATED             ६ ।⠢ ਢ
          REFERENCES_PRIV     襭 뫠  ⮫ ?
          UPDATE_PRIV         襭  ⮫ ?
          GRANTOR              짮⥫, ।⠢襣 ࠢ 㯠
          COLUMN_NAME          ⮫
          TABLE_NAME           ꥪ
          OWNER                ꥪ
          GRENTEE              짮⥫, ஬ ।-
                               ࠢ 㯠

ALL_COL_GRANTS_RECD ࠢ 㯠  ⠡栬, ।⠢
                    ⭮ 짮⥫  ᥬ (PUBLIC)

          CREATED             ६ ।⠢ ਢ
          REFERENCES_PRIV     襭 뫠  ⮫ ?
          UPDATE_PRIV         襭  ⮫ ?
          GRANTOR              짮⥫, ।⠢襣 ࠢ 㯠
          COLUMN_NAME          ⮫
          TABLE_NAME           ꥪ
          OWNER                ꥪ
          GRENTEE              짮⥫, ஬ ।-
                               ࠢ 㯠

                                    -- 23 --



ALL_DB_LINKS   裡, 㯭 짮⥫

          CREATED             ६ ᮧ  裡
          HOST                ப SQL*Net  裡
          USERNAME             짮⥫,  ஬ 믮 ᮥ
          DB_LINK               裡
          OWNER

ALL_DEF_AUDIT_OPTS  樨 ॣ樮 ஫   -
                     ꥪ⮢

          UPD       UPDATE WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          SEL       SELECT WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          REN       RENAME WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          LOC       LOCK WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          INS       INSERT WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          IND       INDEX WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          GRA       GRANT WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          DEL       DELETE WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          COM       COMMENT WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          AUD       AUDIT WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          ALT       ALTER WHENEVER SUCCSESSFUL/UNSUCCSESSFUL

ALL_INDEXES  ᠭ ᮢ  ⠡, 㯭 짮⥫

          PCT_INCREASE        業 㢥祭 ࠧ ⥭
          MAX_EXTENTS         ᨬ쭮 ⢮ ⥭⮢,
                              㯭  ᥣ
          MIN_EXTENTS         쭮 ⢮ ⥭⮢,
                              㯭  ᥣ
          NEXT_EXTENT           ⥭⮢
          INITIAL_EXTENT       砫쭮 ⥭
          MAX_TRANS           ᨬ쭮 ⢮ ࠭権
          INI_TRANS           砫쭮 ⢮ ࠭権
          TABLESPACE_NAME      ⠡筮 ࠭⢠, ᮤঠ饣 
          UNIQUENESS           㭨쭮 : UNIQUE  NOUNIQUE
          TABLE_TYPE           㥬 ꥪ
          TABLE_NAME           㥬 ꥪ
          TABLE_OWNER          㥬 ꥪ
          INDEX_NAME           
          OWNER                짮⥫ -  

ALL_IND_COLUMNS  ⮫, ਭ騥 ᠬ  㯭 ⠡-
                 

          COLUMN_LENGTH        㥬  ⮫
          COLUMN_POSITION      ⮫  
          COLUMN_NAME          ⮫
          TABLE_NAME           ⠡  
          TABLE_OWNER          ⠡  
          INDEX_NAME           
          INDEX_OWNER          

ALL_OBJECTS   ꥪ, 㯭 짮⥫

          MODIFIED            ६ ᫥ DDL - 䨪樨 ꥪ
          CREATED             ६ ᮧ ꥪ
          OBJECT_TYPE          ꥪ

                                    -- 24 --



          OBJECT_ID            ꥪ
          OBJECT_NAME          ꥪ
          OWNER                짮⥫ -  ꥪ

ALL_SQUENCES  ᠭ ᫥⥫쭮⥩, 㯭 짮⥫

          LAST_NUMBER         ᫥ , ᠭ  
          CACHE_SIZE          ᫮ ᫥⥫ ஢  
          ORDER_FLAG            浪  
          CYCLE_FLAG          横  ᫥⥫쭮
                               ⨦ । ?
          INCREMENT_BY        祭,  ஥ 㢥稢
                              ᫥⥫쭮
          MAX_VALUE           ᨬ쭮 祭 ᫥⥫- 
          MIN_VALUE           쭮 祭
          SEQUENCE_NAME        ᫥⥫쭮
          SEQUENCE_OWNER        ᫥⥫쭮

ALL_SYNONYMS   ᨭ, 㯭 짮⥫

          DB_LINK               裡  㤠 ⥬
          TABLE_NAME           ꥪ,   뫠 ᨭ
          TABLE_OWNER          ⮣ ꥪ
          SYNONYM_NAME         ᨭ
          OWNER                ᨭ

ALL_TABLES   ᠭ ⠡, 㯭 짮⥫

          BACKED_UP           뫠  ⠡ ᪮஢  -
                               ᫥ 䨪樨 ?
          PCT_INCREASE        業 㢥祭 ࠧ ⥭
          MAX_EXTENTS         ᨬ쭮 ⢮ ⥭⮢,
                              㯭  ᥣ
          MIN_EXTENTS         쭮 ⢮ ⥭⮢,
                              㯭  ᥣ
          NEXT_EXTENT           ⥭⮢  
          INITIAL_EXTENT       砫쭮 ⥭  

          MAX_TRANS           ᨬ쭮 ⢮ ࠭権
          INI_TRANS           砫쭮 ⢮ ࠭権
          PCT_USED             業 ᯮ짮   
          PCT_FREE             業 ᢮   
          CLUSTER_NAME         , ஬ ਭ
                              ⠡ (᫨ ਭ)
          TABLESPACE_NAME      ⠡筮 ࠭⢠, ᮤঠ饣 ⠡
          TABLE_NAME           ⠡
          OWNER                짮⥫ -  ⠡

ALL_TAB_COMMENTS  ਨ  ⠡  ஢, 㯭 짮⥫

          COMMENTS            ਩  ꥪ
          TABLE_TYPE           ꥪ
          TABLE_NAME           ꥪ
          OWNER                ꥪ

ALL_TAB_GRANTS_MADE  ࠢ 짮⥫  ࠢ  ꥪ 짮⥫



                                    -- 25 --



          CREATED             ६ ।⠢ ਢ
          INDEX_PRIV          襭 믮  ꥪ⮬
                              樨 CREATE/DROP INDEX ?
          ALTER_PRIV          襭  ALTER ?
          REFERENCES_PRIV     襭 뫠  ꥪ ?
          UPDATE_PRIV         襭  UPDATE ?
          DELETE_PRIV         襭  DELETE ?
          INSERT_PRIV         襭  INSERT ?
          SELECT_PRIV         襭  SELECT ?
          GRANTOR              짮⥫, ।⠢襣 ࠢ 㯠
          TABLE_NAME           ꥪ
          OWNER                ꥪ
          GRANTEE              짮⥫, ஬ ।-
                               ࠢ 㯠

ALL_TAB_GRANTS_RECD ࠢ 㯠  ꥪ⠬, ।⠢
                    ⭮ 짮⥫  ᥬ (PUBLIC)

          CREATED             ६ ।⠢ ਢ
          INDEX_PRIV          襭 믮  ꥪ⮬
                              樨 CREATE/DROP INDEX ?
          ALTER_PRIV          襭  ALTER ?
          REFERENCES_PRIV     襭 뫠  ꥪ ?
          UPDATE_PRIV         襭  UPDATE ?
          DELETE_PRIV         襭  DELETE ?
          INSERT_PRIV         襭  INSERT ?
          SELECT_PRIV         襭  SELECT ?
          GRANTOR              짮⥫, ।⠢襣 ࠢ 㯠
          TABLE_NAME           ꥪ
          OWNER                ꥪ
          GRENTEE              짮⥫, ஬ ।⠢ ࠢ
                              㯠

ALL_USERS   ଠ  짮⥫  
          CREATED              ᮧ 짮⥫
          USER_ID             䨪樮  짮⥫
          USERNAME             짮⥫

ALL_VIEWS    ஢, 㯭 짮⥫
          VIEW_NAME            
          OWNER                

AUDIT_ACTIONS  ᠭ ⠡   ⨯ ॣ樮 ஫

          NAME                 ⢨  ॣ樨
          ACTION              ᫮   ⢨

COLUMN_PRIVILEGES  ࠢ 㯠  ⮫殢,   짮-
                   ⥫ ᠬ ।⠢ ࠢ, ।⠢ ,
                     楬  ⮫ 饤㯥

          CREATED             ६ ।⠢ ਢ
          REFERENCES_PRIV     襭 뫠  ⮫ ?
          UPDATE_PRIV         襭  ⮫ ?
          GRANTOR              짮⥫, ।⠢襣 ࠢ 㯠
          COLUMN_NAME          ⮫
          TABLE_NAME           ꥪ


                                    -- 26 --



          OWNER                ꥪ
          GRENTEE              짮⥫, ஬ ।-
                               ࠢ 㯠

CONSTRAINT_COLUMNS  ଠ  㯭 ⮫  ।-
                     楫⭮
          POSITION            浪  ⮫  ।
          COLUMN_NAME         , 樨㥬  ⮫殬, 㪠-
                                । 楫⭮
          CONSTRAINT_NAME     , 樨㥬  । 楫⭮
          OWNER                । 楫⭮

CONSTRAINT_DEFS  । 楫⭮  㯭 ⠡

          R_CONSTRAINT_NAME    㭨쭮 । 楫-
                                ᮮ⢥饩 ⠡
          R_OWNER              ⠡, ᯮ㥬  -
                              ⢥饬 ।
          SEARCH_CONDITION     ᫮ ᪠  ஢ન ⠡
          TABLE_NAME          , 樨㥬  ⠡楩  -
                              ࠭祭 楫⭮
          CONSTRAINT_TYPE
          CONSTRAINT_NAME     , 樨㥬  । 楫⭮
          OWNER                ⠡


DBA_AUDIT_DBA
          RETURNCODE            ORACLE, 㥬
                              ⢨. , ᫨ ⢨ ᯥ譮
          STATEMENTID         ஢ 䨪  -
                                ( 
                               稭 ᪮쪨 ⢨)
          ENTRYID             ஢ ID   ॣ-
                              樨  ᥠ
          SESSIONID           ஢ ID ᥠ ORACLE
          GRANTEE              ਢ, 㪠  -
                               RGANT/REVOKE
          RESOURCE_PRIV       Y - ᫨   GRANT/REVOKE
                              㪠 ਢ RESOURCE
          DBA_PRIV            Y - ᫨   GRANT/REVOKE
                              㪠 ਢ DBA
          CONNECT_PRIV        Y - ᫨   GRANT/REVOKE
                              㪠 ਢ CONNECT
          ACTION_NAME          ⨯ ⢨, ᮮ⢥饣
                              ஢   ACTION
          ACTION              ஢  ⨯ ⢨
          OBJ_NAME             ꥪ,   믮 ⢨
          OWNER                ꥪ,   ந-
                               ⢨

          TIMESTAMP           ६ ᮧ  ஫
                              㯠 ( ࢮ 짮⥫)
          TERMINAL            䨪 ନ 짮⥫
          USERHOST            ஢   ORACLE, 
                              ண 짮⥫ ⨫
          USERNAME             ( ID) 짮⥫,  -
                              ⢨ ॣ


                                    -- 27 --



DBA_AUDIT_EXISTS

          RETURNCODE            ORACLE, 㥬
                              ⢨. , ᫨ ⢨ ᯥ譮
          STATEMENTID         ஢ 䨪  -
                                ( 
                               稭 ᪮쪨 ⢨)
          ENTRYID             ஢ ID   ॣ-
                              樨  ᥠ
          SESSIONID           ஢ ID ᥠ ORACLE
          GRANTEE              ਢ, 㪠  -
                               RGANT/REVOKE
          PRIVILEGE           ।⠢/⬥ -
                              ஬ GRANT/REVOKE
          NEW_NAME              ꥪ, २
                              ஬ RENAME
          ACTION_NAME          ⨯ ⢨, ᮮ⢥饣
                              ஢   ACTION
          OBJ_NAME             ꥪ,   믮 ⢨
          OWNER                ꥪ,   ந-
                               ⢨
          TIMESTAMP           ६ ᮧ  ஫
                              㯠 ( ࢮ 짮⥫)
          TERMINAL            䨪 ନ 짮⥫
          USERHOST            ஢   ORACLE, 
                              ண 짮⥫ ⨫
          USERNAME             ( ID) 짮⥫,  -
                              ⢨ ॣ


DBA_CATALOG

          TABLE_TYPE           ꥪ
          TABLE_NAME           ꥪ
          OWNER                ꥪ

DBA_CLUSTERS
          PCT_INCREASE        業 㢥祭 ࠧ ⥭
          MAX_EXTENTS         ᨬ쭮 ⢮ ⥭⮢,
                              㯭  ᥣ
          MIN_EXTENTS         쭮 ⢮ ⥭⮢,
                              㯭  ᥣ
          NEXT_EXTENT           ⥭⮢  
          INITIAL_EXTENT       砫쭮 ⥭  
          MAX_TRANS           ᨬ쭮 ⢮ ࠭権
          INI_TRANS           砫쭮 ⢮ ࠭権
          KEY_SIZE            ਥ஢ ࠧ  -
                                ᮮ⢥騥 ப
          PCT_USED             業 ᯮ짮   
          PCT_FREE             業 ᢮   
          TABLESPACE_NAME      ⠡筮 ࠭⢠, ᮤঠ饣 
          CLUSTER_NAME         
          OWNER                짮⥫ -  

DBA_CLU_COLUMNS
          TAB_COLUMN_NAME     祢 ⮫ ⠡
          TABLE_NAME           ਧ ⠡


                                    -- 28 --



          CLU_COLUMN_NAME     祢 ⮫  
          CLUSTER_NAME         
          OWNER                짮⥫ -  

DBA_COL_COMMENTS
          COMMENTS            ਩  ꥪ
          COLUMN_NAME          ⮫
          TABLE_NAME           ꥪ
          OWNER                ꥪ

DBA_COL_GRANTS
          CREATED             ६ ।⠢ ਢ
          REFERENCES_PRIV     襭 뫠  ⮫ ?
          UPDATE_PRIV         襭  ⮫ ?
          GRANTOR              짮⥫, ।⠢襣 ࠢ 㯠
          COLUMN_NAME          ⮫
          TABLE_NAME           ꥪ
          OWNER                ꥪ
          GRENTEE              짮⥫, ஬ ।-
                               ࠢ 㯠

DBA_CROSS_REFS
          REF_DB_LINK           ꥪ 뫪
          REF_TABLE_NAME       ꥪ 뫪
          REF_OWNER            ꥪ 뫪
          TABLE_TYPE           ꥪ 뫪
          TABLE_NAME           ꥪ 뫪
          OWNER                ꥪ,  뫠  

DBA_DATA_FILES
          STATUS               䠩: INVALID/AVAILABLE
          BLOCKS               䠩   ORACLE
          BYTES                䠩  
          TABLESPACE_NAME      ⠡筮 ࠭⢠,  -
                              ஬ ਭ 䠩
          FILE_ID             䨪 (ID) 䠩
          FILE_NAME            䠩

DBA_DB_LINKS
          CREATED             ६ ᮧ  裡
          HOST                ப SQL*Net  裡
          PASSWORD            ஫  ॣ樨
          USERNAME             짮⥫,  ஬ 믮 ᮥ
          DB_LINK               裡
          OWNER

DBA_EXP_FILES
          TIMESTAMP           ६ 믮 ᫥ ᯮ
          USER_NAME            짮⥫, 믮襣 ᯮ
          FILE_NAME            䠩 ᯮ
          EXP_VERSION          ᨨ ᫥ ᯮ

DBA_EXP_VERSION
          EXP_VERSION          ᨨ ᫥ ᥠ ᯮ

DBA_EXTENTS
          BLOCKS               ⥭   ORACLE
          BYTES                ⥭  

                                    -- 29 --



          BLOCK_ID            砫    ⥭
          FILE_ID              䠩, ᮤঠ饣 ⥭
          EXTENT_ID            ⥭  ᥣ
          TABLESPACE_NAME      ⠡筮 ࠭⢠, ᮤঠ饣 ⥭
          SEGMENT_TYPE         ᥣ
          SEGMENT_NAME         ᥣ
          OWNER                ᥣ, 易   ⥭⮬

DBA_FREE_SPACE
          BLOCKS               ⥭   ORACLE
          BYTES                ⥭  
          BLOCK_ID            砫    ⥭
          FILE_ID             ID  䠩, ᮤঠ饣 ⥭
          TABLESPACE_NAME      ⠡筮 ࠭⢠, ᮤঠ饣 ⥭

DBA_INDEXES
          PCT_INCREASE        業 㢥祭 ࠧ ⥭
          MAX_EXTENTS         ᨬ쭮 ⢮ ⥭⮢,
                              㯭  ᥣ
          MIN_EXTENTS         쭮 ⢮ ⥭⮢,
                              㯭  ᥣ
          NEXT_EXTENT           ⥭⮢
          INITIAL_EXTENT       砫쭮 ⥭
          MAX_TRANS           ᨬ쭮 ⢮ ࠭権
          INI_TRANS           砫쭮 ⢮ ࠭権
          TABLESPACE_NAME      ⠡筮 ࠭⢠, ᮤঠ饣 
          UNIQUENESS           㭨쭮 : UNIQUE  NOUNIQUE
          TABLE_TYPE           㥬 ꥪ
          TABLE_NAME           㥬 ꥪ
          TABLE_OWNER          㥬 ꥪ
          INDEX_NAME           
          OWNER                짮⥫ -  

DBA_IND_COLUMNS
          COLUMN_LENGTH        㥬  ⮫
          COLUMN_POSITION      ⮫  
          COLUMN_NAME          ⮫
          TABLE_NAME           ⠡  
          TABLE_OWNER          ⠡  
          INDEX_NAME           
          INDEX_OWNER          
          DBA_OBJECTSMODIFIED ६ ᫥ DDL - 䨪樨 ꥪ
          CREATED             ६ ᮧ ꥪ
          OBJECT_TYPE          ꥪ
          OBJECT_ID            ꥪ
          OBJECT_NAME          ꥪ
          OWNER                짮⥫ -  ꥪ

DBA_ROLLBACK_SEGMENTS
          STATUS               ᥣ ⪠
          PCT_INCREASE        業 㢥祭 ࠧ ⥭
          MAX_EXTENTS         ᨬ쭮 ⢮ ⥭⮢
          MIN_EXTENTS         쭮 ⢮ ⥭⮢
          NEXT_EXTENT           ⥭⮢  
          INITIAL_EXTENT       砫쭮 ⥭  
          BLOCK_ID
          FILE_ID             ID  , ᮤঠ饣  ᥣ
          SEGMENT_ID          ID  ᥣ ⪠

                                    -- 30 --



          TABLESPACE_NAME      ⠡筮 ࠭⢠, ᮤ-
                              饣 ᥣ ⪠
          OWNER                ᥣ ⪠
          SEGMENT_NAME         ᥣ ⪠

DBA_SEGMENTS
          MAX_EXTENTS         ᨬ쭮 ⨬  
                              ᥣ ᫮ ⥭⮢
          EXTENTS             ᫮ ⥭⮢, ।  ce
          BLOCKS               ᥣ   ORACLE
          BYTES                ᥣ  

          HEADER_BLOCK
          HEADER_FILE
          TABLESPACE_NAME      ⠡筮 ࠭⢠, ᮤ-
                              饣 ᥣ
          SEGMENT_TYPE         ᥣ: "TABLE", "CLUSTER",
                              "INDEX", "ROLLBACK", "DEFERRED ROLLBACK"
          SEGMENT_NAME         ᥣ  (᫨ )
          DBA_SEGMENTS        OWNER
                               짮⥫ -  ᥣ

DBA_SEQUENCES
          LAST_NUMBER         ᫥ , ᠭ  
          CACHE_SIZE          ᫮ ᫥⥫ ஢  
          ORDER_FLAG            浪  
          CYCLE_FLAG          横  ᫥⥫쭮
                               ⨦ । ?
          INCREMENT_BY        祭,  ஥ 㢥稢
                              ᫥⥫쭮
          MAX_VALUE           ᨬ쭮 祭 ᫥⥫쭮
          MIN_VALUE           쭮 祭
          SEQUENCE_NAME        ᫥⥫쭮
          SEQUENCE_OWNER        ᫥⥫쭮

DBA_SYNONYMS
          DB_LINK               裡  㤠 ⥬
          TABLE_NAME           ꥪ,   뫠 ᨭ
          TABLE_OWNER          ⮣ ꥪ
          SYNONYM_NAME         ᨭ
          OWNER                ᨭ

DBA_SYS_AUDIT_OPTS  뢠 ⥪騥 ⥬ 樨 ୠ
                    ॣ樨 㯠

          RESOURCE_ACTION      ⢨ RESOURCE
          NOT_EXISTS           ⢨  ꥪ⠬,
                                
          DBA_ACTION           ⢨, ॡ b DBA
          CONNECT_ACTION       ⢨ ⨯: CONNECT/DISCONNECT

DBA_TABLES
          BACKED_UP           뫠  ⠡ ᪮஢  -
                               ᫥ 䨪樨 ?
          PCT_INCREASE        業 㢥祭 ࠧ ⥭
          MAX_EXTENTS         ᨬ쭮 ⢮ ⥭⮢,
                              㯭  ᥣ
          MIN_EXTENTS         쭮 ⢮ ⥭⮢,

                                    -- 31 --



                              㯭  ᥣ
          NEXT_EXTENT           ⥭⮢  
          INITIAL_EXTENT       砫쭮 ⥭  
          MAX_TRANS           ᨬ쭮 ⢮ ࠭権
          INI_TRANS           砫쭮 ⢮ ࠭権
          PCT_USED             業 ᯮ짮   
          PCT_FREE             業 ᢮   
          CLUSTER_NAME         , ஬ ਭ
                              ⠡ (᫨ ਭ)
          TABLESPACE_NAME      ⠡筮 ࠭⢠, ᮤঠ饣 ⠡
          TABLE_NAME           ⠡
          OWNER                짮⥫ -  ⠡

DBA_TABLESPACES
          STATUS           ⠡筮 ࠭⢠:"ONLINE"  "OFFLINE"
          PCT_INCREASE        稢 業 㢥祭 ࠧ ⥭
          MAX_EXTENTS         稢 ᨬ쭮 ⢮ ⥭⮢
          MIN_EXTENTS         稢 쭮 ⢮  ⥭⮢
          NEXT_EXTENT         稢 ࠧ  ⥭⮢  
          INITIAL_EXTENT      稢 ࠧ 砫쭮 ⥭  
          TABLESPACE_NAME      ⠡筮 ࠭⢠

DBA_TAB_AUDIT_OPTS
          UPD          UPDATE WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          SEL          SELECT WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          REN          RENAME WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          LOC          LOCK WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          GRA          GRANT WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          DEL          DELETE WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          COM          COMMENT WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          AUD          AUDIT WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          ALT          ALTER WHENEVER SUCCSESSFUL/UNSUCCSESSFUL

          TABLE_TYPE   ꥪ
          TABLE_NAME   ꥪ
          OWNER        ꥪ

DBA_TAB_COLUMNS
          DATA_DEFAULT        稢 祭  ⮫
          DEFAULT_LENGTH       㬠稢 祭
          COLUMN_ID           ᫥⥫  ⮫
          NULLBASE            ⨬  祭 NULL ?
          DATA_SCALE          ⢮   ஡  ᫠
          DATA_PRECISION      :᫮  (NUMBER)  ᨬ- (CHAR, RAW)
          DATA_LENGTH         ਭ ⮫  
          DATA_TYPE              ⮫
          COLUMN_NAME          ⮫
          TABLE_NAME           ⠡,   
          OWNER                ⠡,   

DBA_TAB_COMMENTS
          COMMENTS            ਩  ⮫
          COLUMN_NAME          ⮫
          TABLE_NAME           ꥪ
          OWNER                ꥪ




                                    -- 32 --



DBA_TAB_GRANTS
          CREATED             ६ ।⠢ ਢ
          INDEX_PRIV          襭 믮  ꥪ⮬
                              樨 CREATE/DROP INDEX ?
          ALTER_PRIV          襭  ALTER ?
          REFERENCES_PRIV     襭 뫠  ꥪ ?
          UPDATE_PRIV         襭  UPDATE ?
          DELETE_PRIV         襭  DELETE ?
          INSERT_PRIV         襭  INSERT ?
          SELECT_PRIV         襭  SELECT ?
          GRANTOR              짮⥫, ।⠢襣 ࠢ 㯠
          TABLE_NAME           ꥪ
          OWNER                ꥪ
          GRANTEE              짮⥫, ஬ ।-
                               ࠢ 㯠

DBA_TS_QUOTAS
          MAX_BLOCKS           짮⥫   ORACLE.
                              NULL 砥 " ࠭祭"
          BLOCKS              ⢮  ORACLE, ਭ-
                               짮⥫
          MAX_BYTES            짮⥫  . NULL,
                              ᫨ ࠭祭 
          BYTES               ⢮ ⮢, ਭ 짮⥫
          USERNAME            짮⥫  ਢ "RESOUR-
                              CE"  ⠡筮 ࠭⢠
          TABLESPACE_NAME      ⠡筮 ࠭⢠

DBA_USERS
          EXPIRES              祭 ⢨ ஫
          CREATED              ᮧ 짮⥫
          TEMPORARY_TABLESPACE 稢 ⠡筮 ࠭-
                                ६ ⠡
          DEFAULT_TABLESPACE  稢 ⠡筮 ࠭⢮  
          DBA_PRIV              짮⥫ ਢ DBA ?
          RESOURCE_PRIV         짮⥫ ਢ RESOURCE ?
          CONNECT_PRIV          짮⥫ ਢ CONNECT ?
          PASSWORD            ஢ ஫
          USER_ID             ID -  짮⥫
          USERNAME             짮⥫

DBA_VIEWS
          TEXT                 
          TEXT_LENGTH          ⥪ 
          VIEW_NAME            

DICTIONARY  ᠭ ⠡  ஢ ᫮ 
          COMMENTS               ꥪ
          TABLE_NAME           ꥪ

TABLE_PRIVILEGES ࠢ 㯠  ꥪ⮢,  ।⠢
                 짮⥫,    砥,  楬
                  ,  ⠪ 饤㯭 (PUBLIC)

          CREATED             ६ ।⠢ ਢ
          INDEX_PRIV          襭 믮  ꥪ⮬
                              樨 CREATE/DROP INDEX ?
          ALTER_PRIV          襭  ALTER ?

                                    -- 33 --



          REFERENCES_PRIV     襭 뫠  ꥪ ?
          UPDATE_PRIV         襭  UPDATE ?
          DELETE_PRIV         襭  DELETE ?
          INSERT_PRIV         襭  INSERT ?
          SELECT_PRIV         襭  SELECT ?
          GRANTOR              짮⥫, ।⠢襣 ࠢ 㯠
          TABLE_NAME           ꥪ
          OWNER                ꥪ
          GRANTEE              짮⥫, ஬ ।-
                               ࠢ 㯠


USER_AUDIT_CONNECT
          RETURNCODE            ORACLE, 㥬
                              ⢨. , ᫨ ⢨ ᯥ譮
          SESSIONID           ஢ ID ᥠ ORACLE
          LOGOFF_DLOCK        㯨 樨, 㦥  ६ ᥠ
          LOGOFF_LWRITE       ᫮ ᪨ ᥩ  ᥠ
          LOGOFF_PREAD        ᫮ 䨧᪨ ⥭  ᥠ
          LOGOFF_LREAD        ᫮ ᪨ ⥭  ᥠ

          LOGOFF_TIME         ६ 砭 ᥠ 짮⥫
          ACTION_NAME          ⨯ ⢨, ᮮ⢥饣
                              ஢   ACTION
          TIMESTAMP           ६ 砫 ᥠ
          TERMINAL            䨪 ନ 짮⥫
          USERHOST            ஢   ORACLE, 
                              ண 짮⥫ ⨫
          USERNAME             ( ID) 짮⥫,  -
                              ⢨ ॣ

USER_AUDIT_RESOURCE
          RETURNCODE            ORACLE, 㥬
                              ⢨. , ᫨ ⢨ ᯥ譮
          STATEMENTID         ஢ 䨪  -
                                ( 
                               稭 ᪮쪨 ⢨)
          ENTRYID             ஢ ID   ॣ樨  ᥠ
          SESSIONID           ஢ ID ᥠ ORACLE
          ACTION_NAME          ⨯ ⢨, ᮮ⢥饣
                              ஢   ACTION
          OBJ_NAME             ꥪ,   믮 ⢨
          OWNER               짮⥫, ⠢訩 ᮧ 
                              騩 ꥪ
          TIMESTAMP           ६ ᮧ  ॣ樨 㯠
          TERMINAL            䨪 ନ 짮⥫
          USERHOST            ஢   ORACLE, 
                              ண 짮⥫ ⨫
          USERNAME             ( ID) 짮⥫,  -
                              ⢨ ॣ

USER_AUDIT_TRAIL

          RETURNCODE            ORACLE, 㥬
                              ⢨. , ᫨ ⢨ ᯥ譮
          STATEMENTID         ஢ 䨪  -
                                ( 
                               稭 ᪮쪨 ⢨)

                                    -- 34 --



          ENTRYID             ஢ ID   ॣ樨  ᥠ
          SESSIONID           ஢ ID ᥠ ORACLE
          COMMENT_TEXT        ਩   ॣ樨 㯠
          LOGOFF_DLOCK        㯨 樨, 㦥  b६ ᥠ
          LOGOFF_LWRITE       ᫮ ᪨ ᥩ  ᥠ

          LOGOFF_PREAD        ᫮ 䨧᪨ ⥭  ᥠ
          LOGOFF_LREAD        ᫮ ᪨ ⥭  ᥠ
          LOGOFF_TIME         ६ 砭 ᥠ 짮⥫
          SES_ACTIONS         饭  ᥠ. ப  11
                              ᨬ -     ⨯ ⢨
          GRANTEE              ਢ, 㪠  -
                               RGANT/REVOKE
          PRIVILEGE           ।⠢/⬥ -஬ GRANT/REVOKE
          NEW_NAME              ꥪ, २
                              ஬ RENAME
          ACTION_NAME          ⨯ ⢨, ᮮ⢥饣
                              ஢   ACTION
          ACTION              ஢  ⨯ ⢨
          OBJ_NAME             ꥪ,   믮 ⢨
          OWNER                ꥪ,   ந- ⢨
          TIMESTAMP           ६ ᮧ  ஫
                              㯠 ( ࢮ 짮⥫)
          TERMINAL            䨪 ନ 짮⥫
          USERHOST            ஢   ORACLE, 
                              ண 짮⥫ ⨫
          USERNAME             ( ID) 짮⥫,  -
                              ⢨ ॣ


USER_CATALOG  , , ᨭ  ᫥⥫쭮, -
              㯭 짮⥫
          TABLE_TYPE           ꥪ
          TABLE_NAME           ꥪ

USER_CLUSTERS ᠭ ᮡ⢥ ஢ 짮⥫
          PCT_INCREASE        業 㢥祭 ࠧ ⥭
          MAX_EXTENTS         ᨬ쭮 ⢮ ⥭⮢,
                              㯭  ᥣ
          MIN_EXTENTS         쭮 ⢮ ⥭⮢,
                              㯭  ᥣ
          NEXT_EXTENT           ⥭⮢  
          INITIAL_EXTENT       砫쭮 ⥭  
          MAX_TRANS           ᨬ쭮 ⢮ ࠭権
          INI_TRANS           砫쭮 ⢮ ࠭権
          KEY_SIZE            ਥ஢ ࠧ  -
                                ᮮ⢥騥 ப

          PCT_USED             業 ᯮ짮   
          PCT_FREE             業 ᢮   
          TABLESPACE_NAME      ⠡筮 ࠭⢠, ᮤঠ饣 
          CLUSTER_NAME         

USER_CLU_COLUMNS ⮡ࠦ ⮫殢 ⠡  ⮫ 
          TAB_COLUMN_NAME     祢 ⮫  ⠡
          TABLE_NAME           ਧ ⠡
          CLU_CLOUMN_NAME     祢 ⮫  
          CLUSTER_NAME         

                                    -- 35 --



SER_COL_COMMENTS ਨ  ⮫殢  ⠡   짮⥫
          COMMENTS            ਩  ⮫
          COLUMN_NAME          ⮫
          TABLE_NAME           ꥪ

USER_COL_GRANTS  ࠢ 㯠  ⮫栬,   짮-
                 ⥫  楬, । 㣨  -
                 砥  㣨 짮⥫

          CREATED             ६ ।⠢ ਢ
          REFERENCES_PRIV     襭 뫠  ⮫ ?
          UPDATE_PRIV         襭  ⮫ ?
          GRANTOR              짮⥫, ।⠢襣 ࠢ 㯠
          COLUMN_NAME          ⮫
          TABLE_NAME           ꥪ
          OWNER                ꥪ
          GRENTEE              짮⥫, ஬ ।-
                               ࠢ 㯠

USER_COL_GRANTS_MADE  ࠢ  ⮫ ꥪ⮢, ਭ 짮⥫
          CREATED             ६ ।⠢ ਢ
          REFERENCES_PRIV     襭 뫠  ⮫ ?
          UPDATE_PRIV         襭  ⮫ ?
          GRANTOR              짮⥫, ।⠢襣 ࠢ 㯠
          COLUMN_NAME          ⮫
          TABLE_NAME           ꥪ
          GRENTEE              짮⥫, ஬ ।-
                               ࠢ 㯠

USER_COL_GRANTS_RECD ࠢ 㯠  ⠡栬, ।⠢
                           ⭮ 짮⥫
          CREATED             ६ ।⠢ ਢ
          REFERENCES_PRIV     襭 뫠  ⮫ ?
          UPDATE_PRIV         襭  ⮫ ?
          GRANTOR              짮⥫, ।⠢襣 ࠢ 㯠
          COLUMN_NAME          ⮫
          TABLE_NAME           ꥪ
          OWNER                ꥪ

DBA_CROSS_REFS ४ 뫪  짮⥫᪨ ஢,
               ᨭ  ࠭祭

          REF_DB_LINK           ꥪ 뫪
          REF_TABLE_NAME       ꥪ 뫪
          REF_OWNER            ꥪ 뫪
          TABLE_TYPE           ꥪ 뫪
          TABLE_NAME           ꥪ 뫪

USER_DB_LINKS  裡  짮⥫
          CREATED             ६ ᮧ  裡
          HOST                ப SQL*Net  裡
          USERNAME             짮⥫,  ஬ 믮 ᮥ
          DB_LINK               裡

USER_EXTENTS ⥭, 室騥  ᥣ, 묨  짮⥫
          BLOCKS               ⥭   ORACLE
          BYTES                ⥭  
          EXTENT_ID            ⥭  ᥣ

                                    -- 36 --



          TABLESPACE_NAME      ⠡筮 ࠭⢠, ᮤঠ饣 ⥭
          SEGMENT_TYPE         ᥣ
          SEGMENT_NAME         ᥣ

USER_FREE_SPACE  ⥭  ᥣ, 㯭 짮⥫
          BLOCKS               ⥭   ORACLE
          BYTES                ⥭  
          BLOCK_ID            砫    ⥭
          FILE_ID             ID  䠩, ᮤঠ饣 ⥭

        TABLESPACE_NAME      ⠡筮 ࠭⢠, ᮤঠ饣 ⥭

USER_INDEXES  ᠭ ᮢ 짮⥫
          PCT_INCREASE        業 㢥祭 ࠧ ⥭
          MAX_EXTENTS         ᨬ쭮 ⢮ ⥭⮢,
                              㯭  ᥣ
          MIN_EXTENTS         쭮 ⢮ ⥭⮢,
                              㯭  ᥣ
          NEXT_EXTENT           ⥭⮢
          INITIAL_EXTENT       砫쭮 ⥭
          MAX_TRANS           ᨬ쭮 ⢮ ࠭権
          INI_TRANS           砫쭮 ⢮ ࠭権
          TABLESPACE_NAME      ⠡筮 ࠭⢠, ᮤঠ饣 
          UNIQUENESS           㭨쭮 : UNIQUE  NOUNIQUE
          TABLE_TYPE           㥬 ꥪ
          TABLE_NAME           㥬 ꥪ
          TABLE_OWNER          㥬 ꥪ
          INDEX_NAME           

USER_IND_COLUMNS ⮫,  室騥    ⠡ 짮⥫
          COLUMN_LENGTH        㥬  ⮫
          COLUMN_POSITION      ⮫  
          COLUMN_NAME          ⮫
          TABLE_NAME           ⠡  
          INDEX_NAME           

USER_OBJECTS ꥪ, 묨  짮⥫
          MODIFIED            ६ ᫥ DDL - 䨪樨 ꥪ
          CREATED             ६ ᮧ ꥪ
          OBJECT_TYPE          ꥪ
          OBJECT_ID            ꥪ
          OBJECT_NAME          ꥪ

USER_SEGMENTS  , ।   ᥣ⮢ 
          MAX_EXTENTS         ᨬ쭮 ⨬  
                              ᥣ ᫮ ⥭⮢
          EXTENTS             ᫮ ⥭⮢, ।  ᥣ
          BLOCKS               ᥣ   ORACLE
          BYTES                ᥣ  
          TABLESPACE_NAME      ⠡筮 ࠭⢠, ᮤঠ饣 ᥣ
          SEGMENT_TYPE         ᥣ: "TABLE", "CLUSTER",
                              "INDEX", "ROLLBACK", "DEFERRED ROLLBACK"
          SEGMENT_NAME         ᥣ  (᫨ )

USER_SEQUENCES ᠭ ᫥⥫쭮⥩ 짮⥫
          LAST_NUMBER         ᫥ , ᠭ  
          CACHE_SIZE          ᫮ ᫥⥫ ஢  
          ORDER_FLAG            浪  

                                    -- 37 --



          CYCLE_FLAG          横  ᫥⥫쭮
                               ⨦ । ?
          INCREMENT_BY        祭,  ஥ 㢥稢 ᫥-
          MAX_VALUE           ᨬ쭮 祭 ᫥⥫쭮
          MIN_VALUE           쭮 祭
          SEQUENCE_NAME        ᫥⥫쭮

USER_SYNONYMS  ᨭ 짮⥫
          DB_LINK               裡  㤠 ⥬
          TABLE_NAME           ꥪ,   뫠 ᨭ
          TABLE_OWNER          ⮣ ꥪ
          SYNONYM_NAME         ᨭ

USER_TABLES ᠭ ᮡ⢥ ⠡ 짮⥫

          BACKED_UP           뫠  ⠡ ᪮஢  -
                               ᫥ 䨪樨 ?
          PCT_INCREASE        業 㢥祭 ࠧ ⥭
          MAX_EXTENTS         ᨬ쭮 ⢮ ⥭⮢,
                              㯭  ᥣ
          MIN_EXTENTS         쭮 ⢮ ⥭⮢,
                              㯭  ᥣ
          NEXT_EXTENT           ⥭⮢  
          INITIAL_EXTENT       砫쭮 ⥭  
          MAX_TRANS           ᨬ쭮 ⢮ ࠭権
          INI_TRANS           砫쭮 ⢮ ࠭権
          PCT_USED             業 ᯮ짮   
          PCT_FREE             業 ᢮   
          CLUSTER_NAME         , ஬ ਭ
                              ⠡ (᫨ ਭ)
          TABLESPACE_NAME      ⠡筮 ࠭⢠, ᮤঠ饣 ⠡
          TABLE_NAME           ⠡


USER_TABLESPACES ᠭ 㯭 ⠡ ࠭

          STATUS               ⠡筮 ࠭⢠:
                              "ONLINE"  "OFFLINE"
          PCT_INCREASE        稢 業 㢥祭 ࠧ ⥭
          MAX_EXTENTS         稢 ᨬ쭮 ⢮ ⥭⮢
          MIN_EXTENTS         稢 쭮 ⢮ ⥭⮢
          NEXT_EXTENT         稢 ࠧ  ⥭⮢  
          INITIAL_EXTENT      稢 ࠧ 砫쭮 ⥭  
          TABLESPACE_NAME      ⠡筮 ࠭⢠


USER_TAB_AUDIT_OPTS 樨 ஫ 㯠  짮⥫᪨
                          ⠡栬  ࠬ
          UPD          UPDATE WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          SEL          SELECT WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          REN          RENAME WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          LOC          LOCK WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          INS          INSERT WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          IND          INDEX WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          GRA          GRANT WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          DEL          DELETE WHENEVER SUCCSESSFUL/UNSUCCSESSFUL



                                    -- 38 --



          COM          COMMENT WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          AUD          AUDIT WHENEVER SUCCSESSFUL/UNSUCCSESSFUL
          ALT          ALTER WHENEVER SUCCSESSFUL/UNSUCCSESSFUL

          TABLE_TYPE   ꥪ: "TABLE"  "VIEW"
          TABLE_NAME   ꥪ

USER_TAB_COLUMNS ⮫  짮⥫᪨ ⠡,   

          DATA_DEFAULT        稢 祭  ⮫
          DEFAULT_LENGTH       㬠稢 祭
          COLUMN_ID           ᫥⥫  ⮫
          NULLBASE            ⨬  祭 NULL ?
          DATA_SCALE          ⢮   ஡  ᫠
          DATA_PRECISION      : ᫮  (NUMBER)  ᨬ-
                               (CHAR, RAW)
          DATA_LENGTH         ਭ ⮫  
          DATA_TYPE              ⮫
          COLUMN_NAME          ⮫
          TABLE_NAME           ⠡,   

USER_TAB_COMMENTS ਨ  ⠡  ஢ 짮⥫
          COMMENTS            ਩  ꥪ
          TABLE_TYPE           ꥪ: "TABLE"  "VIEW"
          TABLE_NAME           ꥪ

USER_TAB_GRANTS ࠢ 㯠  ꥪ⠬,   짮-
                ⥫  楬, ।⠢ ࠢ
                㯠  砥 

          CREATED             ६ ।⠢ ਢ
          INDEX_PRIV          襭 믮  ꥪ⮬
                              樨 CREATE/DROP INDEX ?
          ALTER_PRIV          襭  ALTER ?
          REFERENCES_PRIV     襭 뫠  ꥪ ?
          UPDATE_PRIV         襭  UPDATE ?
          DELETE_PRIV         襭  DELETE ?
          INSERT_PRIV         襭  INSERT ?
          SELECT_PRIV         襭  SELECT ?
          GRANTOR              짮⥫, ।⠢襣 ࠢ 㯠
          TABLE_NAME           ꥪ

          OWNER                ꥪ
          GRANTEE              짮⥫, ஬ ।-
                               ࠢ 㯠

/T=
          CREATED             ६ ।⠢ ਢ
          INDEX_PRIV          襭 믮  ꥪ⮬
                              樨 CREATE/DROP INDEX ?
          ALTER_PRIV          襭  ALTER ?
          REFERENCES_PRIV     襭 뫠  ꥪ ?
          UPDATE_PRIV         襭  UPDATE ?
          DELETE_PRIV         襭  DELETE ?
          INSERT_PRIV         襭  INSERT ?
          SELECT_PRIV         襭  SELECT ?
          GRANTOR              짮⥫, ।⠢襣 ࠢ 㯠


                                    -- 39 --



          TABLE_NAME           ꥪ
          GRANTEE              짮⥫, ஬ ।-
                               ࠢ 㯠

USER_TAB_GRANTS_RECD ࠢ 㯠  ꥪ⠬, ।⠢
                    ⭮ 짮⥫

          CREATED             ६ ।⠢ ਢ
          INDEX_PRIV          襭 믮  ꥪ⮬
                              樨 CREATE/DROP INDEX ?
          ALTER_PRIV          襭  ALTER ?
          REFERENCES_PRIV     襭 뫠  ꥪ ?
          UPDATE_PRIV         襭  UPDATE ?
          DELETE_PRIV         襭  DELETE ?
          INSERT_PRIV         襭  INSERT ?
          SELECT_PRIV         襭  SELECT ?
          GRANTOR              짮⥫, ।⠢襣 ࠢ 㯠
          TABLE_NAME           ꥪ
          OWNER                ꥪ

USER_TS_QUOTAS    짮⥫  ⠡筮 ࠭⢥

          MAX_BLOCKS           짮⥫   ORACLE.
                              NULL, ᫨ ࠭祭 
          BLOCKS              ⢮  ORACLE, ਭ-
                               짮⥫
          MAX_BYTES            짮⥫  . NULL,
                              ᫨ ࠭祭 
          BYTES               ⢮ ⮢, ਭ 짮⥫
          TABLESPACE_NAME      ⠡筮 ࠭⢠

USER_USERS ଠ  ⥪饬 짮⥫

          EXPIRES              祭 ⢨ ஫
          CREATED              ᮧ 짮⥫
          TEMPORARY_TABLESPACE 稢 ⠡筮 ࠭-
                                ६ ⠡
          DEFAULT_TABLESPACE  稢 ⠡筮 ࠭⢮  
          DBA_PRIV              짮⥫ ਢ DBA ?
          RESOURCE_PRIV         짮⥫ ਢ RESOURCE ?
          CONNECT_PRIV          짮⥫ ਢ  CONNECT ?
          USER_ID             ID -  짮⥫
          USERNAME             짮⥫

USER_VIEWS   ஢ 짮⥫
          TEXT                 
          TEXT_LENGTH          ⥪ 
          VIEW_NAME            


     ᪮ ந⥫쭮

     6.0 ORACLE RDBMS  ᮤন    ᥡ    ७
"⠡", ন  RDBMS  㯭 짮⥫ SYS. 
⠡ 뢠 "⠡栬  ᪮  ந⥫쭮",
⠪    ६ ࠡ  ଠ   ﭭ -
,   ᮤঠ ⭮  ᭮ -  ந⥫쭮.


                                    -- 40 --



      ⠡  묨 ⠡栬  ,  -
묨   .   ROWID  ROWNUM,  ⠡ -
 訢,    ஢ 짮⥫.


            ⠡栬 ᪮ ந⥫쭮

    ᫥ ⠫樨  ⮫쪮  짮⥫      SYS  
  ⨬ ⠡栬.     ⨬ ⠡栬 㦥 -
 짮⥫,  騬  ࠡ   MONITOR ⨫ SQL*DBA.

    ᫨ DBA  ।⠢     ⨬  ⠡栬  㣨
짮⥫,    ᮧ   ᭮   ।-
 짮⥫   롮થ (SELECT).

     ⢥ ୠ⨢    믮  䠩  MONITOR.SQL,
⮡ ।⠢ ਢ PUBLIC  㯠  짮-
  ⠡栬 ᪮ ந⥫쭮.  ⮪ ⮣
⮤ ⮨    ⮬,        ।⠢
ᥬ 짮⥫  ࠢ 㯠    ⮩  ଠ樨.
⥫쭮,  ।⥫ ⮤ ᮧ ஢  -
⠢    ࠢ  짮⥫.  ⠫쭮    䠩
MONITOR.SQL ᬠਢ  "㪮⢥ 짮⥫  -
樨".

  , ᯮ㥬  ࠭  MONITOR

    ᫨     ।⠢ 짮⥫ -DBA 
᫥ ᯮ짮   ॠ쭮 ६    -
࠭  MONITOR, ⨬ 짮⥫ 室 ।⠢
ࠢ 㯠  ⠡栬,  ᯮ㥬    ࠭.  
ࠧ, ᫨  - 짮⥫  SYS  ᯮ짮-
 MONITOR,           ᪮쪨
⠡栬 ᪮ ந⥫쭮.

     ।⠢  롮筮  㯠  ⨬ ⠡栬 -
 ।⠢  ଠ樥.

      MONITOR         ॡ㥬 ⠡()

    FILE                          V$DBFILE
                                  V$FILESTAT
    IO                            V$STATNAME
                                  V$PROCESS
                                  V$SESSION
                                  V$SESSTAT
                                  V$SYSSTAT
    LATCH                         V$LATCHNAME
                                  V$LATCHHOLDER
                                  V$LATCH
    LOCK                          V$LOCK
                                  V$PROCESS
                                  V$RESOURCE
    PROCESS                       V$PROCESS
    ROLLBACK                      V$ROLLNAME
                                  V$ROLLSTST
    STATISTICS                    V$STATNAME
                                  V$PROCESS

                                    -- 41 --



                                  V$SESSSION
                                  V$SYSSTAT
                                  V$SESSTAT
    TABLE                         V$ACCESS
    USER                          V$PROCESS
                                  V$SESSION
                                  V$BGPROCESS
                                  V$LATCH
                                  V$LATCHNAME
                                  V$LOCK
                                  V$RESOURCE
                                  V$TRANSACTION


        ᠭ ⤥ ⠡

      䨪ᮬ V$,  ᠭ ਢ .
     V$ACCESS     PID
                         TABLE#
                         OWNER
                         OWNERNAME
                         TABLENAME

     V$BGPROCESS  뢠 䮭 .
                         PADDR
                         NAME
                         DESCRIPTION
                         ERROR

     V$DBFILE     ଠ   䠩  
                         FILE#
                         NAME

     V$LATCH      ଠ    ⨯ 饫
                         ADDR
                         LATCH#
                         LEVEL#
                         WAITS
                         IMMEDIATES
                         TIMEOUTS
                         NOWAITS
                         SUCCESSES

     V$LATCHHOLDER ଠ  ⥪ , -
                          ᨢ 饫

                         PID
                         LADDR

     V$LATCHNAME  ஢  饫, 
                          ⠡ V$LATCH

                         LATH#
                         NAME





                                    -- 42 --



     V$_LOCK      LADDR
                         PADDR
                         RADDR
                         LMODE
                         REQUEST

     V$LOCK       ADDR
                         PID
                         TY
                         ID1
                         ID2
                         LMODE
                         REQUEST

     V$PROCESS    ଠ  ⥪ ⨢ 

                         ADDR
                         PID
                         SPID
                         USERNAME
                         TERMINAL
                         PROGRAM
                         BACKGROUND
                         LATCHWAIT
                         LOCKWAIT

     V$RESOURCE   ADDR
                         TY
                         ID1
                         ID2

     V$SESSION    ଠ   ⥪饬 ᥠ

                         SID
                         PADDR
                         SESSION#
                         USER#
                         USERNAME
                         COMMAND
                         TADDR

     V$SESSTAT      ⥪饣 ᥠ - ⥪騥
                         祭 ⨪

                         SID
                         STATISTIC
                         VALUE

     V$STATNAME ஢    ⮢ -
                         ⨪, 뢠  ⠡ V$SESSTAT
                          V$SYSSTAT

                         STATISTIC#
                         NAME
                         CLASS




                                    -- 43 --



     V$SYSSTAT    饥 ⥬ 祭  -
                           ⨪  ⠡
                         V$SESSTAT

                         STATISTIC#
                         VALUE

     V$TRANSACTION
                         ADDR
                         SCNBASE
                         SCNWRAP
                         XIDUSN
                         XIDSLOT
                         XIDSQN
                         UBADBA
                         UBASQN
                         UBAREC










































                                    -- 44 --
