Oracle8i 分散システム, リリース8.1

Save this PDF as:
Size: px
Start display at page:

Download "Oracle8i 分散システム, リリース8.1"

Transcription

1 Oracle8i J

2 Oracle8i, 8.1 J Oracle8i Distributed Database Systems, Release 2(8.1.6) A Jason Durbin, Lance Ashdown William Creekbaum, Steve Bobrowski, Katherine Hughes, Pavna Jain, Peter Vasterd, John Bellemore, Anupam Bhide, Roger Bodamer, Jacco Draaijer, Diana Foch-Laurentz, Nina Lewis, Raghu Mani, Basab Maulik, Denise Oertel, Paul Raveling, Kendall Scott, Gordon Smith, Katia Tarkhanov, Randy Urbano, Sandy Venning, Eric Voss, and others Copyright 1996, 1999, Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Corporation Restricted Rights Notice Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial computer software" and use, duplication, and disclosure of the Programs, including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR , Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA

3 ... xi Oracle8i... xii xii xiii... xiii... xiv... xv... xv... xv... xvi I / i

4 : SQL SQL SQL RPC / : ii

5 : iii

6 II : : DML : Oracle : : : : iv

7 7: ID PURGE_LOST_DB_ENTRY DBMS_TRANSACTION : : : DBA_2PC_PENDING : DBA_2PC_NEIGHBORS : : : DBA_2PC_PENDING RECO v

8 III 6 Oracle Oracle SQL Transparent Gateway Generic Connectivity Transparent Gateway Oracle Oracle : : : Oracle : SQL HS HS vi

9 DBMS_HS Generic Connectivity Generic Connectivity Generic Connectivity SQL Generic Connectivity Oracle SQL Generic Connectivity Generic Connectivity Agent ODBC OLE DB ODBC OLE DB SQL OLE DB FS OLE DB : SQL DBMS_HS_PASSTHROUGH SQL SQL OCI Oracle Oracle Tools Oracle vii

10 Oracle Server Oracle A HS_COMMIT_POINT_STRENGTH... A-2 HS_DB_DOMAIN... A-2 HS_DB_INTERNAL_NAME... A-3 HS_DB_NAME... A-3 HS_DESCRIBE_CACHE_HWM... A-3 HS_FDS_CONNECT_INFO... A-4 HS_FDS_SHAREABLE_NAME... A-5 HS_FDS_TRACE_LEVEL... A-5 HS_FDS_TRACE_FILE_NAME... A-5 HS_LANGUAGE... A-6 HS_NLS_DATE_FORMAT... A-7 HS_NLS_DATE_LANGUAGE... A-7 HS_NLS_NCHAR... A-8 HS_OPEN_CURSORS... A-8 HS_ROWID_CACHE_SIZE... A-9 HS_RPC_FETCH_REBLOCKING... A-9 HS_RPC_FETCH_SIZE... A-10 B C Generic Connectivity... C-2 Oracle... C-2... C-3... C-4... C-5 Generic Connectivity... C-6 ALL_CATALOG... C-6 ALL_COL_COMMENTS... C-6 ALL_CONS_COLUMNS... C-6 ALL_CONSTRAINTS... C-7 viii

11 ALL_IND_COLUMNS... C-7 ALL_INDEXES... C-8 ALL_OBJECTS... C-10 ALL_TAB_COLUMNS... C-11 ALL_TAB_COMMENTS... C-12 ALL_TABLES... C-12 ALL_USERS... C-14 ALL_VIEWS... C-14 DICTIONARY... C-14 USER_CATALOG... C-15 USER_COL_COMMENTS... C-15 USER_CONS_COLUMNS... C-15 USER_CONSTRAINTS... C-15 USER_IND_COLUMNS... C-16 USER_INDEXES... C-17 USER_OBJECTS... C-19 USER_TAB_COLUMNS... C-19 USER_TAB_COMMENTS... C-20 USER_TABLES... C-21 USER_USERS... C-22 USER_VIEWS... C-23 D ODBC Oracle... D-2 OLE DB Oracle... D-2 ix

12 x

13 Oracle8i Oracle8i Oracle8i Oracle8i Enterprise Edition Oracle8i Oracle8i Enterprise Edition Enterprise Edition xi

14 Oracle8i Oracle8i ODBC OLE DB Generic Connectivity 8 Generic Connectivity C Generic Connectivity D Transparent Gateway Oracle Oracle Generic Connectivity HS ODBC Oracle Oracle8i 1-27 LDAP DML DDL INSERT 4-3 DML DDL Kerberos 1-24 Oracle Advanced Security SSL Single Sign-on HS_FDS_CONNECT_INFO HS_FDS_SHAREABLE_NAME HS_FDS_TRACE HS_FDS_TRACE_FILE_NAME xii

15 Oracle Server SQL Oracle Oracle SQL Oracle Oracle Oracle SELECT Oracle 7-15 V$HS_AGENT V$HS_SESSION / I II 4 5 Oracle DBA Oracle 2 xiii

16 / III 6 Oracle 7 Transparent Gateway Oracle 8 Generic Connectivity 9 A B C Generic Connectivity D Oracle Oracle Transparent Gateway ODBC OLE DB Oracle Oracle Oracle Generic Connectivity Agent Oracle8i Oracle ODBC OLE DB Oracle Generic Connectivity C Generic Connectivity D Generic Connectivity III Oracle8i PL/SQL xiv

17 Oracle Oracle Oracle DBA Oracle8i Oracle8i Oracle Oracle 2 7 Transparent Gateway Oracle 8 Generic Connectivity 3 9 A B C Generic Connectivity D 1 6 Oracle xv

18 SQLPLUS username/password INTO TABLENAME 'table' { } VARCHAR (length) ASC DESC 1 {column_name array_def} DECIMAL (digits [, precision ]) < > SQL WHERE x <operator> x... WHERE column_1 <operator> x AND column_2 <operator> y [AND...] xvi

19 I

20

21 1 Oracle 1-1

22 Oracle 1 Oracle / / 1 Oracle 1-1 HQ MFG SALES 3 MFG Manufacturing 1 PRODUCTS HQ DEPT MFG HQ DEPT MFG SELECT * FROM dept; MFG 1-2 Oracle8i

23 1-1 MFG.ACME.COM HQ.ACME.COM Oracle Oracle Oracle. SALES.ACME.COM.... Oracle Oracle Oracle Oracle8i SQL Oracle7 1-3

24 / Oracle Oracle Oracle : : Oracle Oracle8i 1-4 Oracle8i

25 1 Oracle Oracle Oracle Oracle Oracle Oracle8i Oracle Transparent Gateway Oracle Oracle Sybase Oracle Sybase Transparent Gateway Oracle ODBC OLE DB Generic Connectivity Oracle Oracle Transparent Gateway : III HS Oracle8i Server Oracle Transparent Gateway HS Oracle Gateway Oracle Transparent Gateway : 6 Oracle Transparent Gateway Oracle Transparent Gateway Oracle Oracle Transparent Gateway Oracle Oracle Oracle Oracle Oracle SQL : Oracle Transparent Gateway 1-5

26 Generic Connectivity Generic Connectivity Oracle8i ODBC OLE DB 2 Oracle8i ODBC OLE DB Generic Connectivity Agent Generic Connectivity ODBC OLE DB : Generic Connectivity 8 Generic Connectivity 1 Oracle Oracle SQL Oracle Oracle 1 SQL Oracle SQL SQL NLS Oracle 1 Oracle Oracle SQL Oracle SQL Oracle SQL Oracle Oracle SQL Oracle PL/SQL Oracle Oracle8i 1-6 Oracle8i

27 Generic Connectivity Oracle8i ODBC OLE DB Oracle : Oracle Transparent Gateway / Oracle HQ 2 DEPT SALES EMP 1-7

28 1-2 Oracle Net8 Net8 DEPT EMP HQ SALES INSERT INTO DELETE FROM DEPT..; SELECT... FROM COMMIT;. 1-8 Oracle8i

29 1-2 HQ DEPT SELECT * FROM dept; 1-2 HQ SALES EMP SELECT * FROM 2 1 : 1-9

30 Oracle A A B B A B A B 1-3 SCOTT HQ.ACME.COM EMP 1-10 Oracle8i

31 1-3 SCOTT Select * FROM emp PUBLIC SYNONYM emp -> EMP 1 JANE SCOTT/TIGER HR JANE SCOTT JANE SCOTT HR HR 1-11

32 JANE SCOTT SCOTT HR SCOTT Oracle Advanced Security Advanced Networking Option CREATE DATABASE LINK SQL MTS 4 1 MTS 1-12 Oracle8i

33 : Oracle8i Net8 A/PA/P HR A/P HR HR A/P HR HR A/P HR SCOTT SCOTT LINK$ SSL : 1-17 DB_DOMAIN DB_NAME 1-13

34 EDU COM ORG ACME_TOOLS ACME_AUTO DIVISION1 DIVISION2 DIVISION3 ASIA AMERICAS EUROPE JAPAN US MEXICO UK GERMANY HQ FINANCE SALES MFTG SALES HQ SALES SALES SALES SALES HUMAN_RESOURCES.EMP HUMAN_RESOURCES.EMP MFTG COM ACME_TOOLS DIVISION3 MFTG MFTG.DIVISION3.ACME_TOOLS.COM US.AMERICAS.ACME_ AUTO.COM UK.EUROPE.ACME_AUTO.COM SALES 1-14 Oracle8i

35 AMERICAS SALES EUROPE SALES SALES.US.AMERICAS.ACME_AUTO.COM SALES.UK.EUROPE.ACME_AUTO.COM : 2-2 SALES.US.ORACLE.COM SALES.US.ORACLE.COM GLOBAL_NAMES TRUE HQ HQ.ACME.COM GLOBAL_NAMES TRUE HQ.ACME.COM Oracle DB_DOMAIN 2-4 GLOBAL_NAMES FALSE HQ.ACME.COM FOO : Oracle Advanced Replication SALES CREATE PUBLIC DATABASE LINK sales.division3.acme.com USING 'sales1'; : GLOBAL_NAMES Oracle8i 1-15

36 Oracle DBA_DB_LINKS ALL_DB_LINKS PUBLIC DBA_DB_LINKS ALL_DB_LINKS PUBLIC DBA_DB_LINKS ALL_DB_LINKS PL/SQL PL/SQL Oracle Oracle Names Oracle PL/SQL Oracle 1-16 Oracle8i

37 Oracle Oracle Names : SYSTEM SYSTEM Oracle SYSTEM : CURRENT_USER X.509 Oracle Advanced Security : Oracle8i Advanced Security / CREATE PUBLIC DATABASE LINK hq USING 'hq'; CREATE PUBLIC DATABASE LINK hq CONNECT TO CURRENT_USER USING 'hq'; CREATE PUBLIC DATABASE LINK hq CONNECT TO jane IDENTIFIED BY doe USING 'hq'; :

38 Oracle REMOTE_OS_AUTHENT REMOTE_OS_AUTHENT REMOTE_OS_AUTHENT TRUE FALSE Oracle Advanced Security JOE SCOTT TIGER JANE JANE SCOTT/TIGER LINK$ SELECT ANY TABLE O7_DICTIONARY_ACCESSIBILITY TRUE 1-18 Oracle8i

39 : O7_DICTIONARY_ACCESSIBILITY TRUE JANE HR SCOTT/TIGER O7_ DICTIONARY_ACCESSIBILITY TRUE SELECT ANY TABLE JANE LINK$ HR SCOTT/TIGER JANE HR TIGER HR SCOTT JANE SCOTT JANE SCOTT X.509 CURRENT_USER JANE HR JANE HR SCOTT SCOTT SSL JANE SCOTT SELECT SCOTT JANE SCOTT.P SCOTT SCOTT ID JANE SCOTT.P SCOTT 1-19

40 SCOTT.P JANE JANE DB1 GUEST : : 1-24 CREATE DATABASE LINK SALES.US.AMERICAS.ACME_AUTO.COM SQL SQL CREATE DATABASE LINK sales.us.americas.acme_auto.com USING 'sales_us'; SALES_US SALES CREATE DATABASE LINK foo CONNECT TO CURRENT_USER USING 'am_sls'; AM_SLS SALES CREATE DATABASE LINK sales.us.americas.acme_auto.com CONNECT TO scott IDENTIFIED BY tiger USING 'sales_us'; SALES_US SALES TIGER SCOTT CREATE PUBLIC DATABASE LINK sales CONNECT TO scott IDENTIFIED BY tiger USING 'rev'; REV SALES TIGER SCOTT CREATE SHARED PUBLIC DATABASE LINK sales.us.americas.acme_ auto.com CONNECT TO scott IDENTIFIED BY tiger AUTHENTICATED BY anupam IDENTIFIED BY bhide USING 'sales'; SALES SALES BHIDE ANUPAM TIGER SCOTT : 2-8 CREATE DATABASE LINK Oracle8i SQL 1-20 Oracle8i

41 SQL FOO EMP SELECT * FROM Oracle schema schema_object global_database_name DB_NAME DB_DOMAIN GLOBAL_NAMES FALSE SALES.DIVISION3.ACME.COM SELECT * FROM # emp table in scott's schema SELECT loc FROM 1-21

42 GLOBAL_NAMES FALSE SALES.DIVISION3.ACME.COM FOO SELECT name FROM # link name different from global name Oracle SELECT * FROM EMP SELECT * FROM emp; : 2-28 Oracle Oracle 1 1 Oracle Oracle SYSTEM CONNECT HQ.ACME.COM HQ SCOTT JANE SELECT * FROM INSERT INTO (acc_no, acc_name, balance) VALUES (5001, 'BOWER', 2000); 1-22 Oracle8i

