Posts by DBsGuru

How to Validate Applied Patch in Oracle 12c 0 (0)

Validate Applied Patches in Oracle 12c Whenever we do patch apply before/after, need to validate all applied patches in Oracle home & databases. Below is the command to validate patches…

How to Check when Database was Last Cloned or Open Resetlog Mode in Oracle 4 (1)

How to Check when Database was Last Cloned or open Resetlog Mode in Oracle. If we want to find when was my database cloned last time or when you open…

Step by Step Installation of Oracle Client 5 (1)

Step by Step installation of Oracle Client As most of us already know oracle client is installed on the application server to execute SQL command or compile script related to…

How to Validate Invalid Objects in Oracle 5 (2)

How to Validate Invalid Objects in Oracle Whenever we perform such activities like database upgrade, refresh, clone, migration etc. We require to capture invalid objects before /after activities. Below are…

How to Check Temp Tablespace Usage in Oracle 0 (0)

How to Check Temp Tablespace Usage in Oracle Below is SQL query to find out temporary tablespace utilization of the database. Mountain climber | Exercise Videos & Guides | Bodybuilding.com…

Target Blackouts in OEM 13c 5 (4)

Step by Step Demonstrations on Target Blackouts in OEM 13c So blackouts allow Enterprise Manager administrators to suspend all data collection activity on one or more monitored targets. The primary…

How to check ASM diskgroup Size in Oracle 4.8 (4)

Sometimes we need to fetch ASM diskgroup utilization of the database in Oracle. Below is the SQL query to find ASM diskgroup size in a database which includes Name, Total_GB,…

Below is command to check database startup time along with server up time. This is require whenever we perform reboot of database due to patching, change of parameters activities etc….

Below sql query is used to find total tablespace size of your database. which includes Tablespace name used size in MB, free size in MB and Total size in MB…

Sometime we have to run the application script from application server, but the script required a defined oracle version to run the application script successfully. Below are the Sql query…