DATABASE

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…

How to find all physicals files in Oracle 4.5 (2)

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…

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…