• Database Blog
  • GoldenGate 12c
    • Top 50 Oracle Goldengate Interview Questions To Get the Job!
  • Master Oracle 12c DBA
  • Oracle Tutorials
    • Oracle Tips & Tricks
    • Oracle VirtualBox
  • Learn Excel

VitalSoftTech

Database Administration | Oracle | Oracle Training | DBA Support | Oracle 12c DBA | GoldenGate | GoldenGate 12c | DBA Interview Questions | Goldengate Interview Questions | Natik Ameen

  • Digital Marketing
  • Blogging Tutorial and Tips
  • Cool Names
  •   Login
« Previous Post
Next Post »

Oracle 12c Deprecated Database Parameters

August 26, 2015 by Natik Ameen   /  DBtips, Oracle 12c, Oracle 12c Database, Oracle 12c Installs, Oracle-Blog

When upgrading to Oracle 12c it’s good to be familiar with the deprecated parameters.

These are not really desupported, just that they will be de-supported in future versions of the Database.

SELECT name, description from v$parameter
WHERE isdeprecated = 'TRUE';

NAME DESCRIPTION
lock_name_space lock name space used for generating lock names for standby/clone database
instance_groups list of instance group names
resource_manager_cpu_allocation Resource Manager CPU allocation
active_instance_count number of active instances in the cluster database
buffer_pool_keep Number of database blocks/latches in keep buffer pool
buffer_pool_recycle Number of database blocks/latches in recycle buffer pool
log_archive_start start archival process on SGA initialization
standby_archive_dest standby database archivelog destination text string
log_archive_local_first Establish EXPEDITE attribute default value
parallel_server if TRUE startup in parallel server mode
parallel_server_instances number of instances to use for sizing OPS SGA structures
fast_start_io_target Upper bound on recovery reads
serial_reuse reuse the frame segments
max_enabled_roles max number of roles a user can have enabled
remote_os_authent allow non-secure remote clients to use auto-logon accounts
sec_case_sensitive_logon case sensitive password enabled for logon
global_context_pool_size Global Application Context Pool Size in Bytes
cursor_space_for_time use more memory in order to get faster execution
plsql_v2_compatibility PL/SQL version 2.x compatibility flag
plsql_debug PL/SQL debug
background_dump_dest Detached process dump directory
user_dump_dest User process dump directory
commit_write transaction commit log write behaviour
sql_trace enable SQL trace
parallel_automatic_tuning enable intelligent defaults for parallel execution parameters
parallel_io_cap_enabled enable capping DOP by IO bandwidth

Oracle Document
• Database Upgrade Guide

Realted Links
• Oracle 12c RAC: New Features
• Oracle 12c Database: Upgrading to Oracle Database 12c
• Oracle 12c Multithreaded Database Configuration

Filed Under: DBtips, Oracle 12c, Oracle 12c Database, Oracle 12c Installs, Oracle-Blog Tagged With: 12c Database, Oracle 12c

Leave a Reply Cancel reply

Your email address will not be published.

« Previous Post
Next Post »

Join over 3,000 others My posts. Your Inbox. Beautiful.

Database    GoldenGate

Natik Ameen

About Natik Ameen

Natik Ameen is an Oracle Production DBA, Oracle Certified RAC Expert and a DBA track Certification trainer for over 17 years. He is an Oracle Evangelist and has presented at IOUG & UTOUG conferences. He writes on topics such as Database Administration, RAC, GoldenGate and the Cloud.

Who is Natik Ameen?

Guides

  • My GoldenGate Tutorials
  • Oracle 12c Database Tutorials
  • GoldenGate GGSCI Command Series
  • My OraTips and Tricks

Popular Blogs

  • My GoldenGate Home Page
  • Top 50 Oracle Goldengate Interview Questions To Get the Job!
  • Top 30 RAC Interview Questions That Helped Me. Are You Prepared?
  • Oracle GoldenGate Concepts and Architecture Made Simple!
  • Virtualize Oracle RAC 12c on My Laptop
  • Step by Step Oracle 12c Database Install on Virtual Box

Popular Oracle Articles

Oracle Announces Beta Availability of Oracle Database 12c Release 2
Top 5 Announcements at Oracle Open World
News on Oracle Database STANDARD EDITION 12.1.0.2

Technology Centers

Oracle Business Intelligence and DW
Cloud Computing, SOA, Virtualization
Big data, Java, Linux, PLSQL, Security
Enterprise Architecture, Digital Experience

Oracle Documentation

10g R1, 10g R2, 11g R1, 11g R2, 12c R1
Oracle CPU's, EM 11g, EM 12c
GoldenGate 12c, Oracle VM, VirtualBox

Copyright ©2019

BLOGOracle Tutorials