Visual Studio Oracle Database 11g アプリケーション開発入門

Transcription

1 Oracle on Windows etc Windows Server System Center / OTN Japan + Oracle Database.NET Developer Center / OTN Japan Oracle / OTN Japan

2 / Oracle on Windows 2

3 Oracle Direct Seminar < >

4 Agenda Visual Studio 2008 Oracle 4

5 Visual Studio Oracle Data Access Components Oracle Developer Tools for Visual Studio.NET (ODT) Microsoft Visual Studio C++ / C# VB.NET (ASP/ASP.NET) MTS/COM IIS Oracle Database Extensions for.net (ODE.NET) Oracle Data Provider for.net (ODP.NET) Oracle Services for MTS Visual Studio 2005, 2008.NET Framework 2.0/3.x 5

6 ODP.NET NET Oracle 6

7 ODP.NET 2002 VS.NET , 2008.NET Framework 1.0 ADO.NET Oracle 7

8 ODP.NET ODP.NET Oracle CD OTN-J h/dotnet/index.html Oracle ODT ODP.NET VS.NET 8

9 OTN-J.NET Developer Center 9

10 Oracle Data Access Components (ODAC) ODP.NET, ODT ODAC 10

11 Oracle Data Access Components (ODAC) Oracle Universal Installer GUI 11

12 ODT Visual Studio Oracle 12

13 ODT Oracle Explorer DB PL/SQL PL/SQL Data Window Oracle Query Window SQL*Plus 13

14 ODT Oracle PL/SQL Oracle Oracle Oracle 14

15 Oracle Oracle Oracle 15

16 PL/SQL PL/SQL 16

17 PL/SQL Visual Studio PL/SQL 17

18 ODAC ODT Server Explorer Oracle Database SQL*Plus 18

19 ODAC ODT Server Explorer Visual Studio 2005 Server Explorer ODT Visual Studio 2005 Oracle Database SQL Visual Studio 19

20 ODAC ODT GUI.NET Custom Class(C#,VB.NET, C++ ) SQL*Plus EDIT HOST SQL*Plus SQL 20

21 ODT ODT Oracle CD OTN-J Oracle EXE setup.exe setup.exe OUI ODT ODP.NET VS.NET 21

22 ODE.NET.NET 22

23 Oracle Database Extensions for.net Microsoft Visual Studio.NET 2005 C++ / C# VB.NET Oracle Database Extensions for.net (ODE.NET) DLL (foo.dll) PL/SQL Oracle Developer Tools for Visual Studio.NET (ODT) 23

24 ODE.NET Oracle Instance PL/SQL Oracle CLR Host Microsoft.NET CLR 24

25 .NET Oracle Project.NET 25

26 .NET 1. Oracle 2..NET 3..NET DLL PL/SQL SYS SYSTEM 26

27 .NET Oracle Deployment Wizard for.net.net 27

28 ODAC ODE.NET.NET Stored Procedure Nullable type.net Framework 2.0 Nullable Type 28

29 Agenda Visual Studio 2008 Oracle 29

30 ODP.NET 30

31 ODP.NET 1 FetchSize 65,536 31

32 ODP.NET 2 1 Select * from emp DB 1 WEB DB 2 Select * from emp 2 WEB DB 32

33 ODP.NET 3 Client = Connection WEB DB Client > Connection WEB DB 33

34 ODP.NET 34

35 ODP.NET FetchSize 64KB 35

36 ODP.NET / BLOB BLOB Oracle Data Provider for.net 11.1 LOB Oracle 11g

37 ODP.NET OracleBulkCopy Oracle Oracle Oracle Data Provider for.net

38 ODP.NET 38

39 Oracle Database Result Cache Oracle Datatbase 11g 1.0 Inventory Orders Line Items Inventory Orders Line Items Back Orders Pick Lists Back Orders Pick Lists SQL 39

40 Oracle Database Result Cache SQL SGA A Select SGA SQL Select B 40

41 Oracle Database Result Cache alter system set RESULT_CACHE_MODE = 'FORCE'; MANUAL FORCE select /*+ result_cache */ first_name, last_name from employees RESULT_CACHE_MODE MANUAL SQL 41

42 ODP.NET SQL Where 42

43 ODAC ODP.NET ODP.NET SQL or PL/SQL Application (A) ODP.NET Cache ODP.NET Cache ) ODP.NET Cache 43

44 Oracle Database SecureFiles SecureFiles LOB Oracle 11g

