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...
Month: March 2023
3 min read
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...
