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 SQLs to find invalid objects. SQL to find invalid object types which are owned by the owner. Click here to get sample output. SQL to
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 monster steroids.net Dymatize Elite Casein at Bodybuilding.com: Best Prices for Elite Casein | Bodybuilding.com which includes Tablespace name(Temp tablespace), Total size, Used size, and Free
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 reason for blacking out targets is to allow Enterprise Manager administrators to perform scheduled maintenance on those targets so it will not prompt any alerts
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, Free_GB, Used_GB and Free_percentage of the disk. SQL query to fetch ASM diksgroup size. Click here to get sample output. Click here to know about
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. SQL command to check database startup time along with server up time in standalone database. Click here to get sample output. SQL command to check
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 Sql command which fetch tablesapce size in GB Click here to get sample output We always encourage the technical person to visit section SCRIPTS to get more
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 to find the oracle client version. SQL command to get oracle client version. Click here to get sample output. We always encourage the technical person
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 in oracle Question: Why do we need all physical files together? Answer: Whenever we do decommission / clone / restore / migrate etc. We always
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 database size in GB. Click here to get a sample output of the Oracle client version. SQL command which fetch database size in MB. Click
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 the steps that we have to follow to de install Weblogic. Step1:- Stop Node manager and WebLogic services. Step2 :- Go to <MW_HOME>\oui\bin and execute de