Pavan DBA's Blog

The DBA Knowledge Store

12cR2 feature #2 – desupported parameters

Posted by Pavan DBA on December 9, 2016


In this post we will see what are all the parameters that are desupported since 12cR2.

GLOBAL_CONTEXT_POOL_SIZE

This parameter used to allocate memory in SGA for storing and managing global application context

MAX_ENABLED_ROLES

It specifies max no of roles that can be enabled by a user

OPTIMIZER_ADAPTIVE_FEATURES

This has been split into two new parameters.

OPTIMIZER_ADAPTIVE_PLANS=TRUE which determines alternative execution plans
OPTIMIZER_ADAPTIVE_STATISTICS=FALSE which determines alternative plan directives

PARALLEL_AUTOMATIC_TUNING

It provides default value for controlling parallel processing

PARALLEL_IO_CAP_ENABLED

It is replaced with PARALLEL_DEGREE_LIMIT to spcify default degree of parallellism

PARALLEL_SERVER

It is to start database in parallel server mode. It is replaced by CLUSTER_DATABASE

PARALLEL_SERVER_INSTANCES

It specify no of instances configured in cluster database environment and is replaced by CLUSTER_DATABASE_INSTANCES

USE_INDIRECT_DATA_BUFFERS

The parameter was used to enable the Very Large Memory feature for 32-bit platforms. These platforms are no longer supported.

Posted in 12cR2 New features | Leave a Comment »

12cR2 feature # 1 – deprecated parameters

Posted by Pavan DBA on December 8, 2016


Hey friends, as many of you already know that Oracle database 12c Release 2 documentation is officially available now in Oracle site. Thought of sharing some new features through some posts.

When software is available, I will share the practical demos on these new features.

12cR2 feature # 1 –

Following init parameters are deprecated

O7_DICTIONARY_ACCESSIBILITY

This parameter prevents any schema to access SYS schema objects.

ASM_PREFERRED_READ_FAILURE_GROUPS

In 12cR2 ASM, specifying the preferred read failure groups is done automatically. We need to use the PREFERRED_READ.ENABLED disk group attribute to control the preferred read functionality.

PARALLEL_ADAPTIVE_MULTI_USER 

This specifies the use of adaptive algorithm to improve performance in multi-user environments that use parallel execution. We need to use Database feature parallel statement queuing instead of this parameter.

UTL_FILE_DIR

Oracle recommends to use DIRECTORY feature instead of this parameter.

 

Posted in 12cR2 New features | Tagged: , , , , | Leave a Comment »

TechMaster – New SQL Server DBA online batch

Posted by Pavan DBA on December 6, 2016


Attend demo tomorrow ie 7th Dec 2016 at 6 AM IST using below link directly

Posted in Training | Leave a Comment »

TechMaster announcing Business Intelligence (Qlikview) online training

Posted by Pavan DBA on November 23, 2016


TechMaster announcing Business Intelligence (Qlikview) online training by Mahesh
 
New batch: 28th Nov 2016 at 7:30 AM IST
Mode: Online training
Duration: 20 – 25 days
Frequency: 5 days a week
Timings: 7:30 AM – 9:30 AM IST
Fee: 15000 INR
 
Demo date : 26th Nov 2016 at 7:30 AM IST
Please register for demo using below link
 
After registering you will receive a confirmation email containing information about joining the demo.
 
For more details:-
Email to: admin@thetechmaster.in
Call or Whatsapp to: +91 9676516545
bi-advt-mahesh-nov2016

Posted in Training | Leave a Comment »

TechMaster – New batch for Oracle 12c DBA training

Posted by Pavan DBA on November 10, 2016


DBA classes starting from Monday ie 14th Nov.

Duration: 35 days
Frequency: 5 days a week (excluding weekend)

Contact admin@thetechmaster.in or call/whatsapp to +919676516545 for demo video and registration process.

oracle-dba-advt2-pavandba-nov2016

Posted in Training | Leave a Comment »

 
%d bloggers like this: