Oracle Database 12c DBA Handbook = ORACLE qe DBAE FAH xem SRT AGZAOraclPLBRER ARM [88] Bob Brylaioce) BAe & | MEAS AtOracle Database 12c DBA BA Fit (# 8 hh) [4%] Bob Brylacoce) # HA see & MEAS MAL deoBob Bryla Oracle Database 12c DBA Handbook EISBN: 978-0-07-179878-5 Copyright © 2015 by McGraw-Hill Education. All Rights reserved. No part of this publication may be reproduced or transmitted in any form or by any means, electronic ‘or mechanical, including without limitation photocopying, recording, taping, or any database, information or retrieval system, without the prior written permission of the publisher. This authorized Chinese translation edition is jointly published by McGraw-Hill Education and Tsinghua University Press Limited. This edition is authorized for sale in the People’s Republic of China only, excluding Hong Kong, Macao SAR and Taiwan, Copyright © 2016 by McGraw-Hill Education and Tsinghua University Press Limited, WSBT AT © ALE A TEATS ME DRE ASHE MNO EAT BB) ASS CL AAO Ay A wi PEAS Hl ed. ELIAS Y SEC, Sei). aE ETA. fF ALB AT RE BE. ABEL SCIAP U1 AE BA 3 a ASAE BH FOS A A AT BS] PERS EN AEE BL ALM CEH eA ES ANT ANAS LAR UD ARES CES ATR A Ll 785 HOLD yt FEALO2O16 111 FE He SAS AS TEN) HM 2) SE EAC CE HT ILS DFE ALTAR BL AREA ec PAF: 01-2016-3097 AHEM McGraw-Hill Education QAM MRE, KARST. AGARET A, ALD. ALSHMMBIA: 010-62782989 13701121933 (8 te RiLom B (CIP) BLE Oracle Database 12e DBA 1177 Fills 38 8 M/ (2) Shi * ASEH (Bob Bryla) Sethe 16 14 1X: Oracle Database 12¢ DBA Handbook ISBN 978-7-302-44475-6 1.@o- 1. Ost IL OXF MAES SP BRING AS Pa 5 CIP Hid He 7(2016)5%5 165265 15 Wise if. db. WHER 4 —T- WV. DTP311,138-62 REM: EO TF SMART: ii BAER: RAE RECDA: KH HEART i EOI NEA FA bits hupy/[Link],_ hutp:/[Link] Ske ULAR EOLA ASE ABH: 100084 it & Ml: 01062770175 #8 BY: 010-62786544 AQIS SIRAAMS- 010-62776969. c-servicer@[Link] KR SR Re 010-62772015, zhiliang@[Link] EDS te ACHE a ATRL ETS HE # 185mm 260mm El: 40.25 FM: 1030 Fy 1 2016 HF 8 598 1 He ED 2016 HH 8 HIB 1 UREN 1: 1~3500 & 19.80 7 P=bhAi Es 067089-012 4 F (Oracle Database 12¢ DBA AUR SUES RA Iv FMS 8 WR)> HEHE. Se ASS DEE DR ASC wNe 9 Aa FAM Le FH Ae ASR cle AMIE 5 ACPA AL Re A tf AC TH PE, HEAL, ALT HE GE As Vide Le FRY AERA ANCL 4S EES ASAT AL" (KH, Oracle Database In-Memory SATE CT 2s TE TE ASF SEP eh Sp pe ee A aA 31 TAP UEA Oracle (RHF. Oracle Database 12c F244] BALA tel, SIL kay SPE AD PUA 2 BM BATE RNA MEM. TTY EE” A “EEE” be Oracle Database 12¢ He ATUFERT, HHS HU BORE, BD CE GRRE TE RE AS ENO HIRE FET ES ie ie PES BES, SE EAT SC I Be EE TTT} ey a FARE". SPH RAC, VRE RATE At, HPAL FEFE Oracle Data Guard F686. HIV ALFIE Oracle Net. FGF POPPED. (iC AWD EDA SAL Aa THUY TER, PBS SMD SSH 4) Ah SR IHN ER PURI ee MAE 6 (f] Oracle DBA iI, {SPA AAG ETN Oracle DBA AAT SAI, RS SOILS ARTEL. Wi te he Hs Bite, RGR MBE A — tht DBA fiat AOwM EFA Pe, PSTIAML. EOE. ASNUHRR ARR (EME, BOR MIE ARR AAR. MAII Oracle Database 12¢DBA BA FAN 8 Hi) AEA KUALA AHS, ARS MR. TERAVELALY, DEB TOMES, BOM T (RS PAE IE DBA THEE RT ASSERT Ps Fei ES RT F. BOR DBA RRMA RAR, ABR ASIRAIE RR, MITTEN I Oracle Be HEY 6 LI — tau! 5X EE BE TAG AE NOC EASA ATT UAT CAS aS A FL PE TE Co UAT SAC HE, I NIE RAL, AA, : ees SEBS AN. AAR ASAE Ta) SEAT LT. DPR PEL EN SS AR Hi) BAT PATTY SANE, AF AS HY ITA HN AEA ERP, SMARTIES WG, PURE ZS. TEI. FTW. NR, BEA. HRM DS Re. BAB. MPRA He PRATT “URE” NASI, FE”, FURY, HOROMIA PALA A, JR bite LAE. A, FASWKT, MMAR ZA, Mam BEATER Beit Rep FLEE! RUG, RAAB A CM RAR EER, BEAK DBA, fe TARE PAGED! BBR. HAR Wed. MILfe & ii dt Bob Bryla Xt Oracle 91, 10g, Ig Bl 2c Ui RR, CERGNIE RH. BOREISIP ARS NEL E Oracle BUH ME JSD ATA 20 TENZEH2. Bob Je Epic 23 7) ((¢ 7 BRUT REE MAE ah) (PE Oracle DBA FIRM: RAE LAM, MILES AC Oracle Press FAT MURA SAE, (4h —Be EX} Oracle Database 10g. 11g il 12¢ WAGE EARTH. UZ Ah BRE Android BAHL WETTER BR Sa Fh Scott Gossett Jt Oracle 21 ART BALIN AM, 7E Oracle RAC. HEAEIE RE AIA AT FMEA IE Ay 0d 430 23 AENIZE ME. UERT, Scott MILLE Oracle Education MZ tT VEIT 12 4F 2A, A BEVHE Oracle ABB, PERE. RAC UAB RUHEEEE. ELIF, Scott Jz Oracle HAWN Be Th eA EEE EZ, AW AE 12 AS Oracle Press {54H (KS AMAA»x it WERE BARE OHA ese, AB AAAS. CARRS EP, BRIG Oracle Open World, Oracle Support #fl Oracle Partner Network (iff % AENEFF ETE» fey ASS MT RAR: ABE S, AIA——PU, CELE — IPL. thi} McGraw-Hill Education Hfi#tft Paul Carlstroem il Amanda Russell %F, ff) 434! PAU, LAPIS AEB. LABIAL Scott Gossett, WHMCS RAAT, ABEL Ti SARIN. Epic [7] $f James Slager. Scott Hinman, Joe Obbish #1 Lonny Niederstadt “i THR 4 Witt, BRT RMAERS, RAERMAE “MAKATEN SMA A” ME. CEMA BMA, ROA LE RRL, GY LUN IRR, FRAN MT rjbdba@[Link]. —Bob Brylail a Kit 241 421) DBA, DBA ELIMITE AA DL, tbitTE T fit Oracle Database 12c (BANE, Ph See ee btaiil AL Bin PUTT. AIAG SP EH etee MAE TE ELH In-Memory i658) UA ta MOREE LH GB Oracle BURP HEE 6 BLASTS EA SA EAE) A BAG AULA SIP OPA, GELEIN. Be STAAL REE q LIAB EATS. AAR LPH, ZESPET Oracle tk AHH. Oracle Ie The iE AeA TUT. RRR ITT Rote ae BL PL A A NE EHS SEAT Co SD An ED BAR PES OR NE AE A ST AAS UL EBADAE SPATE AL LAD ID 28 EAU ME BERS AFA SPH TD FeRAM BR SLE I BSE 8 Ve ASA ok AL IE AD ES HUME Hh ANTM. HTS" RE MEANS HAGE JE Oracle Database 12c #145 AMDIGEZ Wh. "7 Oracle Database 12c (alt nitty 90) His LLG, CLA di AB EO & BI i PEA AIA) OY EA Sy SY RCRA OT CE RE EAR EB PT ER eh is APES BES, RIE ATLEAST ie ASH PLE EES, AN FE a EGE “ROR” WTAE, SSE RIAL” 95 — 4 RR, PALL ay DARA te BE AG ASR AP TFA BA ES BH 95 ASTAMIDS ATI HD FIE, SUDHA & » Bins SMH SANT FAL BY AS(Real Application Clusters, RAC). P2527 RHRMAN), fii 4f6] 445% Oracle Data Guard HE. iVIL Oracle Database 12¢ DBA B AFM(3 8 AD AR FE tS WDE a PS 2 A ad LB Sh A PE SE BV BB HPPA ITI Oracle Net, MSLACH. VL PLER. REPUTE HC AT AE, AAD A ASI) SEIN) Ai SX SAR PER Fe Pit RB IE 5 EBS SS — Me ak Se A SI Rab. TIM DBA HANA AGH he SH, ASIP 4H Oracle Enterprise Manager Cloud Control 12¢ FOR, OUT CEI PATA. FASS PIAA, BMAP ITI CA RSE, SATO IS KD MET He. SIRE ELT fe Ws EA EL, FAD PS Ah, FE HH] DE fe OF AA, BARREN HR, WR-APAA AR, ARM, MAA PRAT. ATVI) [Link] HILAR PIAHS IE 12¢ DBA Handbook Code [Link].1B Oracle th RA HLA. BBS BGRRARRAY LL BGR ERIS MEd LL Bae 112 Sf ~ 1.2 Oracle 124077 iH S549 12D RE fe 12.2 the 123° &E~ 124 B 1.3 Oracle 3 28H 131 Ben ee 14 13.5 FIP ABE 13.6 RR 13.7 FRR = 13.8 FIR ~ 13.9 PLISQI 13.10 SABC PR a ~~ 13.11 Bei EEA RR StH Oracle YI ERAT (ii it 23 14.1 Batct 24VIII Oracle Database 12cDBA BH FAH 8 hi) 19 1.10 Ll 112 142 ALAR 24 143 HEISE ener 4 144 JME 25 14S Wb SHOE 25 1.4.6 SHURE ELAS PE 26 147 Be OPSCt~ : 148 Oracle SIBLE ~ 14.9 SCPE STC BIE MAF 15.1 Plante “28 152 FRYE TAM meme 8 Oracle Py FHF ~ 161 Re EII EE 162 BUF E RAB 1.63. arb Rabe 164 ifthe ~ IR SL 171 GI EA- 1.7.2 BBL 1.7.3 UBL GD ~ 1.7.4. RMAN: 36 RETIN 36 18.1 BORLA fern 7 18.2 i penn 37 1.8.3 RRBRONG 38 1.84 Mest Bea “38 18.5 bie ete SEIN ATE Oracle ii Oracle eb A3828 Oracle Hi Bak Lid aR SH 1.12.2 Rie BH 4 ATE ANE: 5 #82 Oracle Database 12c--47 RABY Fr PRO HHE THe {WU DBUA : 24 25 26 27 28 B38 3. 32 42 PAT FAD TB ee SL 4%) Data Pump Export Hil Impo fesnsn 2.5.1 {iH Export M1 Import Bi 252 IITA EF GE SS HT: FEBS nnn ARNG EN FA Be SEG] one 57 AEM RS 58 BLD RAEI Morne $B 3.12 OFA 64 Oracle 2:48 4 68 3.2.1 SYSTEM ee 68 3.22 SYSAUX* 68 3.23 TEMPr rnin 68 3.2.4 UNDOTBS! rorreneneenenen GQ) 3.2.5. USERS 69 3.2.6 EXAMPLE errs 69 BU ARB Ise UES SMTHe ee 71 MEERA EL LAIN nee TD, 411 BURRS VE SCY Keb 412 Walters 4.13 WANPRBLTEMEL “81 ALA BAIL ff meno 83 ELBIT FARE BB | 4.2.1 ASM RAE HI 85 4.2.2 GRE ASM Efile 86 4.23. ASM Seialf 88 4.24 ASM abst feel 4.2.5 ASM SCPE OL 4.2.6 ASM SPP IED ABE 93 4.2.7 AESHLASM BERLE om 9443 BSR sl 5.2 53 54 55 5.6 5.7 AI SR RUSE FRAOL TS AF WHET: BEES: Sad S12 5.13 HORS BT EDA Le S14 515 RAC Ee ML wt DPF Me Bt 5.1.6 Ew SAT MEATS BUR 5.2.1 SELB EEA EE 5.2.2 ARERR MERE RAY Kyo 5.2.3 (RAID ae SEE EF tll BAER Hyde S31 (TDR SUI ~ 53.2 gestae smn 53.3 RR MR IU HE Oat Ral (stirHb eae ~ SAFE S51 PRR Ko 5.5.2 Bibb ER PEE E TR 5.6.1 AeA 5.6.2 UTR 5.63 wae 5.6.4 5.6.5 5.6.6 3.6.7 5.6.8 5.6.9 AR FOARTER « duTita) Seika tit WR EY i BO 6.1 62 63 64 65 6.6 6.12 6.13 6.14 Oracle Bk. ht be AB: 621 6.22 623 Rit PAH ET Fe eb 2p Ve en ABR 145, HUE BRK Be BCH FUL Pla AS HERE 63.2 DBA SEGMENTS 63.3 DBA_EXTENTS 634 DBA FREE SPACE~~~~151 63.5 DBA_LMT_FREE_ SPACE 152 63.6 DBA_THRESHOLDS~~~~ 152 63.7 DBA_OUTSTANDING_ ALERTS 638 DBA_OBJECT_USAGE~152 63.9 DBA_ALERT_HISTORY'~ 153 63.10 VSALERT_TYPES-~~~-~ 153 63.11 VSUNDOSTAT ===" 153 63.12 VSSORT_SEGMENT ~~ 154 63.13 VSTEMPSEG_USAGE~~ 154 Efe Ae 6.4.1 AHA ITEE MI Ze HEI 642 48H] OME fi 643 KURI 644 air iiit 6.4.5 NTSB EET 160 SYSAUX Hi#e ANE ABBA Vy SAD fe ETL SCY EEBTR X_ Oracle Database 12cDBA BA FANS 8 Hl 6.7.1 BRB 163 627.2. SAN La A Sh “ei 166 673 HOLA 167 6.74 SEIRTAIL RSE HES 169 6.75 HUBLI SHE mm IL 6.7.6 JELADR SPS S48 FlatsAl shane “174 6.7.7 OS (aE 68 Fela TIA 68.1 GP SPALATI ELEK YE 176 6.8.2 EILAMBAN CC ET aU eT 6.9 Hentai 69.1 ti} DBMS_ SCHEDULER 178 6.9.2 Cloud Control #MIML FE 178 6.10 AR ei eee 1 72 721 (liR~ 7.2.2 ik —-Bitt ~ 7.2.3 BOR MEDR SL: 7.2.4 PAlBLRTE SHUN Rael ‘Cyaan eee) REN Mea AE BE ‘Hath dee fe BAB M- SPM AEE LA] more STA) BY A A 73 14 TAL Flashback Query (PALE) 203 15 1.6 Boe 8.1 82 83 84 8.5 742 743 DBMS_FLASHBACK ~"204 Flashback Transaction Backout (ALE 55 #81) 206 7.44 Flashback Table((*IE1%)~~207 7.4.5. Flashback Version Query (BABAR AY) mm 208 7.4.6 Flashback Transaction Query (PAB it 7.4.7 Flash Data Archive (ALBIS T)~ 748 (AI515 LOB SEBEL A SHAT E, ARNG SURES WE A BL 220 R11 AMRIT 220 8.1.2 CPU RMSE ME 221 8.13 aR it SQL 8.2.1 NUR naa REIN 8.2.2 Seba Liki 8.23 “En Ati Ll TARE FP 83.1 HESGA Tt 83.2 fH SGA MA 231 8.3.3 PET AMIR 232 REBAR 5 84.1 IRE 8.4.2 (UROL: “234 843 HalM SAMRAT 235 ASR BRIE +236 85.1 HMA: fii SQL*Loader Direct Path iis 236 85.2 HRM A. IRE geno 237 85.3 HAMA: ILIAD HBT 2388.5.4 HtHtMbR: TRUNCATE 87 88 8.9 8.10 8 BOR 91 8.6.1 HALL BR tlt 8.62 sWILMCRRLLARIAPH ~~ {] AWR- 8.7.1 TEARBRE a72 873 874 ALR AWR HE SEF Automatic Database Diagnostic Monitor #8 ~~ 8.7.5 (HUH ES) SQL i eR BAP RSH HT Be i 8.8.1 BEATE 88.2 ite CDB 8.8.3 1k ANTF Rial ~ 8.84 4A AWRAIL 8.8.5 H/F] SQL ia REM 245 4S #2 PDB hi vet Ae 8.9.1 (JA GHLK #8 PDB fa wore} -252 8.9.2 JAANE Resource Manager ibe “253 TUT GRE i 257 8.10.1 A TIREEMEL Seti 8.10.2 ARERR I Shi 8.10.3 AEH REE LANE TH Si 258 8.104 {EHP CDB bi HF Benne 258 8.10.5 SiiiE AAA ME “258 AR A 258 In-Memory ssi 261 Oracle In-Memory 350) #628 +261 9.2 93 #108 10. 10. 10. 10. 1 2 5 8 9.1 RECA CEL ~ 9.1.2 In-Memory 2 (5 HOES SUL 9.2.1 VSIM_SEGMENTS~~~~-~-266 9.2.2. VSINMEMORY_AREA “267 9.23 VSSGA- 267 Kh RURERSA MBE APRA ER Be HE SED CEA TE 10.2.1 BAR FE RIE “--~ 10.2.2 MR ot BREE nn BE RA ta Fae ME SBS ORE SP AE marie supe HE ITIA: ROR E REIL BI i fol. ShcA Siti 296 48D VPD SRSA RAR ce dae ae tT Be ALLA BTR SURE HELIN ER SSA ANB Tt BLED nn TRAP TERE 10.4.7 SIMBA 10.5.1 DBMS_CRYPTOXII Oracle Database 12¢DBA BFA 8 HR) 10.6 Bue Ma M2 113 4 1s 10.5.2 0H) Seat Ne SAP RRERRE 331 FEES ALP ARR Gh 33. TAL AUP SARL RPE 333 N12 FREE ALP RBE 333 HES ALP SRE BAUR 335 V2.1 SBR ATH A Rea FIR 11.2.2 RUMOR CD 1123 SSOP ese pa PPrnsennrnrneee 349 11.24 i PDB -~- 1125 PAE PDB FHL CDB All PDB 113.1 388% CDB #1 PDB TRI 352 11.3.2 f8F] SQL Developer if 1 CDB a PDB 353 1133 3s CDBaL PDB arte Mp 384 113.4 4 CDB HERE HE 355 113.5 kiahAI3&ia) CDB PDB moe 355, 113.6 Wa CDB nyse 362 11.3.7 $38 CDB fl PDB +f) AA AIG BEE fi 363, BHP ES 366 14.1 SEERA SERIA S366 114.2 PERASAI ACHR 368 1143 ARASH fH 369 1144 GASERLA Rate PDB fF 370 SPR HN AL SL “372 11.3.1 MF CDB AIBA PDB ft Berner 37D 1152 %#}cDB “= 375 116 1193 115.4 i PDB: WAL EAN PDB HK Se 487] DRA ie i sh 48FL RMAN 49 th PDB Avi ~ 1S.S 11.56 15.7 SIRS FS AT A te 8128 12.1 122 123 12.4 B13 13.1 13.2 13.3 13.4 SEPT AY ARE SRA NE BE SE BE 12.1.1 EPRRGEE 121.2 SAbAGEE T213 POSEN 12.14 eA RAC #5 iE: 1221 MRI BRS EOC APEY AL 12.22 at 12.2.3 ahdstene ere RAC #4" 123.1 Fab RAC 1232 sw 12.3.3 RAC EME (di EK 12.3.4 MURS ESHA TAP 12.3.5 WHEE RAC Hi stm AAS SHRM th taht JA te i SIL te 13.3.1 ILO} 133.2 UBL Ot 48/1] Data Pump Export Ail Data Pump Import 5 RAC HIGHER HE 377 379 387 392 393 393 397 398 “398 399 399 400 400 400 401 401 03 403 404 404 “413TRA BA EL gfe 413 13.4.2 Data Pump Export ibs eee 4 13.4.3 18) Data Pump Export CS ae 13.44 Data Pump Import asi: we AT 13.5 SEBUBEBLA Bho 428 13.6 SEBUIKDL A eee 2B 13.6.1 JRGR EF): se 29 13.62 4A frIRDLE I A 430 13.7 Sen th hi Be “431 13.7.1 SAR a AEE Fe fpermnnnsennsnne 3] 13.7.2 SRA fe A ORE 432 se 433 14% (EARS SER (RMAN)--435 14.1 RMAN f+ HAIL 14.L1 RMAN iff 14.1.2 RMAN 4 feS fb Hike 437 14.1.3 Oh 439 14.2, RMAN fin Aldi BE 440 14.2.1 € RMAN 1247 SQL fir omen 440 i v 441 1423 BRYAN 442 14.24 ABDI omen 142.5 PAGE RMAN WH 445 14.2.6 MBH rm 49 142.7 Hae Ana Ast Ne we 49 143 14.3.2 frit 48 fA] ~~ 14.3.3 fe RAE SC hmmm ST 144 14.5 14.6 85a 15.1 15.2 15.3 15.4 15.5 Ba # XUL 143.4 143.5 BIR ARH Bmore ST SECA SPFILE 459 OPP Eats 459 SH 143.8 HHL RTA 14.3.9 JEN pete 14.3.10 R/T ie SLD 143.11 ig SLB fn 144d eS MSE 14.4.2 EM SCH 1443 ii AeEEO TAA BIE Ronn TL 1445 BRM tt 14.4.6 ARIE 472 144.7 BeliEHE BUR 14.4.8 Offi ete 14.49 HKU SEAbBE HE 14.5.1 ESE AO 14.5.2 SREP ~ 1453. REPORT Al LIST: Asi see 83, 143.6 143.7 Oracle Data Guard: Data Guard (4 Aw #4 15.1.1 Osa Ae A FRAN 15.12 HAR GRAB: LOG_ARCHIVE_DEST_n Skat “489 aude isennrena “489 15.3.1 HE EMU 490 15.3.2 ORR HIB 494 AT SEINE BY TES AP a Tad Bate “497XIV Oracle Database 12¢DBA BHFANS 8 HE) 15.6 15.7 15.8 B16e 16.1 16.2 16.3 16.4 16.5 fa fA HE 15.6.1 Wien 15.6.2 URES rn 500 EBB JE nn S01 18.7.1 BISA ARYA AE oe SOL 15.7.2 DASE AT PPD HD BIE om 502 15.7.3 #€ Data Guard SRG 58 BLUE PE mnemnnne $02 15.7.4 ei Sib FAIL #47 DDL 502 AEE NE “503 Feb AT Ete “505 eee eee BIB 506 FLASHBACK DATABASE te 48/8] LogMiner 507 “510 163.1 LogMiner ff) CAF As 510 163.2 BURR Benn 510 163.3 Mira He TI aBiSK ff omrmnemnn SL meta A were 514 164.1 BRDLOURLEE Hn $14 1642 WRULAERRBE Hmmm S15 16.43 BELA IRL 515 1644 BBL AELA SIA Bien son 515 164.5 WEPLIER IE MA $15 16.4.6 BEALE BANE CP me S17. PRE fern eve § 17 SVE Pee AY Oracle $817 & Oracle Net 1 2521 Oracle Net #Eid “522 172 173 174 17.5 176 17.7 178 179 17.10 17.1 VL Hei gi F 525 17.1.2 MS Ao “525 17.1.3 JH] Oracle Internet Directory #8 [Link] "526 VLA BE 2-826 48/4 Oracle Net Configuration Assistant =~ $30 172.1 RERLERUE REF mm 531 17.2.2 Naming Methods ‘Configuration 532 17.2.3 Local Net Service Name Configuration $32 17.2.4 Directory Usage Configuration ~ 48 J4] Oracle Net Manager SUT RLT ARS BBUEFE 535 SALT FIR 95 ES Fei Oracle Connection Manage 17.6.1 {8/1} Oracle Connection Manager ‘sree $40, 17.6.2 fi#t Oracle Connection Manager revere 540, 17.6.3 (HALEY HESS Bes RF(CMCTL rrr 542 {JH Oracle Internet Directory £19 ELS A a3 17.7.1 Oracle Internet Directory eH 543 17.7.2 HL Oracle Internet Directory=seorenan54 4854] Easy Connect Naming*545 IFT FE EE “546 ‘i. Oracle Net ~~ 347 1710.1 REN HIT 548 1710.2 ABIIEE Mmm SAB 17.10.3 ia $86 fy “549 ARANHs 18.1 18.2 18.3 SAR RUEE ¢£ VLDB el RAE 18.1.1 ena ees 18.1.2 18.1.3 18.1.4 DBMS_ROWID ll SC Ae et 4 DBVERIFY Si) AH KS SRG HA EINE ~ 559 KSC MAREE fet. “$59 REN Oracle 2 IEA “560, 18.21 ALE 560 18.22 panda 561 18.23 SRA EE 182.4 $ret 182.5 {ela AALS |- 18.3.1 OLE 183.2 ELLE RS | 590 18.3.3 (UAL EHR S| “555 18.1.5 18.1.6 18.1.7 18.4 B9e 19.1 19.2 19.3 19.4 19.5 19.6 19.7 19.8, BABA Gil Piste 19.4.1 ARIES Be Sate 19.42% 19.4.3 19.44 19.4.5 48/1] DBMS_MVIEW fi DBMS_ADVISOR FY BUAT HT A Fe WE feces 617, SF HEE a ATH FELD AB HORA oo 19.5.1 PDR ARI EAN a5 19.5.2 Hae Ta HR Ak ES) faa ARNE 608 19.46 19.4.7Bie B28 B38 B4e 5B | BA SUR AR AY Oracle tk ASAHI FREI Oracle Database 12¢ TRS RS a] WB BUE eth ae IS#215 Oracle KARAM Oracle Database 12c 4 Oracle 11g (Ft. FIR, A “REEAR SIGE” Ha, Oracle I1g J£%! Oracle 10g HATE TTA. FLAT MIRATHR—PE, Oracle 12c al FSG TLE RE, CUATTT RI TBE) PE ey, BST RAE, AAD TT FE Ae ASE). ANSE 1 MBAS Oracle PRAH EIT, FPL Ly ae a ee LL AY Oracle NATIT SEAN, ADAM Oracle LENT FR. BLE Oracle 120 HP HY FMF SERN, HIKARI AE a] 5 CEA IAP. HESPH AEG Oracle 12c BGR FERNY A AEP ALR EAE SUR. ES + H§ Oracle ISO WR AE TENRS AZT, DBA mi BRRE REAR. Wan (AF FULL Ta]. FEL CPU AAAS. HE Oracle BLL RAEI 5 DED, LAL ota BE ED A He SH AE E.R a EH,4 MiSs RuBe RE FEB UALS, Oracle 12c HAVA IALHEHE Tea) As EE itd Cady in AY EEG. ASH SIN ABS} HE EE Oracle 12c ff eh AT HVE, L485 18 FW Oracle ff Dk 52 FL28 (Recovery Manager, RMAN)IM47 3 A Bh 7E LBA IE He OAK SL, {BF Oracle Data Guard( cdi Pb) HALA EE GE YT Se AY a EB DK BST IE. Oracle 12c Bid HY A Be BCA FE (container database) aX & ELI SCH FE M045 HE A Be HIS A a He SCH PE RT SEAT HAF ET AK B— PME DEA BRED, EKG “OTA I” ET RAT IE. Ha SP et iE (4) Oracle 12c RAC(Real Application Clusters, SE HY 5 FE BEE ) Mee fd ASS 455 A Si FY WH PE AU CHE BD EE RSS BPE. BEANE Oracle 12c ff) RAC HtE, fF PHtE WAH Oracle 12c JL 15 WSR APT SPE Fea PHAR AER AE A BE A PEAS TLR, RATA EAN EE, BELEN EL RAC BGP ZiT, HORT Rett HAT FLEET SE ARTES LV BUST HEIP BS A BHL Oracle(Networked Oracle) Hi Fila, ALS eA bn fil CE N APPS AGE Oracle Net, ESP HUHU fF BLAM REE i BGR PE, REREAD ESE FYE UAE A HN THT RE ER AHESST AH Oracle 12c MURERLSTIA, HLA SRIA ABIES SPH ES RTE, DADA Oracle iti Fi #4 F2/¥ (Oracle Universal Installer, OUI) #1 #48 MF Ae #1) F-(Database Configuration Assistant, DBCA)%¢ Oracle 12c MAE AAI. AH LATSPRALM Oracle 120 TAA FIER, UR ATEN, BERN. WMS, 2. RSM PLISQL F. fEAW Oracle 120 FA RHE BY FLYER ee SET, AEA TC ABH AT fs 11 KER AO BARS “BUH FE(Database)” #1 “Sef (instance)” PEP AGE Hs He, AEE ZU FE, (RAG. ZE Oracle BRA, EAVES. Fil esrHik— si. 1.1.1 BURR “RRME” FERAL LEMS AS, (LPM ARE A AD HE 95-8 I — RS AP SCHED BAR IAE 1h Bh Py SE AU SA WML Ae SP SH SH.” Hy £3 AR AFT AEA A PER > AD Fe O22 9 PA L-1 Sha T af) He MPA 4 TIT. RPS AT MAB: TAA] ee A AT {ie Jesh, WORT RES, AFB AOR AGEL. Oracle 12c ETE SAL HKD SDL POLE AOE AD BUT ATE EE. TO REMMI ITA Oracle Se4EYE A vil PEtal.HH Oracle thaestmit 5 TABLE: HR_EMPLOYEE¢@——— & % Ae EMPLOYEE NUMBER LAST. NAME FIRST_ NAME 1 KRAUSE JULIE 2 PYEATT JOHN SK 3 TYLER uv 5 MUNN OLIVIA 4 FA 1-1 asia Baie ALR PEND SCE BEY Rs BARA CE AAR EE 5 PRE ZAI LEP fh (eA. UIE SCD, Ao NE TCR. IE SCPE Oe SA SRA LS SECA SC ST AE EEA ER OTE 1.4 WL RE Hit. 1.1.2 RG SALAS EM IR 5 85 HIE BE ALAR AB SPE — ARS 4S CPUC & MZ). BEET] AA 4¥.. Oracle SUB ME CER CENES Orit LF, iii Oracle 3 fil(instance)Mll 4-7 FIRS BA TEP. Oracle 326) HSS FAN A BEG ERA Ms APY TER AY ARLE ABE Jed JAR(System Global Area, SGA)T!, Ja GUERETE SGA ANfRiit b BRE SCZ Te. #£ Oracle RAC 1, SSSR MEE. EES CAE SE TT BE ER Fees, (ROT HEA AL MES BAF ARS A HET I , IP EL Ua lel SERA AE ST SEF RAID HEE TE ASEM BOE Oracle Exadata (4% — {PL (database appliance) kt 7°45 SU FE MR 9 88. VO WRG Be AUER TFA @ BI—AEREU, IEEEAE RAC FRIST HI AS BI ELE LAGER 1 40 Gbps fiat JE 18 TK eH A (HM InfiniBand 4%). 98 1 ROM TAS SPE GOT, RAC ee h ESS 5 1.2 Oracle 244 4 #2574 Oracle SH AEHP HS RH SC AE BE PLS — RS ETD HERES SE STA, ESE RE ACM ZANE GABE BL, WEE AGH} Hy “GEE” (extent) All “S(block)”» ANTE HANA SAY FOF Oracle WE -#y Ha 4 il AS 2 TE 5 PAL 1-2 A AST EH ei ZEA6 B18 Bee At ea USERS ez) co eet) aur B2 atk 2 BS asf i hk Ba L2 Bate eens 1.2.1 28/8) Oracle #22 [4](tablespace) thi “Bk & + SH SC PALER, —-AVBAR ICP RE ELA AEE P20 (IK —ABS}. AF Oracle 12c IH beetle PS Ae li]: SYSTEM 21H) Fl SYSAUX ACEH]. Oracle 12c HIBKIA AE ANE 6 4 eee [a]. Oracle 10g 7x Jes 22H AS FUT F GEN AS EE Ua], KA) ICE RE ETA (bigfile tablespace), FCARUE ATTY 128TB. (ASCH RD (Lee 1a) SER DBA FEET ML, HAVEL, DBA BY EAA 26 2 YE Ao SUE AT EL, HAS A Dak I PEA A SH A {HF Oracle ##H13Cf}(Oracle Managed File, OMF)F/ (i 47110) Beds CAPPED FES. HE FL OMF, DBA HIZEXTEAB MEE — TMS ML AORSE BORIC Th. FSi CAP ALTE ad fh, FF Oracle Maye FAR MECH dae AEE. 8 4 OD PIS ie OMF. BAe Ae FALE), Ae ASTY A A A, AT ORE CE Ae DEE EP GE AE SETA eT THREE, UAL ete TA SMT ee. A 4 ae Fe FIDE WD MRSS BEAN TEA TE 4 AP 26 72) AKA RCA) ZL VO Fe Fido ROE AT EFM TEAS A. CEPT 22 a), RE ER Se. Blk, BIL ITAT AD ALE 2eAB CE USERS ETA. La BEViT] SYSTEM 248 1a), CA ES AE ee Ef DML. AY PAT AL) ASE A AP EY SYSTEM 228 1a] ARE WEAT BE PEEL, RRS AU BA TEL. TEASE BEA 227% UH, Oracle ER STADE EC EES — “i, PRR ETT AE. RA ROR ELL, Oy PAM aD HAE FI AE IIE» HEDIS ZF LOK GUE FE SEY BOF Ul]. AERA Oracle 12e Bt, 22st Ze ASAE EL SYSTEM #l SYSAUX 222816]. Jy TRARY (Meanie Beet, ReREITTT hy FRITH, PUR AIN.1K Oracle RITA 7 1.2.2 SEU ERCE Oracle SRE RAI AFAR AT 0 SARI AAAS SE EE A 2 EA TR I WTF RET HOU REE RGORMLUB A, ATW) PHETHEERE VO ARE. Oracle H)MiB2t DB_BLOCK SIZE THEMU MURAD. AS Oy BGR PE SERRE TAL 4 TKD, Th SYSTEM, SYSAUX AIF fel 22 fl HEA 2529 DB_BLOCK_ SIZE ftffi RUSE SKB, STAT Oracle WikAIEA SKB RDUT. Oracle HAESERRIRIN, BRAEBE ALBA AL A, BRUNE Ys TAT AOE EI SKB PEK. ASR AY EAR EM EAT AME 20KB. KU. FSH 32KB ER, (LMT MWA, — PARA EA HERE. 123 BR ARE AE BR PEP A FASE SH," ABR PL a aT A Bat, ARR BASILE) HE ST Cy — PRES 0 124 & BORMEP YF THD EBL. BOE AE, IAL AER ALERT BR Oracle BL A—A SPATE ECHR RG, Gn Re ge | NE, LA BIA FB be A A ALLL. Oracle RAE EB) 4 HRA: BARRED ADR RINT), BSI BL. nM BCT] REL. 1. SUBEL BRE EAS ae AE CE OR HE, BOE — RS ER MRE AE 424} K 2 (partitioned table)B HEE A (clustered table), jl) Oracle HiAARIMS TA. ARATE Wi RAR. Bd Be AFF fk LOBOS) BGR IY LOB BL, LOB Bd aS BP ny LOB ‘i (8, 23 513 FH (ELIE LOB 7S ELL WS Hy SURREY) 2. Ral FEARS OTE E EL LAIR TIER GAPE AE, FPPC RES IRE PD PRE ER "MRSA MM LOB RGB, MUAH LOB Fi), 4H) LOB PILAR LOB HA KRG| ATT SERIES eel, Dee AE. 3. a RT ES SSPE POO SQL GBs 45) lg BE BARR 2 i] Hs HER PE (DA AS BEE FP EA BEE INT Oracle A LUGITEL. MINE PLE SQL i FUSS. 4. BREE AR Oracle 10g FFs, TAH AUP ELA TPE F SYSTEM 22/6, $f A DBA —fRAN GE SE HE OP SYSTEM [ALR BL. ZELARTHY Oracle MRA, BES IAL AY, 2 GURL REE DML BRVEZ MEL, FE ALATPMEM? ZBI” ANPING Aa Re CAP eRe ME AR8 Bl Bs RRR BE LER RR Fd FP A PE eS TDL AA TE SNE CA PE TE SATA IEMA» E114 FFE (Automatic Undo Management, AUM) ib #8 iF e702 Fd FRE Be 9 Fh) FOAM ATE, LEMS AEAE Da HES BLY ARAL TTR Be AS Zh CET fl 4 i A Wel Oracle Hii], TASH DBA PFFEGH A AIK). M Oracle 91 IFLA TE ASHEN BL. (146 Oracle 12c PAT Favs MRE. Mit, WM Oracle 10g FF RAVES MAE, EIT EENL AINE ATERT AL. 46 Oracle 12c P, BRU AUM, JE SRHE OE T PL/SQL WE, WL ‘PHBNHE UNDO REM A. Y7 RAS MT He A OD TE 1.3 Oracle 2 4 3k48 #2544 ASTAE STATA EPEAT AE ELE YET BOY, ESET EA Ae BYP iE MATE A. CECI AT IAI, ATE A MS (constraint)”» (15% ANGE Me FER GE Relational Database Management System, RDBMS)‘ #2408 (19 AEE F, SEDNAAIH Oracle BAR MENS Sea te AU STE. ATAGIE AE Wid, FOS FEL RY SICH Ed ad FS FEAT ANE SPB DUES AT th DBA BRA PE MAAK, LEIA] ANSE AIA BER 1.3.1 # BER Oracle MISIMEH AOSE ACE AG MA BRA AR RI ERY FUR BREA EET EL FERRET A, CORE LT ELEAT A, ORT LENT 2c PEE 5 (HL OMAR REF. RE CERT TERMS RUIN, HIF Oracle BUR FEISRTGEEE, Ze MEE AU] AH AGTE AE ACO UE AEE ALE, GEMS FAME IR CER AWTS IVR Oracle BFE HP VFS AST] AS AY Be, BA BEAT) APSARA A, I REAR ES NEU, 8 REAR AA Sp UOT RARE A OF EP I REP AIG DI vel ERE. 1. RAR KERIB EM MN ZR. KARA “HE(heap)” TERT: Bey BL, Be YT BATT EMU Ri. 4E CREATE TABLE f@@'}, 432 44) ORGANIZATION HEAP 252 CUHEME RANI, (DI RAI, PDL A AY Ld Fa RUE ATLA MRE, BE — TAAL — PEA ARIE. M Oracle 8 FPA, Sita CLA se CNR RR. RE AER VARRAY. UES, ERY LUGE MR. ACHAT FFIPLRA RE SAAT SH # 1-1 SUT PI Oracle BARA MY. Oracle Lace ANSI ARAM BARI, 421-2 hth T ANSI S260 -All Oracle Bei AZ fi] AMRIT K Re ii], INAS AEA EE1B Oracle ARM DO FAA Oracle AB MIA A Oracle PB RBI ew VARCHAR2(size)[BYTE | CHAR] BEEP. RAHI 32 767B, SiJ9 1B. CHAR 291 Fi) PG SCF MN Kes BYTE ZO HEI XE Oracle Database 12c , IML MAX_STRING SIZE bi B RCE EXTENDED, 1] #§ 32 767 Jil ff VARCHAR? iit die KCN NVARCHAR2(siz REMIT, MAINE 32 7167-711 NUMBER(p.s) AIHA AUPRIMEGOMIBCE, HIKE 1~38, HIRE ~ 84~127. Antec {, NUMBER 41> Wl) 1B, $l) 22B LONG BEAM, KNEE I 2GBO”' = 1) DATE LLIONGE, AAAS Te 4712 AE A FLL 132876 9999 4 121311 BINARY_FLOAT 32 4PM BINARY_DOUBLE 64 (FP TIMESTAMP(fractional_seconds) A. A BPP. WO AUBD (BOE 4}. fractional_seconds APSHA O~9, ATI, RE A HLS ALINE. BRA OZ) TIMESTAMP(fractional_seconds) tug TIMESTAMP fii, ALSREE AT “PY HL YC RE WITH TIME ZONE 8co7 DL AL) UICC Hn-06:00)2%b< JF) US/Centra ft TIMESTAMP(ractional_seconds) 30. F TIMESTAMP WITH TIMEZONE. (114753: (DEE WITH LOCAL TIME ZONE SAAR. MHI a RGM (2) CR SUH SS HY oP SNL I eM INTERVAL YEAR(ear precision) — | UME-AI/J(H ATs (HBIITIEE, year precision (R{fLA: YEAR “PBL TO MONTH Me Fm Orme INTERVAL DAY(day_precision) DLL ANI 2+. Bs CRUEL (Ff PLM. day precision TO SECOND(fractional_seconds_ (91 O~9, BRU 2. fractional seconds precision (8610. precision) 5 TIMESTAMP {fishify-ictb: 71H 0~9. BRU 6 RAW(size) Wier WEIMAR RACK 20008 LONG RAW Ws EKG. UCR GB. ROWID DA ok SARUM, AeA esd Re FM. zs A a thy UROWID[(size)] Ak SMR Aeacdeme TL eeh AHA ize lit Afi 9 40008, (CHAR(size)[BYTE | CHAR] 4M SLICE sizes BUNK Is 1B. BEA 20008. BYTE il CHAR @#U% BYTE fll CHAR iff X. 'i VARCHAR2 sett NCHAR(size) 348 JOR Ys 20008; ICA PHI FAR MT SRE. UAV | cLoB PGK, ORME TREE WT IVER RMIT FEE. HAIR Sf 9(4GB - 1)*DB_BLOCK_SIZE10 81RD Siem Re CER) Oracle AMES! ie mR NCLOB AWE CLOB, BRT FHKE PIER AER FIFI Unicode #5. AP NUGB - 1)"DB_BLOCK S| BLOB UH ASUS, ACR U(4GB - 1)*DB_BLOCK_ SIZE BFILE HEE CEA OT AY I AF Oracle SpA NIRS ABU AE. OCR 4B. 321-2 _5 ANSI SIBALRIAF HY Oracle MIRAE ANSI SQL BuB3¢2) Oracle S120 CHARACTER(n) CHARI) CHAR(n) CHARACTER VARYING(n) VARCHAR(n) CHAR VARYING(n) NATIONAL CHARACTER(n) NCHAR(n) NATIONAL CHAR(n) NCHAR(n) NATIONAL CHARACTER VARYING(n) NVARCHAR2(n) NATIONAL CHAR VARYING(n) NCHAR VARYING(n) NUMERIC(p.s) NUMBER(P.s) DECIMAL(p.s) INTEGER NUMBER(38) INT SMALLINT FLOAT(b) NUMBER DOUBLE PRECISION REAL 2. Wit Ae Ad Oracle 81 JF, Oracle MAFIA. LOTR “UIE”, CEMA ALBA A BCRAPINCE ZED. WOARSEFPARTE 2 GME MI. hr CREATE GLOBAL TEMPORARY TABLE FY 6) ahi 2 5 SUA FATT 2 ANAL, ALATA LA Me LAN AT SELECT fi 22k DML de, d0 INSERT. UPDATE 2 DELETE. (Ail, MVE RARER PH IMS. “4H PMG Ze, AEP MBE RATE AR i 8&4 ASA A OSES =D 2 SAA Zt [Link] BA AF Atk ON COMMIT ¥-fUdsti], ¢EHUT COMMIT 88 ROLLBACK ft, ON COMMIT DELETE ROWS fi Zi MPR 2e"P IN PTAT 4. ili ON COMMIT PRESERVE1H Oracle RRMA UL ROWS fiECERE HY GES WIE OR EA eH ET. PNT, MAP SiS INS, INE See TA OA HZ BER 6 AEFI WT SEINE Hh Se EAL. BURY TEMG AE OURS], LSS A ASB Bab eR, AeA. Sb, PT Re AE CIE, Oracle ANZ aibithh eR DML tA EAH AG 2a CE HAP 28 2 3. RSA Sau LA Fe GL B85 A aH a SD, EE S| AT SG SA Re Ee a AT U2 FESTA IETS, BL AH PE Us DY EA Ae OR TE EL IR e HKE. i FL DiS CEES, AA? APTA DL EBSA (Index Organized Table, 1OT) FT fiat A EWI WERT Re LOT LA B- RE G| HVELTitsee PAT Der BAR G1 NY ET AY i AB EL HE BER S|) UA — TRS PARR F 1OT SOA OL RET eR — Tee en, TARP. blak, eee RNA TE TOT FFA — Ue» dE RH Ze 1 MN BEE AR PU PRI, (EA IOT hfe te FMR, WRIA, BARA AEA EE, iti TOT WALT AE. FAI, TOT ASAT AR. BI, MRP AEN, Te LAE ROE Ae AT AS HG EI Hd EF], LOT BY fH AE OT 4. HR MA Oracle 8 Ti, Oracle Database BEX Hy BARE HY, DA Be EE YI ME RY BG EE TT. a (Object-Oriented, OO)MIIT AIHA BRST ADEM GAME COMET. ADULT AH WD(Object ID, OID) 3] AIA BRPINT, RGKACMMTM AT EMERG. RM, SRR MRT AT FERRE Ht. BW, BEBLIEAS TPE —4* A) EI(Human Resources, HR) ASE, WIHT LATE AA PES THATS ME. ALP oe UR VASE SESH EL Oracle +P iii a x TEU) RY eS OG RBH IE 0 SS eA Ad ES He Ne BARS HK I create type PERS_TYP as object (Last_Name varchar2 (45), First_Name varchar? (30), Middle Initial char(1), Surname varchar2 (10), ssn varchar2(15))¢ CELINE, AMIR PERS_TYP RAVE AI, 14 Oracle RU WR ET A BOT, ES I8 8 Sle CEAC BILAL PERS_TYP). GRE 99 PERS_TYP Xf SAMBA, ATA BUNA CREATE TABLE iG, FLEE: create table pers of pers_typ; SHES BTM BI GA, ATLL INSERT edits HR MOT We insert into pers12 Blais HABER REIS values (pers_typ(*Nickels', *Randy', 'E', *Ms.', '123-45-6789")) + A Oracle Database 10g JF Ai, WRAP AR GAIAM, MAS TEBE Be. TEAL, (ist Fs insert into pers values('Confused’, 'Dazed', 'E', 'Ms.', '123-45-6789'); Xf PERS_TYP 1SSE CSTE REF WS Armee, JE LLATI Pe PERS YB. iA TG HEPES PERS AY. SS BEARD LES AA St 2H td AFH AS eS I dR HL 5. Sh ABH Oracle 97 FIAT SPB AE. HUMOR. SRB AE FUE AL Ui BR. SCALE A i BORE BGR IEP IZ HE. Ae TORE TEINCE Oracle BARS IRE, (EL RCIIS PETA TE SE i 6 He BAS AEUID HEE LAL PNAS SPAR (WB HENS Db) A ABRADED SF IE A REM. ae MAW CE CREATE TABLE iff fy PGS ALE M. DSB AP FP BRP SA Ae AT SU 28 5 SC AE EA PRATER: WTC IEG PUBMES, TAT HE, CAP ROSA HES TE AE — h]. YME ORACLE_ LOADER MERU 0 1 IE Bb F LF SQL* Loader F8SCA EMH IDS. ALORA 4 GR asi , FELP4 Gi at A fi Vid ba A HE Be EA BI A SP SCE TA (EFA Sb ab de Ue fF Uke ESRB AE ASAT AONE, 1 AS HT SCAN ATRIA SEB SNUBS CE BALA Yb a aD AS HB eRe PE Ri, Heh, 6. BRR MeL FR Vd USE iy ad DS A ke & AS Ae Ct ASAT PR AL — 4S A He) A (clustered table) Hi] fi PPAF HAI, “EAT VR UES | ERA PERE. AEST AAT TH{CLine-item) HH] AN AENITT AEN, TT PRR CEE EL TS FTP ME EA], Mat DRO AT MANET SUL Cee LAST is BE) VO BCH BELGE Wah > TF TPN SIA CO IT ot BE ET Be, PSA LS fF". WESSEL Ait CEE GEE SL. BEG SERA RAAT eS, MLL PSC AECL, ATAU RTA AE Ae it). CE ELAT TT PAL AT UMass EP aa BE i Re AEE ET SH AAT I 8 ARTE ERAT MY SELECT 8 FUth Bete, MUG CHAR ALI T 5 SURAT Zed AT HA EE ALI BR a NU Se de nV. WALA 5 Heh. EE HEL BEET M8 AS Ae aUE AT PEA Us Zo ORGS OT SEER AEE AT AE Heth. 7. WORE {He Dy RP RRA ESE 22. MCDA SEChash cluster) (ERE AEA SAL PL Ee, ALLA CAMEL RPA RES | TT AED A em ORE ATES Ae AT 5 UAE. ANA Ce OT DD SE BA SE CP CT a EY HG ET). LETT A A Aa, BLL Oracle Mea ie BEBEBR Oracle HAHA 13 {Qik HY BA Ae RCA GOS IE SS OT AS). TAINS, TREE 6 HO, AUS ZY fe Os aT Bs create cluster order cluster (order_number number (6)) size 50 hash is order_number hashkeys 1000000; create table cust_order ( order_number number (6) primary key, order_date date, customer_number number) cluster order_cluster(order_number); EAE LRT TOME EPE TTI, BOUT IL TERE. an Pia: select order_number, order_date from cust_order where order_number = 196811; —ALHIR F, WR HASHKEYS [fC ALG & J ALA A ea BM) HASH IS FAAS] SPATE, ABA HAD CE HR ATS HU — 2k VO. 8. HERR URES FEF IIOAESEIE Oracle 10g PE RTM YS A. “EATS T HESUL O BAU BEE, SOLS ARIE HA PR MOR ELE TT BREST AO BESS FE TAS 1 FT HR Z DET IVES. URGE PI UETT SE UESE (First In First Out, FIFO EY, Bara OD A SECC Heh 5 FPLC ARRAS, FLOM KOURES, fame BEE ME RP Hse LA fa dn SORT (RB. Pun AE CHEE BURR SEP OUR Ret BA create cluster order_detail cluster ( order_number number (6), order_timestamp timestamp) size 50 hash is order_number hashkeys 100; create table order_detail ( order_number number, order_timestamp timestamp sort, customer_number number) cluster order_detail_cluster ( order_number, order_timestamp) ; SEF HP EGRESS FIFO #4, iL order_number Ufa] My, F448 order_timestamp BAO AEL Ae a sO Td BAHT 9. PRR HY REHEAT 4K SURE 8 1 BEAT AP KB — SPEED BER SUE AT DR) i a WY KR HGRA (LEAR SD) AAS. DISPERSE PEE CAB BE bh, CEREAL PY SQL PAS GE BERT CE (OT RE 9 3d EAT MBC | FD)» FD PME — fe WG MR 4E WHERE “£44144 UCAS) BX Hy bE RY PR EET AEH, HST AES14 Bian Kee JA DBA (YM, META RARE 1. MURA — TOT Ce E,W TENE SLY BUR ASIN, FP ST PEACE STK. UE RSILL, RSP DEH Od AT LE ABE FE, EU ATR TAN EE OPER BES EAT A OF BRABA 3 RM: TE. BOAR RAZ. M Oracle lig FFM, ATLA SUFRAMTAE, MAES, IFN REA SR AMUMT RSM, URAL Pi, URW, ARTES. ARN ATMEL A EAEET — TP. SP RRA ERIAK, CARMA, RAMA PM 16 Fl). NASR MARAT — HEIL, GM, 44 LONG B& LONG RAW Fiji) 22 A HEUETT SPX.» LONG fib fil > HO fa]. LOBE PF AMA & CLOB MU] AAA BLOB) RIGS, 1 LONG Fl LONG RAW #8 920 0 TAPE 6 Rm: Oracle 24] IX, MP TAETAF 2GB MHA, AREF EHTS ER, FECA LPAI SS CEN, SPD PEE A ABs A HAD AE, BUENA HAE. WRT, HBR OP MAIER UC, “EAT ET BEAL All. CET, IRS, OP SK REPRISE, “CASA CEE TA. POM, EAN eT SEH aL ARSED dE RE Ie, EERE AR. HE 2012 4E 5S A 25 AR ala SLES #y FY2012Q2 HUSH, HAZE 2012 AF 12 A 2 EW NTA WIRE By FY2012Q4 Ware WRAP R CRY, TRAE TESA. Gl, Hee TER Pasi a APH SET BEAT NY, CT. MA Fil VT REPKE IL, WI. LA Al MN G88 575 ASHE 5 WR A INERT, UAT R ft See TIS DIY BADR HURT ROT RAR, FB Ee Re Fi, AMMA GE UT OP, TA ARBRE EAT BAD FAT AY. Oracle HEAT URAAT ER. FER BEDE PAT HSA. DAT TUE} DX HEEL} SC RE AE PHA, BRAY HT AD BE, AG BEPT PES th Fy wg FY RAS, SU ENC LE AES. BADR WMA REPT. AlN, A RUT, RUB TE AE GLB A, ELI Zeek MALE 26 9) EK. Oracle Mg BTM IAL 3) LAGE, ARN. WTAE 1 SK 10. PRES HERS RATE RG IS RARE), A HRI FAG 1 5) BR ESET AR (RG). MATAR PME, AMAR RS ATR TAIT TE. fn, ESSERE} PE FY2008Q4 AFCA SLR GIA Ze MAE SEAL SP BK (HE S| NT FE. 1.3.2 28 Oracle #9 3€(constraint) EARS AU, “ECERM WR SH Lae, AP Si, FIR LN, AURAL HST ME ASH AS EH IRF'$25 000.00 IXPENIE SHEN. 53 —‘ Siti1K Oracle HRB MMER 15 Sp AMI NG LA ASDA» AU RAS BB) 4ST WIS AR FR AVA AT BSE ABT) WUT DAHLE a, JR CE T DEPT #2410 SEAT 6 PPR SE ETE NIN AT EIT Ae: AEM. ME UAL. ERR. GL SeeHE CIT. Fe PURSE MERE ANSE FA AEE 5 FTE AY BE SSS I GRE AK Al BE Sad bee + EAE IAT ARE BS PR, EPR CE RE SAAT ORS DML HEE SI) 5 LE GARIN RASS OR ERI TD BRR J AL BA CH RHEF ENABLE 2 DISABLEYYEAI, AUR ATAMHIES BUM, ULF FRE AS ta BE HEC LF VALIDATE 2 NOVALIDATE) #21} C245 BAR JE AFT LK Bil, HCAS PRAR EN CAR_INFO AARNE RAE, AEE AY AIRBAG _ QTY Hiss — AH AGE NULL, JPL TAT AH, RAB AiR Ay 1 Ki, RRS S4 PRA RE SB, Alt AIRBAG_ QTY 4 f Afi 0 aR NULL. GX PRL F, PMU RILYE AIRBAG QTY 4 1 GNR20R, MSI B Ze ITAL it HR RU LAS IE LE AT A PALEY A CAP GNESI TATE AA. PTS APE REET create table cust_order (order_number number(6) primary key, order_date date not null, delivery date date, warehouse_number number default 12, customer_number number not null, order_line_item_qty number check (order_line_item_gty < 100), ups_tracking_number varchar2(50) unique, foreign key (customer_number) references customer (customer_number)); 1. BAR NOT NULL #4 ACH} bir: NULL {fi4f A ORDER_DATE #2 CUSTOMER_NUMBER 3}. AME REMUS SIE Ti» FPA AT EE Me ET CAT TRI, AS EE BT, WAAR. + AT NULL (83 FAS aE PEI AS, BEANS WEI) -4 NULL ffi. JMR SAR HS TE. 2. MEF 0: HEWUMLUE, MAE. NULL (iS AD AE LLAT NULL (HEFL SQL fe ifynt, UNIQUE 56 HEE 25 Amit SR A GOLAN AA EMEA ET EME A. CERT EAA fa"), UPS_TRACKING_NUMBER 4} 44 FTW iL. Oy HEI SIEHEATIR, Oracle 7 UPS_TRACKING_NUMBER 4) [:@)22ME—329]. Wn UH EEA RIE 48 51, Oracle HEEL RAE SKS HLT SUT UNIQUE 29 34 (15 91) U8 8] 8°] 99 NOT NULL bal HLT 7 HAHA E47 NOT NULL 2K, SU ERR BOY FT AST ALA NULL ffi, RAAT EP fi. HE Sci — RS FLAT NULL fe 2, AE NULL {te ae 2A, 29H. NULL AURAL AC, PAY NULL HAS PEA AE16 81S He RT 3. ESR PRIMARY KEY 56S: 25 CSE CG E20 15k 2 SERRA. ALR SEIKASREA NULL ffl. fen MMA, ORDER_NUMBER Fike Tt. AAG OIEME Bes | LAS IALT AL, tH RZ EER HOME — 225], TERRA ATA SL 6 4. S/FAzeSetE a S| Alsete teak FOREIGN KEY 295 Le LR El —Ph LIB BSS A, BE BE 9) RE RC GL NBM ET A Sh AS) LAT 1 se EEL A TAL ZEW a, 7 CUSTOMER_NUMBER i |: #8 9+4t(FOREIGN KEY); 4A i250 {AU FETE Fh AS Re CHEIX ALF XE CUSTOMER %)/)) CUSTOMER_NUMBER ¥)"{!. ‘5 0iF NULL fA SM2OR PE, ATS SEREPELY RUMI AT NULL fff, FLAS 3ES] FMA NULL fit. woh, FOREIGN KEY “R87 EL S|FN. fe a:fit 9 EMPLOYEE NUMBE (t) EMPLOYEE eH, MANAGER_ NUMBER Bil £147 Hf a] 7-4" HK) EMPLOYEE_NUMBER Sil 71] ff 5b, SSH SCHETE EMPLOYEE #4 4 REM BEA TESHAL(FOREIGN KEY) 31) EFS) a2 51D OBETE ME, 2S MME fl Sb th Ee Rt AB 2 EAT ERM RSC AEH 15 | se a RHE — EI 5. SAAR ME SM GE CHECK 295K. BY Ze Bil Be Sl) Se i BESS i) Mb 3 I = A aS ORDER_LINE_ITEM_QTY J 4$i2 Hi 99. CHECK 29 ACF (FSH A BRE ANAT HE A AREA. fA, STATE_CD 41) ft AUR te COUNTRY_CD Sf {AN USA YA SOF NULL ffl. Hah, RA TE Sn CLA Wy #te8 2, ft) TO_CHAR 2k TO_DATE, iid Akik “Ee MEM EF tek eb OH. PVE VET & > CHECK 2998. FA TEDTAT I CHECK 20 MSHS TRUE IN, Asif AAMAS. Glan, PSeK ATE) CHECK 43%, it ORDER_LINE ITEM_QTY X¥ 0 Jf AF 100. 6. RPM AEH SURAL MULT SLAY, EME EAD ESE, WUT AHP] CREATE TRIGGER ff 7. AL BEM PE fab Se a, DEF —4 PL/SQL (UHR SE EIA — 3% ILI 6 GLP RE LET AS Ts HIE PE AFD Ph eB FN HE 6 fe TY FAL FS A aH 2 AT RB, RE RET AT Ry HD). 7 BERGER AS A ST RB. 13.3 #41 SRR PD RITIT, HEAL Oracle 25] KEE Diy MAP NDR AT. Be FET RET RL GOFAL PLANS A i, APL E FT HE ROWID, ME — (19 i) Yb SE | MR (Index-Organized RASA. ASAE EIS PURE ARLESBR Oracle SRSA Table, 1OT), ‘EARLS ANZA ROWID. —AYERS|PIRHWEACI, lh HY) ROWID Bt STRAT OME: BSCE. SCENT, EA beep HE AYE FMS Fl LOR S|. RIAA AP HTE BARE, PALI 5 FSR DAY VO BYE. CEME— SES FSF Se 1 EAT HUE, JP CE RS FL Se HME — ATE. AERA, RUMI Ae AT 19 EI PRURA. MMBRAEMT, HEAL CURA TAT Hl te EMER Oracle 41 HER NOR SIR, REARS ET ER Uy TEE PRE PUA SAAS IL BES | AE 1. ESI OE — Fe G1 FRI AS ULE BoB BESTEL EH FP Sew AeA AE RL ERE 5 TRE | PRS Fil PAETE LH. BTZE EMPLOYEE %'#' Social Security Number(#h 22 (RBS AIRY ALAM RS, AABAPAN AER. Mili, —MEARG ATR Social Security Number, FUi%5) A] LLL NULL fii. 2. 4ERE— #31 APM 5 | FE DR es fd AeA E, TAS Ze aest)S E —-E. fbn, wy ¥E EMPLOYEE ff) LAST_NAME 31) E@U224EME—2e5|, MAE ARE. RPE NIE, KYA YS MSA. MURTE CREATE INDEX 18 4) PUR 744 ELEM ET, MUERTE LB ESEME— B-FAp Ral. 3. RRR) 5] VARS AT A BEL tera > AMMA BR (0) BER GI (reverse key index) AE FF AI WAY 5], —fBE FF OLTP(OnlineTransaction Processing, JQHLNA AEE) ERET. HERMIT, RMN SEMA PAP. CREATE INDEX fir"! (8/1) REVERSE Xfi 7 43752 5c fy HES PG AE Ec HEHE Nats create index ie line item order_number on line_item(order_number) reverse; BURST PSHE 123459, WY SCRE AG LETT SAPARD 9543216 AA BREE A PAPA AERATOR, ATT AE TARRY ARIZ EL. ARE BRA ARAB PEMDERIERT Fh, MUR aR Gt ae OLTP AME pIKee “Hse” VAT AERE. Fil, FRAT RRS > TA, ERO T OI EE A, tes S| SRO} AB. 4. BFRMORS| SEF BROOK SAF PREM BBY RG], ATA Z ALE CAG EP HY Hy BEAK FIAT SPACERS, MARAE AS. SB PRADALLE DT (Ei A TERE RE FE PY, SEP SARA ATA. WAS 1718 #1 Bee as PRAE Smith, 6 2 (ii SmiTh (VF) LMT MER MAABEUEM TL. AM, RSL DLA FEY ER TE BME UT AT RE (A EA AT ES E.R TB A as BZ EMPLOYEE #it) LAST_NAME 31/6) 235-7 Bet 91: create index up_name on employee (upper (last_name)); De, AP EATS ee A |, TA ET eH RH select employee_number, last_name, first_name, from employee where upper (last_name) = ‘SMITH’; 5. {1 R3l PERS HOWE, (CAZES (bitmap index) IEF BHA SALE TE PEAT RA. TE FERVENT REA GEROI AEB, ROB MICE F291 Ze NT AAA 6 ESRI, MARIA BAAR, PORTA), NCE WRAL, Oracle MAT UMASS WHERE FANE itl Pt AN ENT | PBA ALFA, BY ALE 4 AND Bl OR BEE AME Ui fl Ze TOME AT. RST Rep AEA I, (LCE RS FU AT BE REA TA AAMT, EAL FARA RTM. Gli, PERS PI] GENDER FiH#47 NULL. M 2% F fil. GENDER 3) Ff BLEND 3 MLPA TERRE RESP. 593 —FaT, LAST_NAME 41) Eff (ie a8 51H Fi Ade A AAT HOLA AIA BRE! OUR FDA ARG, PRR ee ET AE HOD ARE AYRE TE DRL AD HITT) «ARERR, MEH SEMY BPE IEME 38 5145 ATH. ALEVE | BPE RN “fir AMEE 22 5 | (bitmap join index)”, APES ER TAA bE APR, HEB HAAR AT UH MS PIU AEA. EAE te Pea Be PERT ASLO, CEASE HE Be EO PEER |, IEP SER, MATT PERT SEER MELE WH CPU HI VO Bev. ee: 420 #3) RAE Oracle 11g 47 12c Hy skMP TA. PAR LMT DML, 291 SMI RAAF IAN, AREA PAY Rap as 5. 13.4 #H PAPE FOP BE PAPERS HEE Ae EN EE ea PLP “TF EY”: FEL Fear PS BH SAY 5 ES LP AE AT, EE SL. PEER UH PAI ABZAT IANA. PPL “PPLE (materialized view)”. cit FIM TE eee HD eA AHA ELSA TT NR IE, SFR AT AAR RLS TEAL PA, BURSARIES eae REAM AY, IE FOE EAR EAT DRE RTT AA I, TI IE A ETD PEARS RARER AACE SK “FIRTH SP EAP TPAC AR DBA A IF PH MY MEA LP IO AE IA1B Oracle HALE 1. HEE PEEL. HR “RPA”, REA TERE, AE Me MRE) See. PUPAE ERR HEE”, BLP HH MeV Ee AB OT DLE — 26 5 ON. PDAS A, CTL RR 82 4 RI} A BL PT LAE XL EMPLOYEE. DEPARTMENT il SALARY 2¢(/ HL. OAPI EMEA PY DL 2s SoHE SELECT i A) RAK ARAM, ARAMA RAMA, SE LA AAU, ATE 4% EMPLOYEE, DEPARTMENT #il SALARY #5 PLFA tH BY LAF FS zee. EMPLOYEE #2 1-(f) #224 EMP_INFO tu} 7 SALARY(# TKR TALI, FE ALG DLP GE ME, ATT BH EE TRE create view emp_info as select employee_number, last_name, first_name, middle initial, surname from employee with read only: WRAL READ ONLY fi), UAT LAT RT ANSI, HAS A CES PRT, FEATHER A. PLP 4 — He ai OY RE CET BT, BLE DISTINCT Sf ETE. AE Sieh Bak GROUP BY ¥-4y). “4 Oracle Sha PUPAE HORS, “CRMRAL OM SELECT IRA) PMR trie X, IFA MRT, BRULEE E—PE. Bik, PED, eRe AE RSA EA ae. 2. HE TERED POPE LES PULL ARAL, BLP CPR PP, TP ELLE SPF REUSE re Hy. AIL AO ae. te LR a ee BB a Ta, FORTEAN AT ETE HS BA OVC BL IE 8 AP den Ri il A SH 8 5) — AH BAN LAS HE PRATT EY eC AU 5 aC RA A HL 9 a EW all AT A gm IE Fa), A A Paks CUBS CPLE . AU, BEM UT aa OLGA AT eA AN Ts LA LSAT AE AE HA A RL ABU AOAC PL 5 POC HLS Bh aks Dy DAS Bat SA HL OT TE HCME CorEE SGT, Ye BLES AT 4H {it A GROUP BY ROLLUP 8% GROUP BY CUBE #14] AVS RG . UR ELE MVM MAM, tl QUERY_REWRITE_ENABLED, 3 Hil) A Scie #E iE (HIE QUERY REWRITE Fi), WUE (51 $5 My He AL PA AT ABD 2 ft RB 1 PE i GS I AP, AS es ty aE EH. FEAR MOC LE EEA A, LEME RE HEE SS OE GEE, AZ ERY WB. OA PEL LEAR & 77 Ul WBE, EAN TEE AY EMTALA EDR AL tei. BAT TEASE Se 2H afi CE ah AE ie SAL, CATE A ARIE HL A Aa, AEE aE eT A id ee Seah Le A SiS FD a i BO HED 1920 1 KHER 3. TRA TG FAY (OO) ML RIF RIPE ARTE AT, Oracle 12c MEH PE 764 CF BA PE PAH, REBATES. PTT, SAORI ISA A FEES FI SLE OO ME PEPE IF AE SL RDF A EAE Be TE A EVA SL TG TE ABE, MT Oracle 12c HEIR) SPL HE EE SEAE TEA ZED 5 HY GOOLE FFT Ht HIN FL EH PE AH, CA BR A FA REA AIA, TU RBETAT A INVENTORY 2632 THEE ee. RESALE AT LAR SBA. KYSER (OID) LAR SEHE MY OO BGR FE BE HERE SE ENS AL. AG USELEA FE. PY ZE DUE XP HEAT INSTEAD OF feb 2 282K POVF ET RY LEA) DML, i HEAR ANGE PL/SQL (RHSER, TARA Bee DML if. 1.3.5 AR Ast AULD) FAR PE SR PE FEE PE, ASA AL AE AAT RT SS PRI, WRAL ERR PED OUEST Re, aE RS Se A A MICHEAL Td 3 VBESK (schema) ARS}. BRAT RARE EAR: 2. Rl. PALS. MST ak DBA PYAR ALICE EF Py PAE APA REMOTELY SEE HL AP HTH 24 DBARIEL AEA CREATE USER ACA R MUFC ERA aL, SICA SE, WARS ALP, Gil FP RE Ree URE RH, A EA MII TYE 3 BATE RR Pe A th: SORES OE. DRE REY GPE A SOMBIE. (EGER S HIERN, FP nee EERE. ZAR, BERD CY WEME ATO PBR: Pete RSE OSD OE AY AT SE LAB PR, Sa JAP Fa AI PRR LE % PRG OS_AUTHENT_PREFIX #)$@ BAH). 464 OIE AUEAUIE F ASE DERE HE Public Key Infrastructure, PKI) RAT. IX FHT VME AA Oracle Fit PHM AY Oracle Ig BR 12¢ MLA. 13.6 Remix AGREE, Flt DBA 24a Pra RR PEA A PC. BORE REE feat AE CPU RY (E, JE AL Sei. SELL ANE HRY fa). SAFE ME BOC CE EAT Dates Fa RSE BEL BE. BEE Oracle fi, DEFAULT ACHE TEBE FLE, H+ AAEM SOE (EA CCR ECC. DBA ATM a AAC SCfFRB DEFAULT REICH, ATO TE AeA AR. DEFAULT ROB IC AE BIA CHA PRA FLT 18) A FE 1.3.7 RSI Oracle FAAP AACA FA, Ft ACRESME—TE ORAL OER MER). EES FAP RSE ER — AME IE» TELA AE REE ET AR VO TU RSF E I. ik AA AF AGF FMR BIC eh TE Be TTR 6 FFPI(sequence) AT 4 MAGE 38 HF, MFA RTE RMA, FAA AT AL ARENA, FFA Oracle WHE TEP RTE PER, ATTIRE ER AVENE.HH Oracle RB 21 Fes AEE TT GENE, (LAR EP. REECE, JFL BL, BEAL ALES SFL «SUK UA FD EFA PRR BEAR eR 5 LF ELAS A PHA. 1.3.8 fia Oracle FF] Xial(synonym) AE BAER RI» FPO BORER SASL, IP AL Bae SUPERS QURAN. Lia my DU ae. UP. PLE. FPS. PE. OE. PAPERAL, BRT BAS Med a STC] AS Ce MAR OP i Fe] SCH AT AR A RAH 1). ATT a EP EE, FLT. 2S ATTA SG HH DBA GSE, Jf LITA ADS EF AT ah A 2S Aa Td SC i. Rr: OLEAA GG, BAAR) C58) O45 AP ANA Ah ik HG) PAT RE AR, SUALRGR FER RAL, Oracle MATER A TAET HP. WEEE ALG, Oracle BETA ALA Tal Lin]. WRAL ATA] SLi, Oracle BEAT AEA ATIF] Sind. ART AiR], Oracle WRI. 1.3.9 PL/SQL Oracle PL/SQL Ht Oracle Xf SQL fkAMbin a RE. “bsifeRY DML Ml SELECT if 4) 2 Gi ak PE 7 ED ACTS: Ba Eg A RT EAR, PL/SQL TRA ATN, et RL OR EAE BEI = (GB (A CHA Ada) PARA TL. M Oracle 91 JF EI. SQL AbHES1SEZE SQL All PLISQL ZiWIEF, BORAT SINE SQL Har HE AY LA A su PL/SQL. Fifi fa 38 SPH 12H] Oracle PL/SQL fi 1. MBL PL/SQL ih #27 RUE PL/SQL sr BER FEB. PLISQL HL PLISQL AFH, HPHGIEML AR FRUTM MENIAL, ERB AS 3 PAS: BSAA. HUT ERDAS ADS} SPE AMR BCA APC CE Ps POS MEI BI BY, Ol SQL SELECT iA). HAR, AAEM, LBEURAT. Wii, PRMSRUR HATE RR, HELA] i RI Hee ELAS eR A. TPEAIR BESS aS On. CRUE AP A EEK, AB PEM, BECAME, FARA TARE TE. Itoh, BRS We, BIEL AT GE] PL/SQL fick BEA HE tt XE GOs « — Ye PL/SQL 8 FH 07 435 FH 14 PS HE Ay F Sf Hill ict Is 2K SQL SELECT #il INSERT iA), ikiDR APE AAT RIE BERG AAT TT AT 5 2. BFE PLISQL Fil €L(package) #41 4 EB BA iL FELL Ae MLL 4 BANE (cursor) Eile 5 AFA MATMAAR: POMONA Eh. POM, PENT AR HE FFT ASSIA DR AE LAT EA IE EE LE OP. UE TT22 Rl BURR AEA Pe, WU LEO A NLA SL A A, AAT DARI IP CREAT HABA ZK ATES, TEMES EE So 3. ARAL ES fale 28 (trigger) AL AVE AAY PL/SQL BR Java {UE th PEACE HG SEPARA O22 EPL Y DML HJ, DDL ity LEAR RUE EU AREA). ATLL IE HE AAAS a, ICE en HF SR Te HD eb A. WRAP fae: EAT AT FL TBE AS Tal GR ES AZ TR HR (a a OB Ab, WY FA] PSI HAA A PEN Oracle 29 HC Lie SC OP BL HEU. BAT BEHG SP A fi A YD TR A ET 1.3.10 SaB3C fis Tal PRT SBE, Oracke 45 AME MEM AY AST Ui ed SE Se © CE SQL*Plus 1, ijl) Loy Bee TAY Heft SQL sin SAH Hb PBA AS ir HATE EIS AEN IC EAE e 7E PL/SQL WHEY, (KI UTL_FILE PS PY els iL AEH DBMS_OUTPU ili Ay Ese LALIT, 55-4 i TARMAC, IMR EECA HE © BFILE SGA EAT SSBB. BRILE 2d 2 Abdi iy 9b ab HEM CAMS. YE BFILE WA FRG AEZ i, YEG CREATE DIRECTORY MG ARMA, Or OAH EL TFIK BFILE Fl batty 76 8 Aah EIN HS. © DBMS PIPE HY5 Oracle SUPE 3GL INTER s% COBOL. © UTL_MAIL 3é Oracle 10g "PTAA. (E ft/F PLISQL IAP AE Fm PE, AS hk EE FY AEA Gs YT SMTP BIL HE FEAR SE SCTE Dy ER RET AAA EI, DORE MUTE. CEO Yb A, BZA, MARAE ill: BREA ALP HC HY HEE AS — AREAL AY © HER PL DT US 0 DLT ALI Se, TOR RS YG, 1k BASIC E RY fe Le HES, FAA CENA CE A DS SCARE A EPL LP? JAMEL, PEE RSE OMOEA IL OT HEME TTL YETI © FEF HAE DIRECTORY RATA HRM SCHE. REIT ee ete. STL TERA AI A He ATE RIE T Bed EMR Le 2 1.3.11 SURES EMEE SCE PE GEAR FOYE Oracle Bcd HE SI FH 49th CE AS Se MS EZ ATR fir CREATE DATABASE LINK 1) 2 B26 PURGE ME MUP, MAiTG FO a ERB ET RTS EE FT ELA EGE: RE HE 4 PS ERE DE AEN Hs. ST) T-8E Ae He A SQL*Plus SPOOL SA J JADU, PL/SQL WRF ry Dai aie Ak, CH. Ada, Java NAD ACP NER ee CES 4S He eS LE 5 EAP HT OR A]WR Oracle KABA 23 MEME TIT » BARRA BARES OL ACS PED Cd: AR ERE TD Dy Ag AFT, TEAL TRE POEM TT EOR Ui lad Fb — EI. EMER CE, eC SA ME Sb TH AS 4 8G, Ate ae ORS A 5 TILED, el GAR ET CYS TRH PAR I A ae SORA PUA EP EES Pate DAs RSE PM) AS EE AEE Al ED FE 2 AAS PBA TE ABIL. ast, FUL IE Wh 4) ALA SH DB_NAME fil DB_DOMAIN.. At Pca REE. TA A] CDR AR ER, HERE Via) EG, AIAN nila JRE AWA BIL A IE LEG EG AAA ERE, Way LL ARAM BANE, OED ied BARI, BEAT ARS i fal BL RH V7 REA UE 28 Sp tf A Ai AS EH PY BH PB 1.4 Oracle 43247-4825 74 Oracle SSF LTT LAE 1) XD EEG LAE ER RAAT SEL PSS PE AG NE FEA HH. WBC PE. IAC as SCPC SCPE. PRESB aS SAE Hy, WUTC, FPA RAMEE ARAS, TUE SC ACY SHR AMR AH ae i SALA AMEN De PE AS. 1-3 Shas TL SIZ, MEP RATE 12 POR To tet se : rr a a —H A) I | : sari [exer |[ ean |fsmnsen ty Bote t J nace | | seta | | eomsres | | sumer remxagsa system ] [users SYSAUX, Reet) Reef ee 141-3 Oracle Ef hit24 BiGS MEA 1.4.1 SUES HE EAS Oracle BIEL A 8 “> 7 BE SCF (datafile). > Oracle SH CAE RYDE fa tit Ef 7B TE RSESE HF» Oracke SSCS FEM? BAI ESAS SCE LEE AS dT) P18) PR, PRT — Ae 2 Fs A ea FS BE Se PPAL(BIGFILE 2222 18 F&F ch 4 A SCAU). 4 Oracle BURSCH Te K, “EMA A BAT ke, ABE DBA 2248S] AUTOEXTEND 22 SRK CAEL. MLA] MAXSIZE S¥L, DBA tH AT LLP HIE BOR CEM HEAR. ZE EAT ORF» BESO AI A aE AB Se SE BE IT TB (1 A A (1 im: DBA ih FLA MRAP R—ATAAIR AB RSE LH, ER PBF S AR OA AIR EMMA L A. Oracle HF HMAP, HA AIE, Rie S MER, HAE BATANE LAS), MEAT BIGFILE ARMAS, TERZARNEBASRAD, BLA, RMAN #77 347 G4 BIGFILE & MAA Oracle Database Ig #48), AAP ABLE ROSE UBT, GREE Rat 8 hae BUSH IT AT A ae AE BE SB OC PP REED SADLY RARER AS Se 37 2S BUA SPE A ERE AUT PRA FAR ASIN SERGE. RTT, CEPTS SEM ZW, ESF AT AL 1.4.2 Bi AG FACIE, BG ERITH Oracle MEPS, MPR BG, MSH — A AGA HA TENG Foo 5 PF (redo log file). 4 Oracle Het FEW Zit BAA TAC tt, IY Oracle UE Aa AEF CAA SCE. A PE PT I a I RL BRE, WM ae CE Me bR I ACTIVE; WRIA PSL A AGB E, Wid INACTIVE: KIS SAETE Ge BE PU BDF 4 a CE, IEEE RI CURRENT. RARER F, AREAS SS A ICR CPR. NTT, RA UB, BR ae SEAULII eA BR HE WE Oracle SAR INC, ASHE FE SE DR 2 ef AR I NE TY AE aT BG AG A BGEDCEE . AGRA ZY Oracle SIS , aa iSh aT ER Es EAM as SC EPH a FERIA SCE, SAAT SHR JE OAR ASHE GU Be AE MCF) AIT a AE IA EAC SS SAL PE — 4S a A as SU Ze A SAB a ES A ARR AP LEAS TAN VDI AEE: © FREE APSE tn il 7 Sd FH A A A. USPS as ca CHE, ANTTTBIR Oracle Scab HE MUTT FE AUCH SEALE. 1.4.3 4m SCH 45> Oracle SHEA bts — Mest SC PE. FEL AED AR PEC 70 AR CA RP SREP SRA) © EEA PEL ee RIE Bak. OR BH EOF 2 TS SCP A SHAAN. WES, PEA EA RS ERMAN), UATE RMAN BEAN CEE LAN IT ASA. E12 BRR SPER BA EAT ONIN, APR1B Oracle Asta 25 AVR BTEREBISCEE TD » SCR BOE PED EE EE, PPD ATR SUT BCS. MRT. BEREICH BS DASE — ASE IK, FR BEAR Se HE PB CE PE EE 7 Ba sete ALTER DATABASE BACKUP CONTROLFILE TO TRACE sir JE 3) id (243A SC FFD BK. EM M—P SQL WIA, WR ENF ROME HE A BRT Ze CE SCE TAT & 76 8 A — AAS UTADA FD ID AS a i EP BIC fal, HU REG Gis MAG EEG BY BA PEO hl] — 7 OE PIE PRACTICA AER a, HCI BD DIA LAS PPR ak SC PPR BE URE HSL ES MK Oracle 10g JFMy HY (LT nid SFP As RATE, ASS EL OUR SCP. 1.4.4 JAAD ACHE Oracle BARE PS ADR FAS; ARCHIVELOG #1 NOARCHIVELOG #izt. “iH Meak F NOARCHIVELOG #500, ACL a CAEP “IDLER ICA as Ste” RATE Le Ai Be (TTT EH 1 RYE EE ARIAS HE Aa Tt AA Ke ACB ASE 5 ZE NOARCHIVELOG #230 PETER. FI CERES: Bil MB ASE UN RP REI PAL Fy BEE IEE AT 5 A BE SCE ITT AE HAT EOL HL 38s SCPE PR AMR, ARCHIVELOG SESH SFG HE Mik Eas SP RR) — ORS “MEY FLEA, FEL BY EA BAe BIAS FE SPA SEE Fi UE eI FH AE. Bn, FL HE ‘PR ERT BER ST A A SB A HS IE ABERET th tt Pap AA TE Sc AE A aC I OPT Se SAG 9 HEC as HE & PY SN RE Oracle HATA PER HE —, Bl“ Oracle Data Guard (24% P-L)”, I % “Oracle A BGR HE(Standby Database)”. 3% 13 SPKSiFAI STH Oracle Data Guard. 145 MSM SREB BUNT, 29 Oracle KGISREAITE, ITFF SRP IM SREP LE SCAHISCHE, 294 init.ora(—fLAE NY initora 8 PFILE); BRA JEM aS Bev UC SPFILE)» 3:51 P SEERA IE RAEN ERU AY BBA fl Unix t.fSORACLE_HOME/dbs)#t 42 SPFILE: spfile.ora 5% [Link], MIKE MATE CE, SIAL Wy init.ora ff) PFILE. Ea — Bie AWAY LAG STARTUP 6 SE sR HT ft PFILE. ACME, WB BOC EAB AT LE BREE CEE. PERC AN, Fa SCEPC EAE. EAR RGA ISCAS PATO AAI, DAD AIAT 2 LP OT ed eB Be PE TE Oracle 94 Li, {FH initora Sc PEs RAGE SMI BS MIME — as. LR CR EAS FT MILES SD HEA SCE, (EAT HEL. WR YE dr 247 ARH] ALTER SYSTEM dr ek RASRKSM, Ml DBA WAGGA [Link] LUE. MATTE MS BAA AT VLE FC EAB Sead AE26 HISD HEARS SPFILE {# DBA WILLE ATMA MS He. WA SPFILE PST, MAe AVS RAVE] ALTER SYSTEM fr 2 eTT LL AoE SPFILE PHM SH, BRA FEAT ATVI SL, LAIN PA. NEAL AS i BESS SPFILE, 2648 6] DLAMILMS SPFILE AD. BURA IE BUR S BOC EM SPFILE (44, {10 4f SPFILE 6321 [Link] Sf, Pa aS IRM E BBE fir 8K RMAN(ZE SPFILE ftifde F) th) Oracle 3541119 [Link] Fil SPPILE. 4H DBCA GAGE, SKU O12 SPFILE. 1.4.6 SRANIRERA BIC “UIRABIN, Oracle iAP HHT AS ASHER A a(alert log), (ACEI AUER i Ot BLE, GHA ASRER A ak(trace log)3ctF. WH ELT Eh Wh SH BACKGROUND_DUMP_DEST /##2 MER, EAAHE ASR TE. ORB, TERRA ERA, INRA FR MMS RI. Hb, DBA #22211 (EJ ALTER DATABASE 2% ALTER SYSTEM fi PBA WEL TG. BI Ae BB 3c PF RE A RE ACR i ee ET) BR RE EIA) UA BAS A CES ON BAe ETA). RR, OF ASL Pe. A AE a Widsets. Oracle 3: ffl fri fr UbAY M4 MLE IL fk iit BACKGROUND_DUMP_DEST 4 fii. {i M11, PMON(Process Monitor, iif fiiKiill) il SMON(System Monitor, AEN) ICE PLE AcBR SMON ‘fi BEAT SE OAM SE ak — 4 4 A, QMON(Queue Monitor, [+ Hil) MFR EE Ie PREECE BEE Bi . BERS Ph Pe EDEL 2 QU ERERER SCTE. SEER ERIC PERL PM BL USER_DUMP_DEST #813@ (9 Flatt. 22 Fi By POR F 22 GUE A ERR NE AR Fe Ly BR R.A ALT EA a ER. CE A BT Ar ALTER SESSION SET SQL_TRACE=TRUE {i x(Jth @ 281 fe ERT AD DT AES SQL i AVE RENE, ATES AY SQL HAUS EEF HY AE AO] TA RE fn BAR LEE, PE RR EL fh. DBA ile “MERA BA He i ft Ao¥), PRA dite 4A RA. 1.4.7 BH ASE AS TORU, UBT RACY hl oy & BK OracleRMAN( HSL FH HL28)» HR DBA tt AE” BAKE SOR ME SAAS IL 7H), BOSCH ARE SCPE. HEBEL SCA SSBC APE ATELIER SER AS Bae Td SC ADE ACPA (Qe AS(RMAN "PAYER Aah), RMAN HBO LA ERE SCPE. Bech SCE. TASCA. VARA CAPR SPFILE ATE REA AIM Le, RES OR PRA, POU “4 OME", SAT RMAN TT LLBEIR. RMAN #4348 189 fi OO a AP aA SCH, PAA RMAN 3645 4b ACFE. HE OY PIR aE Oracle die 4F 32 25 (19 1