Lin Hong's TECH Blog! 刀不磨要生锈,人不学习要落后 - Thinking ahead

Oracle session reset parameter Tips

2021-10-20

Oracle session reset parameter Tips

session reset parameter ORA-00922/ORA-03001

11g:

SYS@orcl> alter session reset "_small_table_threshold";
alter session reset "_small_table_threshold"
              *
ERROR at line 1:
ORA-00922: missing or invalid option

SYS@orcl> 

12c/19c:

HONG@pdb1> alter session reset "_small_table_threshold";
ERROR:
ORA-03001: unimplemented feature

HONG@pdb1> 

12.2 database, alter session reset failed with ORA-03001. (alter system reset didn’t run into this problem).

Fix:

Run alter session set to revert init parameter value back

Reference

12.2 Alter Session Reset Failed With ORA-03001: unimplemented feature (Doc ID 2548082.1)	

Have a good work&life! 2021/10 via LinHong


Similar Posts

Comments