Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
- --Version 19.9.0.0.0
- CREATE TABLE dropme_t (pkey, val)
- partition BY range(pkey) INTERVAL(1)
- (partition p0 VALUES less than(0) segment creation deferred)
- AS SELECT rownum*10000, rpad('val'||(rownum*10000),2000) FROM dual CONNECT BY level < 100
- ;
- DECLARE l_pkey INT := 10000;
- BEGIN
- INSERT /*+ MONITOR */ INTO dropme_t SELECT * FROM dropme_t WHERE pkey = l_pkey;
- END;
- /
- Binds
- ========================================================================================================================
- | Name | POSITION | TYPE | VALUE |
- ========================================================================================================================
- | :B1 | 1 | NUMBER | 10000 |
- ========================================================================================================================
- SQL Plan Monitoring Details (Plan Hash VALUE=3888867286)
- ===================================================================================================================================
- | Id | Operation | Name | ROWS | Cost | TIME | START | Execs | ROWS | Activity | Activity Detail |
- | | | | (Estim) | | Active(s) | Active | | (Actual) | (%) | (# samples) |
- ===================================================================================================================================
- | 0 | INSERT STATEMENT | | | | 1 | +0 | 1 | 0 | | |
- | 1 | LOAD TABLE CONVENTIONAL | DROPME_T | | | 1 | +0 | 1 | 0 | | |
- | 2 | PARTITION RANGE SINGLE | | 1 | 7 | 1 | +0 | 1 | 1 | | |
- | 3 | TABLE ACCESS FULL | DROPME_T | 1 | 7 | 1 | +0 | ==>1 | 1 | | |
- ===================================================================================================================================
- DECLARE l_pkey INT := 2000000; -- Out of allowed interval partitions range
- BEGIN
- INSERT /*+ MONITOR */ INTO dropme_t SELECT * FROM dropme_t WHERE pkey = l_pkey;
- END;
- /
- Binds
- ========================================================================================================================
- | Name | POSITION | TYPE | VALUE |
- ========================================================================================================================
- | :B1 | 1 | NUMBER | 10000 |
- ========================================================================================================================
- SQL Plan Monitoring Details (Plan Hash VALUE=3888867286)
- ===================================================================================================================================
- | Id | Operation | Name | ROWS | Cost | TIME | START | Execs | ROWS | Activity | Activity Detail |
- | | | | (Estim) | | Active(s) | Active | | (Actual) | (%) | (# samples) |
- ===================================================================================================================================
- | 0 | INSERT STATEMENT | | | | | | 1 | | | |
- | 1 | LOAD TABLE CONVENTIONAL | DROPME_T | | | | | 1 | | | |
- | 2 | PARTITION RANGE SINGLE | | 1 | 7 | | | 1 | | | |
- | 3 | TABLE ACCESS FULL | DROPME_T | 1 | 7 | | |==>100 | | | |
- ===================================================================================================================================
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement