|
|
| Check Deprecated Initialization Parameters in 11g/10g |
| Monday, June 16, 2008 |
Run the following command on your SQL Prompt,
it will give you the list of Deprecated Initialization
Parameters. This is in 11g.
SQL> SELECT name FROM v$parameter WHERE isdeprecated ='TRUE';
1. BACKGROUND_DUMP_DEST (replaced by DIAGNOSTIC_DEST)
2. OMMIT_WRITE
3. CORE_DUMP_DEST (replaced by DIAGNOSTIC_DEST)
4. INSTANCE_GROUPS
5. LOG_ARCHIVE_LOCAL_FIRST
6. PLSQL_DEBUG (replaced by PLSQL_OPTIMIZE_LEVEL)
7. PLSQL_V2_COMPATIBILITY
8. REMOTE_OS_AUTHENT
9. STANDBY_ARCHIVE_DEST
10. TRANSACTION_LAG (attribute of the CQ_NOTIFICATION$_REG_INFO object)
11. USER_DUMP_DEST (replaced by DIAGNOSTIC_DEST)
In 10g,
SQL> SELECT name FROM v$parameter WHERE isdeprecated ='TRUE';
NAME
---------------------------------------------------------------------
lock_name_space
buffer_pool_keep
buffer_pool_recycle
log_archive_start
parallel_server
parallel_server_instances
fast_start_io_target
max_enabled_roles
global_context_pool_size
serial_reuse
plsql_compiler_flags
NAME
----------------------------------------------------------------
parallel_automatic_tuning
drs_start
13 rows selected. |
posted by Senthil Kumaran @ 4:28 AM   |
|
|
|
|
| About Me |
|
Name: Senthil Kumaran
Home: Oslo, Oslo, Norway
About Me: I'm working as a oracle applications dba(Apps DBA OCP) and fusion middleware.This views are my own only and not neccessary to match with others
See my complete profile
|
| Previous Post |
|
| Archives |
|
| Links |
|
|
| Powered by |
 |
| Add On |
|
|
|
|
|
|
|
|
