Oracle DBA Scripts

I will explain Find Oracle Locked Objects | Remove Table Lock in Oracle in this post.  640 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.  415 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 …

Hi, Sometimes application developers or client offers you to kill any session or sessions group like SQL Net Client, or JDBC Client sessions or RMAN sessions.  1,498 views last month

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

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

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

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;    489 views last month