Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- QUESTION
- ========
- Does dbms_stats.gather_table_stats issue commit?
- SESSION 1
- =========
- SQL> create table t ( n number );
- Table created.
- SQL> insert into t ( n ) values ( 0 );
- 1 row created.
- SESSION 2
- =========
- SQL> select n from t;
- no rows selected
- SESSION 1
- =========
- SQL> exec dbms_stats.gather_table_stats( null, 'T' )
- PL/SQL procedure successfully completed.
- SESSION 2
- =========
- SQL> select n from t;
- N
- ----------
- 0
- ANSWER:
- =======
- Yes, it does.
- Observed on 11.1 and 12.1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement