IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi, I will share all Oracle DBA Scripts related Dataguard in this post.
Read More »Dataguard ( Standby ) Monitoring Lag Command and Scripts | Oracle DBA Scripts All in One -2
Tag Archives: useful oracle scripts
Useful Oracle RAC (Cluster Command) Scripts | Oracle DBA Scripts All in One -1
Hi, I will share all Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.. ) in this tutorial series.
Read More »How to Find Active And Inactive User Sessions in Oracle
Hi, You should list all User sessions ( Active and inactive ) in the Oracle database in case of Performance problem.
Read More »How to Monitor RMAN Backup and Long Operations in Oracle
Hi, If you have big database about more than 1 TB, then your backup and export operations are taking long times.
Read More »Oracle Kill Session Scripts -4 and gv$lock view
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.
Read More »How to Delete Archivelog in Oracle Dataguard Automatically
Hi, Archivelogs in Oracle database are accumulated or kept when they are not deleted automatically.
Read More »Oracle Dataguard Monitoring Scripts -4
Hi, Dataguard should be monitored everytime by Oracle DBA.
Read More »Oracle Dataguard Stop Start
Hi, You should stop and start your dataguard sometimes in case of need.
Read More »Oracle Database Name Change Using NID
Hi, Database name is very important parameter in Oracle especially for backup operations.
Read More »How to find Character set of the Oracle Database
Hi, The character set is most critical parameter for the database setup because it is one of the unchanging properties after installation.
Read More »