2 min read
Macros Search macros are reusable chunks of Search Processing Language (SPL) that you can insert into other searches. Search macros can...
2 min read
1 min read
Automate RMAN Backup using Shell Script In a real environment, you will not manually trigger all the Oracle database backups....
2 min read
Roles: There are basically three different types of Roles in Splunk:User: This is the basic role in Splunk which provides...
2 min read
A) Recovery Point Objective(RPO) A recovery point objective (RPO) is the maximum length of time permitted that data can be...
1 min read
1. Verify that client networking connections are functional. Clients must be able to login to sql*plus with username/password/host string (where...
2 min read
Once the ASM instance is started, all the basic background processes, as well as some that are specific to the...
3 min read
Row Chaining Occurs when the row is too large to fit into one data block when it is first inserted....
4 min read
The PGA is memory specific to an operating process or thread that is not shared by other processes or threads...
1 min read
The UGA is session memory, which is memory allocated for session variables, such as logon information, and other information required...
3 min read
It is small xml file located in $GRID_HOME/gpnp/<hostname>/profiles/peer under the name profile.xml. It is used to establish the correct global...
3 min read
11g database - Datafile created with extra blank space similar to existing datafile. Please note that oracle database will not...
1 min read
We can change the snap_interval and retention period for the automatic awr snapshot collection, using modify_snapshot_settings function. The default settings...
1 min read
During 19c Upgrade, Materialized view creation which is from a pre-built base table is showing COMPILATION ERROR without any specific...
1 min read
After upgrading a database from 11.2.0.4 to 12.1.0.2, the following errors are reported executing a datapump import process: Import: Release...
5 min read
RAID stands for Redundant Array of Inexpensive Disks which was later interpreted to Redundant Array of Independent Disks. This technology...
3 min read
A checkpoint is an operation that Oracle performs to ensure data file consistency. When a checkpoint occurs, Oracle ensures all...
1 min read
Oracle 19c Grid Infrastructure requires certain files and provides tools to access each Standalone Cluster . It should have a...
3 min read
Sometimes you may need to kill the RMAN session which is hanging and does not respond. There are several ways...
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...
