ϓϩάϥϚͷͨΊͷ ORACLE DBA ೖ໳ 2011/04/16 ୈ57ճ CLR/Hษڧձ ૉఢͳ͓ͻ͛

ࣗݾ঺հ •  H/N : γόλ(ૉఢͳ͓ͻ͛) •  Twitter : @stknohg •  Blog : http://d.hatena.ne.jp/stknohg/ •  ࡳຈͰಇ͘SIerͰ͢ɻ Πϯϑϥߏங͔Βɺઃܭɺ੡଄ɺอक·Ͱ͍Ζ͍Ζத్൒୺ʹ ΍͍ͬͯ·͢ɻ ̎̌̍̌೥ΑΓCLR/Hελοϑͱͯ͠׆ಈதɻ •  อ༗ࢿ֨ •  ORACLE MASTER Gold Oracle Database 10g •  σʔλϕʔεεϖγϟϦετ •  ଞ…

DBAͱ͸ • Database Administratorͷུ • σʔλϕʔε؅ཧऀ • σʔλϕʔεͷ؅ཧͬͯԿ͢Δͷʁ

DBAͷλεΫʢOracle Database؅ཧऀΨΠυΑΓҾ༻ʣ •  Oracle DatabaseαʔόʔͱΞϓϦέʔγϣϯɾπʔϧΛΠϯετʔϧ͓ΑͼΞοϓάϨʔυ ͠·͢ɻ •  σʔλϕʔεɾγεςϜʹγεςϜهԱҬΛׂΓ౰ͯɺকདྷͷهԱҬཁ݅Λܭը͠·͢ɻ •  ΞϓϦέʔγϣϯ։ൃऀ͕ΞϓϦέʔγϣϯΛઃܭͨ͠ޙɺϓϥΠϚϦɾσʔλϕʔεͷهԱ Ҭߏ଄ʢදྖҬʣΛ࡞੒͠·͢ɻ •  ΞϓϦέʔγϣϯ։ൃऀ͕ΞϓϦέʔγϣϯΛઃܭͨ͠ޙɺϓϥΠϚϦɾΦϒδΣΫτʢදɺ ϏϡʔɺࡧҾʣΛ࡞੒͠·͢ɻ •  ΞϓϦέʔγϣϯ։ൃऀ͔Βಘͨ৘ใʹج͖ͮɺඞཁʹԠͯ͡σʔλϕʔεߏ଄Λमਖ਼͠ ·͢ɻ •  ϢʔβʔΛొ࿥͠ɺγεςϜɾηΩϡϦςΟΛϝϯςφϯε͠·͢ɻ •  OracleͷϥΠηϯεܖ໿ʹै͍ͬͯΔ͜ͱΛ֬ೝ͠·͢ɻ •  σʔλϕʔεʹର͢ΔϢʔβʔɾΞΫηεΛ੍ޚ͠ɺ؂ࢹ͠·͢ɻ •  σʔλϕʔεͷύϑΥʔϚϯεΛ؂ࢹ͠ɺ࠷దԽ͠·͢ɻ •  σʔλϕʔε৘ใͷόοΫΞοϓ͓ΑͼϦΧόϦͷܭըΛཱͯ·͢ɻ •  ςʔϓ্ͷΞʔΧΠϒࡁσʔλΛϝϯςφϯε͠·͢ɻ •  σʔλϕʔεΛόοΫΞοϓ͓ΑͼϦετΞ͠·͢ɻ •  ٕज़αϙʔτʹ͍ͭͯOracleαϙʔτɾαʔϏεʹ࿈བྷ͠·͢ɻ

ࠓ೔ͷ໨ඪ 1.  OracleΛΠϯετʔϧͰ͖Δ༷ʹͳΔ 2.  σʔλϕʔεΛ࡞ΕΔ༷ʹͳΔ 3.  Oracleͷߏ଄Λ”ͪΐͬͱ”ཧղ͢Δ 4.  Oracleͷӡ༻Λlͪΐͬͱ”ཧղ͢Δ

ΞδΣϯμ 1.  Oracleͷ࢓૊Έ 2.  Πϯετʔϧͯ͠ΈΔ 3.  σʔλϕʔεΛ࡞ͬͯΈΔ 4.  σʔλϕʔεͷઃܭ 5.  σʔλϕʔεͷӡ༻ 6.  ·ͱΊ

