2 min read
Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants 2) Roles Grants: oracle12c have...
Oracle
2 min read
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....
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
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
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...
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
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
Hey Folks, We have recently faced issue with huge lag due to bulk transaction(Insert Operation). To resolve the gap quickly,...
5 min read
Datafiles are part of the Oracle Database, these are the files that have the actual data in them. Datafiles can...
1 min read
Grid-Installation-ASRBLG-1Download Hope it helped !! :)
