-
SQL> alter session enable parallel dml;
Session altered.
SQL> explain plan for update /*+ PARALLEL(testme,4)*/
2 testme set a=a+1 ;
Explained.
SQL> @?/rdbms/admin/utlxpls
Plan Table
--------------------------------------------------------------------------------
| Operation | Name | Rows | Bytes| Cost | Pstart| Pstop |
--------------------------------------------------------------------------------
| UPDATE STATEMENT | | 82 | 1K| 1 | | |
| UPDATE |TESTME | | | | | |
| TABLE ACCESS FULL |TESTME | 82 | 1K| 1 | | |
--------------------------------------------------------------------------------
6 rows selected.
SQL> drop table testme;
Table dropped.
SQL> create table testme( a int,b int)
2 partition by range (a)
3 (partition d1 values less than(10),
4 partition d2 values less than(20),
5 partition d3 values less than (30),
6 partition d4 values less than(maxvalue));
Table created.
SQL> explain plan for update /*+ PARALLEL(testme,4)*/
2 testme set a=a+1 ;
Explained.
SQL> @?/rdbms/admin/utlxpls
Plan Table
--------------------------------------------------------------------------------
| Operation | Name | Rows | Bytes| Cost | Pstart| Pstop |
--------------------------------------------------------------------------------
| UPDATE STATEMENT | | 328 | 4K| 1 | | |
| UPDATE |TESTME | | | | | |
| PARTITION RANGE ALL | | | | | 1 | 4 |
| TABLE ACCESS FULL |TESTME | 328 | 4K| 1 | 1 | 4 |
--------------------------------------------------------------------------------
7 rows selected.
seems like it didn't use parallel plan , why?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|