Sometimes you may need to kill the RMAN session which is hanging and does not respond. There are several ways to terminate an RMAN command in the middle of execution: 1. The preferred method is to press CTRL+C (or the equivalent “attention” key combination for your system) in the RMAN interface. This will also terminates … Read more
ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that have occurred in the database so that you can recover to any point in time. NOARCHIVELOG mode is basically the absence of ARCHIVELOG mode and has the disadvantage of not being able to recover to … Read more
Commands: In Splunk, to write a query we need to learn the various commands it offers. Each command comes with a special use case and can be used for its own purpose. Any search query that used transforming commands such as stats, chart etc. are known as Transforming search. Transforming commands uses the existing results … Read more
During the Creation of database via DBCA , SPFILE is created in the file location that we specify. This location can be an ASM disk group, cluster file system file, or a shared raw device. If we manually create your database, it is recommended that you create an SPFILE from a PFILE. All instances in … Read more
Sometimes the DBA requires to create the read-only user for a particular schemas.While creating the user,one should always keep in mind that the user should have minimum privileges. There is no any direct command to create the read-only user in oracle. Sometimes I find people grants “read any table ” privileges to create the read-only … Read more
Large objects (LOBs) LOBs can be a problem in data replication by virtue of their size and the ability to extract, transmit, and deliver the data from source to target. Tables containing LOB datatypes should be isolated from regular data to use a dedicated Extract, Data Pump, and Replicat process group to enhance throughput. It … Read more
System Locks Oracle Database uses various types of system locks to protect internal database and memory structures. These mechanisms are inaccessible to users because users have no control over their occurrence or duration. Latches A latch is a simple, low-level serialization mechanism that coordinates multiuser access to shared data structures, objects, and files. Latches protect … Read more
Hey Folks, We have recently faced issue with huge lag due to bulk transaction(Insert Operation). To resolve the gap quickly, we opted in creating Range Replicat. The RANGE function The way the @RANGE function works is it computes a hash value of the columns specified in the input. If no columns are specified, it uses … Read more