ORACLE

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…

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…

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….

TABLE SHRINKING AND DATA FILE RESIZE in Oracle 5 (1)

Step By Step Table Shrinking and Data File Resize in Oracle Due to less budget sometimes the client asks to shrink the mount point space where our datafiles exist and…

How to increase Processes, Sessions and Transactions Initialization Parameters in Oracle 4.8 (12)

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…

DATABASE MIGRATION FROM WINDOW SERVER TO LINUX SERVER IN ORACLE 4.7 (24)

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…

DBMS_LOCK.sleep procedure to suspend the session in Oracle 4.6 (21)

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…

Step by Step Apply Patch on Oracle Database Home (July 2020) 4.7 (27)

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….