1 min read
From 12c onwards we have new feature called lockdown profile to control the PDB level activities. It can be created...
1 min read
2 min read
Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants 2) Roles Roles: Collection of...
2 min read
Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants 2) Roles Grants: oracle12c have...
3 min read
The redo log buffer is a circular buffer in the SGA that stores redo entries describing changes made to the database.A redo record is...
6 min read
The shared pool caches various types of program data.For example, the shared pool stores parsed SQL, PL/SQL code, system parameters, and data dictionary information....
2 min read
Macros Search macros are reusable chunks of Search Processing Language (SPL) that you can insert into other searches. Search macros can...
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...