43 UPDATE SET balance = balance + 500; DELETE FROM WHERE acc_name = 'BOWER'; DESCRIBE DESCRIBE ANALYZE JANE SCOTT JANE SCOTT JANE SET ROLE MTS SSL NT Oracle 1-23

44 Oracle 1 DISTRIBUTED_LOCK_TIMEOUT DISTRIBUTED_TRANSACTIONS COMMIT_ POINT_STRENGTH : 2 7 Transparent Gateway Oracle Kerberos 5 DCE 1-24 Oracle8i

45 Oracle : Oracle8i Advanced Security PUBLIC CREATE PUBLIC DATABASE LINK foo USING 'sales'; CONNECT TO AUTHENTICATED BY CREATE DATABASE LINK sales CONNECT TO scott IDENTIFIED BY tiger USING 'sales'; CREATE SHARED PUBLIC DATABASE LINK sales CONNECT TO mick IDENTIFIED BY jagger AUTHENTICATED BY david IDENTIFIED BY bowie USING 'sales'; Oracle ID/

46 ID/ 2 ID/ Kerberos end-to-end end-to-end JANE JANE 1-26 Oracle8i

47 : 2-8 Oracle SSL Net8 Oracle Advanced Security Net8 Oracle Windows NT Oracle : Oracle8i Net8 Oracle8i Advanced Security 1 SQL FRED CREATE USER fred IDENTIFIED GLOBALLY AS 'CN=fred adams,o=oracle,c=england'; FRED FRED Oracle 1-27

48 Oracle8i : JANE BILL SCOTT HR HR GUEST GUEST JANE BILL SCOTT 3 GUEST HR Oracle8i

49 1-5 LDAP SSL DB1 SSL SSL SSL DB2 SCOTT DB1 DB2 DB1 clerk1 guest bill scott DB2 clerk2 guest jane scott DB1 DB2 DB1 DB2 CREATE CREATE USER guest IDENTIFIED GLOBALLY AS ''; CREATE ROLE clerk1 GRANT select ON emp; CREATE PUBLIC DATABASE LINK db2_link CONNECT AS CURRENT_USER USING 'db2'; CREATE USER guest IDENTIFIED GLOBALLY; CREATE ROLE clerk2 GRANT select ON dept; 1-29

50 SCOTT DB2 DB1 1. SCOTT DB1 SSL 2. SCOTT SELECT e.ename, d.loc FROM emp e, d WHERE e.deptno=d.deptno 3. DB1 DB2 SSL 4. DB1 SCOTT DB1 SCOTT CLERK1 GUEST 5. DB2 SCOTT DB2 SCOTT CLERK2 GUEST 6. SCOTT CLERK2 DB2 GUEST SELECT DB1 7. DB1 DB2 SCOTT : Oracle8i Net8 Oracle8i Advanced Security Oracle Advanced Security Net8 RSA RC4 DES Oracle Advanced Security 1-30 Oracle8i

51 : Oracle Advanced Security Oracle8i Net8 Oracle8i Advanced Security SQL HR.ACME.COM JANE SCOTT HR SCOTT SCOTT HR JANE HR SCOTT : Oracle Oracle Enterprise Manager SNMP 1-31

52 Oracle Enterprise Manager Enterprise Manager Oracle Enterprise Manager GUI Oracle Enterprise Manager Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Oracle Net8 SQL PL/SQL Enterprise Manager Enterprise Manager Enterprise Manager 60 Oracle 150 SNMP SNMP SNMP Oracle SNMP HP OpenView Digital POLYCENTER Manager NetView IBM NetView/6000 Novell NetWare Management System SunSoft SunNet Manager 1-32 Oracle8i

53 : SNMP Oracle SNMP 1 SQL SQL SQL SQL SQL 2 SQL 1 SALES SCOTT DEPT SELECT * FROM 1 SALES SCOTT DEPT UPDATE SET loc = 'NEW YORK' WHERE deptno = 10; 1-33

54 : 1 1 SQL SALES SELECT ename, dname FROM scott.emp e, d WHERE e.deptno = d.deptno; 2 PL/SQL PL/SQL SALES BEGIN UPDATE SET loc = 'NEW YORK' WHERE deptno = 10; UPDATE scott.emp SET deptno = 11 WHERE deptno = 10; END; COMMIT; 1 SQL SQL SQL SQL : SQL Oracle8i 1-34 Oracle8i

55 1 SALES 2 UPDATE SET loc = 'NEW YORK' WHERE deptno = 10; UPDATE SET deptno = 11 WHERE deptno = 10; COMMIT; 2 1 SALES UPDATE SET loc = 'NEW YORK' WHERE deptno = 10; UPDATE scott.emp SET deptno = 11 WHERE deptno = 10; COMMIT; : Oracle8i Oracle 1-35

56 Oracle 2 2 DML : Oracle 2 4 SELECT * FROM SELECT * FROM dept sales acme.com emp mktg us.acme.com SQL SELECT * FROM Oracle ORDERS.US.ACME.COM 1-36 Oracle8i

57 1. SQL Oracle Names Server SQL SELECT * FROM PROD1 US.ORACLE.COM SQL DB_DOMAIN DB_NAME CONNECT SELECT * FROM LOCDB US.ACME.COM ORDERS ORDERS.US.ACME.COM Oracle CONNECT SELECT * from scott.emp;

58 Oracle CONNECT CONNECT TO... IDENTIFIED BY CONNECT TO CURRENT_USER USING Oracle CREATE DATABASE LINK k1 USING 'prod' CREATE DATABASE LINK k2 CONNECT TO scott IDENTIFIED BY tiger USING 'prod' CREATE DATABASE LINK k3 CONNECT TO CURRENT_USER USING 'prod' CREATE DATABASE LINK k4 CONNECT TO CURRENT_USER Oracle SQL SQL 1-38 Oracle8i

59 SQL SALES.DIVISION3.ACME.COM HQ.DIVISION3.ACME.COM Oracle Names Server : EMP TSMITH SCOTT CONNECT CREATE PUBLIC DATABASE LINK sales.division3.acme.com CONNECT TO guest IDENTIFIED BY network USING 'dbstring'; JWARD CONNECT CREATE DATABASE LINK sales.division3.acme.com CONNECT TO tsmith IDENTIFIED BY radio; UPDATE SET deptno = 40 WHERE deptno = 10; 1. Oracle JWARD UPDATE 2. JWARD JWARD.SALES.DIVISION3.ACME.COM SALES 1-39

60 Oracle 3. SCOTT Oracle DBSTRING 4. TSMITH/RADIO SALES 5. EMP Oracle TSMITH EMP 6. : SALES EMP SCOTT TSMITH EMP SALES SALES TSMITH.EMP 1-40 : HQ CREATE PUBLIC DATABASE LINK sales.division3.acme.com CONNECT TO guest IDENTIFIED BY network USING 'dbstring'; HQ CONNECT CREATE DATABASE LINK sales.division3.acme.com; DELETE FROM WHERE empno = 4299; 1-40 Oracle8i

61 DELETE 1. Oracle SCOTT DELETE DELETE FROM WHERE empno = 4299; SCOTT Oracle / CREATE PUBLIC DATABASE LINK sales.division3.acme.com CONNECT TO guest IDENTIFIED BY network USING 'dbstring'; 4. Oracle DBSTRING 5. Oracle SCOTT/TIGER SCOTT EMP 6. EMP 7. PL/SQL 1-41

62 Oracle SALES.UK.ACME.COM HR.UK.ACME.COM 2 SALES CREATE VIEW employee_names AS SELECT ename FROM CREATE SYNONYM employee FOR EMPLOYEE 1: SALES.UK.ACME.COM HR.UK.ACME.COM SALES.US.ORACLE.COM HR.US.ACME.COM 1-42 Oracle8i

63 SALES SELECT * FROM employee_names SELECT * FROM employee SELECT * FROM SELECT * FROM SELECT * FROM SELECT * FROM 2: SALES.UK.ACME.COM HR.UK.ACME.COM SALES.US.ORACLE.COM SALES SELECT * FROM employee_names SELECT * FROM employee SELECT * FROM SELECT * FROM SELECT * FROM SELECT * FROM EMPLOYEE_NAMES EMPLOYEE HR.UK.ACME.COM 1-43

64 RPC : 3 Oracle 1 Oracle Oracle CREATE PUBLIC SYNONYM emp FOR CREATE PUBLIC SYNONYM dept FOR 1-44 Oracle8i

65 SELECT ename, dname FROM e, d WHERE e.deptno = d.deptno; SELECT ename, dname FROM emp e, dept d WHERE e.deptno = d.deptno; SQL COMMIT Oracle SELECT INSERT UPDATE DELETE SQL SQL COMMIT SAVEPOINT ROLLBACK 1 SCN SCN 1 SQL 1-45

66 SCN Oracle Oracle8i RPC PL/SQL RPC PL/SQL SALES DEL_ EMP 1257 BEGIN END; RPC Oracle8i SQL Oracle SQL DRIVING_SITE NO_MERGE INDEX Oracle 1-46 Oracle8i

67 : 3-5 Oracle Oracle Oracle Oracle8i NCHAR NLS HS NLS HS NLS_LANG / NLS_LANGUAGE / Oracle NLS_CHARACTERSET NLS_TERRITORY HS_LANGUAGE Oracle Transparent Gateway NLS_NCHAR HS_NLS_NCHAR Oracle Transparent Gateway 1-47

68 / / 1-6 Oracle 1-6 / NLS NLS_LANG = Oracle NLS Oracle Oracle8i

69 1-7 NLS NLS_LANG = Oracle NLS Oracle Oracle Oracle NLS 1-8 Transparent Gateway Oracle NLS Oracle NLS Transparent Gateway NLS 1-49

70 1-8 NLS NLS_LANG = Oracle NLS Oracle NLS Oracle NLS Oracle HS Transparent Gateway NCHAR Transparent Gateway NCHAR Oracle Transparent Gateway NCHAR Transparent Gateway : Oracle8i 1-50 Oracle8i

71 2 : 2-1

72 1 : 2 DB_NAME 8 SALES DB_DOMAIN US.ACME.COM 2-2 Oracle8i

73 DB_NAME DB_DOMAIN SALES AU.ORACLE.COM SALES.AU.ORACLE.COM SALES US.ORACLE.COM SALES.US.ORACLE.COM MKTG US.ORACLE.COM MKTG.US.ORACLE.COM PAYROLL NONPROFIT.ORG PAYROLL.NONPROFIT.ORG DB_DOMAIN DB_NAME DB_DOMAIN ALTER DATABASE DB_DOMAIN HQ MNFG MNFG MNFG SN1 SN2 HQ.ACME.COM HQ HQ :

74 V$PARAMETER MNFG MNFG globalnames.sql COL name FORMAT a12 COL value FORMAT a6 SELECT name, value FROM v$parameter WHERE name = 'global_names' / NAME VALUE global_names FALSE GLOBAL_ NAME SELECT * FROM global_name; GLOBAL_NAME SALES.AU.ORACLE.COM ALTER DATABASE DB_DOMAIN database domain ALTER DATABASE RENAME GLOBAL_NAME database.domain; 2-4 Oracle8i

75 1. SELECT * FROM global_name; GLOBAL_NAME SALES.AU.ORACLE.COM 2. ALTER DATABASE ALTER DATABASE RENAME GLOBAL_NAME sales.us.oracle.com; 3. GLOBAL_NAME SELECT * FROM global_name; GLOBAL_NAME SALES.US.ORACLE.COM : Oracle DB_DOMAIN 1. SALES.US.ACME.COM GLOBAL_NAME CONNECT SELECT * FROM global_name; GLOBAL_NAME SALES.US.ACME.COM 2-5

76 2. V$PARAMETER DB_DOMAIN SELECT name, value FROM v$parameter WHERE name = 'db_domain'; NAME VALUE db_domain US.ACME.COM 3. HQ CREATE DATABASE LINK hq USING 'sales'; 4. USER_DB_LINKS SELECT db_link FROM user_db_links; DB_LINK HQ.US.ACME.COM US.ACME.COM 5. SALES SALES SALES.JP.ACME.COM ALTER DATABASE RENAME GLOBAL_NAME TO sales.jp.acme.com; SELECT * FROM global_name; GLOBAL_NAME SALES.JP.ACME.COM 6. V$PARAMETER DB_DOMAIN SELECT name, value FROM v$parameter WHERE name = 'db_domain'; NAME VALUE db_domain US.ACME.COM 2-6 Oracle8i

77 DB_DOMAIN ALTER DATABASE RENAME GLOBAL_NAME ALTER DATABASE DB_DOMAIN DB_ DOMAIN 7. SUPPLY USER_DB_LINKS SUPPLY CREATE DATABASE LINK supply USING 'supply'; SELECT db_link FROM user_db_links; DB_LINK HQ.US.ACME.COM SUPPLY.JP.ACME.COM JP.ACME.COM DB_DOMAIN 8. SALES JP.ACME.COM ASIA.JP.ACME.COM ALTER DATABASE RENAME GLOBAL_NAME TO sales.asia.jp.acme.com; SELECT * FROM global_name; GLOBAL_NAME SALES.ASIA.JP.ACME.COM 9. V$PARAMETER DB_DOMAIN SELECT name, value FROM v$parameter WHERE name = 'db_domain'; NAME VALUE db_domain US.ACME.COM 2 ALTER DATABASE RENAME 10. WAREHOUSE USER_DB_LINKS 2-7

