Oracle Database Tutorials for Beginners

Hi, I will share with you Step by Step Oracle Database Tutorials for beginners.

Read more

Oracle DBA Scripts All in One – Useful Database Administration Scripts

    Hi, I will share all Oracle DBA Scripts in this post to access them easily.

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

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

Read more

Oracle Kill Session Scripts -4

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

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

Read more