؀ڥ • ୯ҰͷαʔόɺΫϥΠΞϯτແ͠ • OS • Windows 2008 Server R2 SP1(64bit) • Standard Edition • σʔλϕʔε • Oracle Database 11g R2(11.2.0.1.0) • Standard Edition

1.ORACLEͷ࢓૊Έ

Oracleͷྺ࢙ ϦϦʔε όʔδϣϯ ಛهࣄ߲ 1978೥ Oracle version 1 ౰࣌ͷ໊ࣾ͸RSIࣾɻΞηϯϒϦͰ࣮૷ɻະϦϦʔεɻ 1979೥ Oracle version 2 ࠷ॳͷ঎༻ϦϦʔεɻ 1983೥ Oracle version 3 ໊͕ࣾOracleʹมߋɻCͰ࠶࣮૷ɻ 1984೥ Oracle version 4 ಡΈऔΓҰ؏ੑͷαϙʔτɻ 1985೥ Oracle version 5 C/SରԠɻ 1988೥ Oracle version 6 PL/SQLɺߦϨϕϧϩοΫͷαϙʔτɻ 1992೥ Oracle 7 ετΞυϓϩγʔδϟɺτϦΨʔͷαϙʔτɻ 1997೥ Oracle 8 ΦϒδΣΫτࢦ޲ɺେ༰ྔσʔλʹରԠɻJava΁ͷίϛοτɻ 1998೥ Oracle 8i i͸ʮinternetʯͷུɻ 2001೥ Oracle 9i RAC(Real Application Cluster)ɻ 2002೥ Oracle 9i Release 2 ։ൃ؀ڥͷػೳڧԽͳͲɻ 2003೥ Oracle 10g g͸ʮgridʯͷུɻRACͷ֦ுɻASMɻϑϥογϡόοΫػೳɻ 2005೥ Oracle 10g Release 2 ֤छػೳڧԽͳͲɻ 2007೥ Oracle 11g Real Application Testingɻ 2009೥ Oracle 11g Release 2 Oracle Grid Infrastructureɻ

ΫϥΠΞϯτϓϩηε هԱྖҬ Oracleͷ࢓૊Έ Πϯελϯε Ϧεφʔ αʔόʔϓϩηε όοΫ άϥ΢ϯυ ϓϩηε System Global Area (SGA) Program Global Area (PGA) ੍ޚϑΝΠϧ Redoϩά σʔλ ϑΝΠϧ ΞʔΧΠϒ ϩά ύϥϝʔλ ϑΝΠϧ

Πϯελϯε • σʔλϕʔεΛ؅ཧ͢ΔҰ࿈ͷϝϞϦߏ଄ • Πϯελϯε͸ҎԼͷཁૉ͔Βߏ੒͞ΕΔ •  System Global Area(SGA) •  όοΫάϥ΢ϯυϓϩηε • Πϯελϯε˺σʔλϕʔε • Πϯελϯεͷ࣮ମ͸WindowsαʔϏε (Oracle.exe)

System Global Area (SGA) •  Πϯελϯεʹର͢Δ੍ޚ৘ใ΍Ωϟογϡ౳ͷڞ༗ϝϞϦ ྖҬ •  ओͳྖҬ ྖҬ໊ ಺༰ Shared Pool ղੳࡁΈSQL΍σʔλσΟΫγϣφϦͷ಺ ༰ΛΩϟογϡ Database Buffer Cache σʔλϒϩοΫͷΩϟογϡ Java Pool Javaίʔυ͓Αͼσʔλ༻ Large Pool େ༰ྔϝϞϦׂΓ౰ͯ༻ Redo Log Buffer Redoϩάॻ͖ࠐΈ༻ͷόοϑΝ

ུশ ໊শ ಺༰ PMON ϓϩηεϞχλʔ ଞͷϓϩηεΛ؂ࢹ ϓϩηεϦΧόϦͷ࣮ࢪ SMON γεςϜϞχλʔ ΠϯελϯεϦΧόϦͷ࣮ࢪ ະ࢖༻ηάϝϯτͷΫϦʔϯΞοϓ DBWn σʔλϕʔεϥΠλʔ όοϑΝͷ಺༰ΛσΟεΫʹॻ͖ࠐΉ LGWR ϩάϥΠλʔ REDOϩάϑΝΠϧͷॻ͖ࠐΈ CKPT νΣοΫϙΠϯτϓϩηε νΣοΫϙΠϯτͰͷDBWnॻ͖ࠐΈࢦࣔ MMON ؅ཧੑϞχλʔϓϩηε ࣗಈϫʔΫϩʔυϦϙδτϦʢAWRʣʹؔ࿈ ͢ΔλεΫͷ࣮ࢪ ARCn ΞʔΧΠό ΞʔΧΠϒϩάͷॻ͖ࠐΈ JCQ0 δϣϒΩϡʔϓϩηε εέδϡʔϧδϣϒͷ࣮ߦ؅ཧ όοΫάϥ΢ϯυϓϩηε •  ओͳόοΫάϥ΢ϯυϓϩηε