78 CREATE DATABASE LINK warehouse USING 'warehouse'; SELECT db_link FROM user_db_links; DB_LINK HQ.US.ACME.COM SUPPLY.JP.ACME.COM WAREHOUSE.ASIA.JP.ACME.COM : DB_NAME DB_DOMAIN Oracle8i CREATE DATABASE LINK CREATE PUBLIC DATABASE LINK CREATE SESSION 2-8 Oracle8i

79 ROLE_SYS_PRIVS privs.sql SELECT DISTINCT privilege AS "Database Link Privileges" FROM role_sys_privs WHERE privilege IN ( 'CREATE SESSION','CREATE DATABASE LINK', 'CREATE PUBLIC DATABASE LINK') / Database Link Privileges CREATE DATABASE LINK CREATE PUBLIC DATABASE LINK CREATE SESSION 3 link_name CREATE DATABASE LINK link_name...; SQL CREATE DATABASE LINK supply.us.acme.com; SUPPLY ID/ SCOTT TIGER SCOTT/TIGER 2-9

80 SQL CREATE DATABASE LINK link_2 CONNECT TO jane IDENTIFIED BY doe USING 'us_supply'; CREATE DATABASE LINK link_1 CONNECT TO CURRENT_USER USING 'us_supply'; US_SUPPLY LINK_2 ID/ JANE/DOE US_SUPPLY LINK_1 ID/ : 1-17 Oracle Advanced Security : CREATE DATABASE LINK Oracle8i SQL PUBLIC link_name CREATE PUBLIC DATABASE LINK link_name...; SQL CREATE PUBLIC DATABASE LINK supply.us.acme.com; SUPPLY ID/ SCOTT TIGER SCOTT/TIGER 2-10 Oracle8i

81 SQL CREATE PUBLIC DATABASE LINK pu_ link CONNECT TO CURRENT_USER USING 'supply'; CREATE PUBLIC DATABASE LINK sales.us.acme.com CONNECT TO jane IDENTIFIED BY doe; SUPPLY PU_LINK ID/ : 1-17 SALES ID/ JANE/DOE : CREATE PUBLIC DATABASE LINK Oracle8i SQL Oracle Names Server Oracle8i Net8 CREATE DATABASE LINK... CONNECT TO username IDENTIFIED BY password...; 2-11

82 SQL CREATE PUBLIC DATABASE LINK supply.us.acme.com CONNECT TO scott AS tiger; CREATE DATABASE LINK foo CONNECT TO jane IDENTIFIED BY doe USING 'finance'; SUPPLY ID/ SCOTT/TIGER FINANCE FOO ID/ JANE/DOE : 1-17 CONNECT TO dblink net_service_name CREATE [SHARED] [PUBLIC] DATABASE LINK dblink... [USING 'net_service_name']; CREATE DATABASE LINK sales.division3.acme.com USING 'sales'; 2-12 Oracle8i

83 CONNECT TO CURRENT_USER Oracle Advanced Security dblink net_service_name CREATE [SHARED] [PUBLIC] DATABASE LINK dblink CONNECT TO CURRENT_USER [USING 'net_service_name']; SALES CREATE DATABASE LINK sales CONNECT TO CURRENT_USER USING 'sales'; : : Oracle8i SQL Oracle Parallel Server Oracle Server TCP/IP HQ.ACME.COM Oracle Parallel Server HQ HQ_1 HQ_2 2 HQ 2-13

84 CREATE PUBLIC DATABASE LINK USING 'string_to_hq_1'; CREATE PUBLIC DATABASE LINK USING 'string_to_hq_2'; CREATE PUBLIC DATABASE LINK hq.acme.com USING 'string_to_hq'; 2 USING 3 USING SELECT * FROM : Oracle8i

85 3 /MTS MTS MTS

86 CREATE DATABASE LINK SHARED CREATE SHARED DATABASE LINK dblink_name [CONNECT TO username IDENTIFIED BY password] [CONNECT TO CURRENT_USER] AUTHENTICATED BY schema_name IDENTIFIED BY password [USING 'service_name']; SCOTT KEITH SALES CREATE SHARED DATABASE LINK link2sales CONNECT TO scott IDENTIFIED BY tiger AUTHENTICATED BY keith IDENTIFIED BY richards USING 'sales'; SHARED AUTHENTICATED BY AUTHENTICATED BY AUTHENTICATED BY : CREATE DATABASE LINK Oracle8i SQL Oracle8i

87 : SERVER=DEDICATED 2-1. Oracle Oracle Oracle

88 2-2 Oracle Oracle : Oracle8i Net Oracle8i

89 linkname ALTER SESSION CLOSE DATABASE LINK linkname; DROP PUBLIC DATABASE LINK dblink DROP [PUBLIC] DATABASE LINK dblink; 1. SQL*Plus CONNECT 2. USER_DB_LINKS SELECT db_link FROM user_db_links; DB_LINK SALES.US.ORACLE.COM MKTG.US.ORACLE.COM 2 rows selected. 3. DROP DATABASE LINK 2-19

90 DROP DATABASE LINK sales.us.oracle.com; 1. DROP PUBLIC DATABASE LINK CONNECT AS SYSDBA 2. DBA_DB_LINKS SELECT db_link FROM user_db_links WHERE owner = 'PUBLIC'; DB_LINK DBL1.US.ORACLE.COM SALES.US.ORACLE.COM INST2.US.ORACLE.COM RMAN2.US.ORACLE.COM 4 rows selected. 3. DROP PUBLIC DATABASE LINK DROP PUBLIC DATABASE LINK sales.us.oracle.com; OPEN_LINKS 1 1 SQL 3 OPEN_LINKS 3 OPEN_LINKS 4 OPEN_LINKS 0 : OPEN_LINKS Oracle8i SQL 2-20 Oracle8i

91 DBA_DB_LINKS ALL_DB_LINKS USER_DB_LINKS OWNER USER_* PUBLIC DB_LINK USERNAME NULL PASSWORD USER_* HOST CREATED USER_DB_LINKS DBA 2-21

92 COL owner FORMAT a10 COL username FORMAT a8 HEADING "USER" COL db_link FORMAT a30 COL host FORMAT a7 HEADING "SERVICE" SELECT * FROM dba_db_links / OWNER DB_LINK USER SERVICE CREATED SYS TARGET.US.ACME.COM SYS inst1 23-JUN-99 PUBLIC DBL1.UK.ACME.COM BLAKE ora51 23-JUN-99 PUBLIC RMAN2.US.ACME.COM inst2 23-JUN-99 PUBLIC DEPT.US.ACME.COM inst2 23-JUN-99 JANE DBL.UK.ACME.COM BLAKE ora51 23-JUN-99 SCOTT EMP.US.ACME.COM SCOTT inst2 23-JUN-99 6 rows selected. USER_DB_LINKS DBA LINK$ DBA SELECT ANY TABLE O7_DICTIONARY_ACCESSIBILITY TRUE : LINK$ DBA O7_ DICTIONARY_ACCESSIBILITY FALSE SQL*Plus col userid format a10 col password format a10 SELECT userid,password FROM sys.link$ WHERE password IS NOT NULL / 2-22 Oracle8i

93 USERID PASSWORD SYS ORACLE BLAKE TYGER SCOTT TIGER 3 rows selected. DBA LINK$ AUTHENTICATED BY... IDENTIFIED BY... DBA SELECT ANY TABLE O7_DICTIONARY_ACCESSIBILITY TRUE : LINK$ DBA O7_ DICTIONARY_ACCESSIBILITY FALSE SQL*Plus col authusr format a10 col authpwd format a10 SELECT authusr as userid, authpwd as password FROM sys.link$ WHERE password IS NOT NULL / USERID PASSWORD ELLIE MAY 1 row selected. : Oracle8i Oracle8i SQL 2-23

94 COL owner FORMAT a8 COL db_link FORMAT a15 COL username FORMAT a8 HEADING "CON_USER" COL password FORMAT a8 HEADING "CON_PWD" COL authusr FORMAT a8 HEADING "AUTH_USER" COL authpwd format a8 HEADING "AUTH_PWD" COL host FORMAT a7 HEADING "SERVICE" COL created FORMAT a10 SELECT DISTINCT d.owner,d.db_link,d.username,l.password, l.authusr,l.authpwd,d.host,d.created FROM dba_db_links d, sys.link$ l WHERE password IS NOT NULL AND d.username = l.userid / OWNER DB_LINK CON_USER CON_PWD AUTH_USE AUTH_PWD SERVICE CREATED JANE DBL.ACME.COM BLAKE TYGER ELLIE MAY ora51 23-JUN-99 PUBLIC DBL1.ACME.COM SCOTT TIGER ora51 23-JUN-99 SYS TARGET.ACME.COM SYS ORACLE inst1 23-JUN-99 SYSDBA V$DBLINK GV$DBLINK IN_TRANSACTION YES Oracle Parallel Server 2-24 Oracle8i

95 1 DB_LINK OWNER_ID LOGGED_ON HETEROGENEOUS NO YES PROTOCOL OPEN_CURSORS IN_TRANSACTION UPDATE_SENT COMMIT_POINT_ STRENGTH INST_ID GV$DBLINK COL db_link FORMAT a25 COL owner_id FORMAT HEADING "OWNID" COL logged_on FORMAT a5 HEADING "LOGON" COL heterogeneous FORMAT a5 HEADING "HETER" COL protocol FORMAT a8 COL open_cursors FORMAT 999 HEADING "OPN_CUR" COL in_transaction FORMAT a3 HEADING "TXN" COL update_sent FORMAT a6 HEADING "UPDATE" COL commit_point_strength FORMAT HEADING "C_P_S" SELECT * FROM v$dblink / 2-25

96 DB_LINK OWNID LOGON HETER PROTOCOL OPN_CUR TXN UPDATE C_P_S INST2.ACME.COM 0 YES YES UNKN 0 YES YES 255 EMP DEPT 2 CREATE VIEW company AS SELECT a.empno, a.ename, b.dname FROM emp a, b WHERE a.deptno = b.deptno; 2-26 Oracle8i

97 JWARD.DEPT DEPTNO DNAME MARKETING SALES HQ SALES SCOTT.EMP EMPNO ENAME JOB SMITH ALLEN WARD JONES CLERK SALESMAN SALESMAN MANAGER MGR HIREDATE 17 DEC FEB JUN APR 93 SAL COMM DEPTNO COMPANY EMPNO ENAME DNAME SMITH ALLEN WARD JONES MARKETING SALES SALES MARKETING

98 SELECT * FROM company; SQL Oracle8i

99 CREATE [PUBLIC] synonym_name FOR PUBLIC synonym_name schema object_name database_link_name CREATE PUBLIC SYNONYM object_name object_name : HQ SCOTT.EMP CREATE PUBLIC SYNONYM emp FOR SQL EMP EMP HQ HR 2-29

100 SCOTT EMP SCOTT SCOTT SALES EMP PL/SQL 3 SQL CREATE PROCEDURE fire_emp (enum NUMBER) AS BEGIN DELETE FROM WHERE empno = enum; END; 2-30 Oracle8i

101 FIRE_EMP 2 CREATE SYNONYM emp FOR FIRE_EMP CREATE PROCEDURE fire_emp (enum NUMBER) AS BEGIN DELETE FROM emp WHERE empno = enum; END; DML SCOTT LOCAL_DB CONNECT CREATE PROCEDURE fire_emp (enum NUMBER) AS BEGIN EXECUTE END; SCOTT CONNECT CREATE PROCEDURE term_emp (enum NUMBER) AS BEGIN DELETE FROM emp WHERE empno = enum; END; 2-31

102 LOCAL_DB FIRE_EMP HQ.ACME.COM TERM_EMP SCOTT SALES.ACME.COM CREATE PROCEDURE fire_emp (enum NUMBER) AS BEGIN DELETE FROM WHERE empno = enum; END; PEGGY SUPPLY.ACME.COM SCOTT SALES SQL> CONNECT SQL> CREATE PUBLIC SYNONYM emp FOR SUPPLY SALES EXECUTE DML SELECT INSERT UPDATE DELETE SELECT... FOR UPDATE LOCK TABLE 2-32 Oracle8i

103 SELECT... FOR UPDATE 2 SELECT e.empno, e.ename, d.dname FROM e, d WHERE e.deptno = d.deptno; UPDATE INSERT DELETE LOCK TABLE JWARD EMP SCOTT.SALES EMP INSERT INTO SELECT * FROM jward.emp; SQL LONG LONG RAW Oracle DBMS_SQL DDL CREATE ALTER DROP 'drop table emp', v7); DDL ANALYZE LIST CHAINED ROWS SYSDATE USER UID USERENV SQL : USERENV 2-33

104 : : DBMS_SQL Oracle8i PL/SQL Oracle 5-28 : JANE SALES SCOTT SLDB CONNECT CREATE PUBLIC DATABASE LINK sales.division3.acme.com CONNECT TO SCOTT IDENTIFIED BY TIGER USING 'sldb'; SALES.DIVISION3.ACME.COM SCOTT 2-34 Oracle8i

105 : SCOTT EMP SQL SELECT * FROM DANA SALES SLDB SCOTT SCOTT CONNECT CREATE SHARED PUBLIC DATABASE LINK sales.division3.acme.com CONNECT TO scott IDENTIFIED BY tiger AUTHENTICATED BY scott IDENTIFIED BY tiger USING 'sldb'; MTS SALES SCOTT 1 SALES.DIVISION3.ACME.COM LARRY SLDB CONNECT CREATE PUBLIC DATABASE LINK redwood USING 'sldb'; 2-35

