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