Edit D:\app\Administrator\product\11.2.0\dbhome_1\jlib\oracle\sysman\resources\VtoiInitParamMsg_ko.class
?? /? ?? ?????????????????????????????????????????????????????????? !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ contents [[Ljava/lang/Object; <init> ()V Code LineNumberTable getContents ()[[Ljava/lang/Object; <clinit> SourceFile VtoiInitParamMsg_ko.java???? [Ljava/lang/Object; java/lang/Object 1'??? : ?????? ????????? ???????? ??? ???????? ????? ?? ????? TRUE?? ????? ??? GV$ ????? ????? ????????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: FALSE | TRUE ????? : FALSE 27??? : ??? ????? NOT IN ??? ????? ?????? ??? ????????. ?????? ??? ????? ??????? ????? ?????? ??????? ?? ??????? ??? ??? ??? ????? ????????. ??? ????? ??: NESTED_LOOPS | MERGE | HASH ????? : NESTED_LOOPS 3D??? : ??? ????? EXISTS ??? ????? ?????? ??? ????????. ??? ????? ??? ????? ??? ????? ?????? ??? ????? ?????? ??? ??? ??? ????? ?????? ?? ??????. ??? ????? ??: NESTED_LOOPS | MERGE | HASH ????? : NESTED_LOOPS 4"??? : 0??? ?? ??? ????? ??????? ???? ??? ???????? ?????????. ????? ??? ?????? ????? ?????? ???? ?? ??? ???????? ??????? ??????? ????? ?? ??????. ??? ????? ??: 0 - 10 ????? : 0 5 ???? : ????? ????? ??????? UNIX ????????? ????????. ?? ??? ??? ??? 8.0.3????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : TRUE 6 ???? : ????? ????? ??????? UNIX ????????? ????????. ?? ??? ??? ??? 8.0.3????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : TRUE 7 ???? : ????? ?????? ??????? ??? ???????? ARCH ?????? ??? ???????? ?? ????????. (8.1.3????? ?????? ???) ??? ????? ??: 0 - 15 ????? : 0 8 ???? : ??????????? ???? ??? SYSDBA ??? INTERNAL ????? ?? ???????? ??? ????? ????????. (UNIX?? ??????) ??? ????? ??: ????? ??? ?????? ??? ????? : ORACLE_HOME/rdbms/audit 9[??? : ????????? ??? ????? ????????? ???????????. ??? ?????? ??????? ??? TRUE ??? DB?? ?????? SYS.AUD$ ?????? ?????? ??????? ??? OS?? ?????? ??? ??? ????? ????????. ??? ????? ??: NONE | FALSE | DB | TRUE | OS ????? : NONE 10??? : ?????? ??? B ??? ?????? ??? ??? ?????? ????? ?§??? ????? ?????? ????? ????????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : TRUE 11 ???? : ????? ??? ????? SGA ????? ?????? ????? ????????. (UNIX?? ???) ??? ????? ??: FULL | PARTIAL ????? : FULL 12???? : Oracle ??? ?? ???????? ??????(LGWR, DBW n ??)?? ???? ??? ????? ????? ?????(?????? ??? ?????)?? ????????. ??? ????? ????? ?? ??????? ?????? ????????? ??? ????? ????? ????????. ??? ????? ??: ????? ??? ?????? ????????. ????? : ORACLE_HOME/rdbms/log (??? ????? ??? ???) 135??? : Recovery Manager ???????? ???, ???, ??? ????? ??? ????? ?????? ????? ?????? ??? ?????? ?? ????????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 0 - 15 (7 ????? ?? ???) ????? : 0 14 ???? : Recovery Manager ???????? ??? ?????? ??? ??? ????? ???????? ?????? ?????? ????? ?????? ?????? ????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 15 ???? : ?????? ??? ????? ??? ?????? ?????? ?????? ?? ?????? ????? ????? ????????. ??? ????? ??: ?????? ??? ??????. ????? : 1MB 16 ???? : TRUE ??? ??????? ??? ????? ???? ?????? ?????? ?????? ????? ?? ??????. (SQL92 ???) ??? ????? ??: TRUE | FALSE ????? : FALSE 17??? : ????? ?????? ?????? ?????? ????????? ????? ??? DB_BLOCK_BUFFERS??? ????? ??? ?? ????????. ??? ????? ??: ??? ????? ??????. (??:. buffers:400, lru_latches:3) ????? : ??? 18 ???? : ????? ????? ?? ?????? ?????? ???????? ??? DB_BLOCK_BUFFERS??? ????? ??? ?? ????????. ??? ????? ??: ??? ????? ??????. (??: buffers:50, lru_latches:1) ????? : ??? 19G??? : ?? ??????(??? ?????? ??????????? ??? ??? ??????)?? ??? ????? ????? ??? ????? ??? ??? ????????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: ????? ????????. ?????: 0.1*DB_BLOCK_BUFFERS 20 ???? : ????? ????? ?????? ????? ??????. ?? ??? ??? ??? 8.0.4????? ?????? ??????. ??? ????? ??: ??? ????? ??? ??????. ????? : ??? ????? ??? ??? 21%??? : ???????? ??? ????? ??? ??? ????? ??? LGWR ???????? ?????? ???? CKPT ???????? ???????? ????????. ?? ??? ??? ??? 8.0.3????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 22 ???? : ???????? ????? ?? ?? ??? ?????? ??? ??? ????? ??????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: ????? ????????. ????? : 20 23??? : ?? ???????? PL/SQL?? ??? ?????? ?????? ????? ????? ?? COMMIT??? ?????? ????? ????? ????????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 24 ???? : ?? ??? ??? ????????? ??? ??? ?????? ????????. ??? ????? ??: 0-255 ????? : ??? ????? ??? ??? 329 ????: CLUSTER_DATABASE?? TRUE?? ?????? Real Application ?????? ????? ?????????. ??? ????? ??: TRUE | FALSE ?????: FALSE 330????: ?????? ??????????? ????? ??? ?????? ??? ???????? ??????. ?? ??? ????? ?????? ??? ??? ??????? SGA ????? ????? ????? ?? ????????. ?? ???????? ????? ?????? SGA?? ????? ????? ????????. ??? ???????? ?? ??? ?????? ????????. ??? ????? ??: 0?? ??? ??????. ?????: 1 3314???: Real Application ?????? ?????? ????? ?? ??? ??? ??? ????????. ??? ??? ????? ?????? ??????????? ????? ??? ????? ????? ???????? ??? ?? ?? ???????? ?????? ?????. ?? ???????? ?????? ????? Oracle?? Oracle9i Real Application ?????? ??? ??? ????? ???? ??? ??? ????? ?????? ??? ????? ????????. ??? ????? ??: ?????? ????? ??? ????? IP ????????. ?????: NONE 25 ???? : ??? ???????? ???????? ?????? ????? ?? ?????? ????? ?? ??????. ??? ????? ??: ??? ?????? ???????? ?????. ????? : ?????? ??? ??? 26<??? : COMPATIBLE ???????? ???????? ??? ????? ????? ??? ??????????? ????? ?? ??????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: ??? ?????? ???????? ?????. ????? : ?????? ??? ??? 27 ???? : ??? ??? ????? ????????? ???????????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 28 ???? : ??? ????? ????? ???? ????? ??? ?????? ?????? ??? ??? ???(?? ??)?????. ??? ????? ??: 0 - 365 ????? : 7 297??? : ??? ????? ??? ??? ????? ????????. Oracle?? ??? ??? ??? ??? OS ??? ?????? ???? ??? ??? ????? ???????? ????????. ??? ????? ??: 1 - 8 ??? ????????. (????? ???) ????? : ??? ????? ??? ??? 30 ???? : ??? ??? ????? ??????? ?????? ????????. (UNIX?? ???) ??? ????? ??: ????? ??? ?????? ????????. ????? : ORACLE_HOME/dbs 31 ???? : Oracle?? ??? ??????? ??? ?????? ?? ????? ?? ??? CPU ??????. ?? ??? ??????? ??????. ??? ????? ??: 0 - ?????????. ????? : Oracle?? ?????? ????? 32 ???? : CREATE_BITMAP_AREA_SIZE?? ????? ????? ????? ????? ????? ????? ????????. ??? ????? ??: ??? ????? ??? ??????. ????? : 8 MB 33 ???? : ??? SQL ????? ????? ?????? ??? ??? ???? ?????? ??? ??? ????? ???? ?? ?????? ????????. ??? ????? ??: TRUE | FALSE ????? : FALSE(??? ??? ?? ?????) 34 ???? : ??? ????? Oracle ??? ??????. ?? ??????? ??? ???????? ???? ??? SGA ????? ????? ????? ?????. ??? ????? ??: 4 - ??? ????? ??? ??????. ????? : 32768 35??? : ????????? ????? ???????? ???????? ??? ????? ????? ?????? ??? ??? ??????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 0 - ????????. ????? : 8 36 ???? : ?????? ???? ????? ??? ????? ?????? ????? ?? ????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 37 ???? : ????? ????? ??? ????? ????? ???? DBWn, ARCH, SQL*Loader?? ??? ?????? ??? ??? ?????? ????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 38V??? : X$KCBRBH ?????? ????? ??????? ??? ????? ????? ?? ??? ??? ????? ??? ????????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 0 - ????? ????? ????? ??? ??????. ????? : 0(??? ????? ?????? 0????? ??) 39 ???? : LRU ??? ??? ??? ?????? ????????. ??? ??? V$LATCH?? 3% ????? ?????? ?? ??? ???????????. ??? ????? ??: 1 - CPU ??(7.3) ??? 1 - CPU ??(8.0+)?????. ????? : CPU_COUNT/2 40??? : TRUE?? ????? ??? ??? ?????? ??? ??? ????? ????? ?§???? ??? ????? X$KCBCBH ?????? ????????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 41/??? : ??? ?????? ????? ????? ?? ??? ????? ??? ??? ?? ?????? ????? ??? ????????. ??? ????? ??: 1000 - ??? ??? ???(0??? ?????? ??? ????? ?????? ???)?????. ????? : ??? ????? ??? ??? 42/??? : ????? ????????? ????? ???(?????)?????. ?? ??? ????????? ??? ?? ?????? ?????? ????? ?? ??????. ??? ????? ??: 1024 - 65536?????. (??? ????? ??? ???) ????? : 2048(??? ????? ??? ???) 43+??? : ?????? ????? ????????? ????? ?????? ??? ?????? ????????? ????? ?????? ????????. (??: US.ORACLE.COM) ??? ????? ??: ?????? ????? ????? ?????? ??? ????? 128??????. ????? : WORLD 44 ???? : ???, ??? ??? ??? ??? ??? ?? ??? ????? ????? ????? ??? ??????. \n??? ????? ??: ??? ????? ??? ??????. ????? : 64 45 ???? : ??? ??? ??? ???? ????? ????? ??? ??? ????? ??? ??? ??????. ??? ????? ??: ??? ????? ??? ??????. ????? : 8 46??? : ??? ????????? ??? ?? ????? ??? ????? ???? ????????? ??? ??? ?????? ????????. ??? ????? ??: ????? ???/???? ?????? ?? ??? ??? ??????. ????? : ??? 47 ???? : DBWR?? ??? ????? ?? ?? ????????? ????? ???? ??? ??? ???(??????)?? ??????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 1 - 24 ????? : 4 48E??? : ??? ????????? ??? ?? ????? ??? ????? ???? ????????? ??? ??? ?????? ????????. ?? ??? 8.0.3??? DB_FILE_NAME_CONVERT?? ??????????. ??? ????? ??: ????? ???/???? ?????? ?? ??? ??? ??????. ????? : ??? 49??? : ??????????? ???? ?? ?? ??? ????????? ????? ??? ????????. ??? ????? ??: MAXDATAFILES - ??? ????? ??? ??????. ????? : ??? ????? ??? ??? (??: Solaris?? ??? 200) 50 ???? : CREATE DATABASE ??? ????? ????? ????? ????????? ?????????. ??? ????? ??: ??? 8??? ????? ????? ????????. ????? : ???(??????? ??) 51 ???? : ???????? ???? ????????? ????? ???????? ??? ????????. ?? ??? 8.0.3??? DB_WRITER_PROCESSES?? ??????????. ??? ????? ??: 1 - 10 ????? : 1 52 ???? : ???????? ???? ????????? ????? ???????? ??? ????????. DBWR_IO_SLAVES?? ?????? ??? ????? ????????? ?????? ????????. ??? ????? ??: 1 - 10 ????? : 1 53 ???? : ??? Oracle ????? ??? ??? ?? ????????? ????? ?????? ????? ?????? ????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 54 ???? : DBW0 ???????? ?????? ????? ???????? ??????. DBW0 ???????? ??? ???????? ??? ?????? ????????. ??? ????? ??: 0 - ??? ????? ??? ??????. ????? : 0 55??? : TRUE?? ????? ??? ??? ??? ????? ??? ?? ?????? ??? ????? ????? ?§???? ?? ????????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : TRUE 56X??? : ??? ????? ??? ????? ?????? ???????? ???????? ???? ?????? ?????? ?? ??????. ????? ??? ????? ????? ???????? ????? ????????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 57???? : ????? ???, ??? ???, ??? ????? ???? ?????? ?????????, ?? ????? ??? ?? ???????? ????? ?? CPU ????? ?????? ????????. ??? ??? ?????? ?????? ???? ????? ?????? ????? ?????? ?? ???????? ??????????. ??? ????? ??: TRUE | FALSE ????? : TRUE 58 ???? : ??? ???????? ??? ?????? ??? ??????? ?? ??? ????????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 1 - ?????????. ????? : 60?? 59n??? : ??? ???????? ????? ?? ??? ?????? ????? ???????? ??? ????? ?? ??? ????? ????????. ??? ????? ????? ????? ???????? ??? ?????? ?? ?????? ?????? ?????. (8.1.3????? ?????? ???) ??? ????? ??: 0 - 1800??????. ????? : 200?? 60p??? : ??????????? ?? ??? ????? ?? ??? ??? ???????? ??? ????????. ?????? ????? ????????? ??? ?????? ??? ??? ????? ???????? ????? ??? ?? ??? ??????. ??? ????? ??: 0 - TRANSACTIONS ??????? ??????. ????? : ??? ????? ??? ??? 61???? : ??? ?????? ??? ????? ????? ????? ??? ????????. DML(????? ?????) ????? ??? ??? ?? ???????? DML(????? ?????) ????? ????????. ??? ???, 3??? ?????? 2??? ?????? ?????? ??? 6?? ??? ????????. ??? ????? ??: 0 ??? 20???? ?????????. ????? : 4 * TRANSACTIONS (???) 62???? : ??????? ????? ??? ?????? ???? ??? ???????? ?????? ?? ??????. ??? ???, Oracle?? ??? ???????? ??? ????? ?????? ????? ??? ???????? ??? ??? ????? ??? ?????? ????? ????? ????????. ??? ????? ??: 10 - 65535(7.3) ??? 10 - ?????(8.1)?????. ????? : ?????(??? DML_LOCKS + 20 ????? ??? ?????) 63%??? : ??? ????? ????? ??? ????? ????? ?????? ?????? ????????. ????? ?????? ??? ?????? ?????? ?? ???????? ????????. ??? ????? ??: ??? X.500 ??? ??? ??? ??????. ????? : ??? 64 ???? : ????? ??? ???? ?????? ?????? ???????? ?? ????????. ???????? ???????? ??????. \n??? ????? ??: ????? ?? ??????. \n????? : ??? 65 ???? : ???????? ?????? ????? ??? ??? ???????????. ?? ??? ??? ??? 8.0????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 66???? : ??? ??? ?????? ??? ?? ????? ?????? ??? ????????. DB_BLOCK_MAX_DIRTY_TARGET ??? ????? ????? ??? ??? ????? ???? ??? ????? ????? ??????? ?????. ??? ????? ??: 0?? ????? ??? ????? ?????? ??? 1000?? ????? ??? ????? ????????. ????? : ????? ??? ??? 67 ???? : ????? ??? ??? ????? ????????? ???????????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 68 ???? : ??? ??? ??? ?? ??? ?????? ??? ????????. ??????? ???????? ?????? ??? ??? ???????? ????????. ??? ????? ??: FALSE | LOW | HIGH ????? : LOW (2 * CPU_COUNT) 69??? : SYSDATE?? ?????? ????????. ????? ????? ??? ????? ????? ??? ?????? ?? ??? ???????? ?? ????????. ?? ?????? ???????? ?????? ??????. ??? ?????? ?????? ??????. ??? ????? ??: YYYY-MM-DD-HH24:MI:SS ??? ??? Oracle ??? ????????. ????? : NULL 70/??? : ?????? ????????? ???????? TRUE?? ????? ??? ??? ??? ????? ????? ?????? ??? ????? ?????????. ?? ??? ?????? ??????????? ????? ?? ??? ????? ????? ?? ??????. ?? ??? ??? ??? 8.1.3????? ?????? ??????. \n??? ????? ??: TRUE | FALSE \n????? : ????? ????? ??? ????? ?????? ??? ?????? TRUE??? ????? ????? ??? ????? ?????? ??? ?????? FALSE?????. 71v??? : ?????? ????????? ???????? SGA??? ????? ????? ?????? PCM ????? ??? ????????. ??? ???? ????? ????? ?????????. ?? ??? ??? ??? 8.0????? ?????? ??????. \n??? ????? ??: 1 - ?????????. (????? ?? ??? ????? ??? ?????) \n????? : 0 72???? : ?????? ????????? ???????? ??? ?? ????? ?????? ??? ??? ????? ??????? ????? ????? 100??? 1?? ????? ????????. ?? ??? ?????? ?????? ????? ????? ???????? ??? ?§???? ?????? ?? ??????. \n??? ????? ??: ????? ????????. (0??? ?????? ?? ????? ????? ?? ???) \n????? : 10 73 ???? : ?????? ????????? ???????? ????? ????? ???? PCM(??? ??? ????) ??? ????? ????????. ??? : GC_FILES_TO_LOCKS = '{file_list=lock_count[!blocks][R][EACH][:...]' ????? : NULL 74,??? : ?????? ????????? ???????? ???????? ??? ????? ??? ??? ????? ???? ????? ????? ??? ????????. ????? ??? ????? ??? ????? ?????? ?? ??? ?????? ????? ????? ??? ??? ?? ???????? ????? ??? ????? ??? ????? ???????? ?? ???????? ??????????. ?? ??? ??? ??? 8.0.5????? ?????? ??????. \n??? ????? ??: 0 - ?????????. \n????? : GC_SEGMENTS ??? 5?? 75 ???? : ??? ??????(DFS)?? ???? ????? ??????. ??? ????? ??: ??? ????? ??? ??????. ????? : 0(8.0.5?? ??? 2) 76???? : ?????? ????????? ???????? ???????? ???? ???????? ??? ??????(LCK0??? LCK9???)?? ??? ????????. ??? ??? ??? ????? ??? ??? ??? ???????? ??? ????? ?? ??? ??? ?? ??? ?????????. (??? ????? ??????????? ????? ????? ????? ????? ????????.) ?? ??? ??? ??? 8.1.3????? ?????? ??????. \n??? ????? ??: 1 - 10 ??? ??? ????? ??? ??? ??? ???????? ??? 0?????. \n????? : 1(??????????? ??? ????? ?????? ?????? ?????) 770??? : ?????? ????????? ???????? ??? ????? ???? ????? ?????? ??? ??? ???? ??? ????? ????????. ?????? ????? ????? ?????? ????????. \n??? ????? ??: 50 ????????. \n????? : DB_BLOCK_BUFFERS ?? 78???? : ?????? ????????? ???????? ????? ????? ?? ??? ?????? ????? ??? ??? ??? ????????. ????? ??? ???????? ????? ?????? ????? ????? ????? ?? ?? ?????? ???? ???????? ??? ?????? ??? ??? ????? ????? ????????. \n??? : GC_ROLLBACK_LOCKS = '{rs_list=lock_count[!blocks][R][EACH][:...]' \n????? : '0-128=32!8REACH' 79)??? : ?????? ????????? ???????? SYSTEM ??? ???????? ?????? ??? ???????? ????? ??? ???????? ??? ????? ????????. ????? ????? ??? ?????? ??? ??? ???????? ?????? ??? ??? ????????. ?? ??? ??? ??? 8.0????? ?????? ??????. \n??? ????? ??: 0??? (GC_ROLLBACK_SEGMENTS * (GC_ROLLBACK_LOCKS + 1 ))??? \n????? : 20(??????????? ??? ????? ?????? ?????? ?????) 80M??? : ?????? ????????? ???????? ?????? ????? ???????????? ???????? ???? ??? ????? ?????? ??? ??? ????? ????????. ???????? ??? ??? ?? ???????????? ?????? ????? ????? ???????? ?? ?? ????? ??? ?? ??? ???????????. ?? ??? ??? ??? 8.0????? ?????? ??????. \n??? ????? ??: ??? ????? ??? ??????. \n????? : 20(??????????? ??? ????? ?????? ?????? ?????) 81??? : ?????? ????????? ???????? ??? ???? ????? ????? ????? ?? ??? ???????? ??? ????? ????????. ?????? ??? ?????? ??? ?? ??? ????? ?????? ????? ??? 3??? ?????? ????? ???????????. ?? ??? ??? ??? 8.0????? ?????? ??????. \n??? ????? ??: ??? ????? ??? ??????. \n????? : 10(??????????? ??? ????? ?????? ?????? ?????) 82???? : ?????? ????????? ???????? ????????? ????????(??? ?????) ????? ????? ?? ??? ?????? ??????????? ???????????? ??? ????? ????????. ?? ??? ??? ??? 8.0????? ?????? ??????. \n??? ????? ??: ??? ????? ??? ??????. \n????? : 5(??????????? ??? ????? ?????? ?????? ?????) 83c??? : ????????? ??? ????? ?????? ????????? ????? ?????? ????? ????????. FALSE?? ??????? ????? ?????? ??????. ??? ????? ???????? ??? ???? ????? ??? ?? ???????? TRUE?? ?????????. ??? ????? ??: TRUE | FALSE ????? : TRUE 84????: ??? ??? ???, DML ?? ??? DDL ??? ????? ????? ??? ????? ????? ??? ????? ????? ????? ????? ????????. ????? ????? ????? ????????? ????? Concepts ?????? ?????????. ??? ????? ??: 0 - ??? ????? ??? ??????. ?????: ???: 2 * SORT_AREA_SIZE ??????? ?? 85,??? : TRUE?? ????? ??? ?????? ???? ?????? ??? ????? ????? ?? ??? ????? ????????. Oracle?? ????? ???????? ??? ???????? ???? TRUE ??? ???????? ????????. ??? ????? ??: TRUE | FALSE ????? : TRUE 86???? : ??? ????? ?? ??? ???????? ????? ??? ??? ????? ??? ????????. ?? ??? Oracle ???(MAX_IO_SIZE / DB_BLOCK_SIZE)??? ?????? ??? ????? ??? ????? ?????? ??? ????? ?????. Oracle?? ??? ????? ???? ??? R / M <= Po2(M/C) ????? ?????? ????????. ??? ????? ??: ??? ????? ??? ??????. ????? : ????? ??? ??????. 0??? ????? 87???? : ????? ????? ???(SGA)?? ????? ?? ??? ????? ????????. SGA?? ??? ????? ??? ?? ??????? ????????? ????????. 64??? ????????? ?? ???????? ?????? ??? ?? ??? 32????? ????????. ?????? ??? ??? ???????? ?????? ??? ??? ????? ????????. ??? ????? ??: ??? ?????????. ????? : 0 88_??? : ????? ?????(HS) ???????? ??? ??? ????? ????????? ???????????. ?????? ??? ????? ???????? ??? ????? ????? ?? ??? ??? ???????? ???????? ????? ????? ???????? ?????????. ??? ????? ??: TRUE | FALSE ????? : TRUE 89???? : ??? ??????? ????? ??? ??????? ????? ???????? ??? ????????. ?? ???????? ??? ??? ????? 3????? ?????? ??? ??? ????? ????? ??????? ????? ??? ??? ??? ??? ?? ?????? ?? ??????. ??? ????? ??: ????? ??? ??????? ??? ????????. (???: IFILE = parameter_file_name) ????? : NULL 90l??? : ?????? ????????? ???????? ??? ???????? ????? ????? ????? ?????? ????? ????? ????????. ?????? ????? ??? ????? ???? ??? ???????? ????? ?? ????????. \n??? ????? ??: ????? ????? ??? ????? ?????????. \n????? : NULL 91 ???? : ???????? ?????? ??? ??? ????? ????????. ?? ??? ??? ??? 8.1????? ?????? ??????. ??? ????? ??: ??? ????? ????? ????????. ????? : NULL 92p??? : ??? ???????? ??? ????? ????? ????? ?? ?? ????????? ???????? ?????? ????????. INSTANCE_NAME?? ????? ????? ??? ?????? ??? ?????? ?????? ?????? SID?? ?????? ??????. ??? ????? ??: ??? ?????????. ????? : ????????? SID 93???? : ?????? ????????? ???????? ???? ??? ??????? FREELIST GROUPS?? ?????? ????? ????????? ??? ????? ??? ????? ??? ????? ???? ?????? ????? ??? ????? ????????. ALTER TABLE ... ALLOCATE EXTENT ??? INSTANCE ??? ?? ??? ?????? ?? ???????? ??? ????? ?????? ???????? \nn??? ????? ??: 1 - MAX_INSTANCES?????. (????????? ??? ?? ?????) \n????? : ??? ????? ????? ???(?????? ??? ????? ??? ???????? ????? INSTANCE_NUMBER ??? ??? ???) 94???? : ?????? Java ?????? ????? ????? ?? ??? ?????? ??? ????? ????? ????? ????????. ??? ????????? ?????? ??? ????????? ????? Java ????? ????????. ?????? ??? ???? ??? Java ????? ?? ??? ?????? ?? ????? ????? ???? ????? ????????. ??? ????? ??: ??? ????? ??? ??????. ????? : 0 95????: ??? ??? ?? Java ??? ?????? ????? Java ????? ????? Java ?????? ????? ????? ???? ??? ?????? ????? ??????? Java ?? ?????? ????? ????? ????? ????????. ????? ????? ????? ????????? ????? Java Developer's Guide?? ?????????. ??? ????? ??: ??? ????? ??? ??????. ?????: ??? ????? ??? ??????. 96S??? : Java ?????? ?????? Java ?????? '???? ???'?? ????? ????? ????????. ?????? ??? ???? ??? Java ????? ??? ??? ?????? ?????? ??? Oracle?? ????? ?????? ??? ????? ??????? ????????. ??? ????? ??: 0 - 4GB ????? : 0 97 ???? : ????? ?????? ????? ????? ???????? ?? SNPn ???????? ???????? ??? ????? ?? ????? ????????. ??? ????? ??: 1 - 3600 ????? : 60 98 ???? : ??? ??? ??? ?????? ????? ??? ????? ????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 99x??? : ????? ?????? ????? ????? ?????? ?? SNP ??? ????? ???????? ??(SNP0, ... SNP9, SNPA, ... SNPZ)?? ????????. ????? ?????? ?????? ???????? DBMS_JOB?? ??? ????? ????? ???????? ?? ??????? ??? 1 ?????? ?????????. ??? ????? ??: 0 - 36 ????? : 0 100 ???? : ???? ????? ??? ??? ????? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 16KB(?????)??? 64MB(?????)?????. ????? : 16KB 101???? : ??? ????? ??? ?????, ????? ????? ??? ??? ?? RMAN ???, ????? ????? ??? ????? ?????? ???? ?? ??? ??? ????? ????????. ??? ????? ??: 600K(?????)??? >= 20000M(?????? ??? ????? ??? ???)?????. ????? : 0(??? ??? ??? DBWR_IO_SLAVES?? ?????? ??? ???) 102???? : LGWR ???????? ??? ??? ??? ????? ??? ?????? ??? ????? ????? ?? ?????? ????? ???????? ??? ????????. ????? ???????? ????? ????? ???????? ??? ??? ?????? ??? ???????? ????? ?????? ????????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 0??? ????? ??? ??????????. ????? : 0 103???? : ????? ?????? ??? ????? ????? ??? ??? ????????. ?? ??? ??? ?????? RESTRICTED SESSION ????? ???? ?????? ????? ????? ?? ??????. ??? ??? ?????? ?????? ??? ????? ???????? ??? ??????? ??? ?????. ??? ????? ??: 0??? ??? ?????? ??????????. ????? : 0 104l??? : ??????????? ????? ?? ??? ??? ????? ??? ????????. ??? ??? ??? ???????? ????? ???????? ??? ???????? ??????. LICENSE_MAX_SESSIONS?? LICENSE_MAX_USERS ??? ?? ?? 0????? ?????. ??? ????? ??: 0??? ????? ?????? ??????????. ????? : 0 105???? : ??? ????? ??? ??? ??? ????? ????????. ?? ??? ??? ?????? ??? ?????? ????? ?? ????? ALERT ????? ??????? ????????. RESTRICTED SESSION ????? ???? ?????? ????? ?? ?????? ??? ????? ?????? ????? ??? ??????? ????????. ??? ????? ??: 0 - LICENSE_MAX_SESSIONS ????? : 0 106???? : ?????? ????????? ???????? ??? ??????? ???? ????? ??? ??? ????????. ??? ??? L = R + (R*(N - 1))/N ?????? ????? ?? ??????. ?? ?? R?? ????? ??, N?? ??? ??? ??, L?? ??? ??? ??????. \n??? ????? ??: 512(?????)??????? ?????? ??? ????? ??? ??????. \n????? : 12000 107???? : ?????? ????????? ???????? PROCESSES ???????? ??? ?????? ??? ??? ?????? ??? ????????. ?????? ????? ??? ????? ???????? ?????? ??? ?????????. \n??? ????? ??: 36(?????)??? PROCESSES + MAX_INSTANCES + ??? ???(?????)????????. \n????? : 64 + ?????? ??????? ??? ?????? ?? 108???? : ?????? ????????? ???????? ?? ??? ????? ???????? ??? ?? ??? ????? ??? ????????. ????? ??? 2 * DML_LOCKS ??? ?? 20??? ????? ?????? ???????? ??? ????? ????? ?????. \n??? ????? ??: 256(?????)??????? ?????? ??? ????? ??? ??????. \n????? : 6000 109[??? : ????? ?????? ????????? ???????? Oracle Net ?????? ?????? Oracle Net ??? ????????. ?? ???????? ??? ?????? ???????? ????? ???????? ??? ?????? ????????. ?? ???????? ??? ??? 8.1????? ?????? ??? MTS_LISTENER_ADDRESS?? MTS_MULTIPLE_LISTENERS ?????????? ??? ????????. ??? ????? ??: ????? Oracle Net ??? ????????. ????? : (ADDRESS_LIST=(Address=(Protocol=TCP)(Host=localhost)(Port=1521)) (Address=(Protocol=IPC)(Key=DBname))) 110???? : ??? ??? ?????(DLM)?? ??? ????? ?????? ??? ?????? ??????????? ????????. ????? ???????? ????? ????????? ????? ???? ???? ??? ??? ??????????? ??? ??? ?? ??? ?????? ?????. ??? ????? ??: ??? 8??? ??? ????? ?????? ??????. ????? : NULL 111 ???? : ??? SGA?? ????? ?????? ??? ?? ????????. ?? ????? ??????? ??? ????????? ????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 112N??? : ??? SGA?? ??? ????? ????? ?????? ??? ?? ????????. ?? ????? ??????? ??? ????????? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: ??? ??? ??????????. ????? : ??? ??? ????? 113???? : ?? ?????? ????? ????? ??? ??? ???(??? ??? ???)?? ????????. ?? ???????? LOG_ARCHIVE_BUFFERS?? ??? ?????? ????? ?????? ??? ????? ????? ????? ???????? ??? ??? ????? ????? ??? ?????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 1??? ??? ??? ?????????????. ????? : ??? ??? ????? 114???? : ?????? ????? ???? ?????? ????? ??? ????????. ?? ???????? LOG_ARCHIVE_BUFFER_SIZE?? ??? ??? ????? ????? ????? ???????? ??? ??? ????? ????? ??? ?????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: ??? ??? ??????????. ????? :??? ??? ????? 115???? : ??????????? ARCHIVELOG ????? ??? ?????? ???????? ??? ?????? ??????????? ?????? ????? ??? ????????. 8.1 Enterprise Edition????? LOG_ARCHIVE_DEST_n?? ???? ?????? ?????. ??? ????? ??: NULL ????? ??? ??? ??? ????? ????? ????? ??? ??? ?? ??? ????????. ????? : NULL 116???? : ???????? ??? ??? ????? ????? ?? ??? 5??? ???(LOCATION??? ????) ??? ???(SERVICE?? ????) ???? ?? ????? ????????. ?? ???????? Enterprise Edition Oracle8i ????????? ????? ??????? ????????. ??? ????? ??: ???: (null_string | SERVICE=tnsnames-service |LOCATION=directory-spec)[MANDATORY | OPTIONAL][REOPEN=integer] ????? : NULL 117???? : ???????? ??? ??? ????? ????? ?? ??? 5??? ???(LOCATION??? ????) ??? ???(SERVICE?? ????) ???? ?? ????? ????????. ?? ???????? Enterprise Edition Oracle8i ????????? ????? ??????? ????????. ??? ????? ??: ???: (null_string | SERVICE=tnsnames-service |LOCATION=directory-spec)[MANDATORY | OPTIONAL][REOPEN=integer] ????? : NULL 118???? : ???????? ??? ??? ????? ????? ?? ??? 5??? ???(LOCATION??? ????) ??? ???(SERVICE?? ????) ???? ?? ????? ????????. ?? ???????? Enterprise Edition Oracle8i ????????? ????? ??????? ????????. ??? ????? ??: ???: (null_string | SERVICE=tnsnames-service |LOCATION=directory-spec)[MANDATORY | OPTIONAL][REOPEN=integer] ????? : NULL 119???? : ???????? ??? ??? ????? ????? ?? ??? 5??? ???(LOCATION??? ????) ??? ???(SERVICE?? ????) ???? ?? ????? ????????. ?? ???????? Enterprise Edition Oracle8i ????????? ????? ??????? ????????. ??? ????? ??: ???: (null_string | SERVICE=tnsnames-service |LOCATION=directory-spec)[MANDATORY | OPTIONAL][REOPEN=integer] ????? : NULL 120???? : ???????? ??? ??? ????? ????? ?? ??? 5??? ???(LOCATION??? ????) ??? ???(SERVICE?? ????) ???? ?? ?????? ????????. ?? ???????? Enterprise Edition Oracle8i ????????? ????? ??????? ????????. ??? ????? ??: ???: (null_string | SERVICE=tnsnames-service |LOCATION=directory-spec)[MANDATORY | OPTIONAL][REOPEN=integer] ????? : NULL 121n??? : ??? ???????? ??? ???? ???????? ????? ????? ????????. (LOG_ARCHIVE_DEST_1??? ?????) ?????? ??? ??? ????? ????????? ????? ?????? ??? ?????? ????? ??? ????? ?????? ?????? ????????. ??? ????? ??: ENABLE | DEFER ????? : ENABLE 122n??? : ??? ???????? ??? ???? ???????? ????? ????? ????????. (LOG_ARCHIVE_DEST_2??? ?????) ?????? ??? ??? ????? ????????? ????? ?????? ??? ?????? ????? ??? ????? ?????? ?????? ????????. ??? ????? ??: ENABLE | DEFER ????? : ENABLE 123n??? : ??? ???????? ??? ???? ???????? ????? ????? ????????. (LOG_ARCHIVE_DEST_3??? ?????) ?????? ??? ??? ????? ????????? ????? ?????? ??? ?????? ????? ??? ????? ?????? ?????? ????????. ??? ????? ??: ENABLE | DEFER ????? : ENABLE 124n??? : ??? ???????? ??? ???? ???????? ????? ????? ????????. (LOG_ARCHIVE_DEST_4??? ?????) ?????? ??? ??? ????? ????????? ????? ?????? ??? ?????? ????? ??? ????? ?????? ?????? ????????. ??? ????? ??: ENABLE | DEFER ????? : ENABLE 125n??? : ??? ???????? ??? ???? ???????? ????? ????? ????????. (LOG_ARCHIVE_DEST_5??? ?????) ?????? ??? ??? ????? ????????? ????? ?????? ??? ?????? ????? ??? ????? ?????? ?????? ????????. ??? ????? ??: ENABLE | DEFER ????? : ENABLE 126J??? : LOG_ARCHIVE_DEST?? ??? ????? ?????? ????? ????????. ?? ???????? Oracle8i Enterprise Edition??? LOG_ARCHIVE_DEST_n??? ??????????. ??? ????? ??: NULL ????? ??? ??? ??? ????? ????? ????? ??? ?? ??? ????????. ????? : NULL 127???? : LOG_ARCHIVE_FORMAT?? ??????????? ARCHIVELOG ????? ??? ????? ?? ??????. ???? %s(??? ?????? ???) ?? %t(????? ???)??(??) ????? ????? ?????? ?????? ???????? ??? ??? ????? ????? ??? ????? ????????. ?? ?????? LOG_ARCHIVE_DEST ???????? ????????. ??? ????? ??: ????? ??? ??? ????????. ????? : ??? ????? ??? ??? 128L??? : ????? ARCH ???????? ??? ????????. ?? ??? LOG_ARCHIVE_START = TRUE?? ????? ??? ?????? ??? ?? ???????? SQL*Plus ??? SQL ????? ??? ARCH ???????? ????? ?? ????????. ??? ????? ??: 1?? 10 ????? ??? ????????. ????? : 1 129_??? : ??? ????? ?????? ??? ?????? ??? ??? ???? ??? ????????. ?? ??? LOG_ARCHIVE_DEST_n?? MANDATORY ???? ????? ????? ????? ?????. ??? ????? ??: 1 - 5?????. (LOG_ARCHIVE_DEST ?? LOG_ARCHIVE_DUPLEX_DEST?? ??? ????? ?????? 1 - 2?? ?????) ????? : 1 130???? : ??????????? ARCHIVELOG ????? ??? ??? ????? ????? ??? ????? ??? ??? ?????? ?????? ????? ????????. ?????? ??? ???????? ?????? TRUE?????. ?? ??? ?????? ????? ?????? ????? ?????? ??? ALTER SYSTEM ARCHIVE LOG ... ????? ????? ??? ????? ????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 131???? : COMPATIBILITY ??????? ??? 7.2.0 ????? ??? ??? ??? ??? ????? ??? ????? ??? ??? ?????? ?????? ????? ????????. ????? ??? ???? ??? ????? ????? ??? ????? ??? ????? ????? ??? ?? ???????? TRUE?? ?????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. \n??? ????? ??: TRUE | FALSE ????? : FALSE 132P??? : ??? ????? LGWR?? ??? ??? ??? ????? ?????? ??? ????? ??????? ??? ?????? ????? ????? ????????. ??? ????? ????????? ????? ???? ??? ????? ????????. ??? ??? ????? ????? ??? ??? ???????? ??? ??? ???????? ?? ??? 65536 ?????? ?????? ??? ??? ??? ?????? ??? ?? ??????. ??? ????? ??: ??? ????? ??? ??????. ????? : ??? 500K ??? 128K * CPU_COUNT, ?? ?? ????? ?? ?? ?? 133??? : ????????? ?????? ??? ??? ??? ????? ??? ?? OS ???(????????? ????? ???)?? ??? ????????. ????????? ?? ??? ?????? ??? ??? ??? ??? ????????. ?? ??? ????? ????? ?????? ????? ????? ????? ???????? ????? ????? ????? ????? ?? ??????. ??? ????? ??: ?????????. (0?? ??????? ?? ??????? ????? ?????) ????? : ??? ????? ??? ??? 134}???: ??? ????????? ????? ??????? ??? ???(??)?? ????????. ??? ??? ??? 0??? ??????? ??? ??? ????????? ???????????. ??? ??? ??????? ?????? ??? ????? ???????? ????? ????? ????? ????? ?? ??????. ??? ????? ??: 0 - ????? ?????: 1800?? 135 ???? : ???????? ????? ??? ????? ????????. ?? ???????? ?????? ????????? ????? ????? ???????? ????? ?? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 136$??? : ??? ????????? ??? ??? ??? ????? ???? ????????? ??? ??? ??? ?? ??? ?????? ????????. ??? ????? ??? ??????????? ????? ?? ??? ????? ???? ???????????? ?????? ?????. ?? ???????? Oracle8??? LOG_FILE_NAME_CONVERT?? ??????????. ??? ????? ??: ????? ???/??? ???, ???: ''??? ??? ????? ???/??? ???'',''???? ??? ????? ???/??? ???'' ????? : NULL 137+??? : ??? ????????? ??? ??? ??? ????? ???? ????????? ??? ??? ??? ?? ??? ?????? ????????. ??? ????? ??? ??????????? ????? ?? ??? ????? ???? ???????????? ?????? ?????. ?? ???????? Oracle7?? LOG_FILE_NAME_CONVERT ???????? ????????. ??? ????? ??: ????? ???/??? ???, ???: ''??? ??? ????? ???/??? ???'',''???? ??? ????? ???/??? ???'' ????? : NULL 138???? : ???????? ?? ?? ??? ??? ??? ????? ??? ????? ????????. ??? ??? ???? ????? ????? ?? ????? ?? ??? ??? ??? ?????? ????????. ?? ??? ????? SGA ????? ?????? ?? ??????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 2 - 255(MAXLOGFILES*MAXLOGMEMBERS?? ????????? ??) ????? : 255 139$??? : ????? ??? ??? ????? ????? ?? ????? ?? ??? ??? ??? ??? ????? ??? ??? ????????. ??? ?????? ?????? ????? ????? ???????? CPU ??? 2??? ?????? ??? ??? ??? ????? ?????? ?????. ??? ?????? ?????? ?????? 0??? ?????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 0(??? ??? ??? ???) - ?????????. ????? : CPU_COUNT 140???? : ??? ??? ????? ??? ?????? ??? ??? ????? ??? ????? ????? ????? ????????. ?? ????? ????? ????? LOG_SIMULTANEOUS_COPIES ??? 0 ????? ??? ??? ??? ??? ??? ????? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: ??? ????? ??? ??????. ????? : ??? ????? ??? ??? 141???? : ?????? ????????? ???????? LGWR?? ???????? SGA?? ????? SCN(????? ???? ???)?? ??? ??? ????? ????? ??? ????? ????? 100??? 1?? ????? ????????. SCN?? ???????? ???????? ??????? ?? ??? ???????? ??? ????? ????? ??????. \n??? ????? ??: 0 - 90000 \n????? : 700 142~??? : ?? ??? ????? ??? ????? ????????. ??? ????? ??? ??? ????? ?????? ??? ?? ????? ????? ?? ??????. ??? ??? ????? ??? ????? ?????? ?????? ???????? UNLIMITED?? ????????. ??? ????? ??: 0 - UNLIMITED('K' ??? 'M' ??? ??? ????) ????? : 10000??? 143???? : ??? ??? ?????? ?????? ????? ?? ??? ????????? ??? ??? ??? ????????. ?? ?????? PUBLIC?? ????? ??? ??? ?????? 2??? ??? ??? ?????? ??????? ????? ?????? ?????? ?? ??? ??? ??? MAX_ENABLED_ROLES ??? 2?? ??? ??? ????????. ??? ????? ??: 0 - 148 ????? : 20 144f??? : SGA??? ??? ?????? ????? ??? ????? ????????. ????? ????? ????? ???????? ????? ????? ???(??, INUSE ???)?? ????? ?? ??? ??? ???????? ??? ??? ????????. ??? ????? ??: 2 - 65535 ????? : max(30, TRANSACTIONS/TRANSACTIONS_PER_ROLLBACK_SEGMENT) 145???? : ??? ???????? ??? ??? ????????. MAX_TRANSACTION_BRANCHES ??? ??? ????? ?????? (MAX_TRANSACTION_BRANCHES * DISTRIBUTED_TRANSACTIONS * 72?????) ??? ??? ??? ?? ?????? ??? ??? ?? ??????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 1 - 32 ????? : 8 146????: ??? ????? ?????? ??? ????? ?????? ??? ??? ?????? ??? ????? ????????. ?? ???????? ???? ??? ???? ????? ????? ?? ???????, ????? ????? ????? ????????? ????? Administrator's Guide ?? Oracle Net Administrator's Guide?? ?????????. ??? ????? ??? ''(PROTOCOL=TCP)(DISPATCHERS=3)''?????. ??? ????? ??: ????? ??????? ???? ?????: NULL 147???? : ??? ????? ???? ????? ????? ????????. ????? ???????? ???????? ?????? ?? ?????? ???????? ???? ??? ????? ??? ????? ????????. MTS_MULTIPLE_LISTENERS=TRUE?? ????? ????? ????? ?? ????? ????? ??? ??? ????? ?????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? : (ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=7002)) ????? : NULL 148F??? : ??? ??? ?????? ????? ????? ?? ??? ??? ????? ???????? ??? ??? ????????. ??? ????? ??: ??? ????? ??? ??????. ????? : ??? ?????? ????? ??? 5?? ????? ??? ????? ?? ????? ?? ??? ?????? ?????. 149 ???? : ??? ??? ?????? ????? ????? ?? ??? ??? ??? ???????? ??? ??? ????????. ??? ????? ??: ??? ????? ??? ??????. ????? : 20 150???? : ??? ????? ????? ??? ??? ??? ????? ADDRESS_LIST ?????? ??????? ????????. TRUE?? ????? ??? MTS_LISTENER_ADDRESS ???????? ????? ??? ????? ?? ??????. (ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(PORT=5000)(HOST=zeus)) (ADDRESS=(PROTOCOL=decnet)(OBJECT=outa)(NODE=zeus)) ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 151??? : ??? ????? ??? ??? ????? ?????? ??? ????? ????????. ?????? ????? ????? ???? (??? ??? * 8?????) ??? ????????. ????? ??: MTS_RATE_LOG_SIZE=(IN_CONNECTS=4) (TOTAL_BUFFERS=32)(DEFAULTS=16). ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: DEFAULTS | EVENT_LOOPS | MESSAGES | SERVER_BUFFERS | CLIENT_BUFFERS | TOTAL_BUFFERS | IN_CONNECTS | OUT_CONNECTS | RECONNECTS ????? : ?? ??? ?????? 10 152'??? : ??? ????? ??? ????? ?????? ??? ?????? ????????. ??? 100??? 1?? ????? ????????. ????? ??: MTS_RATE_SCALE=''EVENT_LOOPS=6000)'' ??? ??? ????? ??? ????? ?? ????? ???????? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: DEFAULTS | EVENT_LOOPS | MESSAGES | SERVER_BUFFERS | CLIENT_BUFFERS | TOTAL_BUFFERS | IN_CONNECTS | OUT_CONNECTS | RECONNECTS ????? : ?? ??? ?????? 10 153 ???? : ??? ??? ?????? ???????? ????? ?? ????? ??? ???????? ??? ????????. ??? ????? ??: ??? ????? ??? ??????. ????? : 1 154???? : ??? ??? ???????? ????????? ????? ?????? ??? ??? ?????? ????? ????? ????? ????? ????????. ??? ?????? ????? ?? ??? ?????? ??????????? ???????? ?? ??? ?????? ????? ?????? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: ??? ????? ??? ??????. ????? : 0 155???? : Oracle?? ??? ????? ????? ??? ?????? ????????. ??? ???, NLS_CALENDAR?? 'Japanese Imperial'?? ?????? ??? ????? 'E YY-MM-DD'??? ????? 1997?? 5?? 15??? ??? SYSDATE?? 'H 09-05-15'?? ??? ????????. ??? ????? ??: Arabic Hijrah, English Hijrah, Gregorian, Japanese Imperial, Persian, ROC Official (Republic of China), Thai Buddha?????. ????? : Gregorian 156???: SQL ??? NLS_SORT?? ?????? ?????? ???????? ??????. ???????? WHERE ??? ????? ??? ??? ??????? ????? ??? ????? ?????? NLSSORT ????? ?????????. NLS_COMP?? ?????? ????? NLS_SORT ??? ???????? ??? ??? ?????? ??? ????? ?? ??????. ??? ????? ??: ????? ????????? ????? National Language Support Guide?? ????? ????? ????? 10????? ????? ?????: BINARY 157u???: L ??? ??? ????? ???? ???? ??? ????? ????? ?????? ????????. ?? ???????? ?????? NLS_TERRITORY?? ??? ????????. ??? ????? ??: ????? ????????? ????? National Language Support Guide?? ????? ????? ????? 10????? ????? ?????: NLS_TERRITORY??? ????? ?? 158???? : TO_CHAR ?? TO_DATE ????? ????? ??? ??? ????? ????????. ?? ???????? ?????? NLS_TERRITORY?? ??? ????????. ?? ???????? ?? ?????? ????? ????? ????? ??? ??? ?????? ????? ???? ?? ??????. ??: ''MMM/DD/YYYY'' ??? ????? ??: ????? ????? ??? ??? ????? ????? ??? ??? ?????????. ????? : ??? 159*??? : ????? ?? ??? ?? ??? ???(???, ???, AD, BC)?? ????? ????? ????????. ?? ???????? ?????? NLS_LANGUAGE?? ??? ????? ????????. ??? ????? ??: ????? ????? NLS_LANGUAGE ??????. ????? : NLS_LANGUAGE ?? 160???? : NLS_TERRITORY?? ????? ??? ??? ??? ????? ????? ?? ????????. ??? ??? ??? ????? ?? ???????? ?????? ????? ?? ????????. ????? ????? ?? ??? ??? ??? ????? ??? ?? ????? ????????. ??? ????? ??: ????? ????? ??? ????????. ????? : ??? ??? ??? 161-??? : C ??? ??? ????? ???? ??? ??? ????? ????? ?????? ????????. ?? ???????? ?????? NLS_TERRITORY?? ??? ????????. ??? ????? ??: ????? ????? NLS_TERRITORY ??????. ????? : NLS_TERRITORY??? ????? ?? 162o??? : ?????, ??? ?? ?? ???, AD, BC, ???, ????? ??? ???, ??? ??? ????? ?????? ????????? ??? ????? ????????. ??????? ?????? ???, ??????, ????? ??? ??????. ??? ????? ??: ????? ????? ??? ????????. ????? : ??? ????? ??? ??? 163???? : ??? ??? ????? ???????? ????? ????? ????????. ??? ??? ????? ??? ???(??: ??, ??? ??)?? ?????? ?????? ?????? ????? ??? ????? ??? ????? ?????? ????????. ???: <decimal_character><group_separator>. ??? ????? ??: '+', '-', '<', '>'?? ????? ????? ??? ????? ??? ????? : NLS_TERRITORY??? ????? ?? 164???? : ORDER BY ????? ???? ??? ????? ????????. ??? ????? ??? ORDER BY ????? ???? ??? ????? ??? ??? ?????? ?????. ??? ????? ??? ????? ??? ??? ????? ?????? ???????? ??? ?????? ?????? ?????. ??? ????? ??: BINARY ??? ????? ??? ??? ????????. ????? : NLS_LANGUAGE??? ????? ?? 165????: ????? ?? ??? ???, ??? ??? ???, ??? ????? ???, ??? ??? ???, ??? ISO ?? ???? ??? ????? ???? ??? ???? ????? ????????. ??????? ????? ???, ????? ?? ????????. ??? ????? ???? ????? ????? ????????? ????? National Language Support Guide?? ?????????. ??? ????? ??: ????? ????? ???? ??? ?????: ??? ????? ??? ??? 166??? : ??? ??? ????? HOUR, MINUTE, SECOND?? ????? TIME ????? ????? ?????? ?????? ????? ??? ????????. ??? : TIME '09:26:50'. (??? 7?????? ?????) ????? : NLS_TERRITORY??? ????? ?? 167???? : ??? ??? ????? HOUR, MINUTE, SECOND, TIMEZONE_HOUR, TIMEZONE_MINUTE?? ????? TIME WITH TIME ZONE ????? ????? ?????? ?????? UTC?? TZD ?? ??? ????????. UTC?? ??? ??? ?????? TZD?? ???? ??????????. ??? : TIME '09:26:50.20+ 02:00'. (??? 9?????? ?????) ????? : NLS_TERRITORY??? ????? ?? 168Q??? : NLS_TIME_FORMAT?? ???????? ????? HOUR, MINUTE, SECOND ??? ????? ????? YEAR, MONTH, DAY ??? ??????? TIMESTAMP ????? ????? ?????? ????????. ??? : TIMESTAMP '1997-01-31 09:26:50.10'. (??? 11?????? ?????) ????? : NLS_TERRITORY??? ????? ?? 169???? : NLS_TIME_TZ_FORMAT?? ?????? ?? ??? ????? ????? YEAR, MONTH, DAY ??? ????? HOUR, MINUTE, SECOND ??? ????? TIMEZONE_HOUR?? TIMEZONE_MINUTE ??? ??????? TIMESTAMP ?????? ?????? ????????. ??? : TIMESTAMP '1997- 01- 31 09:26:50+ 02: 00'. (??? 13?????? ?????) ????? : NLS_TERRITORY??? ????? ?? 170???? : Oracle7??? Oracle8i?? ????? ?? ??? ????????. TRUE?? ????? ??? SELECT ANY TABLE?? ??? SYSTEM ????? SYS ?????? ????? ???? ?§???? ?????? ??????. (Oracle7 ???) FALSE?? ??? ?????? SELECT_CATALOG_ROLE, EXECUTE_CATALOG_ROLE ??? DELETE_CATALOG_ROLE?? ???? ????? ??? SYS ????? ????? ?§???? ?? ??????. ??? ????? ??: TRUE | FALSE ????? : TRUE 171???? : ??? ??? ????? ??? ????? ????? ?? ??? ??? ??? ??? ?????? ????????. ??? ????? ??? ????? ??? ????? ?? ?????? ??? ??? ??? ??????. ??? ????? ?? ??? ????? ?????? ?????? ????? ??? ????? ????????. ??? ????? ??: 0%??? ??? ????? ??? ?????????????. ????? : 10% 172 ???? : ??? ????? ??? ????? ????? ?? ??? ??? ????? ??? ????? ?????? ????????. ??? ????? ??: 10K??? ??? ??? ??? ?????????????. ????? : 100K 173 ???? : GMS ?? ???????? ??? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: ??? ????? ??? ??????. ????? : ??? ????? ??? ??? 174???? : ????? ?? ??? ???? ?? ??? ??? ???(?????? ???)?? ??? ??? ?????? ??? ???????? ?????? ??? ??? ?????? ??? ??? PL/SQL?? ?????? PL/SQL ??? ??? ????? ????????. ?? ??? ????? ??? ?????? ??? ???????? ??? ??? ????? ????????? ????? ????? ?? ??????. ??? ????? ??: 1 ??? ??? ??? ?????????????. ????? : 64 175???? : ????? ?????? ??? ??????????? ???? ????? ?? ?? ??? ????? ??? ??? ????????. ?? ??? ??? ??????????? ??? ??? ?????? ????? ?? ????? ??? ??????????? ?????? ??? SQL ????? ????? ????????? ????? ????? ????? ?????. ??? ????? ??: 0??? 255????????. (0?? ??? ??? ?????? ??? ???) ????? : 4 176???? : XA ??? ???????? ??? ????? ??? ????? ??? ??? ????????. XA ???????? ??? ????? ??? ????? ?????? ???????? ????? ?? ????? ????? ????????. ???????? ????? ????? ?????? ???????? ????? ?????? ????? ??? ????? ????? ?? ??????. ??? ????? ??: 0 - UB4MAXVAL ????? : 4 177 ??? : ?????? ????????? ???????? ????? ?? ???? ????? ??? ???????? ????? ????????. ?? ??? GV$ ??? ?? ?????? ????? ?????? ???????? ????????. ????? ???????? ??? GV$ ??? ????? ?????? ????? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. \n??? ????? ??: ??? ????? ?????? ?????????. \n????? : ??? ??? ?????? 178 ????: ????? ????? ?????? init.ora ???????? ????? ????????. ??? ????? ??: Oracle Database Performance Tuning Guide and Reference Manual?? ?????????. 179???? : ??? ??? ????? ??? ????? ????? ????? ????? ????? ???? ??? ??? ????? ????????. ?? ??? ?????? ?????? ?????? ??? ??? ????? ??? ????? ????? ?????. ?? ??????? ??? ??? ?????? ?????? ??? ??? ????? ????? ????? ?? ????? ?????. ??? ????? ??: 0??? 100%????????. ????? : 0 180???? : ????? ????? ?§??? ????? ??? ??? ????? ??? ??? ?? ????? ????? ?????? ??? ????????. ??? ??? ?????? ?????? ?? ??? ?????? ?????? ?????. ??, ??? 50%?? ?????? ????? ?§??? ????? ????? ????? ??? ?????. ??? ????? ??: 1 - 10000 ????? : 100(????? ?§??? ????? ?????? ???) 181???? : ????? ????? ???? ????? ??? ????? ?? ?????? ?????? ????? ????? ??? ????????. ????? ??? ??? ??? ??? ????? ??? ??? ??? ?????? ?? ????? ??? ????? ????? ??? ?? ??????. ???????? 1000 ????? ??? ?????? ??? ??? ????? ?? ?? ????? ????? ?? ??????. ??? ????? ??: 4-2^32(~43??)????????. ????? : 80,000 182???? : ????? ????? ????????. RULE?? ?????? ????? ????? ?????? ??? ??? ??? ??? ??? ?????? ????????. CHOOSE?? ?????? ?????? ?????? ????? ??? ??? ??? ??? ?????? ????????. ALL_ROWS ??? FIRST_ROWS?? ?????? ??? ??? ??? ?????? ????????. ??? ????? ??: RULE | CHOOSE | FIRST_ROWS | ALL_ROWS ????? : CHOOSE 183 ???? : ???????? ?????? ????? ??? ??? ???????????. ??? ????? ??: TRUE | FALSE ????? : TRUE 184???? : ?????? ??? ??? ????? ?????? ??? ??? ??? ????????. ?????? ??? ??? ??????? ?????? ?????? ????? ??? ????? ????????. ?? ??? ??? ?????? ??? ????? ??? ????? ??? ????? ?? ????? ??? ??? ??? ????????. ??? ????? ??: 0 - 100 ????? : 100 185R??? : ?????? ?????? ????? ??? ????? ????? ??? ????? ??? ?????? ??? ??? ????????. ????? ??? ?????? ?? ??? ??? ??? ????? ??? ??? ????? ?????? ??? ????? ?? ??????. ??? ????? ??: ?????????. ????? : 5 186???? : Oracle Trace ??? ????? ??????? ??? ??? ???(??? ??? ??? .cdf?? ????? ??? ??? .dat)?? ????????. ?? ???????? NULL?? ????? ?? ??? ??? NULL?? ????? ????? ORACLE_TRACE_ENABLE = TRUE?? ??? ??? Oracle Trace ????? ????????. ??? ????? ??: ??? 16?? ????? ????? ??? ????????. (8?? ????? ??? ????? ?????? ????? ???) ????? : NULL 187??? : Oracle Trace ??? ???(.cdf)?? ????? ???(.dat) ????? ??? ???????? ?????? ????????. ??? ????? ??: ??? ?????? ?????????. ????? : ??? ??? ?????(???????? ORACLE_HOME/otrace/admin/cdf) 1889??? : Oracle Trace ??? ????? ??? ????? ????? ????? ????????. ??? ??? ????? ?? ?????? ?????? ??? ????? ??? ????????. ??? ??? 0?? ?????? ??? ????? ??????. ??? ????? ??: 0 - 4294967295 ????? : 5242880 189???? : ????? Oracle Trace ??? ????? ????????? ?? ??? TRUE?? ?????????. TRUE?? ????? ??? Oracle Trace?? ??? ????? ???? ????? ?? ??????. ????? ???????? ORACLE_TRACE_COLLECTION_NAME?? NULL?? ??? ??? ???????? Oracle Trace Manager?? ?????? ????? ????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 190???? : Oracle Trace ??? ??? ??? ???(.fdf ???)?? ????????. ?? ?????? Oracle Trace ????? ??? API?? ?????? ????? ???? ????? ??? ????? ?? ????? ????? ??? ????? ?????? ??????. Oracle?? ??? ????? ORCLED.FDF?? ????? ????????. ??? ????? ??: ??? 16?? ????? ????? ??? ????????. ????? : oracled 191 ???? : Oracle TRACE ??? ???(.fdf) ????? ????? ?????? ?????? ????????. ??? ????? ??: ??? ?????? ?????????. ????? : ORACLE_HOME/otrace/admin/fdf/(??? ????? ??? ???) 192???? : ?????? ??? ??? ??? ????? ????? ?????? ????? ????? ?????? ????????. ?? ??????? ??? ??? ?????? ??? ??? ????? ????? ????????. NULL??? ??????? OS ??? ?????? ????? ?? ??????. ??? ????? ??: ????? ?????????. ????? : ??? ??? ?????(???????? 'OPS$') 193s??? : ??? ??? ??? ??????????? ?? ?????? ??? ?????? ????????. TRUE?? ?????? ??? ????? ??? ????????? ?????? ???? ?? ????? ?????? ????????. ????? ????? ??????????? ??? ?????? ????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 194??? : ??? ????? ?????? ??? ????? ?????? ????? ???????? ??? ????? ??? ???????? ????????? ???????????. ????? ????? ?????? ????? ??? ??? ??? ?????? ?????? ??? ??? ?????? ?? ????? ????????. PARALLEL_AUTOMATIC_TUNING = TRUE?? ????? ??? ???? ?? ????????. ??? ????? ??: TRUE | FALSE ????? : PARALLEL_AUTOMATIC_TUNING = TRUE?? ????? ??? TRUE, ????? FALSE 195$??? : TRUE?? ????? ??? ??? ????? ?????? ???????? ?????? Oracle?? ????????. ?? ???????? ????? ????? ?????? ?????? ???? ??? ????? ?????? ?????. ??? ????? ??: TRUE | FALSE ????? : FALSE 196???? : ??? ??? ??? ????? ?????? ????? ??? ???(????? ??? ??? ????? ????? ?§???)?? ????? ????? ??? ????? ???? ??? ????? ????? ?? ??????. TRUE?? ????? ??? ?????? ????? ??? ????? ?? ??? ??? ?? ????? ?? ?????? ????????? ?????? ??? ???? ??????????? ?? ??????. \n??? ????? ??: TRUE | FALSE \n????? : FALSE 197???? : ??? ??? ???????? ??? ?????? ??? ??? ?????? ??? ?????? ????????. ????? ????? PARALLEL ??? INSTANCES DEFAULT?? ????? ??? ?? ???????? ??? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 0??? ?????? ??????????. ????? : ??? ????? ??? ??? 198F??? : ??? ???(??? ???, PDML(??? ????? ?????), ??? ???, ???)?? ????? ????? ????????. 2048 ??? 4096??? ?? ??? ??????? ??? ?? ??? ???? ????????. PARALLEL_AUTOMATIC_TUNING = TRUE?? ????? ??? ????? ????? ???? ???? ????? ????????. ??? ????? ??: 2148??? ??????????. ????? : PARALLEL_AUTOMATIC_TUNING?? FALSE?? ????? ??? ???????? 2148 ??? PARALLEL_AUTOMATIC_TUNING?? TRUE?? ????? ??? 4096(??? ????? ??? ???) 199???? : ?????? ????????? ???????? ??? ??? ?????? ????? ?????? ??? ?????? ????? ????? ????????. ??? ????? ??? INSTANCE_GROUPS ???????? ??? ????? ????? ???????? ??????? ??? ??? ???????? ????????. \n??? ????? ??: ??? ????? ?????? ?????????. \n????? : ??? ?????? ??? ???????? ????? ??? 200q??? : ???????? ???? ??? ??? ??? ??? ??? ??? ???????? ??? ??? ????????. ?????? ??? ?? ????? ??? ????? ??? ????? ??? ?? ????? ?????? ?????. ??? ????? ??: 0 - 256 ????? : CPU_COUNT, PARALLEL_AUTOMATIC_TUNING, PARALLEL_ADAPTIVE_MULTI_USER ??? ??? ??? 201 ??? : ??? ?????? ??????? ???? ?????? ??? ??? ????? ????? ??? ??? ?????? ????? ????????. PARALLEL_MIN_SERVERS?? 0?? ??? ??? ???? ??? ?????? ??? ?? ?????? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 0 - (SHARED_POOL_SIZE * 0.9) ????? : CPU ?? * PARALLEL_MAX_SERVERS * 1.5 * (OS ????? ??? ??? ??? CPU ?? * 5 * 1.5 * (OS ????? ???)) 202???? : ??? ????? ????? ?????? ??? ????? ????? ????? ????????. ????? ??? ??? ???????? ??? ????? ????? ?? ??? ??? ??? ??????? ?????? ????? ???????? ?????? ????? ????? ?? ???????? ?????????. ??? ????? ??: 0 - 100 ????? : 0(?? ???????? ?????? ????? ?????) 203 ???? : ??? ????? ??? ???????? ?????? ?? Oracle?? ?????? ??? ??? ???????? ??? ????? ????????. ??? ????? ??: 0??? PARALLEL_MAX_SERVERS????????. ????? : 0 204 ???? : ?????? ????????? ????? ????????? PARALLEL_SERVER?? TRUE?? ?????????. \n??? ????? ??: TRUE | FALSE \n????? : FALSE 205'??? : Oracle?? ??? ??? ???????? ????? ?? ??? ????? ????? ?? ????? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 0??? ?????????. ????? : ??? ????? ??? ??? 206???? : ??? ????? ???????? ??????. ?? ??? ????? ???????? ??? ??? SGA ????? ????? ????? ?? ????????. ?? ??????? ??? ????? ?????? SGA?? ????? ????? ????? ?? ??????. ??? ???????? ?? ??? ?????? ????????. ??? ????? ??: 0?? ??? ????? ??????. ????? : 1 207???? : ??? ??? ?? ??? ??? ??? ?????? ?? ??? ????? ???????? ?????? ??? CPU?? ????? ?? ??? ????? ??? ???????? ??? ????????. ???? ????? ????? ?? ?????? ???????? ?? ??? ????? ?????. ??? ????? ??: 0?? ??? ????? ??????. ????? : ??? ????? ??? ???(???????? 2) 208???? : ?????? ????????? ???????? ??? ???(DML ??? DDL)?? ?????? ????? ??? ????? ????? ??????? ??? ??? ????? ?? ????? ????????. ??? ?????? ??? ??? ?????? ??? ????? ????? ?? ???????? ??? ????? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. \n??? ????? ??: 0??? ??? ??? ?????????????. \n????? : 300 209???? : PARTITION_VIEW_ENABLED?? TRUE?? ????? ??? ?????? ??? ??? ?????? ?????? ????? ?§???? ???????? ????????. ?? ???????? ?????? ??? ?????? ???? ?????? ??? ??? ????? ???? ????? ?????? ??? ??? ????? ????? ?? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 210 ???? : ??? ?????? ?????? ???????????. ??? ????? ??: ??? ????? ??? ??????. ????? : ??? ????? ??? ???(/devices/pseudo/pw@0:pw) 211 ???? : ???????? ?????? ????? ??? ??? ???????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 212*??? : PL/SQL?? ????? ????? ????????. FALSE?? ????? ??? PL/SQL V3 ????? ?????? V2 ????? ????????. ????? ??? ??? PL/SQL V3?? ????? ?? ??? PL/SQL V2 ????? ????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 213???? : ?????? ??? ?????? ???????? TRUE?? ????? ??? ??? SGA ??????? ?????? ?????? ???????? ?????? ??? ????? ????? ?? ????? ?????. ????? ????? ??? ?????? ??? ?? ????? ????? ????? ????????? ????? ?????? ?????? ????? ??? ????? ????? ??? ?? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 214???? : Oracle ????? ????? ????? ?? ??? ??? ??? ????? ???????? ??? ??? ????????. ?? ??? ??? ?????(SNP)?? ??? ???(Pnnn) ???????? ??? ??? ???????? ???????? ??? ?????? ?????. ??? ????? ??: 6??? ??? ??? ??? ??????????. ????? : PARALLEL_MAX_SERVERS ??? ??? ??? 215 ???? : ??? ??? ??? ???? ????? ????????? ???????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 216M??? : ?????? ??? ???? ??? ?????? ????????? ???????????. ??? ??????? ?? ????? ?????? ??? ??? ???????? ??? ??? ?????? ?????? ?????? ??? ?????? ??? ?????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 217???? : Oracle ????? ??? ????? ?????? ??? ?????? ????? ????????. ENFORCED?? ????? ??? Oracle?? ?????? ?????? ?????? ?????. TRUSTED?? ????? ??? ????? ????? ????? ?????? ????????. STALE_TOLERATED?? ????? ??? ?????? ??? ??? ??? ?????? ?????? ??? ?????? ?????? ?? ??????. ??? ????? ??: ENFORCED, TRUSTED, STALE_TOLERATED ????? : ENFORCED 218R???: RDBMS ????? ??? ?????? ????? ?????? ???????? ????? ??? ??????? ?? ????????. ????? ????? ????? ????????? ????? Advanced Security Administrator's Guide?? ?????????. ??? ????? ??: ??? X.500 ??? ??? ????? ?? ?????: ??? 219???? : ??????? ?????? ??? ??? ???????????? ????? ????? ??????????? ????? ??? ??? ????? ??? ????? ???????? ?? ????????. TRUE?? ????? ??? ?????????????? ?????? ??? ?? ??? ??? ???????????? ?????? ??? ?§???????. ????? ??????? ???? ????? ??? ??? ?????? ?????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 220f??? : ?????? ??? ??? ????? ?????? ???????? ??? ????????. 0 ??? 1?? ??? ??????? ??? ???????? ????? ???????? ????????. ??? ????? ??: ??? ????? ??? ??????. (PARALLEL_MAX_SERVERS ??? ????? ?? ???) ????? : ??? ????? ??? ??? 221 ???? : ???????? ?????? ????? ??? ??? ???????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 222???? : ??? PL/SQL ??? ???????? ???? ?????? ??????????? ?????? ????? ??????? ?? ????????. TIMESTAMP?? ?????? ????? ??? ??? ????? ????? ?????? ???????? ????????. SIGNATURE?? ?????? ????? ????? ??? ???????? ????????. ??? ????? ??: TIMESTAMP | SIGNATURE ????? : TIMESTAMP 223???? : ??? ?????? ????? ??? ?????? ?????? ????? ?????? ????????. NONE??? ?????? Oracle?? ??? ????? ????????. EXCLUSIVE?? ?????? ?? ??? ?????? ??????????? ??? ????? ?????? ????????. SHARED?? ?????? ??? ??? ??????????? SYS ?? INTERNAL ??? ??? ?????? ????????. ??? ????? ??: NONE | SHARED | EXCLUSIVE ????? : NONE 224 ???? : REMOTE_OS_AUTHENT?? TRUE?? ?????? OS_AUTHENT_PREFIX ??? ????? ??? ????????? ????? ????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 2252??? : REMOTE_OS_ROLES?? TRUE?? ?????? ??? ????? ??? ????????? ???? ??? ????? ?? ??????. FALSE?? ?????? ??? ????????? ???? ??? ??????????? ?????? ????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 226???? : ??? ????? ???? ????? ????? ???????? ????? ????? ????????. FALSE?? ?????? ??????????? ???? ???/??? ????? ??? ????? ????????? ??? ????? ???? ??? ??? ??? ????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : TRUE(???/??? ????? ??? ?????) 227G??? : ????????? ???????? ????? ????? ??? ??? ????? ????????. FALSE?? ?????? ????? ????? ??? ????? ?????????, TRUE ????? ?????? ????? ????? ??? ????? ?????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 228???? : ????? ??? ????? ??????? ???????? ????? ??? ??? ???(??? ???, ???? ?? ????? ???)?? ?????????. ??????? ??? ??? ????? ??????? ??????????? ALTER SYSTEM ????? ?????? ?????? ?? ??????. ??? ????? ??: ????? ????? ?????????. ????? : NULL 229???? : ??? TRANSACTIONS / TRANSACTIONS_PER_ROLLBACK_SEGMENT ??? ????????? ?????? ??? ?? ????? ??? ????? ??? ???????? ????????. ???: ROLLBACK_SEGMENTS = (rbseg_name [, rbseg_name] ... ) ??? ????? ??: DBA_ROLLBACK_SEGS?? ????? ????? ??? ?????? ????????. (SYSTEM ???) ????? : NULL(??? ??? ???????? ???????? ?????) 230??? : ?? cache manager?? ????? ?????? ??? ?????? ?? ?????? ????? ??? ????? ??????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 10 - 3300 ????? : 10 231q??? : ????? ??? ?? ?? ????? ??? ????? ????????. ALWAYS?? ?????? ?????? ????? ??? ?? ????? ????????. INTENT?? ?????? SELECT FOR UPDATE?? ???? ?? ????? ???????? ??? ????? ????? ????? ????????. ??? ????? ??: ALWAYS | DEFAULT | INTENT ????? : ALWAYS 232???? : ??? ?§?????? ??? SGA?? ????? ????? ?? ??? ??????? ??? ????????. ????? ????????? ?? ??? ?????? ?????? ??? ????? ??? ?????? ??? ????? ?????? ????? ?? ??????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 10 - 32000 ????? : 10 233???? : ??? ?§?????? ??? SGA?? ????? ????? ?? ??? ??????? ??? ????????. ????? ????????? ?? ??? ?????? ?????? ??? ????? ??? ?????? ??? ????? ?????? ????? ?? ??????. ?? ???????? ??? ??? 7.3.4????? ?????? ??????. ??? ????? ??: ??? ?????????. ????? : 7 234Q??? : ????? ????? ???? ????? ????? ????? SQL ????? ????? ????????. CURSOR_SPACE_FOR_TIME = TRUE?? ????? ??? SERIAL_REUSE ??? ?????? DISABLE ??? NULL?? ????? ????? ????????. ??? ????? ??: DISABLE | SELECT | DML | PLSQL | ALL | NULL ????? : NULL 235???? : ????? ????? ????? ??? ????? ?????? ??? ????? ????? ???????? ????? ????? ??? ??? ??? ????? ?????? ????????. ?? ??? ????? ??? ????? ????? ?????? ????? ?????? ??? ????? ?????? ???? ?? ??? ????? ????? ??? ???????? ????? ?? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 236???? : Oracle Net ?????? ????? ????? ??? ??????????? ??? ??? ?????? ?????? ??? ????? ?? ??? ???????? ????? ????? ????????. ?????? ?????? ????? DB_DOMAIN ???????? ????????. ??? : SERVICE_NAMES = name1.domain, name2.domain ????? : DB_NAME.DB_DOMAIN(????? ???) 237???? : ????? ????? ??? ????? ??? ????????. ????? SQL ??? ??? ?? ??? ?????? ??? ??? ????? ??? ??? ????? ????????. ????? ??? ????? ????? ??????? ??? ?? ????? ??????? ??? ??? ????? ????????. ??? ????? ??: 0??? ??? ??? ??? ??????????. ????? : 0 238}??? : ??? ?????? ?? ?? ??? BFILE?? ??? ??? ????????. ?? ??? ?????? ????? ????? ??? ??? ????? ????? ?????? ?????. ?? ???????? ??? ??? ???????? MAX_OPEN_FILES??? ????????. ??? ????? ??: 1??? (50, OS ????? MAX_OPEN_FILES)?? ?????????. ????? : 10 239 ???? : ?????? ????? ????? ?? ??? ????????. ?????? ??? ????? ??? ?????? PROCESSES ????? ?????. ??? ????? ??: ????? ?????????. ????? : ???(1.1 * PROCESSES + 5) 240.??? : UNIX????? ?????? ???????? ????? ??? ????? SGA ????? ?????? ????????. FULL?? ?????? SGA?? ??? ????? ????????. PARTIAL?? ?????? SGA?? ?????? ??????. ??? ????? ??: FULL | PARTIAL ????? : FULL 241???? : SHARED_MEMORY_ADDRESS?? HI_SHARED_MEMORY_ADDRESS?? ????? ?? SGA?? ??? ????? ????????. ??? ????????? SGA?? ??? ????? ??? ?? ????????? ????? ???????? ??? ???????? ????????. ?? ???????? ??? 0 ??? NULL?? ??? ????? ????? ?????? ?????? ?????. ??? ????? ??: ????? ?????????. ????? : 0 242???? : ??? ???? ??? ????? ????? ????? ??? ??? ?????? ????? ?? ??? ??? ????? ????? ????????. ?? ??? ???????? ??? ????? ??? ??? ?? ?????? ?? ??? ?????? ????? ?????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 5000??? SHARED_POOL_RESERVED_SIZE????????. (????? ???) ????? : 5000 243???? : ?????? ??? ??? ????? ????? ??? ??? ?? ?????? ????? ????? ????? ???? ????? ????? ????????. ????? ???? ??? ????? ????? ????? ????? ???????? ????? ??? ????? ?????? ?? ??????? ????? ?? ??? ?????? ?????. ??? ????? ??: SHARED_POOL_RESERVED_MIN_ALLOC??? 0.5 * SHARED_POOL_SIZE????????. (????? ???) ????? : SHARED_POOL_SIZE ??? 5% 244???? : ??? ???? ????? ????? ????? ????????. ??? ????? ??? ???, ??? ??????, ??? ??? ?? ??? ??? ????? ????? ??? ????? ?????? ??????. ?? ??? ??? ?????? ??? ????? ?????? ????? ?????? ?? ??????. ??? ????? ??: 300 KB??? ??? ??? ??? ??????. ????? : 64????? ??? 64MB, ????? 16MB 245/??? : ???????? ???? ??? ??? ?????? ??? ????? ??????? ??? ????????? ???????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 1??? 3600??????. (1?? - 60??) ????? : 60(1??) 246 ???? : ??? ??? ??? ?????? ????? ??? ????? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 247g??? : ???????? ????? ??? ??? ???????? ??? ??????? ??? ????????? ???????????. ?????? ?????? ???????? ?? ??????? ??? 1 ?????? ?????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 0 - 10 ????? : 0 248???? : ??? ????? ????? ?? ????? ????? ??? ???(UGA) ?????? ??? ????? ????????. ?? ?????? ??? ?????? ????? ??? ????? ?? ??? ????? ??? UGA?? ????????. ??? ????? ??: ?? ??? ????????? ????? ?????? ????? SORT_AREA_SIZE ??????????. ????? : SORT_AREA_SIZE ?? 249%??? : SORT_AREA_SIZE?? ????? ?????? ?????? ??? ????? ????? ????? ????????. ????? ????? ?? ??? ?????? ?????? ????????. ????? ????? ?????? ????????? ?? ????? ???????????. ?????? ?????? ??? ????? ???????? ????????. ??? ????? ??: 6??? ????????? ????? ?????? ??(?????)??? ??? ??? ??? ??(?????)????????. ????? : ??? ????? ??? ??? 2500??? : ????? ?????? ??? ????? ????? ??? ??? ????? ?????? ?? ??? ??? ???????????. AUTO?? ?????? SORT_AREA_SIZE > (10 * ??? ???)?? ??? ????? ????? ?????? ????????. TRUE?? ????? ??? ????? ??? ????? ??? ????? ????? ???????? SORT_WRITE_BUFFER_SIZE ?? SORT_WRITE_BUFFERS?? ?????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: AUTO | TRUE | FALSE ????? : AUTO 251???? : ??? ????? ??? ????????? ??? ????? ????? ????? ??? ??? ????????? ????? ??? ????????. ??? ???????? SORT_AREA_SIZE??? ????? ?? ??? ????? ????????. ?? ??? ??? ?????? ?? ??? ????? ???? ?? ??? ?????? ????? ?? ????? ?? ??? ??? ??? ????? ????????. ??? ????? ??: 1??? ????? ??? ??????????. ????? : 2 252???? : ??? ????????? ????? ??? ?? ?????? ????? ??? ?????? ??? ??? ????????. ??? ??? ?????? ??? ????????. sort_read_fac = (avg_seek_time + avg_latency + blk_transfer_time) / (blk_transfer_time) ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: ??? ????? ??? ??????. ????? : ??? ????? ??? ??? 253 ??? : ?????? ????? ??? ??? ??? ????? ????? ????? ????????. ?? ??? ??? ?? ?????? ??????? ???????? ?????. ??? ????? SORT_SPACEMAP_SIZE ??? (total_sort_bytes/sort_area_size) + 64?? ????? ??? ????? ???? ????? ???? ?????? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: ??? ????? ??? ??????. ????? : ??? ????? ??? ??? 254T??? : SORT_DIRECT_WRITES ???????? TRUE?? ???????? ?? ??? ????? ????? ????????. ??? ?????? ?? ???????? ???????? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: ????? ?????????. ????? : 32768 255M??? : SORT_DIRECT_WRITES ???????? TRUE?? ???????? ?? ??? ????? ??? ????????. ??? ?????? ?? ???????? ???????? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: ????? ?????????. ????? : 2 256??? : ???????? ??????? ??? ????? ?????? ??? ?????? ????? ????????. ????? ??? ??? ??? ??? ?????? ?????? ?????? ??? ????????. ???????? ?????? ??????? ?????? ????? CPU ????? ?? ??? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 1 - 1,000,000 ????? : 2000(Oracle 7.x?? ???); 1 (Oracle 8.0?? ???); 8i????? ??? ????? 257 ????: ??? ??? ????? ?? ??? ??? ??? ????? ?????? ?? ????? ??? SELECT ????? ?????? ????? ????????. ??? ????? ??: TRUE | FALSE ?????: FALSE 258f??? : SQL ??? ????? ????????? ???????????. TRUE?? ????? ??? ??? ????? ????? ??? ????? ????????. SQL ??? ????? ????? ???????? ???????? TRUE ????? ??? ????? ????? ?????? ?????? ?????. ??? ????? ??: TRUE | FALSE ????? : FALSE 259???? : ??? ???????? ?????? ??? ????? ????????. STANDBY_ARCHIVE_DEST ?? LOG_ARCHIVE_FORMAT ??? ?????? ???? ?????? ??? ?????? ??? ??? ????? ????????. ???? ??????????? RFS ????? ARCHIVE_LOG_DEST ??? ??? ?? ??? ????????. ??? ????? ??: NULL ????? ??? ??? ??? ????? ????? ????? ???/??? ????????. ????? : NULL 260???? : ??? ????? ???? ??? ??? ??? ????? ??? ????? ????????. TRUE?? ????? ??? ?????? ??? ????? ???? ??? ??? ????? ????????. FALSE?? ????? ??? ????? ?????? ??????. TEMP_DISABLE?? ?????? ??? ????? ???????? ??? ?????? ?????? ??????. ??? ????? ??: TRUE | FALSE | TEMP_DISABLE ????? : FALSE 261???? : ??? ????? ???? ????? ?????(??: Oracle ????? ????? ?????? BACKUP ??? RESTORE) ????? ????????. TRUE ??? ??? ??? ?????? ??? ????? ???? ????? ?????? ??????? ?????? ????????. ????? ????? ????? ???????? ??? ??? FALSE ??? ?????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 262??? : ??? ?????? ????? ????? ?? ??? ??? ?????? ??? ????????. ?????? ???? ????? ???????? ??? ????? ????? ????????. ????? ???????? ??? ??? ????? ????? ????? ????? ??? ?? ??? ???????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: 0??? ??? ??? ??? ??????????. ????? : ???(SESSIONS ???????? ???) 263 ???? : ????? ????? ????????? ????????? ???????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 264???? : ?????? ????????? ???????? ?? ???????? ???? ????? ??? ????? ????? ????????. ???????? ??? ?????? ????????? ??? ???????? ????? ?? ??????. 0??? ?????? ?????? ??? ????? ??? ?????? ?????? ?????. \n??? ????? ??: 0??? ?????? ??? ????? ??????????. \n????? : 0 265@??? : ????? ??????? ??? ??? ????? ?????? ??? ????????. ?????? ???????? ?????? ??? ????? ?????? ?? ??? ????????. ??? ????? ??? ??? ??? ????? ?????? ??? ?? ??? ???????? ????? ??? ????? ?????? ????? ????? ?? ????????. ??? ????? ??? ????? ??? ??? ????? ????? ???? ????????. ??? ????? ??: ?? ????? ????????. ????? : 0(??? ??? ??? ??? ??? ???) 266§??? : ??????????? SQL ??? ?????? ?? ????? ?? ??? ??? ??? ??? ????? ????????. ??? ?????? ????? ?????? ???????? ???????? ?? ??? 0??? ????????. TRUE?? ?????? ??? ??????? ????? ??? ????? ??? ?? ?????? ????? ?? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 267r??? : ?????? ????? ????? ????? ???, ????? ???, ??? ID, ??? ??? ??? ??? ?? ???????? ????? ????? ????? ??? ?????? ?????? ????????. ????? ?????? ??? ??? ??? ????? ????? ?? ????? ?? ??????. ??? ????? ??: TRUE | FALSE ????? : TRUE 268~??? : ??? ???????? ??? ??? ????????. ?? ??? ??? ?????? SGA ????? ?????? ?????? ??? ?? ????? ??? ?????? ??? ?????? ?? ??????. ?????? ??? ?????? ??? ?????? SESSIONS ?? ?????? ?????. ??? ????? ??: ????????. ????? : ???(1.1 * SESSIONS) 269???? : ??? ???????? ????? ??? ???????? ??? ????????. ??? ?? ?????? ??? ???????? ??? ??? TRANSACTIONS ??? ?? ??????? ????? ??? ??? ????????. ??? ?????? ????? ROLLBACK_SEGMENTS ???????? ??????? ?? ??? ??? ??? ???????? ????? ?? ??????. ??? ????? ??: 1??? ??? ??? ??? ??????????. ????? : 5 270 ???? : ??? ???????? ???? ????? ??? ????? ??? ????? ????????. ?? ???????? ??? ??? 8.0????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 271??? : 4GB ????? ????? ?????? ????? ?? ??? 32??? ?????? ???? ????? ??? ??? ????? ????? ????????. ??? ????????? ????????. ??? ????? ??: TRUE | FALSE ????? : FALSE 272 ???? : ??? ????? ?????? ????? ????? ????????. ?? ???????? ??? ??? 8.1.3????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 273 274 275r??? : ????? ???????? ??????? ????? ??? ????? ????? ????? ?????? ?????? ????????. ??: NT?? ??? C:/ORACLE/UTRC; UNIX?? ??? /oracle/utrc; VMS?? ??? DISK$UR3:[ORACLE.UTRC] ??? ????? ??: ????? ??? ?????, ??????, ?????????. ????? : ??? ????? ??? ??? 276???? : ????????? ??????? PL/SQL ??? ?????? ????? ???????? ????? ?? ????? ?????. ??? ????? ???????? ???????? ??? ??? UTL_FILE_DIR ???????? ?????????. UTL_FILE_DIR ???????? ????? ????? ??????? ??? ?????? ??? ??? ??? ????? ????? ?? ??????. ??? ????? ??: ????? ????? ?????? ????????. ????? : ??? 277 ???? : ??? 7.3.3??? ?????? ??? ???? ??? ????? ????? ????? ????????. ?? ???????? ??? ??? 8.0????? ?????? ??????. ??? ????? ??: TRUE | FALSE ????? : FALSE 278???? : 2??? ???????? ?????? ????????? ?????? ????? ???????? ??? ???????? ??????? ????? ???????? ??? ???????? ????? ?? ????? ?????. ?? ???????? 2?? ????? ???????? ????? ??????????? ????? ?????? ??????. ??? ????? ??: 1 ??? >= ???????? ?????? ??????. ????? : ??? 279???? : ???????? ????? ??? ????? ????? ?? ??? SQL ??? ????? ????????. ??? ????? ??: FORCE: ??? ?????? ??????? ?????? ?????? ????? ??? ??? ??????? ????? ??? ?????? ????? ???????? ?????. EXACT: ????? SQL ??? ????? ???????? ?????. ????? : EXACT 281I??? : ?????? ??? ???????? ??? ?????? ????? ????????. ?? ???????? ARCn ???????? ??????(??? ????? ARCn??? ?????)?? ??? ????? ?? ??????. ?????? ??? ??? ???????? ??????(??? ????? ARCH?? ?????) ??? ???? ????? ??? ??? ???(RFS) ??????. ??? ????? ??: 0: ?????? ??? ??? ??? ???(?????) 1: ??? ??? ??? ?????? ??? 2: ?? ?????? ??? ????? ?????? ??? ??? 4: ?????? ??? ??? ??? 8: ?????? ??? ???? ??? ??? 16: ??? ?????? ??? ???? ??? ??? 32: ?????? ??? ???? ??????? ??? ??? 64: ARCn ?????? ??? ??? ??? ????? : 0 282a??? : ??? ?? ?§? ?????? ????? ???? ??? ????? ???? ????? ?? ??? ????????. ?? ??? ???????? ??? SGA ??? ????? ?????? ??? ??????? ??? ????????. ????? : ???: ??? ??? ????? ?????? ??? SESSIONS ??????? ??. ????? ??? ??? 0 283>??? : ????? ??? ??? ??? ????? ????? ?? ??? ????????. ?? ???????? ?????? ??? ????? ????? ????? ????? ?? ??????. ??? ????? ??: 0???? (SESSIONS - 5)??? ????? : ???: MTS_CIRCUITS ??? (SESSIONS - 5) ?? ?? ??? ?? 284 !??? : ?????? ??? 285J???: ?? ???????? ??? ????? ????? ??? ????? ????????. ??? ????? ??: 0 ??? [60, 7200]?? ??? ????????. ?????: ?????? 0??? ??? ????? ????? ??? ????? ???????????. ????? ??? ??? ??? ?? ????? ????? ????????. 2863???: 16K ????? ???? ??? ????? ????????. db_block_size?? 16K?? ??? ??? ??? ?????? ?????? ???????? ????? ?? ??????. ??? ????? ??: 0M ??? ????? 16M?????. ?????? ??? ??? ??? ????? ????????. ?????: 0M 2871???: 2K ????? ???? ??? ????? ????????. db_block_size?? 2K?? ??? ??? ??? ?????? ?????? ???????? ????? ?? ??????. ??? ????? ??: 0M ??? ????? 16M?????. ?????? ??? ??? ??? ????? ????????. ?????: 0M 2883???: 32K ????? ???? ??? ????? ????????. db_block_size?? 32K?? ??? ??? ??? ?????? ?????? ???????? ????? ?? ??????. ??? ????? ??: 0M ??? ????? 16M?????. ?????? ??? ??? ??? ????? ????????. ?????: 0M 2891???: 4K ????? ???? ??? ????? ????????. db_block_size?? 4K?? ??? ??? ??? ?????? ?????? ???????? ????? ?? ??????. ??? ????? ??: 0M ??? ????? 16M?????. ?????? ??? ??? ??? ????? ????????. ?????: 0M 2901???: 8K ????? ???? ??? ????? ????????. db_block_size?? 8K?? ??? ??? ??? ?????? ?????? ???????? ????? ?? ??????. ??? ????? ??: 0M ??? ????? 16M?????. ?????? ??? ??? ??? ????? ????????. ?????: 0M 291????: ??? ??? ????? ????? ??? ????? ???? ??? ????? ????? ?? ???????????. ????? V$DB_CACHE_ADVICE ??? ????????. ??? ????? ??: OFF--????? ?????? ????? ???? ?????? ?????? ??????. ON--????? ????????. (??: CPU ?? ????? ???????? ??? ????????.) READY--????? ???????? ????? ???? ?????? ????? ????? ????????. ?????: OFF 292 ????: ??? ??? ??? ????? ???? ??? ????? ????????. ??? ????? ??: ????? 16M?????. ?????: 48M 293V???: ????? ???, ??? ??? ?? ????? ??? ????? ???? ??? ????? ????????. ??? ????? ??: ??? ????? ?????? ????????. ???????? ?????? ?????. ???????? Oracle?? ??? ???????? ????? ????? ?? ????? ??? ????? ????? ?????. 294????: ????? ??? ?? ??? ??? ????? ???? ??? ????? ????????. ?????? ????? ??? ??? ??? ??? ??? ??? ??? ????? ??????? ??? ????? ????????. ??? ????? ??: ??? ????? ?????? ????????. ???????? ?????? ?????. ???????? Oracle?? ??? ???????? ????? ????? ?? ????? ??? ????? ????? ?????. 295 296 297 298 299O???: KEEP ??? ???? ??? ??? ????????. KEEP ??? ???? ??? ????? ??? ??? ???(??? ????? db_block_size?? ??? ?????)?????. ??? ????? ??: 0 ??? ????? ????? ????? ???(?? ??? ??? ????? ????? ?????? ??????)?????. ?????: 0M 300???: RECYCLE ??? ???? ????? ????????. RECYCLE ???? ??? ????? ??? ??? ????????. ??? ????? ??: 0 ??? ????? ????? ????? ???(?? ??? ??? ????? ????? ?????? ??????)?????. ?????: 0M 301Oracle?? DRMON ???????? ?????? ????? ????? ???????? ?????. DRMON?? ???????? ??? Oracle ???????? ???????? ???????? ?????? ?? ????????. ??? ????? ??: TRUE | FALSE?????. ?????: FALSE 302????: FAL ?????(FAL_SERVER ???????? ??? ???)?? ??? ?????? FAL ???????? ????? FAL ????????? ???????? ????????. ??????? ??? Oracle Net ????? ????????. ?? Oracle Net ????? ????? FAL ??? ???????? FAL ????????(??: ?? ???? ?????????)?? ???????? ????? ????? ????? ????????. ??? ????? ??: Oracle Net ????? ????? ????? ??????. 303i???: ?? ???? ??????????? ???? FAL ????? ????????. ??? Oracle Net ????? ????????. Oracle Net ????? ????? ???? ????????? ???????? ????? FAL ????? ???????? ????? ????? ????? ????????. ??? ????? ??: Oracle Net ????? ????? ????? ??????. 304????: ????????? ??? ???????? ??? ????? ??? ????? ?? ????? ??? ????? ????????. FAST_START_MTTR_TARGET?? ??? ??? ????? ??? MTTR(??? ??? ???) ???? ??? ????? ????????? ????? ?????? ??????? ?????? ???????? ????????. ???????? "fast start fault recovery" ????? ?????? ????? Edition??? ????????. ??? ????? ??: [0, 3600]?????. ??? ????? ??? ??? ??? ?? ????? ??? ?? ??? ????? ????? ??? ??? ????? ?? ????? ????????. ?????: 0 305 ????: ????? ??? ?????? ?????? ???? ?? ????? ??? ????? SGA?? ????? ??????. ??? ????? ??: ??? ??? ??????. ?????: 1M 306 ????: ?????? ??? ????? ????????. ??? ????? ??: ??? ??? ????? ???(????? ???) ??? Oracle Net ????? ???(tns ?????)?? ??? ??? ???????????. 307????: ??? ??? ?????? ????? ????? ????? ??? ????? ????????. ??? ????? ??: ENABLE--???? ????? ????? ??? archivelog ????? ?????????. DEFER--???? ????? ????? ?????? archivelog ????? ???????? ??????????. ALTERNATE--???? ???? ????? ????? ??? ??? ???? ????? ?? ????? ?????? ???????? ?????? archivelog ????? ???????? ??????????. 308 309 310 311????: ????? ??? ???????? ????? ?????? ????? char, varchar2, clob, nchar, nvarchar2, nclob ?? ????? ????????. ??? ??? ????? ????? ????? ??? ????? ???????. ????? ??? ????? ???????? ?? ?????? ????? ??? ?????? ??? ??? ????? ??? ????? ???? ??? ????? ?§?????? ?????. ????? ??? ????? ??? ??????. ??? ????? ??: BYTE ??? CHAR?????. ?????: nls_length_semantics?? ???? ????????? ??? ????? ????? ?§???? ????? ??????? BYTE?????. 328 ????: (TRUE?? ???) ????? ????? ????? ??????? ????? ?? ????? ?????? ???????????. ??? ????? ??: FALSE | TRUE ?????: TRUE 312???: ???????? ????? ??? ??? ???????? ?? ???? PGA ?????? ????????. ??? ????? ??? ????? ???????? ??? ?? ???????? ??? ????? ?????????. ?? ?????? SGA?? ?????? ??????. ??????????? ?????? PGA ?????? ???? ????? ?? ???????? ????????. ?? ???????? ????? ?? Oracle ???????? ???? ??? ????? ?????? ?? ???????? SGA?? ??????. ??? ?????? pga_aggregate_target?? ????? ?? ??????. ??? ????? ??: ?? ????? KB, MB, GB ????? ??????? ??? ??? K, M ??? G?? ??? ????????. ?????? 10M??? ?????? 4000G?????. ?????: ??? ????? ??? ????? ????? ????????? ????? ?????? "??????? ???"?????. 313????: PL/SQL ???????? ??? ????????. ?????? ????? ????? ????? ????? ????? ?????? ????????. ??? ????? ??: native(PL/SQL ????? ??? ????? ??????), interpreted(PL/SQL ????? PL/SQL ????? ??? ?????? ??????), debug(PL/SQL ????? ??? ????? ????? ?????? ??????), non_debug?????. ?????: " interpreted, non_debug " 314????: ????? C ????? ??? ????? ???????? ?? ?????? C ???????? ??? ?????? ????????. ?? ???????? ??? ????????. ?? ?????? ?????? ?????? make ????? ?? ???????? ???? ?????? ????????. ??? ?? ???????? ???? ??????? ??? ??? ??? make ????? ???????? ??? ????????. ??? ????? ??: C ???????? ??? ????????. ?????: ??? 315 ????: PL/SQL ???????? ??? ????????. ??? ???????? ??? ?????? ??? ????? ??? ????????? ????????. ??? ????? ??: ????????????. ?????: ??? 316 ???: ?? ???????? ??? ????? ??? ????? DLL?? ???????? ?? ?????? UNIX?? ID ??? GNU lD?? ??? ????? ??? ?????? ????????. ?? ???????? ??? ????????. ?? ?????? ?????? ?????? make ????? ?? ???????? ???? ?????? ????????. ??? ?? ???????? ???? ??????? ??? ??? ??? make ????? ???????? ??? ????????. ??? ????? ??: ????? ??? ?????????. ?????: ??? 317????: make ????? ??? ?????? ????????. make ??????(PLSQL_NATIVE_MAKE_UTILITY?? ??? ?????)?? ?? make ????? ?????? ??? ????? DLL?? ????????. ??? ?????? DLL?? ?????? make ???????? ???? ????? ?????? ????? make ????? ?? ?????? ????????. ??? ????? ??: make ????? ??? ?????????. ?????: ??? 3181???: UNIX?? make ??? gmake(GNU make)?? ??? make ???????? ??? ?????? ????????. make ???????? ????? C ?????? ??? ????? DLL?? ?????? ?? ????????. ??? ????? ??: make ???????? ??? ?????????. ?????: ??? 319????: ??? ????? ???? ??? ??? ????? ???????? ???????? ????? ????????. ????? ????????? ???????? REDO ??? ????? ?????? ??????????? ?????? REDO ??? ????? ?????? ?????? ???????? ?? "TRUE"?? ?????? ?????. ??? ????? ??: FALSE | TRUE ?????: TRUE 320§???: ?????? ??? ????? ???? ????? ????? ????? ??? ????? ????????. ??? ????? ??: ??? ????? ??? 0?????. ??? ?? ?????? ?????? ?????????? ??? ?????????. ?????: ????? ??? ??? ??? sga_max_size?? ?????? ??? ?? SGA?? ??? ???, X?? ????????. ?? ????? SGA????? ??? ??(??: ??? ???, ??? ??, ???? ?? ??) ????? ??? ??????. ??? X??? ??? ????? ??????? ??? ??? ??? sga_max_size?? ????? X?? ?????. ??, ?????(X?? ?????? ????? sga_max_size ??)?????. 321????: ??? ??? ??? ??? ??????? ????? ????? ????????. ??? ????? ??: ??? ??????? ?????: SPFILE ???????? ????? ??? ??????? ????? ????? ?????? ??? ????????? PFILE?? ????? ?? ??????. ?????? ??? ??? ??????? ????? ?????? ??? SPFILE ??? ????? ??? ???????? ????????. 322????: ???? ??????????? ??? ????? ??? ??????????? ??? ????? ?????? ????? ????????. ??? ????? ??: TRUE ??? FALSE?????. ???: ??? True?? ?????? ???? ??????????? ??? ??????????? ????? ?????? ??? ??? ??? ????????? ????? ???????? ?? ??????. ?????: FALSE?????. 323(???: ?????? ?????? ??? ??? ??? ??? ???? ????? ????????. AUTO?? ????? ??? ???????? SMU ????? ????????. ????? ??? ??? RBU ????? ????????. RBU ?????? ??? ??? ????? ??? ???????? ???????? ????????. SMU ?????? ??? ??? ????? ??? ??? ???????????? ???????? ????????. ??? ????? ??: Auto ??? Manual ?????: ????? ???????? ????? ?? UNDO_MANAGEMENT ???????? ?????? ??? MANUAL?? ?????? ?????? ???????? RBU ????? ????????. ????? ???????? ??? ??? ???????? ??? ??? ????? ???????? ????? ??? ??? ????? ????????. 324????: UNDO_RETENTION ???????? ??????????? ????? ????? ??? ??? ????? ??? ??????? ?? ????????. ??????? ??? ?????? ??? ????? ????? ?? ??????. ??? ??? ??? ??? ??? ????? ???????? ?? ????? ??? ??? ????? ??? ????? ??? ????? ?? ??????. UndoSpace = RD * UPS. ????? UndoSpace?? ??? ??? ??? ??? ?????? RD?? ?? ????? UNDO_RETENTION??? ?????? UPS?? ??? ??? ??? ??? ??? ????????. ??? ????? ??: ??? ?????? (2 ** 32)??????. ?????: 30??????. 325i???: ?????? SMU ????? RBU ???(??: ALTER ROLLBACK SEGMENT ONLINE) ????? ?????? ??? ????? ????? ?? ????? ?????. ?????? ??? ??? ?????? ?? ???????? SMU ????? ??????? ??? SMU ????? ????? ?? ??????. ??? ????? ??: True ??? False ?????: False?????. 326????: ??? ??? ???????????? ??? ??? ????? ??????? ?? ?????? ????????. UNDO_TABLESPACE?? SMU(????? ???? ??? ???) ?????? ????? ?? ??????. ????? ??? ??? ???????????, <undoname>?? ???????? ??? ????????. ???????????? ?????? ??? ???, ??? ??? ???????????? ??? ??? ??? ??? ???????? ??? ??? ??? ??? ?????? STARTUP?? ????????. ?????: ?? ??????????? 0 ??? ?? ??? ??? ??? ???????????? ????????. SMU ?????? ?? ORACLE ???????? ????? ??? ??? ???????????? ????????. 3273???: ??? ??? ??? ??? ????? ????????. ?? ???????? ??? ????? ?????? ????? ????????. ??? ????? ??: AUTO, MANUAL?????. ?????: PGA_AGGREGATE_TARGET?? ?????? ??? ?????? AUTO, ????? ??? ?????? MANUAL?????. 332 r???: ?????? ???????? ????????? (XML ??????????? ??? ???????? ?????) 333 :???: FTP ????? ?????? ??? ????????. 334 ????: FTP ????? ?????? TCP/IP ????????. ?? ???????? ??? ????? ????? ??? TNS ?????? ????????. 335 ;???: HTTP ????? ?????? ??? ????????. 336 ????: HTTP ????? ?????? TCP/IP ????????. ?? ???????? ??? ????? ????? ??? TNS ?????? ????????. 337 f???: HTTP ????? ?? ????? API??? ???????? ?????? ????? ????????. 338 U???: ??? ????? ?????? ?????? ??? ??? ACL ????????. 339 k???: ????? ????? ??? ??? ????????? ????? ?????? ??? ????????. 340 G???: HTTP ??? ?? ??? ????? ???? ??? ????????. 341 <???: HTTP ??? ??? ????? ??? ????????. 342 F???: ftp ??? ?? ??? ????? ???? ??? ????????. 343 ;???: FTP ??? ??? ????? ??? ????????. 344 =???: ????? ?????? ??? ??? ????????. 345@???: ????? ????? ?? ?????? ????? ?? ASM?? ????? ?????? ????? ????? ?????? ?? ?????? ????? ????? ??? ????????. ????? ?????? ?????? ?????? ???????? ????? ????? ????? ?????? ?????. (??: /dev/rdsk/*) 346 ????: ?? ??? IO ??? ?? ?????? ??? ????? ?? ?????? ??? ????? ????? ??? ??? ?? ??? ???(??)?????. ?????: 14400 347 ????: ?? ??? ??? ?? ??? ALTER DISKGROUP ALL MOUNT ??? ??? ?? ASM?? ??? ?????? ????? ??? ??? ????????. 348 p???: ?? ??? ????? ????? ????? ??? ASM ???????? ??? ????????. ?????: 1 349 ????: ??? ??? ?? ??? ??? ????????. Oracle?? ????? ??? ?? ????? ??? db_create_file_dest ?? db_recovery_file_dest?? ??? ?????? ?? ??? ????????. 350 M???: ????????? ??? ??? ??? ????????. ?????: 0 351 3???: SGA?? ???? ????????. ?????: 0 +oracle/sysman/resources/VtoiInitParamMsg_ko java/util/ListResourceBundle *oracle/sysman/resources/VtoiInitParamMsgID !?? ? ?? ?? ? *? ? ? "