106 : REDWOOD SCOTT SCOTT FOX FOX FOX EMP FOX SALES.DIVISION3.ACME.COM FOX EMP CONNECT SELECT * FROM NEIL SALES SLDB ID/ CRAZY/HORSE CONNECT CREATE SHARED PUBLIC DATABASE LINK sales.division3.acme.com AUTHENTICATED BY crazy IDENTIFIED BY horse USING 'sldb'; 1 SALES.DIVISION3.ACME.COM 2-36 Oracle8i

107 : SALES SLDB CONNECT CREATE PUBLIC DATABASE LINK sales.division3.acme.com CONNECT TO CURRENT_USER USING 'sldb'; : SCOTT EMP FIRE_EMP FORD CONNECT CREATE PROCEDURE fire_emp (enum NUMBER) AS BEGIN DELETE FROM WHERE empno=enum; END; GRANT EXECUTE ON FIRE_EMP TO FORD; FORD SCOTT CONNECT EXECUTE PROCEDURE scott.fire_emp (enum 10345); FORD SCOTT.FIRE_EMP SCOTT FORD SCOTT SCOTT FORD 2-37

108 : : FORD Oracle8i PL/SQL SCOTT SCOTT 2-38 Oracle8i

109 3 Oracle Oracle8i : Oracle8i Oracle Oracle8i 3-1

110 SQL SELECT COMMIT ROLLBACK SELECT * FROM COMMIT; CLOSE DATABASE LINK ALTER SESSION SALES ALTER SESSION CLOSE DATABASE LINK sales; ALTER SESSION 3-2 Oracle8i

111 : Oracle ORA ORA Oracle / SALES HQ 2 DML HQ : ALTER SESSION Oracle8i SQL : Oracle8i Oracle 3-3