•  σʔλϕʔεΛߏ੒͢ΔϑΝΠϧ͸ҎԼͷ̏छྨ •  ͦͷଞϑΝΠϧ هԱྖҬ छྨ ಺༰ ಛهࣄ߲ ੍ޚϑΝΠϧ σʔλϕʔεͷ෺ཧߏ੒΍ ϩάॱং൪߸౳Λอଘ͢ΔϑΝΠϧ ଟॏԽՄ RedoϩάϑΝΠϧ σʔλϕʔε΁ͷมߋΛه࿥ ॥؀ར༻ ଟॏԽՄ σʔλϑΝΠϧ σʔλΛอଘ͢Δ (Undoηάϝϯτʣ τϥϯβΫγϣϯதͷมߋΛه࿥͢Δ ϑΝΠϧ ॥؀ར༻ (Ұ࣌ηάϝϯτ) SQL࣮ߦ࣌ͷιʔτॲཧͳͲʹ࢖༻ छྨ ಺༰ ಛهࣄ߲ ΞʔΧΠϒϩά ݹ͍RedoϩάϑΝΠϧͷίϐʔ ύϥϝʔλϑΝΠϧ Πϯελϯεͷઃఆ৘ใΛอ࣋

Program Global Area (PGA) •  αʔόʔϓϩηε͕࢖༻͢ΔϝϞϦྖҬ •  ओͳྖҬ ྖҬ໊ ಺༰ SQL Work Area SQLͷιʔτ༻ϝϞϦྖҬ౳ Session Memory ηογϣϯ৘ใͷϝϞϦྖҬ Private SQL Area ղੳࡁΈSQL৘ใɺόΠϯυม਺౳ͷϝ ϞϦྖҬ

Ϧεφʔ • ΫϥΠΞϯτ͔Βͷ઀ଓΛ࠷ॳʹड͚෇͚Δϓϩηε •  ΫϥΠΞϯτͱαʔόʔϓϩηεͷ஥հ໾ • Πϯελϯεͱ͸ಠཱͯ͠ଘࡏ • ໌ࣔతͳࢦఆ͕ແ͍৔߹ɺΠϯελϯε͸σϑΥϧτ ͷϙʔτ(TCP1521)Ͱ଴ͪड͚ͯΔϦεφʔͱඥͮ ͚ΒΕΔ • ࣮ମ͸WindowsαʔϏε

2.Πϯετʔϧͯ͠ΈΔ

Πϯετʔϧ • OracleͷΠϯετʔϧ͸ͱͯ΋؆୯ʂ • Πϯετʔϥʔͷࢦࣔʹै͏͚ͩʂ • ΨοπੴদͰ΋ΠϯετʔϧͰ͖Δʂ

Demo

Ϧεφʔͷ࡞੒ • Net Configuration Assistant (NetCA) • ΢ΟβʔυܗࣜͰϦεφʔΛߏ੒ • Ϧεφʔͷ࡞੒Ҏ֎ͷωοτϫʔΫߏ੒ʹ΋ ࢖༻͢Δ

Demo

̏.σʔλϕʔεΛ࡞ͬͯΈΔ

σʔλϕʔεͷ࡞੒ʢGUI) • Database Configuration Assistant(DBCA) • ΢ΟβʔυܗࣜͰσʔλϕʔεΛ࡞੒ • ςϯϓϨʔτͱͯ͠อଘͰ͖Δ • εΫϦϓτͷग़ྗ΋Ͱ͖Δ

Demo

σʔλϕʔεͷ࡞੒ʢεΫϦϓτ) • ਖ਼௚ɺDBCA͸Πέͯͳ͍ • DBCAͰ࡞੒͞ΕΔεΫϦϓτ͸ ʮόονϑΝΠϧʴSQLϑΝΠϧʯ • DBCAͰεΫϦϓτ͚ͩ࡞ͬͯɺࣗ෼Ͱ௚ͯ͠ ࢖͏ͷ͕Φεεϝ