45 Oracle Database SecureFiles STORE AS SECUREFILE SQL> SQL> CREATE TABLE TABLE t1 t1 (c1 (c1 CLOB) CLOB) 2 LOB LOB (c1) (c1) STORE STORE AS AS SECUREFILE ; BASICFILE (STORE AS ) BASICFILE SQL> SQL> CREATE TABLE TABLE t1 t1 (c1 (c1 CLOB) CLOB) 2 LOB LOB (c1) (c1) STORE STORE AS AS BASICFILE ; 45

46 LOB Oracle Database SecureFiles LOB 46

47 ODP.NET 47

48 Oracle Database ODP.NET Pooling=FALSE string no_pool = "User Id=hr; Password=hr; Data Source=oramag; Enlist=false; Pooling=false" Pooling=TRUE string with_pool = "User Id=hr; Password=hr; Data Source=oramag; Enlist=false; Pooling=true" Pooling TRUE 48

49 ODP.NET ONLY Oracle Database OS ConnectionString User Id / Windows DBA Privilege SYSDBA SYSOPER Oracle ODP.NET OS 49

50 Oracle Database Perfmon Windows Perfmon ODP.NET ODP.NET Oracle Data Provider for.net 50

51 ODT Visual Studio 51

52 ODAC ODT Oracle Visual Studio Automatic Database Diagnostic Monitor(ADDM) SQL Tuning Adviser ADDM AWR ( ) / SQL SQL 52

53 ODAC ODT SQL Tuning Adviser 53

54 ODAC ODT Oracle Performance Analyzer 54

55 ODP.NET System.Transaction 55

56 ODP.NET System.Transactions TransactionScope 56

57 ODP.NET System.Transactions CommittableTransaction 57

58 ODP.NET System.Transactions Oracle Data Provider for.net System.Transactions Oracle Data Provider for.net System.Transactions PromotableTransaction "local" "Promotable Transaction" "local" ODP.NET ( System.Transactions 58

59 ODP.NET 59

60 OUI ODP.NET Oracle Client Oracle GUI DB Server, Client GUI Silent install Microsoft SMS Instant Client XCopy 60

61 Instant Client XCopy Install Step 1: Unzip and copy IC files to disk Step 2: install.bat Oracle Home 3 Step 3: Windows PATH Step 4: NLS_LANG 61

62 XCopy Install.bat 62

63 Instant Client XCopy Instant Client xcopy SQL*Plus OCI OCCI ODBC JDBC-OCI Instant Client xcopy ODP.NET Oracle Providers for ASP.NET Oracle Provider for OLE DB OO4O Oracle Services for MTS 63

64 tnsname.ora ODP.NET ONLY tnsnams.ora 64

65 Multiple Oracle Homes(MOH) Multiple Oracle Homes (MOH) Oracle : Oracle Database version example: Oracle : d: oracle10 ora102 Oracle : d: oracle11 ora110 65

66 Multiple Oracle Homes Multiple Oracle Homes : HKLM Software Oracle ALL_HOMES and HKLM Software Oracle HOME(n) HKLM Software Oracle KEY_home 66

67 Multiple Oracle Homes Oracle Client Software Oracle client DLLs Windows Path Web (IIS) IIS supports separate worker processes in same instance IIS 6 for Windows Server 2003 process Dll Client/Server Oracle Home PATH 67

68 Oracle Homes in.net ODP.NET ODP.NET.NET config files Oracle DLLs Oracle Client ODP.NET DLL 1. Current application directory 2. Application config or web.config 3. Machine.config 4. Windows Registry HKLM Software Oracle ODP.NET <version> DllPath 5. Windows System Path setting 68

69 .NET Visual Studio 2005, 2008 Oracle Oracle Data Provider for.net(odp.net) Oracle Developer Tools for Visual Studio.NET(ODT) Oracle Database Extensions for.net(ode.net) 69

70 Oracle Direct Seminar 100 Wendy !! Oracle Direct 70

71 OTN!! Oracle Technology Network(OTN) OTN OTN Oracle 100% 71

72 Oracle University LiveL Virtual Class Oracle University Live Virtual Class Oracle Database 11g: -LVC(3 ) ( ) ( ) ORACLE MASTER Silver Oracle Database 11g Oracle University Live Virtual Class 72

73 IT Oracle Direct Concierge BI IT BI Access / SQL Server MySQL / PostgreSQL Oracle Database Oracle Developer Web RFP BI Oracle Database Oracle Database 73

74 Oracle Direct Oracle Direct IT / Web ~ 9:00~12:00 13:00~18:00 74

75