112 2 5 WHERE r1.salary + r2.salary > SELECT SELECT SELECT SELECT e.empno, e.ename, d.deptno, d.dname FROM (SELECT empno, ename from e, dept d; Oracle 3-4 Oracle8i

113 CREATE TABLE CREATE TABLE AS ( SELECT l.a, l.b, r1.c, r1.d, r1.e, r2.b, r2.c FROM local l, remote1 r1, remote2 r2 WHERE l.c = r.c AND r1.c = r2.c AND r.e > 300 ); CREATE TABLE AS ( SELECT l.a, l.b, v.c, v.d, v.e FROM ( SELECT r1.c, r1.d, r1.e, r2.b, r2.c FROM remote1 r1, remote2 r2 WHERE r1.c = r2.c AND r1.e > 300 ) v, local l WHERE l.c = r1.c ); v SELECT

114 SQL Oracle OPTIMIZER_MODE CHOOSE COST OPTIMZER_MODE ALTER SESSION OPTIMIZER_MODE ALTER SESSION OPTIMIZER_MODE = CHOOSE; ALTER SESSION OPTIMIZER_MODE = COST; : OPTIMZER_MODE Oracle8i 3-6 Oracle8i

115 1 ANALYZE EMP DEPT ANALYZE TABLE emp COMPUTE STATISTICS; ANALYZE TABLE dept COMPUTE STATISTICS; DBA/ALL/USER_TABLES DBA/ALL/USER_TAB_COL_STATISTICS DBA/ALL/USER_TAB_COLUMNS DBA/ALL/USER_TAB_HISTOGRAMS DBA/ALL/USER_PART_HISTOGRAMS DBA/ALL/USER_SUBPART_HISTOGRAMS DBA/ALL/USER_USTATS : ANALYZE ANALYZE TABLE COMPUTE STATISTICS; ANALYZE : ANALYZE Oracle8i SQL Oracle8i 3-7

116 DBMS_ STATS ANALYZE GATHER_INDEX_STATS GATHER_TABLE_STATS GATHER_SCHEMA_STATS GATHER_DATABASE_STATS SCOTT.DEPT BEGIN DBMS_STATS.GATHER_TABLE_STATS ('scott', 'dept'); END; : DBMS_STATS Oracle8i PL/SQL CPU NO_MERGE SQL NO_ MERGE 3-8 DRIVING_SITE 3-8 Oracle8i

117 NO_MERGE NO_MERGE SQL 3-8 SELECT SELECT /* with argument */ SELECT /*+NO_MERGE(v)*/ t1.x, v.avg_y FROM t1, (SELECT x, AVG(y) AS avg_y FROM t2 GROUP BY x) v, WHERE t1.x = v.x AND t1.y = 1; /* in query block */ SELECT t1.x, v.avg_y FROM t1, (SELECT /*+NO_MERGE*/ x, AVG(y) AS avg_y FROM t2 GROUP BY x) v, WHERE t1.x = v.x AND t1.y = 1; : NO_MERGE Oracle8i DRIVING_SITE DRIVING_SITE DRIVING_SITE SELECT SELECT /*+DRIVING_SITE(dept)*/ * FROM emp, WHERE emp.deptno = dept.deptno; : DRIVING_SITE Oracle8i 3-9

118 : EXPLAIN PLAN Oracle8i : utlxplan.sql utlxplan.sql PLAN_ TABLE SQL EXPLAIN PLAN FOR EXPLAIN PLAN FOR SELECT d.dname FROM dept d WHERE d.deptno IN (SELECT deptno FROM GROUP BY deptno HAVING COUNT (deptno) >3 ) / 3-10 Oracle8i

119 SQL : utlxpls.sql utlxpls.sql SELECT Plan Table Operation Name Rows Bytes Cost Pstart Pstop SELECT STATEMENT NESTED LOOPS VIEW REMOTE TABLE ACCESS BY INDEX RO DEPT INDEX UNIQUE SCAN PK_DEPT SQL SELECT SELECT other FROM plan_table WHERE operation = 'REMOTE'; SELECT DISTINCT "A1"."DEPTNO" FROM "EMP" "A1" GROUP BY "A1"."DEPTNO" HAVING COUNT("A1"."DEPTNO")>3 : OTHER SET LONG

120 4 PL/SQL EXCEPTION PL/SQL NO_DATA_FOUND SQL ORA ORA RAISE_APPLICATION_ERROR() BEGIN... EXCEPTION WHEN ZERO_DIVIDE THEN /*... handle the exception */ END; WHEN RAISE_APPLICATION_ERROR PRAGMA_EXCEPTION_INIT DECLARE null_salary EXCEPTION; PRAGMA EXCEPTION_INIT(null_salary, ); BEGIN... RAISE_APPLICATION_ERROR(-20101, 'salary is missing');... EXCEPTION WHEN null_salary THEN... END; PL/SQL ORA Oracle8i

121 II

122

123 4 Oracle8i 2 : 4-1

124 DEPT Net8 HQ EMP SALES Net8 MAINT BLDG SCOTT SCOTT SALES HQ MAINT UPDATE SET loc = 'REDWOOD SHORES' WHERE deptno = 10; UPDATE scott.emp SET deptno = 11 WHERE deptno = 10; UPDATE SET room = 1225 WHERE room = 1163; COMMIT; 4-2 Oracle8i

125 : 1 2 DML DDL DML DDL DML DDL CREATE TABLE AS SELECT DELETE INSERT LOCK TABLE SELECT SELECT FOR UPDATE DML DDL INSERT SELECT INSERT UPDATE DELETE table_expression_clause DML/DDL XA OCI 4-3

126 SELECT DML COMMIT ROLLBACK SAVEPOINT Oracle8i 1 2 : SQL Oracle8i SQL : : Oracle 1 Oracle Oracle8i

127 INSERT INTO orders...; UPDATE warehouse...; UPDATE finance...;. COMMIT; SALES.ACME.COM WAREHOUSE.ACME.COM FINANCE.ACME.COM 4-5

128 SALES WAREHOUSE FINANCE 4-2 SALES WAREHOUSE FINANCE SALES.ACME.COM WAREHOUSE FINANCE SALES SALES 4-6 Oracle8i

129 4-2 SALES WAREHOUSE FINANCE 4-2 SALES WAREHOUSE FINANCE SALES.ACME.COM SQL 4-7

130 1 4-3 SALES 4-3 WAREHOUSE SALES COMMIT_POINT_STRENGTH = 75 COMMIT_POINT_STRENGTH = 100 FINANCE COMMIT_POINT_STRENGTH = Oracle8i

131 REDO 2 COMMIT_POINT_STRENGTH : COMMIT_POINT_STRENGTH Oracle8i Oracle

132 4-4 SALES.ACME.COM (45) HQ.ACME.COM (165) WAREHOUSE.ACME.COM (140) FINANCE.ACME.COM (45) HR.ACME.COM (45) 1 ROLLBACK Oracle8i

133 2 : 5-5 COMMIT_POINT_STRENGTH Oracle8i 2 Oracle8i

134 2 REDO REDO : prepared read-only abort SQL 4-12 Oracle8i

135 2 3 : 1 Oracle 2 : SET TRANSACTION READ ONLY : SET TRANSACTION READ ONLY 2 SCN READ ONLY

136 REDO REDO COMMIT ROLLBACK Oracle8i

137 REDO REDO 7. SCN SQL SCN Oracle SCN 1 SQL SCN :

138 Oracle8i SCN SCN SCN Oracle 2 Oracle RECO RECO Oracle 4-16 Oracle8i

139 Oracle LOCAL REMOTE 2 SCOTT LOCAL LOCAL REMOTE LOCAL 2 REMOTE REMOTE COMMIT_POINT_SITE = 200 COMMIT_POINT_SITE = SCOTT 1. SCOTT LOCAL REMOTE LOCAL 4. RECO 4-17

140 LOCAL 6 4 REMOTE 3 REMOTE 2 REMOTE 5 REMOTE COMMIT_POINT_STRENGTH = 200 COMMIT_POINT_STRENGTH = SCOTT 1. SCOTT LOCAL REMOTE 4. REMOTE 5. REMOTE 6. RECO 4-18 Oracle8i

141 : DBA_2PC_PENDING DBA_2PC_NEIGHBORS COMMIT FORCE ROLLBACK FORCE : SCN Oracle SCN Oracle SCN REDO Oracle SCN SCN SCN 3. SCN 4-19

142 : SCN SCN SCN : Oracle8i SALES.ACME.COM WAREHOUSE.ACME.COM SALES WAREHOUSE 1: DML SQL*Plus SQL SALES WAREHOUSE CONNECT INSERT INTO orders...; UPDATE INSERT INTO orders...; UPDATE COMMIT; SQL SQL Oracle8i

143 : SQL INSERT INTO orders...; UPDATE warehouse...; INSERT INTO orders...; UPDATE warehouse...; COMMIT; SALES.ACME.COM SQL WAREHOUSE.ACME.COM SALES SALES.ACME.COM SALES SALES.ACME.COM WAREHOUSE.ACME.COM SALES.ACME.COM WAREHOUSE.ACME.COM SQL SQL

144 : 2: Oracle COMMIT 4-8 SALES.ACME.COM : SALES.ACME.COM WAREHOUSE.ACME.COM 3: 1. Oracle WAREHOUSE.ACME.COM 2. WAREHOUSE.ACME.COM REDO SALES.ACME.COM WAREHOUSE.ACME.COM 3. WAREHOUSE.ACME.COM SALES.ACME.COM 4-22 Oracle8i

145 : 4-9 SALES.ACME.COM 1. Sales to Warehouse Please prepare 2. Warehouse to Sales Prepared WAREHOUSE.ACME.COM 4: 1. SALES.ACME.COM WAREHOUSE.ACME.COM 2. REDO WAREHOUSE.ACME.COM 4-23

146 : 5: : REDO 4-10 SALES.ACME.COM SALES WAREHOUSE.ACME.COM 4-24 Oracle8i

147 : 4-10 SALES.ACME.COM Sales to Warehouse: Commit WAREHOUSE.ACME.COM 7: COMMIT 4-25

148 : 4-26 Oracle8i

149 5 : 5-1

150 DISTRIBUTED_TRANSACTIONS DISTRIBUTED_LOCK_TIMEOUT DISTRIBUTED_RECOVERY_ CONNECTION_HOLD_TIME COMMIT_POINT_STRENGTH DISTRIBUTED_TRANSACTIONS Oracle SQL ORA-02042: DISTRIBUTED_TRANSACTIONS = Oracle8i

151 10 11 DML : DISTRIBUTED_TRANSACTIONS ORA-2042 DISTRIBUTED_TRANSACTIONS DISTRIBUTED_ TRANSACTIONS DISTRIBUTED_TRANSACTIONS SQL RECO Oracle8i : DISTRIBUTED_TRANSACTIONS Oracle8i 5-3

152 SQL Oracle8i DML SQL ORA-02049: Timeout: DISTRIBUTED_LOCK_TIMEOUT DISTRIBUTED_LOCK_TIMEOUT = Oracle 30 : DISTRIBUTED_LOCK_TIMEOUT Oracle8i 5-4 Oracle8i

153 DML ORA-01591: identifier SQL ID 2 DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME COMMIT_POINT_STRENGTH 5-5

154 COMMIT_POINT_STRENGTH = 200 : 4-8 PC PC ID ID 5-6 Oracle8i

155 DBA_2PC_PENDING ID Oracle8i 5-1 DBA_2PC_PENDING LOCAL_TRAN_ID GLOBAL_TRAN_ID STATE MIXED HOST COMMIT# integer.integer.integer : LOCAL_TRAN_ID GLOBAL_TRAN_ID global_db_name.db_hex_id.local_tran_id db_hex_id 8 16 ID : LOCAL_TRAN_ID GLOBAL_TRAN_ID 5-2 DBA_2PC_PENDING STATE YES 5-2 DBA_2PC_PENDING STATE collecting 5-7

156 5-2 DBA_2PC_PENDING STATE prepared committed forced commit forced abort 1 DBA_2PC_PENDING COL local_tran_id FORMAT a13 COL global_tran_id FORMAT a30 COL state FORMAT a8 COL mixed FORMAT a3 COL host FORMAT a10 COL commit# FORMAT a10 SELECT local_tran_id, global_tran_id, state, mixed, host, commit# FROM dba_2pc_pending / LOCAL_TRAN_ID GLOBAL_TRAN_ID STATE MIX HOST COMMIT# HQ.ACME.COM.ef192da commit no dlsun LOCAL_TRAN_ID GLOBAL_TRAN_ID 5-8 Oracle8i

157 DBA_2PC_NEIGHBORS ID ID Oracle8i 5-3 DBA_2PC_NEIGHBORS LOCAL_TRAN_ID IN_OUT DATABASE DBUSER_OWNER integer.integer.integer : LOCAL_TRAN_ID GLOBAL_TRAN_ID.DBA_ 2PC_PENDING IN OUT 5-9

158 5-3 DBA_2PC_NEIGHBORS INTERFACE C N IN_OUT OUT C N IN_OUT IN C N DBA_2PC_PENDING COL local_tran_id FORMAT a13 COL in_out FORMAT a6 COL database FORMAT a25 COL dbuser_owner FORMAT a15 COL interface FORMAT a3 SELECT local_tran_id, in_out, database, dbuser_owner, interface FROM dba_2pc_neighbors / SQL> CONNECT LOCAL_TRAN_ID IN_OUT DATABASE DBUSER_OWNER INT out SALES.ACME.COM SYS C SALES SALES SALES Oracle8i

159 Oracle 2 Oracle : ORA-02050: ID ORA-02051: ORA-02054: ID 1 Oracle8i 5-11

160 ORA ID ID DBA_ 2PC_PENDING DBA_ROLLBACK_SEGS 2 Oracle8i DBA_2PC_PENDING DBA_2PC_PENDING TRAN_COMMENT COMMIT COMMENT 5-12 Oracle8i

161 COMMIT COMMENT 'Finance/Accts_pay/Trans_type 10B'; DBA_2PC_PENDING ADVICE SQL ALTER_SESSION ADVISE DML EMP EMP SQL ALTER SESSION ADVISE COMMIT; INSERT INTO ; /*advice to commit at HQ */ ALTER SESSION ADVISE ROLLBACK; DELETE FROM ; /*advice to roll back at SALES*/ ALTER SESSION ADVISE NOTHING; FORCE ID COMMIT ROLLBACK : STATE 5-13

162 FORCE TRANSACTION FORCE ANY TRANSACTION ID SQL COMMIT FORCE 'transaction_id'; transaction_id DBA_2PC_PENDING LOCAL_ TRAN_ID GLOBAL_TRAN_ID DBA_2PC_PENDING ID LOCAL_TRAN_ID SQL COMMIT FORCE ' '; SCN SCN SCN SCN SCN 5-14 Oracle8i

163 ID SALES.ACME.COM.55d1c DBA_2PC_ PENDING SCN SCN SCN COMMIT FORCE 'SALES.ACME.COM.55d1c ', ; FORCE TRANSACTION FORCE ANY TRANSACTION SQL ROLLBACK FORCE 'transaction_id'; transaction_id DBA_2PC_PENDING LOCAL_ TRAN_ID GLOBAL_TRAN_ID ID ROLLBACK FORCE '2.9.4'; : RECO DBA_ 2PC_PENDING.STATE COLLECTING COMMITTED PREPARED COMMIT FORCE ROLLBACK FORCE FORCED COMMIT FORCED ROLLBACK 5-15

164 DBA_2PC_ PENDING MIXED YES ID DBMS_TRANSACTION PURGE_LOST_DB_ ENTRY PURGE_LOST_DB_ENTRY trans_id DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('trans_id'); SQL*Plus EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY(' '); 2 TPMonitor : DBMS_TRANSACTION Oracle8i PL/SQL DBMS_TRANSACTION 5-16 Oracle8i

165 : STATE Collecting Rolled back Rolled back PURGE_LOST_DB_ ENTRY Committed Committed Committed PURGE_LOST_DB_ ENTRY Prepared Unknown Prepared Forced commit Forced rollback Forced commit Forced rollback Unknown Committed PURGE_LOST_DB_ ENTRY Unknown Rolled back PURGE_LOST_DB_ ENTRY Mixed Committed PURGE_MIXED Mixed Rolled back PURGE_MIXED : DBMS_TRANSACTION Oracle8i PL/SQL :

166 : 5-1 SALES.ACME.COM WAREHOUSE.ACME.COM HQ.ACME.COM WAREHOUSE SALES HQ DBA_2PC_PENDING ID 3. DBA_2PC_NEIGHBORS 4. 1: 2: DBA_2PC_PENDING 3: DBA_2PC_NEIGHBORS 4: 5-18 Oracle8i

167 : 5: 6: DBA_2PC_PENDING 1: ORA-01591: ID ID 2: DBA_2PC_PENDING SQL*Plus WAREHOUSE DBA_2PC_PENDING CONNECT SELECT * FROM sys.dba_2pc_pending WHERE local_tran_id = ' '; Column Name Value LOCAL_TRAN_ID GLOBAL_TRAN_ID SALES.ACME.COM.55d1c STATE prepared MIXED no ADVICE TRAN_COMMENT Sales/New Order/Trans_type 10B FAIL_TIME 31-MAY-91 FORCE_TIME RETRY_TIME 31-MAY-91 OS_USER SWILLIAMS OS_TERMINAL TWA139: HOST system1 DB_USER SWILLIAMS COMMIT# 5-19

168 : ID ID ID global_database_name.hhhhhhhh.local_transaction_id global_database_name hhhhhhh local_transaction_id 16 ID ID ID WAREHOUSE LOCAL_TRAN_ID GLOBAL_TRAN_ID STATE prepared WAREHOUSE TRAN_COMMENT Sales/New Order/Trans_type 10B 5-20 Oracle8i

169 : 3: DBA_2PC_NEIGHBORS DBA_2PC_NEIGHBORS WAREHOUSE CONNECT SELECT * FROM dba_2pc_neighbors WHERE local_tran_id = ' ' ORDER BY sess#, in_out; Column Name Value LOCAL_TRAN_ID IN_OUT in DATABASE SALES.ACME.COM DBUSER_OWNER SWILLIAMS INTERFACE N DBID F4 SESS# 1 BRANCH 0100 DBA_2PC_NEIGHBORS IN_OUT = inin_out = out IN_OUT in out DATABASE DBUSER_OWNER 5-21

170 : DATABASE IN_OUT WAREHOUSE SALES IN_OUT DATABASE in SALES.ACME.COM WAREHOUSE DBUSER_OWNER SWILLIAMS DBUSER_OWNER SWILLIAMS INTERFACE INTERFACE N INTERFACE WAREHOUSE 4: ID 2 3 : 2 3 SALES HQ 2 3 SALES SALES DBA_2PC_PENDING SQL> CONNECT SQL> SELECT * FROM sys.dba_2pc_pending > WHERE global_tran_id = SALES.ACME.COM.55d1c ; Column Name Value LOCAL_TRAN_ID GLOBAL_TRAN_ID SALES.ACME.COM.55d1c STATE prepared MIXED no 5-22 Oracle8i

171 : ADVICE TRAN_COMMENT FAIL_TIME FORCE_TIME RETRY_TIME OS_USER OS_TERMINAL HOST DB_USER COMMIT# Sales/New Order/Trans_type 10B 31-MAY MAY-91 SWILLIAMS TWA139: system1 SWILLIAMS SALES SALES DBA_2PC_NEIGHBORS SELECT * FROM dba_2pc_neighbors WHERE global_tran_id = 'SALES.ACME.COM.55d1c ' ORDER BY sess#, in_out; 3 WAREHOUSE HQ WAREHOUSE Column Name Value LOCAL_TRAN_ID IN_OUT OUT DATABASE WAREHOUSE.ACME.COM DBUSER_OWNER SWILLIAMS INTERFACE N DBID 55d1c563 SESS# 1 BRANCH 1 HQ 5-23

172 : Column Name Value LOCAL_TRAN_ID IN_OUT OUT DATABASE HQ.ACME.COM DBUSER_OWNER ALLEN INTERFACE C DBID SESS# 1 BRANCH 1 SALES ID ID 2 SALES HQ 1 HQ HQ DBA_2PC_PENDING SELECT * FROM dba_2pc_pending WHERE global_tran_id = 'SALES.ACME.COM.55d1c '; Column Name Value LOCAL_TRAN_ID GLOBAL_TRAN_ID SALES.ACME.COM.55d1c STATE COMMIT MIXED NO ACTION TRAN_COMMENT Sales/New Order/Trans_type 10B FAIL_TIME 31-MAY-91 FORCE_TIME RETRY_TIME 31-MAY-91 OS_USER SWILLIAMS OS_TERMINAL TWA139: HOST SYSTEM1 DB_USER SWILLIAMS COMMIT# Oracle8i

173 : ID STATE COMMIT COMMIT# : SALES ID SQL> CONNECT SQL> COMMIT FORCE SALES.ACME.COM.55d1c ; WAREHOUSE ID SQL> CONNECT SQL> COMMIT FORCE SALES.ACME.COM.55d1c ; 6: DBA_2PC_PENDING Oracle8i 2 DBA_2PC_PENDING 5-1 DBA_2PC_PENDING DBA_2PC_PENDING.MIXED MIXED=yes RECO 5-25

174 RECO RECO RECO COMMIT COMMENT 2 COMMENT COMMIT COMMENT 'ORA-2PC-CRASH-TEST-n'; n 1 n Oracle8i

175 COMMIT COMMENT 'ORA-2PC-CRASH-TEST-7'; ORA-02054: ORA-02059: ORA-2PC-CRASH-TEST-7 DBA_2PC_PENDING RECO RECO Oracle8i RECO RECO RECO RECO RECO ENABLE/DISABLE DISTRIBUTED RECOVERY ALTER SYSTEM 2 RECO RECO ALTER SYSTEM DISABLE DISTRIBUTED RECOVERY; RECO ALTER SYSTEM ENABLE DISTRIBUTED RECOVERY; : MS-DOS PC RECO 5-27

176 : Oracle Oracle SCN SCN Oracle SCN SCN SQL 2 SCN SCN SCN SCN SCN 2 SCN 1 2 SELECT DML 2 UPDATE SELECT SELECT 2 SCN SCN SELECT * FROM SCN 5-28 Oracle8i

177 III

178

179 6 Oracle Oracle Oracle 6-1

180 HS Oracle8i Oracle Oracle Oracle SQL Oracle Oracle Oracle Oracle Oracle Oracle API Oracle Oracle Oracle Transparent Gateway ODBC OLE DB Generic Connectivity Oracle Oracle : Oracle SQL Oracle Oracle Oracle Oracle Oracle Oracle Oracle CREATE DATABASE LINK link_name CONNECT TO user IDENTIFIED BY password USING 'non_oracle_system'; Oracle HS SQL PL/SQL Oracle Oracle Oracle Oracle SELECT * FROM 6-2 Oracle8i

181 Oracle SQL Oracle SQL SQL Oracle8i Server Informix Sybase Oracle Oracle Transparent Gateway 8 Oracle Transparent Gateway 1 Generic Connectivity Oracle Transparent Gateway Generic Connectivity Agent : Oracle Transparent Gateway 7 Transparent Gateway Oracle Generic Connectivity Agent 8 Generic Connectivity SQL Oracle Oracle Oracle Oracle Oracle Oracle Oracle 1 Oracle Oracle Oracle 2 Oracle Oracle 2 Oracle Oracle Oracle 6-3

182 SQL SQL Oracle : 7-12 SQL SQL Oracle SQL Oracle HS 1. Oracle SQL Oracle SQL 2. Oracle 3. Oracle SQL Oracle SQL Oracle SQL Oracle SQL Oracle Oracle Oracle HS Oracle Oracle Oracle Transparent Gateway Generic Connectivity 6-4 Oracle8i

183 Transparent Gateway Oracle8i Server Oracle Transparent Gateway Transparent Gateway Oracle Oracle Oracle Generic Connectivity Oracle dbase dbase Sybase Sybase Transparent Gateway Transparent 6-1 Oracle Oracle8i Server Net8 Oracle8i Server Oracle Oracle8i Server Oracle Net8 Oracle 6-5

184 6-1 Oracle Oracle8i Oracle"X" Generic Connectivity Generic Connectivity Oracle Oracle ODBC OLE DB Transparent Gateway Oracle : Generic Connectivity 8 Generic Connectivity Oracle8i Server Oracle Oracle 6-2 Oracle8i Server Oracle Oracle8i Server Oracle SQL Oracle8i 6-6 Oracle8i

185 6-2 Oracle Oracle "X" Oracle"Y" Oracle8i Oracle 3 Oracle SQL Oracle Oracle Oracle 6-7

Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Packインストレーション・ガイド リリース2.2

Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Packインストレーション・ガイド リリース2.2 Oracle Enterprise Manager Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Pack 2.2 2000 11 : J02263-01 Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Pack 2.2

More information

Oracle Enterprise Manager概説 リリース2.2

Oracle Enterprise Manager概説 リリース2.2 Oracle Enterprise Manager 2.2 2000 11 : J02261-01 Oracle Enterprise Manager 2.2 : J02261-01 Oracle Enterprise Manager Concepts Guide, Release 2.2 A85250-01 Copyright 1996, 2000, Oracle Corporation. All

More information

橡ExCtrlPDF.PDF

橡ExCtrlPDF.PDF THE Database FOR Network Computing Oracle Oracle Oracle Oracle Oracle Oracle (Oracle Object for OLE Oracle Developer) SQL Oracle8 Enterprise Edition R8.0.5 for Windows NT Oracle8 Enterprise Edition R8.0.5

More information

new_logo.eps

new_logo.eps Oracle Enterprise Manager 2.0.4 :A62835-1 Oracle Enterprise Manager 2.0.4 :A62835-1 1 :1999 4 1 :Oracle Enterprise Manager Installation, Release 2.0.4 :A67818-01 Copyright 1999, Oracle Corporation. All

More information

KeySQL R5.1 Release Note

KeySQL R5.1 Release Note KeySQL for Microsoft Windows 5.1 2005 10 : B19176-02 Copyright 2005, Oracle Corporation All Right Reserved Oracle Oracle Oracle Corporation KeySQL for Microsoft Windows 5.1 : B19176-02 Copyright 2005,

More information

Oracle8 Workgroup Server for Windows NTインストレーション・ガイド,リリース8.0.6

Oracle8 Workgroup Server for Windows NTインストレーション・ガイド,リリース8.0.6 Oracle8 Workgroup Server for Windows NT 8.0.6 2000 5 : J00213-01 Oracle8 Workgroup Server for Windows NT, 8.0.6 : J00213-01 Oracle8 Release 8.0.6 for Windows NT A69969-01 Copyright 1999, 2000, Oracle Corporation.

More information

KeySQL for Microsoft Windows 6.0 : B28350-01 Copyright 2006, Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Co

KeySQL for Microsoft Windows 6.0 : B28350-01 Copyright 2006, Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Co KeySQL for Microsoft Windows 6.0 2006 3 : B28350-01 Copyright 2006, Oracle Corporation All Right Reserved Oracle Oracle Oracle Corporation KeySQL for Microsoft Windows 6.0 : B28350-01 Copyright 2006, Oracle

More information

Oracleコール・インタフェース for Windows スタート・ガイド リリース8.1.6

Oracleコール・インタフェース for Windows スタート・ガイド リリース8.1.6 Oracle for Windows 8.1.6 2000 4 : J01324-01 Oracle for Windows 8.1.6 : J01324-01 Oracle Call Interface Getting Started, Release 8.1.6 for Windows A73022-01 Eric Belden Joseph Garcia Lisa Giambruno Michael

More information

new_logo.eps

new_logo.eps Oracle for Windows NT and Windows 95/98 8.1.5 1999 5 : A62908-1 Oracle for Windows NT and Windows 95/98 8.1.5 : A62908-1 1 1999 5 1 Oracle Call Interface Getting Started Release 8.1.5 for Windows NT and

More information

D1印刷用.PDF

D1印刷用.PDF [ D-1 ] Windows Oracle8i for Windows Oracle8i for Windows / / Visual Basic - Oracle8i SQL Oracle Oracle8i for Windows Oracle8i Enterprise Edition Oracle8i Personal Edition Oracle8i Workgroup Server Oracle8i

More information

Windowsユーザーの為のOracle Database セキュリティ入門

Windowsユーザーの為のOracle Database セキュリティ入門 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

More information

日本オラクル株式会社

日本オラクル株式会社 FISC 6 Oracle Database 10g ~ ~ : 2005 7 26 : 2005 7 31 : 1.0 2004 4 (* ) FISC ) (* ) FISC 6 (* FISC 6 ) FISC 6 Oracle g Database 10 (FISC) http://www.fisc.or.jp FISC http://www.fisc.or.jp/info/info/050307-1.htm

