Pavan DBA's Blog

The DBA Knowledge Store

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 »

TechMaster – New Oracle RAC online batch from 29th May

Posted by Pavan DBA on May 22, 2017


TechMaster announcing Oracle RAC online training by Raj

Mode: Online training
Duration: 30 classes
Frequency: 5 days a week
Timings: 8:30 – 9:30 AM IST
Batch starting date: 29th May 2017 @ 8:30 AM IST

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

After registering you will receive a confirmation email containing information about joining 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

Posted in Training | Leave a Comment »

TechMaster – New Oracle 12c DBA batch by Pavan DBA from 15th May

Posted by Pavan DBA on May 9, 2017


TechMaster announcing Oracle 12c DBA online training by Pavan DBA

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

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

After registering you will receive a confirmation email containing information about joining 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

Posted in Training | Leave a Comment »

 
%d bloggers like this: