Pavan DBA's Blog

The DBA Knowledge Store

TechMaster – New Oracle RAC batch by Raj

Posted by Pavan DBA on January 12, 2017


TechMaster announcing Oracle RAC online training by Raj.

Course content: oracle-rac-course-content

Mode: Online training
Batch starting date: 16th Jan 2017
Duration: 20-25 days
Frequency: 5 days a week
Timings: 6 – 7:30 PM IST

Demo date: 14th Jan 2017 at 6 PM IST

Please register for the DEMO using below link:
https://attendee.gototraining.com/r/4663271085899331585

For more details:-
Email to: admin@thetechmaster.in
Call or Whatsapp to: +91 9676516545

rac-advt-raj-jan2017

Posted in Training | Leave a Comment »

TechMaster – SQL Server DBA Online training by Venkat

Posted by Pavan DBA on January 2, 2017


TechMaster announcing SQL Server DBA online training by Venkat
 
Mode: Online training
New batch: 9th Jan 2017
Duration: 40-45 days
Frequency: 5 days a week
Timings: 7:30 – 9 AM IST
 
1st Demo date & time: 6th Jan 2017 at 7:30 AM IST
2nd Demo date & time: 7th Jan 2017 at 7:30 AM IST
 
Please register for both the 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
sql-server-dba-advt-venkat-jan2017

Posted in Training | Leave a Comment »

12cR2 feature # 5 – HISTORY in sqlplus prompt

Posted by Pavan DBA on December 17, 2016


12cR2 has introduced new option HISTORY in sqlplus to view or edit or delete the sql, pl/sql commands we have executed in SQL prompt. This works just like “history” command in Unix prompt.

SQL> set history on –> enables the history

SQL> set history off –> disables the history

SQL> show history –> to check if history is ON or OFF

example:

SQL> set history ON

SQL> select count(*) from emp;

SQL> desc dept

SQL> select name from v$database;

SQL> history
1 select count(*) from emp;
2 desc dept
*  3 select name from v$database; (* represents last used command)

Posted in 12cR2 New features | 2 Comments »

12cR2 feature # 4 – table & column name length

Posted by Pavan DBA on December 14, 2016


From 12cR2, table and column name length can be upto 128 characters instead of previous limitation to 30 characters.

But it is having following limitations still

Database name still will be 8 character long
tablespace name, pluggable database name, disk group name is 30 characters

 

Posted in 12cR2 New features | Leave a Comment »

12cR2 feature # 3 – parameters default value change

Posted by Pavan DBA on December 12, 2016


Some parameters default value has been changed in 12cR2 as follows

OPTIMIZER_ADAPTIVE_PLANS controls adaptive plans. It is now set by default to FALSE. Adaptive plans is the alternative execution plans which will be decided during query executions.

OPTIMIZER_ADAPTIVE_STATISTICS controls adaptive statistics. It is set by default to FALSE.

SQL92_SECURITY Default is TRUE

If a user want to perform DELETE or UPDATE on an object, it should have SELECT privilege as mandatory from now onwards.

Posted in 12cR2 New features | Leave a Comment »

 
%d bloggers like this: