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/ Copyright 2009, Oracle. All rights reserved 1
/ Oracle on Windows http://www.oracle.co.jp/campaign/mb_tech/column/ 2 Copyright 2009, Oracle. All rights reserved 2
Oracle Direct Seminar < > Windows Oracle Database Windows Oracle Database
Copyright 2009, Oracle. All rights reserved 4
Copyright 2009, Oracle. All rights reserved 5
Copyright 2009, Oracle. All rights reserved 6
Operating System 9i R2 10g R1 10g R2 11g Windows 2000 Yes Yes Yes Yes Windows XP Professional Yes Yes Yes Yes Windows Server 2003 Yes Yes Yes Yes Windows Vista No No Yes Yes Windows Server 2008 No No Yes Yes Copyright 2009, Oracle. All rights reserved 7
Operating System 9i R2 10g R1 10g R2 11g Windows Server 2003 for Itanium Windows XP & Windows Server 2003, x64 Editions Windows Vista for x64 systems Windows Server 2008 for x64 Systems Windows Server 2008 for Itanium Yes Yes Yes TBD No No Yes Yes No No Yes Yes No No Yes Yes No No TBD TBD Copyright 2009, Oracle. All rights reserved 8
Copyright 2009, Oracle. All rights reserved 9
Copyright 2009, Oracle. All rights reserved 10
Copyright 2009, Oracle. All rights reserved 11
Copyright 2009, Oracle. All rights reserved 12
Copyright 2009, Oracle. All rights reserved 13
Copyright 2009, Oracle. All rights reserved 14
Copyright 2009, Oracle. All rights reserved 15
Copyright 2009, Oracle. All rights reserved 16
Copyright 2009, Oracle. All rights reserved 17
Oracle Database 10g 1 10.1 Oracle Database Copyright 2009, Oracle. All rights reserved 18
oracle.key ORACLE_BASE ORACLE_HOME bin oracle.key SOFTWARE ORACLE KEY_OraDb11g_home1 oracle.key SOFTWARE ORACLE KEY_OraDb11g _home1 Copyright 2009, Oracle. All rights reserved 19
regedit Copyright 2009, Oracle. All rights reserved 20
oracle.key HKEY_LOCAL_MACHINE oracle.key SOFTWARE ORACLE KEY_OraDb11g_home1 Copyright 2009, Oracle. All rights reserved 21
ORA_LPENABLE Windows Server 2003 Oracle ORA_LPENABLE 1 1 ORA_LPENABLE=1: ORA_SID_LPENABLE=1: 0 Copyright 2009, Oracle. All rights reserved 22
ORA_LPENABLE KEY_OraDb11g_home1 Copyright 2009, Oracle. All rights reserved 23
ORA_LPENABLE ORA_LPENABLE=1 Copyright 2009, Oracle. All rights reserved 24
SYSDBA SQL*PLUS SQL> shutdown immediate SQL> startup Copyright 2009, Oracle. All rights reserved 25
Alert alert_orcl.log Large page enabled : 1 Copyright 2009, Oracle. All rights reserved 26
Lock pages in memory SYSTEM Lock pages in memory Windows Copyright 2009, Oracle. All rights reserved 27
Copyright 2009, Oracle. All rights reserved 28
Copyright 2009, Oracle. All rights reserved 29
Oracle Administrator Copyright 2009, Oracle. All rights reserved 30
Copyright 2009, Oracle. All rights reserved 31
Oracle Oracle Database 11g 1 11.1 for Microsoft Windows 7 Oracle Database Windows http://otndnld.oracle.co.jp/document/products/oracle11g/111/windows/e058 85-05/tuning.htm#BCGDHBBD Copyright 2009, Oracle. All rights reserved 32
Copyright 2009, Oracle. All rights reserved 33
Copyright 2009, Oracle. All rights reserved 34
Copyright 2009, Oracle. All rights reserved 35
Copyright 2009, Oracle. All rights reserved 36
Oracle NFS Direct NFS Client Oracle Database OS NFS Copyright 2009, Oracle. All rights reserved 37
Direct NFS Client on Windows Direct NFS Client on Windows Copyright 2009, Oracle. All rights reserved 38
Direct NFS Client on Windows Configuration Server Path Local Export Mount NFS NFS 4 NFS ifconfig IP 4 ipconfig IP NFS UNIX NFS Windows http://otndnld.oracle.co.jp/products/database/oracle11g/pdf/directnfsclient_11gr1_twp.pdf Copyright 2009, Oracle. All rights reserved 39
Direct NFS Client on Windows Configuration Sample server: MyDataServer1 local: 132.34.35.10 path: 132.34.35.12 local: 132.34.55.10 path: 132.34.55.12 export: /vol/oradata1 mount: C: APP ORACLE ORADATA ORCL server: MyDataServer2 local: LocalInterface1 path: NfsPath1 local: LocalInterface2 path: NfsPath2 local: LocalInterface3 path: NfsPath3 local: LocalInterface4 path: NfsPath4 export: /vol/oradata2 mount: C: APP ORACLE ORADATA ORCL2 export: /vol/oradata3 mount: C: APP ORACLE ORADATA ORCL3 Copyright 2009, Oracle. All rights reserved 40
Direct NFS Client on Windows Performance NFS NFS Oracle NFS 16 NFS Direct NFS Client on Windows NFS Copyright 2009, Oracle. All rights reserved 41
Direct NFS Client on Windows Performance - DSS Oracle Direct NFS NFS 113MB/s, 2 223MB/s (99% ) Copyright 2009, Oracle. All rights reserved 42
Direct NFS Client on Windows Performance - DSS Oracle Direct NFS NFS I/O Copyright 2009, Oracle. All rights reserved 43
Direct NFS Client on Windows Performance - DSS Throughput to CPU Metric(TCM) Oracle Direct NFS Client -TCM 85% Copyright 2009, Oracle. All rights reserved 44
Direct NFS Client on Windows Performance - OLTP OLTP Oracle Direct NFS NFS Copyright 2009, Oracle. All rights reserved 45
Direct NFS Client on Windows Performance - OLTP OLTP : I/O Oracle Direct NFS NFS Copyright 2009, Oracle. All rights reserved 46
Direct NFS Client on Windows Oracle Direct NFS Client OS NFS DSS OS NFS 40% OLTP OLTP 11% SQL*Loader Oracle Recovery Manager(RMAN) Copyright 2009, Oracle. All rights reserved 47
Copyright 2009, Oracle. All rights reserved 48
ODP.NET 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 ODP.NET 11.1.0 OS Copyright 2009, Oracle. All rights reserved 49
ODP.NET ONLY ConnectionString User Id / Windows DBA Privilege SYSDBA SYSOPER Oracle ODP.NET 11.1.0 OS Copyright 2009, Oracle. All rights reserved 50
ODP.NET Windows Perfmon ODP.NET ODP.NET Oracle Data Provider for.net Copyright 2009, Oracle. All rights reserved 51
ODP.NET FetchSize 64KB Copyright 2009, Oracle. All rights reserved 52
ODP.NET Oracle Database SQL Copyright 2009, Oracle. All rights reserved 53
ODP.NET 4 Oracle Data Provider for.net 11.1 ODP.NET Copyright 2009, Oracle. All rights reserved 54
ODP.NET 5 ODP.NET 1 Copyright 2009, Oracle. All rights reserved 55
ODP.NET SecureFiles LOB Oracle Datatbase 11g 1.0 SecureFiles LOB Oracle 11g 1.0 Copyright 2009, Oracle. All rights reserved 56
ODP.NET 7 Client Result Cache Oracle Datatbase 11g 1.0 CLIENT_RESULT_CACHE_LAG Copyright 2009, Oracle. All rights reserved 57
ODP.NET 7 Client Result Cache CLIENT_RESULT_CACHE_SIZE Client-Side Query Cache 1 ( :byte) 0(Client-Side Query Cache ) OCI_RESULT_CACHE_MAX_SIZE sqlnet.ora 1 ( :byte) CLIENT_RESULT_CAHCE_SIZE (CLIENT_RESULT_CACHE 0 ) Copyright 2009, Oracle. All rights reserved 58
Copyright 2009, Oracle. All rights reserved 59
Copyright 2009, Oracle. All rights reserved 60
Oracle Direct Seminar 100 Wendy2010 11 12 2!! a. b. c. d. a,b,c,d http://www.oracle.com/technology/global/jp/membership/index.html ORD_SEMINAR_JP@ORACLE.COM 2009 11 12 Oracle Direct Copyright 2009, Oracle. All rights reserved 61
IT Oracle Direct Concierge BI IT BI Access / SQL Server MySQL / PostgreSQL Oracle Database Oracle Developer Web RFP BI Oracle Database Oracle Database Copyright 2009, Oracle. All rights reserved 62
Oracle Direct Oracle Direct IT / Web 0120 155 096 ~ 9:00~12:00 13:00~18:00 Copyright 2009, Oracle. All rights reserved 63
Copyright 2009, Oracle. All rights reserved 64