εΫϦϓτΛݟͯΈΑ͏

oradim.exe • Πϯελϯεͷ࡞੒ɺमਖ਼ɺ࡟আΛߦ͏ •  ࡞੒ •  oradim.exe -new –sid {SID໊} … •  मਖ਼ •  Oradim.exe –edit –sid {SID໊} … •  ࡟আ •  Oradim.exe –delete –sid {SID໊} … • Πϯελϯεͷ࣮ମ͸WindowsαʔϏε (Oracle.exe)

4.σʔλϕʔεͷઃܭ

ϑΝΠϧγεςϜ • OracleͰ࢖༻Ͱ͖ΔϑΝΠϧγεςϜ 1.  OSͷϑΝΠϧγεςϜ •  NTFS౳ͷ͍ΘΏΔී௨ͷϑΝΠϧγεςϜ 2.  Automatic Storage ManagementʢASMʣ •  Oracleઐ༻ͷϑΝΠϧγεςϜ •  ઐ༻ͷϘϦϡʔϜ͕ඞཁ •  ؅ཧ༻ͷΠϯελϯε(ASMΠϯελϯε)͕ඞཁ

ϑΝΠϧγεςϜ • ͲͷϑΝΠϧγεςϜΛબͿ΂͖͔ʁ •  େن໛γεςϜ΍RACΛߏங͢Δ৔߹͸ASM •  SE RACΛߏங͢Δ৔߹͸ASMඞਢ •  ͦΕҎ֎͸௨ৗͷϑΝΠϧγεςϜ • ਖ਼௚ɺASM͸ΊΜͲ͍ •  Oracle͸ӡ༻ίετ͕ݮΔͱ͍ͬͯΔ͚Ͳ… •  ݸਓతʹ͸͍͍ܦݧ͕ແ͍Ͱ͢ɻ ࢲͷܦݧෆ଍ͬͯͷ͋Γ·͕͢…

ॳظԽύϥϝʔλ • σʔλϕʔεશମʹؔΘΔઃఆϑΝΠϧ •  PFILE •  ςΩετܗࣜͷઃఆϑΝΠϧ •  σʔλϕʔεىಈதʹϑΝΠϧͷมߋ͸Ͱ͖ͳ͍ •  SPFILE •  Oracle 9i͔Βొ৔ •  όΠφϦܗࣜͷઃఆϑΝΠϧ •  σʔλϕʔεىಈதʹϑΝΠϧͷมߋ͕Մೳ • جຊSPFILEΛѻ͏

SGA/PGAʹؔΘΔύϥϝʔλ •  ৄࡉ͸ϚχϡΞϧ(Oracle Database ϦϑΝϨϯε)Λࢀর SGA/PGA ύϥϝʔλ ಺༰ SGA SGA_MAX_SIZE SGAͷ࠷େαΠζ SGA_TARGET ࣗಈ؅ཧ͢ΔSGAͷαΠζ DB_CACHE_SIZE σʔλϒϩοΫΩϟογϡͷαΠζ SHARED_POOL_SIZE ڞ༗ϓʔϧͷαΠζ LARGE_POOL_SIZE ϥʔδϓʔϧͷαΠζ JAVA_POOL_SIZE JAVAϓʔϧͷαΠζ STREAM_POOL_SIZE Stream PoolͷαΠζ LOG_BUFFER REDOϩάόοϑΝͷαΠζ PGA PGA_AGGREGATE_TARGET PGAͷूܭαΠζ PGA/SGA MEMORY_TARGET σʔλϕʔεશମͷϝϞϦαΠζ MEMORY_MAX_TARGET MEMORY_TARGETͷ࠷େ஋

SGA/PGAʹؔΘΔύϥϝʔλ • ϝϞϦࣗಈ؅ཧ • ύϑΥʔϚϯε͕γϏΞʹٻΊΒΕΔ৔߹Ҏ֎͸ ࣗಈ؅ཧʹ೚ͤͨํ͕ྑ͍ SGA PGA MEMORY_TARGET SGA_TARGET PGA_AGGREGATE_TARGET