More information

Oracle9i Reportsのチューニング

Oracle9i Reportsのチューニング Oracle9i Reports 2002 5 Oracle9i Reports...3...4...4...9...14...18 Oracle9i Forms...19...19...20 A...22 B...24 Oracle9i Reports 2 Oracle9i Reports Oracle9i Reports Oracle9i Oracle9i Reports 3 Oracle9i

More information

BC4J...4 BC4J Association JSP BC4J JSP OC4J

BC4J...4 BC4J Association JSP BC4J JSP OC4J lê~åäévá=gaéîéäçééê= 9.0.3/9.0.4 BC4J Creation Date: Oct 08, 2003 Last Update: Feb 27, 2004 Version 1.0 ...3... 3 BC4J...4 BC4J...4... 4... 5... 6...7... 8... 9 Association... 13... 15... 20... 22... 25

More information

Windows Oracle -Web - Copyright Oracle Corporation Japan, All rights reserved.

Windows Oracle -Web - Copyright Oracle Corporation Japan, All rights reserved. Windows Oracle -Web - Copyright Oracle Corporation Japan, 2004. All rights reserved. Agenda Oracle Windows Windows Oracle 1 / Active Directory/Enterprise User Security 1-1 Windows 1-2 Kerberos 1-3 Enterprise

More information

Oracle9i

Oracle9i Oracle9i 2002 2 Oracle9i... 4... 4... 4 Oracle... 4 SQL... 6... 6... 6... 7... 7... 9... 9... 9 CUBE... 10... 11... 11... 11 OR... 12... 12... 14... 14... 15... 15... 16... 16... 18... 18... 18... 19...

More information

橡実践Oracle Objects for OLE

橡実践Oracle Objects for OLE THE Database FOR Network Computing 2 1. 2 1-1. PL/SQL 2 1-2. 9 1-3. PL/SQL 11 2. 14 3. 16 3-1. NUMBER 16 3-2. CHAR/VARCHAR2 18 3-3. DATE 18 4. 23 4-1. 23 4-2. / 24 26 1. COPYTOCLIPBOARD 26 III. 28 1.

More information

untitled

untitled Oracle Enterprise Repository etrust SiteMinder 10g 3 (10.3) 2008 10 Oracle Enterprise Repository etrust SiteMinder Setup and Configuration Guide, 10g Release 3 (10.3) Copyright 2007, 2008, Oracle. All

More information

untitled

untitled Oracle Direct Seminar !? Oracle Database 11g - - Agenda Copyright 2009, Oracle. All rights reserved. 2 Agenda Copyright 2009, Oracle. All

More information

橡j_Oracle_whitepaper.PDF

橡j_Oracle_whitepaper.PDF Pervasive-Oracle 1 1 Pervasive Software Pervasive-Oracle / Pervasive Oracle Pervasive-Oracle ISV Pervasive-Oracle Pervasive.SQL Oracle 2 Pervasive-Oracle Pervasive-Oracle Pervasive.SQL Oracle Open Database

More information

untitled

untitled Oracle Direct Seminar SQL Agenda SQL SQL SQL SQL 11g SQL FAQ Oracle Direct SQL Server MySQL PostgreSQL Access Application Server Oracle Database Oracle Developer/2000 Web Oracle Database

More information

Microsoft Word - 430_15_Developing_Stored_Procedure.doc

Microsoft Word - 430_15_Developing_Stored_Procedure.doc Java Oracle 1998 11 Java 3 Java Web GUI Java Java Java Oracle Java Oracle8i Oracle / Oracle Java Virtual Machine VM CORBA Enterprise JavaBeans Oracle Java Java Java Oracle Oracle Java Virtual Machine Oracle

More information

Microsoft Word - J doc

Microsoft Word - J doc SQL*Plus for Windows 8.1.6 2000 5 : J01601-01 : : Oracle Windows Windows NT 4.0 Windows 2000 Windows 95 Windows 98 Windows NT Windows NT 4.0 Windows 2000 Oracle Oracle Oracle Corporation Oracle7 Oracle8i

More information

Agenda

Agenda Oracle データベースの監査機能 株式会社アクアシステムズアプリケーション統括部 PAU001J-00-00SE 株式会社アクアシステムズ Oracle データベースを専門とする技術者集団 Oracle データベースチューニング & 監視ツール Performance Analyzer の開発 / 販売 Oracle データベース診断及びパフォーマンスチューニング Oracle データベースに関するコンサルティング

More information

1 SQL Server SQL Oracle SQL SQL* Plus PL/SQL 2 SQL Server SQL Server SQL Oracle SQL SQL*Plus SQL Server GUI 1-1 osql 1-1 Transact- SQL SELECTFROM 058

1 SQL Server SQL Oracle SQL SQL* Plus PL/SQL 2 SQL Server SQL Server SQL Oracle SQL SQL*Plus SQL Server GUI 1-1 osql 1-1 Transact- SQL SELECTFROM 058 1 SQL Server SQL Oracle SQL SQL* Plus PL/SQL 2 SQL Server SQL Server SQL Oracle SQL SQL*Plus SQL Server GUI 1-1 osql 1-1 Transact- SQL SELECTFROM 058 2 Excel 1 SQL 1 SQL Server sp_executesql Oracle SQL

More information

Oracle Lite Windows CE開発者ガイド,リリース4.0.1

Oracle Lite Windows CE開発者ガイド,リリース4.0.1 Oracle Lite Windows CE 4.0.1 2000 10 : J02401-01 Oracle Lite Windows CE, 4.0.1 : J02401-01 Oracle Lite Windows CE Developper s Guide,Release4.0.1 A86147-01 Copyright 2000, Oracle Corporation. All rights

More information

自己管理型データベース: アプリケーションおよびSQLチューニング・ガイド

自己管理型データベース: アプリケーションおよびSQLチューニング・ガイド : SQL 2005 9 : SQL... 3 SQL... 6... 8... 9 SQL :... 9 SQL... 10... 11 SQL... 12 SQL TUNING SET... 13 SQL... 14 ADDM SQL... 14 SQL... 15 STS... 15... 16 SQL... 16 DBMS_SQLTUNE... 17... 17 SQL... 19 SQL

More information

領域サイズの見積方法

領域サイズの見積方法 White Paper 1998 3 1998 7 NULL 1998 9 2 8.03 Design & Migration Services Oracle Corporation Japan 1998 Printed in Japan Oracle and SQL*Loader are registered trademarks. Oracle7 Oracle Corporation Oracle

More information

PowerPoint -O80_REP.PDF

PowerPoint -O80_REP.PDF Oracle8 Core Technology Seminar 1997109,31 Oracle8 OS: UNIX Oracle8 : Release8.0.3 Oracle8 Quick Start Package Lesson 5 -- Enhancements to Distributed Facilities Oracle8 -- - Oracle8 LOB Oracle8 -- - Updates

More information

untitled

untitled Oracle Enterprise Repository IBM Rational ClearCase IBM Rational ClearQuest 10g 3 (10.3) 2008 10 Oracle Enterprise Repository IBM Rational ClearCase and IBM Rational ClearQuest Integration Guide, 10g Release

More information

KWCR3.0 instration

KWCR3.0 instration KeyWeb Creator R3.0 R3.0 for MS-Windows 2005 10 B25586-01 Oracle Oracle Oracle Corporation Copyright 2005, Oracle Corporation All Right Reserved KeyWeb Creator R3.0 2005 10 Copyright 1997-2005 KeyWeb Creator

More information

Oracle9i Application Server for Windows NT Oracle HTTP Server powered by Apacheパフォーマンス・ガイド, リリース1.0.2

Oracle9i Application Server for Windows NT Oracle HTTP Server powered by Apacheパフォーマンス・ガイド, リリース1.0.2 Oracle9i Application Server for Windows NT Oracle HTTP Server powered by Apache 1.0.2 2001 2 : J02963-01 Oracle9i Application Server for Windows NT Oracle HTTP Server powered by Apache, 1.0.2 : J02963-01

More information

ハイウォーターマークを知る

ハイウォーターマークを知る THE Database FOR Network Computing Oracle Oracle Oracle7 Oracle8 Oracle8 Enterprise Edition R8.0.4 for Windows NTOracle7 Server R7.3.4 for Windows NT Oracle7Oracle8 Oracle,Oracle7,Oracle8 1.5.1.... 6 1.5.2.

More information

7 i 7 1 2 3 4 5 6 ii 7 8 9 10 11 1 12 13 14 iii.......................................... iv................................................ 21... 1 v 3 6 7 3 vi vii viii ix x xi xii xiii xiv xv 26 27

More information

9 i 9 1 2 3 4 5 6 ii 7 8 9 10 11 12 .......................................... iii ... 1... 1........................................ 9 iv... v 3 8 9 3 vi vii viii ix x xi xii xiii xiv 34 35 22 1 2 1

More information

i ii iii iv v vi vii viii ix x xi xii xiii xiv xv xvi 2 3 4 5 6 7 $ 8 9 10 11 12 13 14 15 16 17 $ $ $ 18 19 $ 20 21 22 23 24 25 26 27 $$ 28 29 30 31 $ $ $ 32 33 34 $ 35 $ 36 $ 37 38 39 40 $ 41 42 43 44

More information

DB12.1 Beta HandsOn Seminar

DB12.1 Beta HandsOn Seminar Oracle Database 12c Release 1 CoreTech Seminar Migration 日本オラクル株式会社磯部光洋 Program Agenda Migration 概要 新機能詳細 SQL Translation Framework Implicit Statement Results Enhanced SQL to PL/SQL Bind Handling Identity

