Below section I have tried to present all the important features in Oracle Database management
RMAN List backup is a useful command to list the backup taken in the system. It shows all the details about the backup taken, what time it was taken, location of the backup. First, you need to connect with the Target database with or without a catalog and then these commands can be run. If …
RMAN List backup commands Read More »
Many times questions are being asked about how to find the Oracle database version and version of various Oracle utilities in Linux, Solaris, AIX, and Windows. Let’s check out how is the oracle database version defined and How to find the Oracle database version Oracle Database Versions How to check Oracle database version in Linux …
Statistics played in key role in Oracle performance tuning. Oracle Optimizer creates the execution plan based on the statistics of the Oracle table involved in the SQL queries. You may want to lock statistics in an Oracle table in some cases, for example There could be many more cases where we want to lock statistics …
How to find the table where statistics are locked in Oracle Read More »
We often need to find and delete duplicate rows from the Oracle table due to many reasons in the database. We need to delete to clear off the data issues often. There are many ways to delete duplicate rows but keep the original.I will be showing off a few faster methods to achieve it in …
We often need to perform reorganization of the tables. We have to do offline by taking the system down and it consumes a lot of time. we can perform an Online table redefinition using DBMS_REDEFINITION. This feature is available from 9i. How Oracle internally achieve this Online table redefinition There are some Restrictions Tables with …
Online table redefinition using DBMS_REDEFINITION Read More »
The concept of a “Recycle Bin” plays a crucial role in data recovery and management. This feature, introduced in Oracle 10g, is akin to the recycle bin in Windows or the trash in macOS, providing a safety net for data that has been deleted. This article, we will discuss the recycle bin in Oracle, How …
How to check recycle bin in Oracle: Purge, enable/disable Read More »
