Pavan DBA's Blog

The DBA Knowledge Store

TechMaster – Oracle 12c DBA training

Posted by Pavan DBA on April 5, 2017


TechMaster announcing Oracle 12c DBA online training by Suresh
Mode: Online training

Duration: 45 classes (including 5 classes of Linux basics)

Frequency: 5 days a week

Timings: 7:30 – 9 AM IST

Batch starting date: 12th Apr 2017 @ 7:30 AM IST
Demo date: 8th Apr 2017

Demo time: 7:30 AM IST

Please attend demo using below link

https://global.gotomeeting.com/join/110725869
For more details, contact:-

Email to: admin@thetechmaster.in

Call or WhatsApp to: +919676516545

Posted in General | Leave a Comment »

TechMaster – Exadata online training

Posted by Pavan DBA on April 4, 2017


TechMaster announcing Oracle Exadata online training by Ravi

Course content is here – Oracle Exadata Course Content

Mode: Online training
Duration: 25 days
Frequency: 5 days a week
Timings: 6 – 7 AM IST
Batch starting date: 10th Apr 2017 @ 6 AM IST

Demo date: 8th & 9th Apr 2017
Demo Time: 6 AM IST
Please attend demo using below link
https://global.gotomeeting.com/join/718772773

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

Posted in Training | Leave a Comment »

Grant command hanging for long time

Posted by Pavan DBA on April 2, 2017


Recently I have faced one issue regarding granting some privileges to the user.

I got a request to grant select on a table to a user. when I issued grant command, it just got hung.
Even though select doesn’t hold exclusive lock on a table, I verified in v$locked_object to check if any more information can be collected.

select object_id,session_id,oracle_username from v$locked_object;

OBJECT_ID SESSION_ID ORACLE_USERNAME
———- ———- —————
26187 18 SCOTT

select object_name,owner,object_id,object_type,status from dba_objects where object_id=26187;

OBJECT_NAME OWNER OBJECT_ID OBJECT_TYPE STATUS
———– —– ——— ———– ——
OBJ$ SYS 26187 TABLE VALID

From the above, it is evident that SCOTT user is holding a lock on SYS.OBJ$ table which actually caused the issue.

After confirmation from application team, I have killed the session with id 18. After that grant command got successful.

Hope this helps…

Posted in Admin | Tagged: , , , , | 2 Comments »

TechMaster – New batch for Oracle RAC online training by Raj

Posted by Pavan DBA on March 23, 2017


TechMaster announcing Oracle RAC online training by Raj.

Course content – Oracle RAC Course Content

Mode: Online training
Batch starting date: 27th Mar 2017
Duration: 30 days
Frequency: 5 days a week
Timings: 7:30 AM – 8:30 AM IST

Demo date: 24th and 25th Mar 2017 at 7:30 AM IST

Please attend the DEMO using below link:
https://global.gotomeeting.com/join/857475021

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

Posted in Training | Leave a Comment »

TechMaster – BigData & Hadoop development online training by Ramesh

Posted by Pavan DBA on March 14, 2017


TechMaster announcing BigData & Hadoop development online training by Ramesh

Course content is here – Hadoop Development Course Content

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

Demo date: 18th March 2017 @ 7:15 AM IST

Please attend demo using below link
https://global.gotomeeting.com/join/692635597

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

Posted in Training | Leave a Comment »

 
%d bloggers like this: