Oracle DBA Scripts

I will explain Find Oracle Locked Objects | Remove Table Lock in Oracle in this post.  922 views last month,  5 views today

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.  722 views last month,  7 views today

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,106 views last month,  3 views today

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

Hi, I will explain what are the Oracle DBA Daily/Weekly/Monthly or Quarterly Routine Checklist and Tasks in this article.  3,430 views last month,  5 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;    645 views last month,  5 views today