More information

<Documents Title Here>

<Documents Title Here> Oracle9i Database R9.2.0 for Windows Creation Date: Mar 06, 2003 Last Update: Mar 24, 2003 CD 1 A99346-01 Oracle9i Database Release 2 (9.2.0.1.0) for Microsoft Windows NT/2000/XP CD 1 of 3 2 A99347-01

More information

PowerPoint プレゼンテーション

PowerPoint プレゼンテーション MySQL のロックについて JPOUG> SET EVENTS 20140907 2014/09/07 平塚貞夫 Revision 2 1 自己紹介 DB エンジニアをやっています 専門は Oracle Database と MySQL オープンソースソフトウェアの導入支援をしています 仕事の割合は Oracle:MySQL:PostgreSQL=1:2:7 くらいです Twitter:@sh2nd

More information

I

I I II III IV V VI VII VIII IX X XI XII XIII XIV 1. 2 3 4 5 2. 6 7 8 3. 1 2 3 9 4 5 10 6 11 4. 1 2 3 1 2 12 1 2 3 1 2 3 13 14 1 2 1 15 16 1. 20 1 21 1 22 23 1 2 3 4 24 1 2 ok 25 1 2 26 1 2 3 27 2. 28

More information

~~~~~~~~~~~~~~~~~~ wait Call CPU time 1, latch: library cache 7, latch: library cache lock 4, job scheduler co

~~~~~~~~~~~~~~~~~~ wait Call CPU time 1, latch: library cache 7, latch: library cache lock 4, job scheduler co 072 DB Magazine 2007 September ~~~~~~~~~~~~~~~~~~ wait Call CPU time 1,055 34.7 latch: library cache 7,278 750 103 24.7 latch: library cache lock 4,194 465 111 15.3 job scheduler coordinator slave wait

More information

日本語タイトルを入力

日本語タイトルを入力 Oracle Application Server Infrastructure 2004 6 Oracle Application Server Infrastructure Oracle Application ServerInfrastructure Oracle Application Server 10g Release 9.0.4... 3... 3 i.... 4 ii.... 4...

More information

第 2 章 問合せの基本操作 この章では データベースから情報を検索する際に使用する SELECT コマンド および SELECT コマンドと 同時に使用する句について説明します 1. 問合せとは 2. 基本的な問合せ 3. 列の別名 4. 重複行を一意にする 5. 検索行の絞込み 6. 文字パター

第 2 章 問合せの基本操作 この章では データベースから情報を検索する際に使用する SELECT コマンド および SELECT コマンドと 同時に使用する句について説明します 1. 問合せとは 2. 基本的な問合せ 3. 列の別名 4. 重複行を一意にする 5. 検索行の絞込み 6. 文字パター はじめに コース概要と目的 データベース処理に使用する SQL の基本構文と使用方法について説明します 受講対象者 SQL を使用してアプリケーション開発される方 管理者となられる方 前提条件 Oracle 概要 コースを受講された方 もしくは同等の知識をお持ちの方 テキスト内の記述について 構文 [ ] 省略可能 { A B } A または B のどちらかを選択 n _ 数値の指定 デフォルト値

More information

OM.indd

OM.indd _ INDEX 3 4 5 6 7 8 9 Platinum 10 Gold 12 Silver 14 Bronze 16 18 20 FAQ 21 22 1997 10 15 Platinum Platinum IT 保々雅世 3 IT Control Real Application Cluster Grid Oracle Application Server 10g CLE MASTER ORA

More information

Oracle8簡単チューニング for Windows NT

Oracle8簡単チューニング for Windows NT Oracle8 ... 2 0.... 3 1.WINDOWS NT... 4 1.1.CPU...4 1.2....8 W INDOWS NT...9 2.ORACLE... 10 2.1.SHARED_POOL_SIZE...10 2.2.DB_BLOCK_BUFFERS...11 2.3.SORT_AREA_SIZE...14 2.4.DB_FILE_MULTIBLOCK_READ_COUNT...15

More information

20050314_02-4.ppt

20050314_02-4.ppt Oracle Database 10g Oracle XML DB 2005 3 14 1 Agenda Oracle XML DB XML SQL Oracle Database 10g Release 2 Copyright Oracle Corporation, 2005 All right reserved. 2 XML Oracle Database 10g Release 2 Oracle

More information

Pro*COBOL for Windows プリコンパイラ・スタート・ガイド リリース8.1.6/1.8.51

Pro*COBOL for Windows プリコンパイラ・スタート・ガイド リリース8.1.6/1.8.51 Pro*COBOL for Windows 8.1.6/1.8.51 2000 4 : J01326-01 Pro*COBOL for Windows 8.1.6/1.8.51 : J01326-01 Pro*COBOL Precompiler Getting Started, Release 8.1.6 and 1.8.51 for Windows A73024-01 Riaz Ahmed Eric

More information

dbMAGIC Ver8.2 SQLガイド

dbMAGIC Ver8.2 SQLガイド dbmagic dbmagic SQL dbmagic SQL dbmagic 1999 2 5 (1) (2) (3) (4) (3) Windows WindowsNT Microsoft Corporation Java Sun Microsystems,Inc. dbmagic Copyright 1999 ii SQL 1 1 1 1.1 : : : : : : : : : : : : :

More information

Step2 入門

Step2 入門 ii iii iv v vi NEC Corporation 1999 vii C O N T E N T S PART 1 PART 2 PART 3 viii PART 4 ix C O N T E N T S PART 5 x PART 6 xi C O N T E N T S PART 7 xii PART 8 PART 9 xiii C O N T E N T S xiv xv PART

More information

第 5 章 結合 結合のパフォーマンスに影響を与える結合の種類と 表の結合順序について内部動作を交えて 説明します 1. 結合処理のチューニング概要 2. 結合の種類 3. 結合順序 4. 結合処理のチューニングポイント 5. 結合関連のヒント

第 5 章 結合 結合のパフォーマンスに影響を与える結合の種類と 表の結合順序について内部動作を交えて 説明します 1. 結合処理のチューニング概要 2. 結合の種類 3. 結合順序 4. 結合処理のチューニングポイント 5. 結合関連のヒント はじめに コース概要と目的 Oracle をより効率的に使用するための SQL チューニング方法を説明します また 索引の有無 SQL の記述方 法がパフォーマンスにどのように影響するのかを実習を通して習得します 受講対象者 アプリケーション開発者 / データベース管理者の方 前提条件 SQL トレーニング データベース アーキテクチャ コースを受講された方 もしくは同等の知識をお持 ちの方 テキスト内の記述について

More information

Oracle Database 10gのOracle Data Guard

Oracle Database 10gのOracle Data Guard Oracle Database 10g Oracle Data Guard 2004 Oracle Data Guard... 3... 3... 3 Oracle Data Guard... 4 Oracle Data Guard... 4 Oracle Data Guard... 4 Oracle Data Guard... 5 Oracle Data Guard... 6 Oracle Data

More information

_02_3.ppt

_02_3.ppt XML DB Oracle Corporation Agenda RDB XML SQL/XML XML DB XML Oracle Corporation 2 Agenda RDB XML SQL/XML XML DB XML Oracle Corporation 3 RDB-XML RDB XML Oracle Corporation 4 XML RDB [Oracle] Extract ExtractValue

More information

ITR Market View:アイデンティティ/アクセス管理市場2018目次

ITR Market View:アイデンティティ/アクセス管理市場2018目次 ITR Market View: 2018... 1 1-1... 2 1-2... 3 1-2-1... 3 1-2-2... 5 1-2-3... 5 1-2-4... 5 1-3... 6... 9 2-1... 10 2-1-1... 10 2-1-2... 14 2-2 IDM IAM... 16 2-2-1 IDM IAM... 16 2-2-1-1... 16 2-2-1-2... 19

More information

,, create table drop table alter table

,, create table drop table alter table PostgreSQL 1 1 2 1 3,, 2 3.1 - create table........................... 2 3.2 - drop table............................ 3 3.3 - alter table............................ 4 4 - copy 5 4.1..................................

More information

PowerPoint プレゼンテーション

PowerPoint プレゼンテーション OSS のカラム型データベースエンジン MariaDB ColumnStore ビッグデータ分析などに適した大規模並列処理に対応する データベースエンジン MariaDB について MySQL から派生したオープンソースリレーショナルデータベース MariaDB は MySQL のオリジナルコード開発者である Michael Monty Widenius 氏によって開発されている MySQL と MariaDB

More information

目次 1 集計関数 / 分析関数とは 2 集計関数 / 分析関数のパフォーマンス効果 3 ケーススタディグループ小計やクロス集計を計算するランキングを表示する前月比較を表示する累計を計算する移動平均を計算する構成比を計算する Oracle8i SQL Oracle8i Oracle Oracle C

目次 1 集計関数 / 分析関数とは 2 集計関数 / 分析関数のパフォーマンス効果 3 ケーススタディグループ小計やクロス集計を計算するランキングを表示する前月比較を表示する累計を計算する移動平均を計算する構成比を計算する Oracle8i SQL Oracle8i Oracle Oracle C Oracle8i データウェアハウス機能活用法 ~ レポーティングに有効な集計関数 分析関数 ~ Creation Date: Oct. 11, 2000 Last Update: Oct. 11, 2000 Version: 1.0!! DWH etc Business Intelligence Oracle8i RDBMS DWH Oracle8i Oracle Corporation Japan

More information

C3印刷用.PDF

C3印刷用.PDF [ C-3 ] Oracle8i On Windows Agenda Windows Oracle8i Oracle8i for Windows NT/2000 R8.1.7 Oracle HTTP Server Oracle intermedia Oracle Workflow Windows Oracle8i for Windows Oracle8i Enterprise Edition Oracle8i

More information

PostgreSQL SQL チューニング入門 ~ Explaining Explain より ~ 2012 年 11 月 30 日 株式会社アシスト 田中健一朗

PostgreSQL SQL チューニング入門 ~ Explaining Explain より ~ 2012 年 11 月 30 日 株式会社アシスト 田中健一朗 PostgreSQL SQL チューニング入門 ~ Explaining Explain より ~ 2012 年 11 月 30 日 株式会社アシスト 田中健一朗 アジェンダ 1.EXPLAIN とは 2. 表アクセスの基本 3. 結合の基本 4. 統計情報とは 5.EXPLAIN コマンド 6. 問題解決例 7. まとめ 2 1.EXPLAIN とは 実行計画とは - 目的地は 1 つでもアクセス方法は複数

More information

Oracle - SCOTT/TIGER - 2

Oracle - SCOTT/TIGER - 2 Oracle - SCOTT/TIGER - 2 Oracle Database - - - Standard Edition 3 DoS =$ 4 5 SSO Browser Clients IC OID LDAP/SSL USB PKI SSL Web Server SQL Clients 7 Agenda Oracle Database Oracle Database 8 OS 9 OUI 10

More information

Oracleの領域管理~トラブル防止のテクニック~

Oracleの領域管理~トラブル防止のテクニック~ THE Database FOR Internet Computing Oracle ... 3... 4... 4... 5... 5... 7... 8... 9... 12... 13... 13... 16... 17... 18... 20... 22... 23... 23... 24... 25... 25... 26... 28... 31... 31... 31... 33...

More information

Oracle Database 11g × Hitachi Storage Solutionsのベストプラクティス

Oracle Database 11g × Hitachi Storage Solutionsのベストプラクティス - 1 - 1... 4 2... 5 2.1 ORACLE11G DATABASE REPLAY... 5 2.1.1 DB... 5 2.1.2... 6 2.2 DATABASE REPLAY... 6 2.2.1 DB... 6 2.2.2... 6 3... 8 3.1 ORACLE DATABASE 11G DATABASE REPLAY... 8 3.1.1 Database Replay...

More information

ストラドプロシージャの呼び出し方

ストラドプロシージャの呼び出し方 Release10.5 Oracle DataServer Informix MS SQL NXJ SQL JDBC Java JDBC NXJ : NXJ JDBC / NXJ EXEC SQL [USING CONNECTION ] CALL [.][.] ([])

More information

プレポスト【問題】

プレポスト【問題】 1/5 ページ プレポスト データベース基礎 受講日程受講番号氏名 1 データベースの特徴で間違っているものを選びなさい 1. データの一元管理が可能 2. データの重複が少ない 3. プログラムとの関係が1 対 1 4. データの整合性の確保 2 ANSI/SPARC による 3 層スキーマについて正しいものを選びなさい 1. 外部スキーマ : プログラムに必要な部分のデータ構造を定義概念スキーマ

More information

リリースノートR41.PDF

リリースノートR41.PDF 1. 1) Microsoft Windows 95/98 Windows NT 4.0 Workstation Windows 2000 Net8 Oracle Net8 R8.0.4 2) CPU 80486 Microsoft Windows NT 4.0 Windows 2000 Microsoft Windows 95/98 2M 4M KeySQL 2MB CD-ROM KeySQL CD-ROM

More information

はじめに コースの概要と目的条件分岐の方法や複雑な集計の手法など SQL のコーディングの幅を広げるためのテクニックについて説明します また パフォーマンスを考慮した記述方法や正しい結果を取得するための記述方法などについても あわせて説明します 本コースでは 実践的な SQL の記述手法を広く浅く紹

