Oracle on Windows etc http://www.oracle.co.jp/campaign/mb_tech/ Windows Server System Center / OTN Japan http://www.oracle.com/technology/global/jp/tech/windows/.net + Oracle Database.NET Developer Center / OTN Japan http://www.oracle.com/technology/global/jp/tech/dotnet/!?.net Oracle / OTN Japan http://www.oracle.com/technology/global/jp/columns/easy/dotnet/
/ Oracle on Windows http://www.oracle.co.jp/campaign/mb_tech/column/ 2
Oracle Direct Seminar < >
Agenda Visual Studio 2008 Oracle 4
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
ODP.NET NET Oracle 6
ODP.NET 2002 VS.NET 2003 2005, 2008.NET Framework 1.0 ADO.NET Oracle 7
ODP.NET ODP.NET Oracle CD OTN-J http://www.oracle.com/technology/global/jp/tec h/dotnet/index.html Oracle ODT ODP.NET VS.NET 8
OTN-J.NET Developer Center 9
Oracle Data Access Components (ODAC) ODP.NET, ODT ODAC 10
Oracle Data Access Components (ODAC) Oracle Universal Installer GUI 11
ODT Visual Studio Oracle 12
ODT Oracle Explorer DB PL/SQL PL/SQL Data Window Oracle Query Window SQL*Plus 13
ODT Oracle PL/SQL Oracle Oracle Oracle 14
Oracle Oracle Oracle 15
PL/SQL PL/SQL 16
PL/SQL Visual Studio PL/SQL 17
ODAC 11.1.0 ODT Server Explorer Oracle Database SQL*Plus 18
ODAC 11.1.0 ODT Server Explorer Visual Studio 2005 Server Explorer ODT Visual Studio 2005 Oracle Database SQL Visual Studio 19
ODAC 11.1.0 ODT GUI.NET Custom Class(C#,VB.NET, C++ ) SQL*Plus EDIT HOST SQL*Plus SQL 20
ODT ODT Oracle CD OTN-J Oracle EXE setup.exe setup.exe OUI ODT ODP.NET VS.NET 21
ODE.NET.NET 22
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
ODE.NET Oracle Instance PL/SQL Oracle CLR Host Microsoft.NET CLR 24
.NET Oracle Project.NET 25
.NET 1. Oracle 2..NET 3..NET DLL PL/SQL SYS SYSTEM 26
.NET Oracle Deployment Wizard for.net.net 27
ODAC 11.1.0 ODE.NET.NET Stored Procedure Nullable type.net Framework 2.0 Nullable Type 28
Agenda Visual Studio 2008 Oracle 29
ODP.NET 30
ODP.NET 1 FetchSize 65,536 31
ODP.NET 2 1 Select * from emp DB 1 WEB DB 2 Select * from emp 2 WEB DB 32
ODP.NET 3 Client = Connection WEB DB Client > Connection WEB DB 33
ODP.NET 34
ODP.NET FetchSize 64KB 35
ODP.NET / BLOB BLOB Oracle Data Provider for.net 11.1 LOB Oracle 11g 1.0 36
ODP.NET OracleBulkCopy Oracle Oracle Oracle Data Provider for.net 11.1 37
ODP.NET 38
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
Oracle Database Result Cache SQL SGA A Select SGA SQL Select B 40
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
ODP.NET SQL Where 42
ODAC 11.1.0.7 ODP.NET ODP.NET SQL or PL/SQL Application (A) ODP.NET Cache ODP.NET Cache ) ODP.NET Cache 43
Oracle Database SecureFiles SecureFiles LOB Oracle 11g 1.0 44
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
LOB Oracle Database SecureFiles LOB 46
ODP.NET 47
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
ODP.NET ONLY Oracle Database OS ConnectionString User Id / Windows DBA Privilege SYSDBA SYSOPER Oracle ODP.NET 11.1.0 OS 49
Oracle Database Perfmon Windows Perfmon ODP.NET ODP.NET Oracle Data Provider for.net 50
ODT Visual Studio 51
ODAC 11.1.0.7 ODT Oracle Visual Studio Automatic Database Diagnostic Monitor(ADDM) SQL Tuning Adviser ADDM AWR ( ) / SQL SQL 52
ODAC 11.1.0.7 ODT SQL Tuning Adviser 53
ODAC 11.1.0.7 ODT Oracle Performance Analyzer 54
ODP.NET System.Transaction 55
ODP.NET System.Transactions TransactionScope 56
ODP.NET System.Transactions CommittableTransaction 57
ODP.NET System.Transactions Oracle Data Provider for.net 10.2.0.3 System.Transactions Oracle Data Provider for.net 10.2.0.3 System.Transactions PromotableTransaction "local" "Promotable Transaction" "local" ODP.NET (10.2.0.3 System.Transactions 58
ODP.NET 59
OUI ODP.NET Oracle Client Oracle GUI DB Server, Client GUI Silent install Microsoft SMS Instant Client XCopy 60
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
XCopy Install.bat 62
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
tnsname.ora ODP.NET ONLY tnsnams.ora 64
Multiple Oracle Homes(MOH) Multiple Oracle Homes (MOH) Oracle : Oracle Database version 8.0.4 example: Oracle 10.2.0: d: oracle10 ora102 Oracle 11.0.0: d: oracle11 ora110 65
Multiple Oracle Homes Multiple Oracle Homes : HKLM Software Oracle ALL_HOMES and HKLM Software Oracle HOME(n) HKLM Software Oracle KEY_home 66
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
Oracle Homes in.net ODP.NET 10.2.0.4 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
.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
Oracle Direct Seminar 100 Wendy 2010 11 12 2!! ORD_SEMINAR_JP@ORACLE.COM 2009 11 12 Oracle Direct 70
OTN!! Oracle Technology Network(OTN) http://otn.oracle.co.jp/forum/index.jspa?categoryid=2 OTN OTN Oracle 100% 71
Oracle University LiveL Virtual Class Oracle University Live Virtual Class Oracle Database 11g: -LVC(3 ) 11 12 ( ) 11 14 ( ) ORACLE MASTER Silver Oracle Database 11g http://education.oracle.co.uk/html/oracle/70ja/ilo.htm Oracle University Live Virtual Class http://www.oracle.com/global/jp/education/lvc/ 72
IT Oracle Direct Concierge BI IT BI Access / SQL Server MySQL / PostgreSQL Oracle Database Oracle Developer Web RFP BI Oracle Database Oracle Database 73
Oracle Direct Oracle Direct IT / Web 0120 155 096 ~ 9:00~12:00 13:00~18:00 74