Pavan DBA's Blog

The DBA Knowledge Store

TechMaster – New SQL Server DBA batch from 20th July

Posted by Pavan DBA on July 13, 2017


TechMaster announcing SQL Server DBA online training by Venkat

Mode: Online training
Duration: 45 classes
Frequency: 5 days a week
Timings: 7 – 8 AM IST
Batch starting date: 20th July 2017 @ 7 AM IST

Demo date: 19th July 2017
Demo time: 7 AM IST
Please enroll for the demo using our website(below) link –> click on “Enroll Now” button and provide details
http://www.thetechmaster.in/batches

After enrolling you will receive a confirmation email with link to join the demo.
You can also attend first two classes for free using same link which you get in mail.

For more details, contact:-
Email to: admin@thetechmaster.in
Call or WhatsApp to: +919676516545
http://www.thetechmaster.in

Posted in Training | Leave a Comment »

TechMaster – New Goldengate (weekday) batch from 5th July

Posted by Pavan DBA on June 27, 2017


TechMaster announcing Oracle GoldenGate online training by Ashish

Mode: Online training
Duration: 20 days
Frequency: 5 days a week
Timings: 7:30 -8:30 AM IST
Batch starting date: 5th July 2017 @ 7:30 AM IST

Demo date: 1st July 2017
Demo Time: 7:30 AM IST
Please enroll for the demo using our website(below) link –> click on “Enroll Now” button and provide details
http://www.thetechmaster.in/batches

After enrolling you will receive a confirmation email with link to join the demo.

For more details, contact:-
Email to: admin@thetechmaster.in
Call or WhatsApp to: +91 9676516545
http://www.thetechmaster.in

Posted in Training | 2 Comments »

TechMaster – New Oracle 12c DBA batch from 27th June

Posted by Pavan DBA on June 20, 2017


TechMaster announcing Oracle 12c DBA online training by Suresh

Mode: Online training
Duration: 45 classes (including Linux basics)
Frequency: 5 days a week
Timings: 7:30 – 9 AM IST
Batch starting date: 27th June 2017 @ 7:30 AM IST

Demo date: 24th June 2017
Demo time: 7:30 AM IST
Please enroll for the demo using our website(below) link –> click on “Enroll Now” button and provide details
http://www.thetechmaster.in/batches#

After enrolling you will receive a confirmation email with link to join the demo.
You can also attend first two classes for free using same link which you get in mail.

For more details, contact:-
Email to: admin@thetechmaster.in
Call or WhatsApp to: +919676516545
http://www.thetechmaster.in

Posted in Training | Leave a Comment »

ORA-20000 Error during concurrent statistics

Posted by Pavan DBA on June 4, 2017


Recently I have faced an issue when application team is executing gather stats in their job.

An application job is loading the data into tables and after that it is performing gather stats. They received below error during gather stats

ERROR at line 1:
ORA-20000: Unable to gather statistics concurrently: insufficient privileges
ORA-06512: at “SYS.DBMS_STATS”, line 34634
ORA-06512: at line 1

There are two steps to resolve this issue.

Step 1: Disabling Global preferences

check for the stats global preference value using below query

SELECT DBMS_STATS.get_prefs(‘CONCURRENT’) FROM dual;

DBMS_STATS.GET_PREFS(‘CONCURRENT’)
—————————————————————————————————-
OFF

By output, we can understand that it is OFF and we can turn it on

BEGIN
DBMS_STATS.set_global_prefs (
pname => ‘CONCURRENT’,
pvalue => ‘ALL’);
END;
/

Instead of ALL (which works for both manual and automatic stats collection), we can also set below values
MANUAL – only for manual stats collection
AUTOMATIC – only for automatic stats collection

Step 2: Granting roles to the user

If you see that Global preferences value is already set to ALL, you need to grant below mentioned roles to the user which is performing gather stats.
These grants are not default, so users will face issues if they use concurrent statistics.

SQL> GRANT CREATE JOB, MANAGE SCHEDULER, MANAGE ANY QUEUE TO testuser;

Once both of above steps are done, issue is resolved in my case.

Posted in Perf Tuning | Tagged: , , | Leave a Comment »

TechMaster – New Oracle 12c DBA fast-track batch from 30th May

Posted by Pavan DBA on May 22, 2017


TechMaster announcing Oracle 12c DBA fasttrack online training by Kumar

Mode: Online training
Duration: 15-20 classes
Frequency: 4 days a week
Timings: 7 – 9 AM IST
Batch starting date: 30th May 2017 @ 7 AM IST

Demo date: 27th May 2017
Demo time: 7 AM IST
Please register for the demo using below link
https://attendee.gototraining.com/r/1950990307829467137

After registering you will receive a confirmation email containing information about joining the demo. You can also attend first two classes for free with same link.

For more details, contact:-
Email to: admin@thetechmaster.in
Call or WhatsApp to: +919676516545

Posted in Training | Leave a Comment »

 
%d bloggers like this: