橡ExCtrlPDF.PDF

Size: px

Start display at page:

Download "橡ExCtrlPDF.PDF"

よりおこいまる
9 years ago
Views:

1 THE Database FOR Network Computing

2 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 for Solaris Oracle8 Oracle7 Oracle,Oracle7,Oracle8

3 EXPIRE_TIME

4 1. Oracle COMMIT ROLLBACK COMMIT ROLLBACK ( ) 1Oracle 1.1. COMMIT ROLLBACK COMMIT 7499 emp ROLLBACK 7521 emp 1

5 Oracle COMMIT ROLLBACK DDL CREATEDROPRENAMEALTER DDL COMMIT DDL Oracle CREATE DROPALTER DDL ROLLBACK 1.2. Oracle COMMIT ROLLBACK SAVEPOINT SAVEPOINT ( ) p1 ROLLBACK ROLLBACK; UPDATE SAVEPOINT A ROLLBACK TO A; UPDATE SAVEPOINT B ROLLBACK TO B; DELETE 2 2

6 3 ROLLBACK DELETE UPDATE

7 2. Oracle (ISAM) Oracle Oracle COMMIT 4

8 COMMIT COMMIT COMMIT ROLLBACK UPDATE INSERT ( ) SQL COMMIT 5

9 2.2. Oracle : : ( 2) 100 Oracle ] ( 2) Oracle 6

10 2.3. PM5:00 PM5:00 SERIALIZABLE Oracle7 R7.3 SET TRANSACTION SET TRANSACTION READ ONLY READ WRITE READ ONLY SET TRANSACTION SET TRANSACTION COMMIT ROLLBACK ORA SET TRANSACTION SET TRANSACTION SET TRANSACTION COMMIT 7

11 INSERT UPDATEDELETESELECT FOR UPDATE DML B 8000 CLERK 4. B 5.COMMIT 6. 8

12 SET TRANSACTION ISOLATION LEVEL SERIALIZABLE SQL92 SERIALIZABLE SERIALIZABLE COMPATIBLE READ COMMITED SET TRANSACTION DML Oracle INITRANS 3 ALTER SESSION SET ISOLATION_LEVEL=SERIALIZABLE 9

13 1 1. SERIALIZABLE SERIALIZABLE ORA DELETE 6. 7.ORA

14 3. Oracle Oracle Oracle 3.1. Oracle INSERT/UPDATE/DELETE DML INSERT/UPDATE/DELETE SQL SQL 11

15 SQL SQL 3.2. Oracle LOCK TABLE SELECT FOR UPDATE 12

16 LOCK TABLE tablename viewname mode Oracle 22-1 EXCLUSIVE MODE SHARE MODE LOCK TABLE IN NOWAIT SHARE MODESELECT FOR UPDATE ORA NOWAIT 1 LOCK ANY TABLE LOCK TABLE SQL 1)emp emp 2)emp emp LOCK TABLE IN SHARE MODESELECT FOR UPDATE 3)emp 4)emp dept 13

17 DML SQL ORA LOCK TABLE IN SHARE MODESELECT FOR UPDATE LOCK TABLE IN SHARE MODE SELECT FOR UPDATE SELECT FOR UPDATE UPDATE DELETE SELECT FOR UPDATE UPDATE DELETE OLTP SELECT FOR UPDATE FOR UPDATE OF OF FROM OF NOWAIT ORA NOWAIT SELECT FOR UPDATE NOWAIT NOWAIT 14

18 FOR UPDATE DISTINCT GROUP BY CURSOR 1) ) ) 7900 (emp ) (dept 4) 7900 (emp ) OF OF ORA emp.ename e.ename ename 15

19 FOR UPDATE FOR UPDATE FOR UPDATE NOWAIT SELECT FOR UPDATE SELECT... FOR UPDATE(NOWAIT ) COMMIT 5. 16

20 SELECT... FOR UPDATE(NOWAIT ) : 1: ORA-00054: NOWAIT NOWAIT ORA NOWAIT NOWAIT FOR UPDATE FOR UPDATE NOWAIT 3.3. Oracle ( ) 4 EMP DEPT SCOTT DEPT EMP DEPTNO DEPT EMP 1 N ( )DEPT ( )EMP DELETE CASCADE DELETE 17

21 DELETE UPDATE INSERT DELETE UPDATE INSERT/UPDATE/DELETE DELETE SQL DEPT DEPTNO=10 EMP DEPTNO=10 (EMP) SYSTEM SQL*Plus SQL DEPT EMP EMP LMODE LMODE 2 (RS,SS) 3 (RX,SX) 4 (S) 5 (SRX,SSX) 6 (X) 1 18

22 UPDATE (DEPTNO ) SCOTT SQL ROLLBACK deptno=40 UPDATE SYSTEM EMP DELETE EMP ( ) DELETE CASCADE EMP DEPTNO SQL DELETE SCOTT SQL 19

23 SYSTEM EMP UPDATE SCOTT SQL SYSTEM (EMP) 3.4. A A B C D B 5 20

24 ABCD DCBA A B C C C Oracle SQL Oracle SQL SQL SQL SQL 21

25 SQL ROLLBACK COMMIT SQL SQL INIT.ORA SELECT FOR UPDATE NOWAIT 3.5. Oracle Oracle Oracle Enterprise Manager Instance Manager ALTER SYSTEM KILL SESSION Net8/SQL*Net expire_time

26 ALTER SYSTEM KILL SESSION SID 10SERIAL 344 SQL ALTER SYSTEM ALTER SYSTEM SID SERIAL V$SESSION SYSTEM V$SESSION USERNAME OSUSER PROGRAM Oracle STATUS STATUS KILLED Instance Manager Oracle Enterprise Manager Instance Manager 1.Instance Manager Oracle Enterprise Manager Instance Manager 2. [ ] 23

27 3. [ ][ ] EXPIRE_TIME EXPIRE_TIME TCP/IP keepalive SQL*Net V2.1(Oracle7 R7.1) Windows NT Oracle7 V2.1 sqlnet.ora n [] ( 10)Windows NT n 16 keepalive TCP/IP SYSTEM foo SCOTT 24

28 Oracle 6 1, , ,000 5,000 1,000 7,000 2,000 (Optimistic Lock) (Pessimistic Lock) 25

29 4.1. (Pessimistic Lock) 10 1,000 5, ,000 6, (Optimistic Lock) 10 1, ,000 5,000 6,000 1,000 26

30 5. Oracle Oracle 5.1. Oracle 7369 SMITH : 1: ORA-00054: NOWAIT NOWAIT NOWAIT 3. 4.A NOWAIT 27

31 5.2. Oracle SELECT 2 28

32 FOR UPDATE ( 2 ) NOWAIT NOWAIT NOWAIT 29

33 6. ( ) 6.1. ( ) SELECT / TYPE1 TYPE2 / / TYPE3 3 ( ) TYPE1 SELECT TYPE

34 TYPE3: / ( ) ( ) / TYPE4 / SELECT TYPE5 / TYPE6 TYPE7 4 ( ) TYPE4TYPE2 TYPE5TYPE3 TYPE6 TYPE

35 Design & Migration Services Copyright ORACLE CORPORATION JAPAN

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

ハイウォーターマークを知る 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.

橡ExCtrlPDF.PDF

橡ExCtrlPDF.PDF