How to Check Temp Tablespace Usage in Oracle

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

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

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…

How to find all physicals files in Oracle

Below is command, how to find all physical files in Oracle in one short (control files, datafiles & redolog files). Click here to get sample output of all physical files…

Below commands to find Database size in Oracle which includes Total DB size, Free size, used size of DB along with DB name & Hostname, etc. SQL command which fetches…

De-installation of WebLogic 12.2

De-installation of WebLogic 12.2 We are decommissioning one of our Linux server, that server contains WebLogic instance, so as part of decommission we decided to de- installation WebLogic instance.Below are…

Add Disks to ASM Disk Group in Oracle

How to add disks to ASM disk group in oracle using command line. Application team requested to create new user along with new tablespace. This is require to deploy new…