Oracle 12c List Components Installed

Hi, You should know that which components are installed in your Oracle database as Oracle DBA.

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 Archivelog Delete

Hi, Oracle database is archiving redo log group files if database is in archivelog mode.  

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

Oracle Find queries not using bind variables Object Detail

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

Read more

Oracle Find queries not using bind variables

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

Read more

Oracle Historical SQL Search

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

Read more

Oracle Average Active Session Load

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

Read more

Oracle Kill Session Scripts -3

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

Read more