Oracle DBA Scripts

Hi, Dataguard should be monitored everytime by Oracle DBA.  

Hi, You should stop and start your dataguard sometimes in case of need.  

I will explain Delete Archivelog until time in Oracle Database in this post.  

Hi, The character set is most critical parameter for the database setup because it is one of the unchanging properties after installation.

Hi, Using bind variable in the queries is very crucial for performance tuning.

Hi, Using bind variable in the queries is very crucial for performance tuning.

Hi, Sometimes customer ask you that why spesific sql is running long time or consuming lots of resource.

Hi, Oracle Database Admin should know what is the database load profile and Active Session load to compare it when the complaint comes from Customer.

Hi, Sometimes application developers or client offers you to kill any session or sessions group like SQL Net Client, or JDBC Client sessions, RMAN sessions or All sessions.

Hi, If you get slowness complaint from customer,  you need to monitor database which sql is consuming a lots of resource.