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/ 1
/ Oracle on Windows http://www.oracle.co.jp/campaign/mb_tech/column/ 2 2
Oracle Direct Seminar < >
Agenda.NET + Oracle Appendix:.NET 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 ace C OTN-J http://www.oracle.com/technology/global/jp/tec h/dotnet/index.html Oracle ODT ODP.NET 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
Agenda.NET + Oracle Appendix:.NET 12
ODT Visual Studio Oracle 13
ODT Oracle Explorer DB PL/SQL PL/SQL Data Window Oracle Query Window SQL*Plus 14
ODT Oracle PL/SQL Oracle Oracle Oracle 15
Oracle Oracle Oracle Oracle 16
PL/SQL PL/SQL 17
PL/SQL Visual Studio PL/SQL 18
ODAC 11.1.0 ODT Server Explorer Oracle Database SQL*Plus 19
ODAC 11.1.0 ODT Server Explorer Visual Studio 2005 Server Explorer ODT Visual Studio 2005 Oracle Database SQL Visual Studio 20
ODAC 11.1.0 ODT GUI.NET Custom Class(C#,VB.NET, C++ ) SQL*Plus EDIT HOST SQL*Plus SQL 21
ODT ODT Oracle CD CD OTN-J Oracle EXE setup.exe exe setup.exe OUI ODT ODP.NET VS.NET 22
ODT Visual Studio 23
ODAC 11.1.0.7 ODT Oracle Visual Studio Automatic Database Diagnostic Monitor(ADDM) SQL Tuning Adviser ADDM AWR ( ) ) / SQL SQL 24
ODAC 11.1.0.7 ODT SQL Tuning Adviser 25
ODAC 11.1.0.7 ODT Oracle Performance Analyzer 26
ODE.NET.NET 27
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) 28
ODE.NET Oracle Instance PL/SQL Oracle CLR Host Microsoft.NET CLR 29
.NET Oracle Project.NET 30
.NET 1. Oracle 2..NET 3..NET DLL PL/SQL SYS SYSTEM 31
.NET Oracle Deployment Wizard for.net.net 32
ODAC 11.1.0 ODE.NET.NET Stored Procedure Nullable type.net Framework 2.0 Nullable Type 33
Agenda.NET + Oracle Appendix:.NET 34
ODP.NET 35
OUI ODP.NET Oracle Client Oracle GUI DB Server, Client GUI Silent install Microsoft SMS Instant Client XCopy 36
Instant Client XCopy Install Step 1: Unzip and copy IC files to disk Step 2: install.bat t Oracle Home 3 Step 3: Windows PATH Step 4: NLS_LANG 37
XCopy Install.bat 38
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 39
tnsname.ora ODP.NET ONLY tnsnams.ora 40
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 41
Multiple Oracle Homes Multiple Oracle Homes : HKLM Software Oracle ALL_HOMES HOMES and HKLM Software Oracle HOME(n) HKLM Software Oracle KEY_ home 42
Multiple Oracle Homes Oracle Client Software Oracle Oacece client DLLs s 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 43
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 44
Agenda.NET + Oracle Appendix:.NET 45
ODP.NET 46
ODP.NET 1 FetchSize 65,536 536 47
ODP.NET 2 1 Select * from emp DB 1 WEB DB 2 Sl Select t*f from emp 2 WEB DB 48
ODP.NET 3 Client = Connection WEB DB Client > Connection WEB DB 49
ODP.NET 50
ODP.NET FetchSize 64KB 51
ODP.NET / BLOB BLOB Oracle Data Provider for.net 11.1 LOB Oracle 11g 1.0 52
ODP.NET OracleBulkCopy Oracle Oracle Oracle Data Provider for.net 11.1 53
ODP.NET 54
Oracle Database Result Cache Oracle Datatbase 11g 10 1.0 Inventory Orders Line Items Inventory Orders Line Items Back Orders Pick Lists Back Orders Pick Lists SQL 55
Oracle Database Result Cache SQL SGA SGA SQL Select Select A A B B 56
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 57
ODP.NET SQL Q Where 58
ODAC 11.1.0.7 ODP.NET ODP.NET SQL or PL/SQL Application (A) ODP.NET Cache ODP.NET Cache ) ODP.NET Cache 59
Oracle Database SecureFiles SecureFiles LOB Oracle Oracle 11g 1.0 60
Oracle Database SecureFiles STORE AS SECUREFILE SQL> CREATE TABLE t1 (c1 CLOB) 2 LOB (c1) STORE AS SECUREFILE ; BASICFILE (STORE AS ) BASICFILE SQL> CREATE TABLE t1 (c1 CLOB) 2 LOB (c1) STORE AS BASICFILE ; 61
Oracle Database SecureFiles LOB LOB 62
ODP.NET 63
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 64
ODP.NET ONLY Oracle Database OS ConnectionString User Id / Windows DBA Privilege SYSDBA SYSOPER Oracle ODP.NET 11.1.0 OS 65
Oracle Database Perfmon Windows Perfmon ODP.NET ODP.NET Oracle Data Provider for.net 66
.NET Visual Studio 2005, 2008 Oracle Oracle Data Provider for.net(odp.net) NET) Oracle Developer Tools for Visual Studio.NET(ODT) Oracle Database Extensions for.net(ode.net) 67
68
OTN!! Oracle Technology Network(OTN) http://otn.oracle.co.jp/forum/index.jspa?categoryid=2 OTN OTN Oracle 100% 69
OTN!!!! http://www.oracle.com/technology/global/jp/ondemand/otn-seminar/index.html /tec o ogy/g oba /jp/o a d/ot a /. t 70
IT Oracle Direct Concierge BI IT BI Access / SQL Server MySQL / PostgreSQL Oracle Database Oracle Developer Web RFP BI Oracle Database Oracle Database 71
Oracle Direct Oracle OaceDirect IT / Web 0120 155 096 ~ 9:00~12:00 13:00~18:00 72
73