ઐ༻αʔό઀ଓ/ڞ༗αʔό઀ଓ • ઐ༻αʔόʔ઀ଓ •  1ΫϥΠΞϯτϓϩηεʹର͠ɺ̍αʔόʔϓϩηε͕௨৴ • ڞ༗αʔόʔ઀ଓ •  σΟεύονϟʔ͕ΫϥΠΞϯτϓϩηεͷৼΓ෼͚Λߦ͏ •  ΫϥΠΞϯτϓϩηεͱαʔόʔϓϩηε͸M:Nͷؔ܎ʹͳΔ ΫϥΠΞϯτ ϓϩηε αʔόʔ ϓϩηε ΫϥΠΞϯτ ϓϩηε ΫϥΠΞϯτ ϓϩηε ΫϥΠΞϯτ ϓϩηε σΟεύονϟ αʔόʔ ϓϩηε αʔόʔ ϓϩηε

ઐ༻αʔό઀ଓ/ڞ༗αʔό઀ଓ • ͲͪΒΛબͿ΂͖͔ʁ •  ઀ଓ਺͕গͳ͍ɺαʔόͷੑೳʹ༨༟͕͋Δ৔߹͸ ઐ༻αʔό઀ଓ •  ઀ଓ਺͕ଟ͍ɺαʔόͷੑೳʹ༨༟͕ແ͍৔߹͸ ڞ༗αʔό઀ଓ • ݸਓతʹ͸ʮͱΓ͋͑ͣઐ༻αʔόʯ •  ࠷ۙͷαʔό͸ੑೳ͕ྑ͍ •  ޙ͔ΒͰ΋ߏ੒ͷมߋ͸Մೳ

ϒϩοΫαΠζ • Oracle͕σʔλΛಡΈॻ͖͢Δ࠷খ୯Ґ ʢϒϩοΫʣͷαΠζ • σʔλϕʔε࡞੒ޙ͸มߋͰ͖ͳ͍ • ͲͷαΠζʹ͢΂͖͔ʁ • OLTPܥͳΒϒϩοΫαΠζ͸খ͞Ί • BI/DWHܥͳΒେ͖Ί • Α͘Θ͔Βͳ͚Ε͹σϑΥϧτʹ(8192byte)

෺ཧϑΝΠϧ/දྖҬ/ΦϒδΣΫτ දྖҬA DBF01 DBF02 DBF03 දྖҬB DBF04 DBF05 ςʔϒϧ A ςʔϒϧ B Πϯσο ΫεA Πϯσο ΫεB Πϯσο ΫεC Πϯσο ΫεD ςʔϒϧ C ςʔϒϧ D

5.σʔλϕʔεͷӡ༻

σʔλϕʔεͷىಈͱऴྃ • σʔλϕʔεͷىಈͱఀࢭʹ͸؅ཧऀݖݶ͕ඞཁ • ىಈ͸ STARTUP ίϚϯυ •  STARTUP NOMOUNT •  STARTUP MOUNT •  STARTUP (OPEN) • ఀࢭ͸ SHUTDOWN ίϚϯυ •  SHUTDOWN NORMAL •  SHUTDOWN TRANSACTIONAL •  SHUTDOWN IMMEDIATE •  SHUTDOWN ABORT

هԱྖҬ σʔλϕʔεͷىಈ(NOMOUNT) Πϯελϯε όοΫ άϥ΢ϯυ ϓϩηε System Global Area (SGA) ύϥϝʔλ ϑΝΠϧ •  ύϥϝʔλϑΝΠϧ͕ಡΈࠐ·Εɺ SGA͕֬อ͞Εͨঢ়ଶ •  ੍ޚϑΝΠϧͷߏ੒ΛมߋՄೳ

هԱྖҬ σʔλϕʔεͷىಈ(MOUNT) Πϯελϯε όοΫ άϥ΢ϯυ ϓϩηε System Global Area (SGA) ੍ޚϑΝΠϧ ύϥϝʔλ ϑΝΠϧ •  ੍ޚϑΝΠϧ͕ಡΈࠐ·Εͨঢ়ଶ •  REDOϩάϑΝΠϧɺσʔλϑΝΠϧ ͷߏ੒ΛมߋՄೳ

