How to Validate Invalid Objects in Oracle
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
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
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, 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
How to check database startup time along with server up time in Oracle.
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
How to increase Processes, Sessions and Transactions Initialization Parameters in Oracle
Demonstration on how to increase processes, sessions, and transactions parameters in Oracle. Whenever DB processes are utilized 100% then it’s NOT allowed any new sessions/connections to DB’s instances and we get the below error:ORA-00020: No more process state objects availableORA-20 errors will not be written to the alert log forthe ORA-20 errors. Cause: All process state
DATABASE MIGRATION FROM WINDOW SERVER TO LINUX SERVER IN ORACLE
DATABASE MIGRATION FROM WINDOW SERVER TO LINUX SERVER IN ORACLE In this article, we are going to demonstrate DATABASE MIGRATION FROM WINDOW SERVER TO LINUX SERVER. This is required as part of migration on request of the client to route application on new configuration (Weblogic). DATABASE DETAIL : Source: WINDOWS SERVER VERSION Windows Server 2012 R2 Standard
DBMS_LOCK.sleep procedure to suspend the session in Oracle
DBMS_LOCK.sleep procedure to suspend the session in Oracle DBMS_LOCK.sleep procedure suspends the session for a given period of time or specified time in the procedure, it will wait to complete procedure then next SQL statement will execute. DBMS_LOCK.SLEEP (seconds IN NUMBER); seconds: Amount of time, in seconds, to suspend the session. The smallest increment can
Step by Step Apply Patch on Oracle Database Home (July 2020)
Steps to Apply Patch on Oracle Database Home I this article we are going to demonstrate step by Step Apply Patch on Oracle Database Home (July 2020) patch ID 31113348. Before move ahead we will see here patch July patch IDs for all available version of Oracle database along with four next release date of