How to know if I will be able to use successfully my RMAN Backup? that's is a question performed for many DBA's, RMAN also provide functions to validate corrupted blocks in the database, but also it p...
Introduction You’ve probably been reminded very often that force logging is important in a Data Guard configuration and have also been warned about the dramatic consequences that might happen in a dat...
Role transitions are no more complicated starting from Oracle Database 12c. Role transition, basically, comprises switchover and failover. Using the previous release role transitions, in order to perf...
Some days ago Michael Abbey invited me to a dinner (René Antunez Oracle ACE, also was there) in his apartment in Ottawa. He is such an admirable person, he is also an Oracle ACE and he likes to share ...
The flash recovery area, which allows you to centralize storage of all recovery-related files, is new in Oracle 10g. The flash recovery area is an area of disk that is defined for use for recovery-rel...
Adding an ASM Disk Group ASM disk groups are the foundation of ASM. It is where your data will be stored. ASM disk groups can be allocated to raw disk, cooked disk. To add a ASM disk group you first...
How to Identify a Buffer Cache Chain Latch Problem Internally, Oracle uses various types of structures to control access to elements of the databases including latches and various types of enqueuein...
A sort area in memory is used to sort records before they are written out to disk. Increasing the size of this memory by increasing the value of the initialization parameters SORT_AREA_SIZE or PGA_AGG...
Adding Logfiles To add a redo log, the following command is used: ALTER DATABASE database name ADD LOGFILE THREAD y GROUP n (file specification, file specification) SIZE x; or: ALTER DATABASE dat...
Sometimes, data blocks are read in the database, and are infrequently reused. Often in a database we also have data blocks that are of frequent use (hot blocks). It is for these types of database bloc...
Processing SQL Statements The first time a select query is executed inside the Oracle engine, the statement will generally need to proceed through 4 different stages in order to return results back to...
The Parallel Query Option (PQO) is best used for systems where large, intense queries are being performed or where large amounts of data are being loaded, indexed and queried, such as in data warehous...
