Oracle DBA Scripts

I will explain Find Oracle Locked Objects | Remove Table Lock in Oracle in this post.

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.

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.

I will explain What is the SRVCTL and Useful SRVCTL Commands in Oracle RAC in this post.

Hi, I will explain what are the Oracle DBA Daily/Weekly/Monthly or Quarterly Routine Checklist and Tasks in this article.

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;