"Parallel 설정"의 두 판 사이의 차이
DB CAFE
(새 문서: You disable parallel SQL execution with an ALTER SESSION DISABLE PARALLEL DML|DDL|QUERY statement. All subsequent DML (INSERT, UPDATE, DELETE), DDL (CREATE, ALTER), or query (SELECT...) |
|||
| 1번째 줄: | 1번째 줄: | ||
You disable parallel SQL execution with an | You disable parallel SQL execution with an | ||
| − | ALTER SESSION DISABLE PARALLEL DML|DDL|QUERY statement. All subsequent DML (INSERT, UPDATE, DELETE), DDL (CREATE, ALTER), or query (SELECT) operations are executed serially after such a statement is issued. They will be executed serially regardless of any PARALLEL clause associated with the statement or parallel attribute associated with the table or indexes involved. | + | ALTER SESSION DISABLE PARALLEL DML|DDL|QUERY statement. All subsequent DML (INSERT, UPDATE, DELETE), DDL (CREATE, ALTER), or query (SELECT) operations are executed serially after such a statement is issued. |
| + | They will be executed serially regardless of any PARALLEL clause associated with the statement or parallel attribute associated with the table or indexes involved. | ||
The following statement disables parallel DDL operations: | The following statement disables parallel DDL operations: | ||
ALTER SESSION DISABLE PARALLEL DDL; | ALTER SESSION DISABLE PARALLEL DDL; | ||
2018년 10월 27일 (토) 19:44 판
thumb_up 추천메뉴 바로가기
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
You disable parallel SQL execution with an
ALTER SESSION DISABLE PARALLEL DML|DDL|QUERY statement. All subsequent DML (INSERT, UPDATE, DELETE), DDL (CREATE, ALTER), or query (SELECT) operations are executed serially after such a statement is issued.
They will be executed serially regardless of any PARALLEL clause associated with the statement or parallel attribute associated with the table or indexes involved.
The following statement disables parallel DDL operations:
ALTER SESSION DISABLE PARALLEL DDL;