はじめに コースの概要と目的条件分岐の方法や複雑な集計の手法など SQL のコーディングの幅を広げるためのテクニックについて説明します また パフォーマンスを考慮した記述方法や正しい結果を取得するための記述方法などについても あわせて説明します 本コースでは 実践的な SQL の記述手法を広く浅く紹 はじめに コースの概要と目的条件分岐の方法や複雑な集計の手法など SQL のコーディングの幅を広げるためのテクニックについて説明します また パフォーマンスを考慮した記述方法や正しい結果を取得するための記述方法などについても あわせて説明します 本コースでは 実践的な SQL の記述手法を広く浅く紹介することを目的としているため 細かな構文やオプションの習得を目的とはしていないことを 予めご了承ください

More information

Microsoft PowerPoint - 講義補助資料2017.pptx

Microsoft PowerPoint - 講義補助資料2017.pptx 66 SQL 最も標準的なリレーショナルデータベースの言語 ISO による国際標準規格であり特定の企業に依存しない SQL の規格 :SQL89(SQL1), SQL92(SQL2), SQL:1999(SQL3), SQL:2003, SQL:2006, SQL:2008, SQL:2011 標準規格としての SQL は 何かの略語ではない と規定されている ( 参考 : IBM 社の製品で使われている

More information

困ったときのQ&A

困ったときのQ&A ii iii iv NEC Corporation 1998 v C O N T E N T S PART 1 vi vii viii ix x xi xii PART 2 xiii PART 3 xiv P A R T 1 3 1 2 PART 3 4 2 1 1 2 4 3 PART 1 4 5 5 6 PART 1 7 8 PART 1 9 1 2 3 1 2 3 10 PART 1 1 2

More information

Warehouse Builderにおける予測分析の使用

Warehouse Builderにおける予測分析の使用 Warehouse Builder Oracle 2006 3 Warehouse Builder... 3 ETL... 4 DMBS_PREDICTIVE_ANALYTICS... 4... 5 1... 5 2... 5 3... 5... 6 SQL PREDICT... 7... 9 1... 9 2... 9 3... 9... 10 PL/SQL... 11... 12... 12...

More information

Copyright Oracle Parkway, Redwood City, CA U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated softw

Copyright Oracle Parkway, Redwood City, CA U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated softw Oracle Solaris Studio 12.3 Part No: E26466 2011 12 Copyright 2011 500 Oracle Parkway, Redwood City, CA 94065 U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,

More information

™…

™… i 1 1 1 2 3 5 5 6 7 9 10 11 13 13 14 15 15 16 17 18 20 20 20 21 22 ii CONTENTS 23 24 26 27 2 31 31 32 32 33 34 37 37 38 39 39 40 42 42 43 44 45 48 50 51 51 iii 54 57 58 60 60 62 64 64 67 69 70 iv 70 71

More information

ORACLEデータベース10G データ・ポンプ: 超高速データ移動ユーティリティの基盤

ORACLEデータベース10G データ・ポンプ: 超高速データ移動ユーティリティの基盤 Oracle Database 10g Data Pump: George H. Claborn, Oracle Corporation Data Pump Data Pump Oracle Database Oracle Database 10g Data Pump PL/SQL DBMS_DATAPUMP Data Pump expdp impdp Web Enterprise Manager

More information

1,.,,,., RDBM, SQL. OSS,, SQL,,.

1,.,,,., RDBM, SQL. OSS,, SQL,,. 1,.,,,., RDBM, SQL. OSS,, SQL,,. 3 10 10 OSS RDBMS SQL 11 10.1 OSS RDBMS............................ 11 10.1.1 PostgreSQL................................. 11 10.1.2 MySQL...................................

More information

Oracle Database 10g Release 2を使用したデータベース・パフォーマンス

Oracle Database 10g Release 2を使用したデータベース・パフォーマンス Oracle Database 10g Release 2 2005 9 Oracle Database 10g Release 2... 3... 3... 3 Automatic Workload Repository AWR... 3 Automatic Database Diagnostic Monitor ADDM... 4 Automatic SQL Tuning SQL... 4 SQL

More information

Oracle Spatial

Oracle Spatial Oracle Spatial 2003 10 Oracle Spatial... 3 1.0... 3 2.0 ORDBMS... 5 2.1 ORDBMS... 5 2.2... 5 2.2.1... 6 2.2.2... 6 2.2.3... 6 2.2.4... 6 2.3... 7 2.3.1... 7 2.3.2... 7 2.3.3... 8 2.3.4... 8 2.3.5... 8

More information

TopLink å SampleClient.java... 5 Ò readallsample() querysample() cachesample() Ç..

TopLink å SampleClient.java... 5 Ò readallsample() querysample() cachesample() Ç.. lê~åäé= qçéiáåâ= NMÖENMKNKPF Volume2 Creation Date: Mar 04, 2005 Last Update: Aug 22, 2005 Version 1.0 ...3... 3 TopLink å...4 1... 4... 4 SampleClient.java... 5 Ò... 8... 9... 10 readallsample()... 11

More information

Oracle Identity Managementの概要およびアーキテクチャ

Oracle Identity Managementの概要およびアーキテクチャ Oracle Identity Management 2003 12 Oracle Identity Management... 3 ID... 3 ID... 4 ID... 4 Oracle Identity Management... 5 Oracle Identity Management... 6 Oracle Identity Management... 7 ID... 8 Application

More information

MultiPASS B-20 MultiPASS Suite 3.10使用説明書

MultiPASS B-20 MultiPASS Suite 3.10使用説明書 TM MultiPASS Suite Ver.3.10 for Windows ii iii Copyright 1999 Canon Inc. ALL RIGHTS RESERVED iv v vi vii viii ix x 1 2 3 4 5 6 7 8 9 xi xii 1 1 1-1 1 2 3 1-2 4 5 1 1-3 6 1-4 1 7 8 1-5 9 10 11 1-6 1 1-7

More information

kwcR3.0 Release Note

kwcR3.0 Release Note KeySQL R4.2 R4.2 for MS-Windows 2002 6 J06414-01 Oracle Oracle Oracle Corporation Copyright 2001, Oracle Corporation All Right Reserved KeySQL R4.2 KeySQL 2 KeySQL R4.2 ... 2... 4... 5... 5... 5 KeySQL

More information

01_SWGuide_V8.50.fm

01_SWGuide_V8.50.fm ii iii iv v 2 vi vii viii ix x xi xii xiii xiv xv xvi xvii 1 CHAPTER 1-1 1-2 1-3 2 CHAPTER 2-1 2-2 2-3 2-4 1 2 2-5 3 4 2-6 5 6 2-7 7 8 2-8 9 2-9 10 11 2-10 12 13 2-11 14 15 2-12 16 17 18 2-13 1 2 2-14

More information

Oracle WebDB コンポーネント・ユーザーズ・ガイド、リリース2.2

Oracle WebDB コンポーネント・ユーザーズ・ガイド、リリース2.2 Oracle WebDB 2.2 2000 4 : J01171-01 Oracle WebDB 2.2 : J01171-01 Oracle WebDB Creating and Managing Components - Task Help, Release 2.2 A77057-01 Susan Barton, David Mathews, Carol Menzigian Haranadh Abburu,

More information

<Documents Title Here>

<Documents Title Here> Oracle Application Server 10g Release 2 (10.1.2) for Microsoft Windows Business Intelligence Standalone Oracle Application Server 10g Release 2 (10.1.2) for Microsoft Windows Business Intelligence Standalone

More information

SPP24_Program_WOC(J)-15

SPP24_Program_WOC(J)-15 9:00-9:10 9:20-10:00 Invited Lecture A1-01-I 1 10:00-10:20 A1-02 3 10:20-10:40 A1-03 5 9:20-9:40 B1-01 7 9:40-10:00 B1-02 9 10:00-10:20 B1-03 11 10:20-10:40 B1-04 13 - i - 11:00-12:00 Plenary Lecture S-01

More information

Oracle Lite Tutorial

Oracle Lite Tutorial GrapeCity -.NET with GrapeCity - InputMan Creation Date: Nov. 30, 2005 Last Update: Nov. 30, 2005 Version: 1.0 GrapeCity Microsoft Visual Studio.NET VB.NET Oracle Tips InputMan InputMan Oracle.NET Oracle

More information

パソコン機能ガイド

パソコン機能ガイド PART12 ii iii iv v 1 2 3 4 5 vi vii viii ix P A R T 1 x P A R T 2 xi P A R T 3 xii xiii P A R T 1 2 3 1 4 5 1 6 1 1 2 7 1 2 8 1 9 10 1 11 12 1 13 1 2 3 4 14 1 15 1 2 3 16 4 1 1 2 3 17 18 1 19 20 1 1

More information

パソコン機能ガイド

パソコン機能ガイド PART2 iii ii iv v 1 2 3 4 5 vi vii viii ix P A R T 1 x P A R T 2 xi P A R T 3 xii xiii P A R T 1 2 1 3 4 1 5 6 1 2 1 1 2 7 8 9 1 10 1 11 12 1 13 1 2 3 14 4 1 1 2 3 15 16 1 17 1 18 1 1 2 19 20 1 21 1 22

More information

answer.indd

answer.indd 1 1 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 supplier(supplier_no, city) supplier_article(supplier_no, article) 2 3 1.9 1.10 3 3.1 3.2 3.3 3 4 3.4 1801 16 3 1 'test' 3.5 4 4.1 4.2 4.3 SET DATEFORMAT ymd; 4.4 SELECT

More information

VB-C50i/VB-C50iR 使用説明書

VB-C50i/VB-C50iR 使用説明書 a ii iii iv a v vi vii viii d a a d ix a a d b a a a b x a a g a g a e a a xi a a a xii a a xiii xiv 1-2 1-3 d 1-4 1-5 1-6 1-7 1-8 1-9 1-10 1-11 1-12 2-2 2-3 a 2-4 a 2-5 a 2-6 2-7 2-8 2-9 2-10 2-11 2-12

More information

オラクルのバックアップとリカバリの必須要件

オラクルのバックアップとリカバリの必須要件 WHITE PAPER 1 WHITE PAPER...3...3...4 NetBackup Oracle...6...7 VERITAS NetBackup Oracle Agent...7 VERITAS NetBackup Oracle Agent...8 VERITAS NetBackup Oracle...8...9 GUI RMAN...9 VERITAS NetBackup Oracle

More information

第 1 章 条件分岐 この章では 条件に応じて処理を分岐する方法について説明します 1. CASE 式で複雑な条件分岐を実現 2. 関数を使用した条件分岐 3. MERGE 文による条件に応じた DML の実行

第 1 章 条件分岐 この章では 条件に応じて処理を分岐する方法について説明します 1. CASE 式で複雑な条件分岐を実現 2. 関数を使用した条件分岐 3. MERGE 文による条件に応じた DML の実行 はじめに コース概要と目的 SQL での作業の幅を広げるための応用的なテクニックをご説明します また 効率性の向上や正しい結果を得 るための記述方法など 実践的な記述方法についても併せてご説明します 本コースは SQL の応用的な記述テクニックとしてどのようなものがあるかを 1 日で広く浅くご理解いた だくことを目的としたコースです 細かな構文やオプションの習得は目的としておりませんことをご了承 ください

More information

0 第 4 書データベース操作 i 4.1 データベースへの接続 (1) データベースチェックポイントの追加 データベースチェックポイントを追加します (2)ODBC による接続 ODBC を使用してデータベースへ接続します SQL 文を手作業で指定する場合 最大フェッチ行数を指定する場合はここで最大行数を指定します ii 接続文字列を作成します 作成ボタンクリック > データソース選択 > データベース接続

More information

imt_817_tuning_11_1822.PDF

imt_817_tuning_11_1822.PDF intermedia Text Tuning Guide Creation Date: Mar 12, 2001 Last Update: Apr 19, 2001 Version: 1.1 4 intermedia Text 4 5 5 5 6 6 intermedia 6 6 6 7 7 7 7 8 8 8 8 R816 9 10 10 10 12 12 13 14 15 catalog index

More information

キャラクタ・セットの移行に関するベスト・プラクティス

キャラクタ・セットの移行に関するベスト・プラクティス 2003 9 ... 3 Oracle Database 10g... 3... 3... 4 Unicode... 6 Unicode... 6... 7... 8... 8... 9... 9... 10... 10... 10... 11... 11 US7ASCII... 13... 14... 14 Export/Import... 14 CSALTER... 15 Export Import

More information

第 2 章 PL/SQL の基本記述 この章では PL/SQL プログラムの基本的な記述方法について説明します 1. 宣言部 2. 実行部 3. 例外処理部

第 2 章 PL/SQL の基本記述 この章では PL/SQL プログラムの基本的な記述方法について説明します 1. 宣言部 2. 実行部 3. 例外処理部 はじめに コース概要と目的 Oracle 独自の手続き型言語である PL/SQL について説明します PL/SQL の基本構文 ストアド サブプログラム トリガーの作成方法 またストアド サブプログラムの管理について習得することを目的としています 受講対象者 これから PL/SQL を使用してアプリケーション開発をされる方 前提条件 SQL トレーニング コースを受講された方 もしくは 同等の知識をお持ちの方

More information

活用ガイド (ハードウェア編)

活用ガイド (ハードウェア編) (Windows 98) 808-877675-122-A ii iii iv NEC Corporation 1999 v vi PART 1 vii viii PART 2 PART 3 ix x xi xii P A R T 1 2 1 3 4 1 5 6 1 7 8 1 9 10 11 1 12 1 1 2 3 13 1 2 3 14 4 5 1 15 1 1 16 1 17 18 1 19

More information