How to find Obsolete Oracle12c parameters

Solution:

SELECT name FROM v$parameter WHERE isdeprecated =’TRUE’ ORDER BY name;

Recent Posts

The source database on Windows is PROD1 and the target database is a 11g RAC database RACDB1. 1) Create the tablespace and the test...

1. Create the environment SQL> connect / as sysdba Connected. SQL> drop user ebernal cascade; User dropped. SQL> purge dba_recyclebin;...

Note for 11g and newer installations: This procedure only works if ADR has been disabled in the listener.ora (addition of...