ΫϥΠΞϯτϓϩηε هԱྖҬ σʔλϕʔεͷىಈ(OPEN) Πϯελϯε Ϧεφʔ αʔόʔϓϩηε όοΫ άϥ΢ϯυ ϓϩηε System Global Area (SGA) Program Global Area (PGA) ੍ޚϑΝΠϧ Redoϩά σʔλ ϑΝΠϧ ύϥϝʔλ ϑΝΠϧ •  σʔλϑΝΠϧɺREDOϩάϑΝΠϧ͕Φʔϓ ϯ͞Εɺσʔλϕʔε͕׬શʹىಈͨ͠ঢ়ଶ

σʔλϕʔεͷऴྃ NORMAL TRANSACTIONAL IMMEDIATE ABORT ઀ଓηογϣϯͷ ऴྃ଴ͪ ͢Δ ͠ͳ͍ (ڧ੍੾அ) ͠ͳ͍ (ڧ੍੾அ) ͠ͳ͍ (ڧ੍ऴྃ) τϥϯβΫγϣϯͷ ऴྃ଴ͪ ͢Δ ͢Δ ͠ͳ͍ (ROLLBACK) ͠ͳ͍ (ڧ੍ऴྃ) νΣοΫϙΠϯτͷ ࣮ߦ ͢Δ ͢Δ ͢Δ ͠ͳ͍ (ڧ੍ऴྃ) σʔλϑΝΠϧͷ Ϋϩʔζ ͢Δ ͢Δ ͢Δ ͠ͳ͍ (ڧ੍ऴྃ)

Enterprise Manager • Oracleඪ४ͷσʔλϕʔε૯߹؅ཧπʔϧ (Oracle 10g͔ΒWEBϕʔεʹ) • σʔλϕʔεͷ؅ཧ͔Βࣗಈνϡʔχϯά ͳͲҰ௨ΓͷػೳΛඋ͍͑ͯΔ • ࢝Ί͸Enterprise ManagerͰษڧΛ݉Ͷͯ ӡ༻ͯ͠ΈΔͱྑ͍

࣮ࡍʹݟͯΈΑ͏

Enterprise Managerͷ᠘ • શͯͷػೳΛ࢖͏ʹ͸ Enterprise Edition+ΦϓγϣϯύοΫ͕ඞཁ • Standard EditionҎԼͰ͸جຊػೳͷΈ • Enterprise ManagerབྷΈͷো֐΋… •  ܦݧ্Ͱ͕͢ɺEnterprise Manager͕ఀࢭͰ͖ͳ͘ͳͬͯσʔλϕʔεͷγϟο τμ΢ϯ͕ϋϯά͢Δͱ͍ͬͨࣄ৅͕͋Γ·ͨ͠

ύϑΥʔϚϯενϡʔχϯά • େࣄͳࣄΛ̎఺͚ͩ(ࡉ͔͍ࣄ͸આ໌͠·ͤΜʂ) 1.  νϡʔχϯά͸”ΑΓ଎͘”͢ΔࣄͰ͸ͳ͍ɻ ”ϘτϧωοΫΛղফ”͢ΔࣄͰ͋Δɻ 2.  ϕʔεϥΠϯ௒ॏཁɻ

όοΫΞοϓ/ϦΧόϦ • େࣄͳࣄΛ̏఺͚ͩ(ࡉ͔͍ࣄ͸આ໌͠·ͤΜʂ) 1.  ϦΧόϦͷग़དྷͳ͍όοΫΞοϓ͸ҙຯ͕ ͳ͍ʂ 2.  ඞͣ෮چࢼݧΛ͢Δʂ 3.  ڐ༰Մೳͳμ΢ϯλΠϜΛઃఆ͢Δɻ

αϙʔτʹ͍ͭͯ • OracleΛ·ͱ΋ʹӡ༻͚ͨ͠Ε͹αϙʔτ͸ ඞਢʂ • αϙʔτʹೖΒͳ͍ͱग़དྷͳ͍ࣄ • ύονͷμ΢ϯϩʔυ • KROWNͷઐ༻৘ใʹΞΫηε • KROWN͸ๅͷࢁʂ

6.·ͱΊ

·ͱΊ • OracleΛΠϯετʔϧͯ͠σʔλϕʔεΛ࡞Δ ·Ͱ͸݁ߏ͔ΜͨΜʂ • σʔλϕʔεΛ࡞ͬͨޙ͸࣮ࡍʹखΛಈ͔͠ ͍֮ͯ͑ͯ͜͏ʂ

͝ਗ਼ௌ ͋Γ͕ͱ͏͍͟͝·ͨ͠