Sometimes you may need to kill the RMAN session which is hanging and does not respond. There are several ways...
Month: January 2023
ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that...
Commands: In Splunk, to write a query we need to learn the various commands it offers. Each command comes with...
During the Creation of database via DBCA , SPFILE is created in the file location that we specify. This location...
Sometimes the DBA requires to create the read-only user for a particular schemas.While creating the user,one should always keep in...
Large objects (LOBs) LOBs can be a problem in data replication by virtue of their size and the ability to...
System Locks Oracle Database uses various types of system locks to protect internal database and memory structures. These mechanisms are...
The RANGE function The way the @RANGE function works is it computes a hash value of the columns specified in...