Oracle DBA Scripts

I will explain Find Oracle Locked Objects | Remove Table Lock in Oracle in this post.  1,447 views last month

I will share Find Oracle blocking sessions and Kill Locked Session Scripts & Locked Objects scripts and other Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.. ) …

I will explain Oracle Long Running Queries in this post.  1,311 views last month

Author     : Cihan Gedik Email        : [email protected] Linkedin  : https://www.linkedin.com/in/cihan-gedik-13b55065/ Group      : https://www.linkedin.com/groups/13792740/   PLUGGABLE DATABASE HOT CLONE REFRESH MANUAL Compatible Versions Oracle Database 12.1.x and Later …

I will explain Alter System Kill Session Tips in Oracle in this post. Sometimes application developers or client offers you to kill any session or sessions group like SQL Net …

Hi, I will share with you Session Killer Procedure for Developers in Oracle Database in this post.  1,524 views last month

I will explain What is the SRVCTL and Useful SRVCTL Commands in Oracle RAC in this post.  3,830 views last month

Hi, I will explain what are the Oracle DBA Daily/Weekly/Monthly or Quarterly Routine Checklist and Tasks in this article.  4,167 views last month,  1 views today

You can grant users various privileges to tables. These privileges can be any combination of SELECT, INSERT, UPDATE, DELETE, REFERENCES, ALTER, INDEX, or ALL.   GRANT SELECT ANY CUBE TO …

The privileges to revoke.   REVOKE EXECUTE ANY PROCEDURE FROM BARANYILDIZ; REVOKE create ANY table  FROM BARANYILDIZ; REVOKE SYSDBA FROM BARANYILDIZ;    956 views last month