Database Writer Process (DBWn) : Oracle Background Process
Writes modified blocks from the database buffer cache to the data files. The database writer…
Read moreOracle
Manageability Monitor Process (MMON) and Manageability Monitor Lite Process (MMNL) : Oracle Background Process
MMON Performs many tasks related to manageability, including taking Automatic Workload Repository snapshots and performing…
Read moreFAL (Fetch Archive Log) Gap Resolution
Once an Archive Log is received or archived from a Standby Redo Log on the…
Read moreQuery is picking a bad execution plan , fix it using Oracle baselines ?
The goal of SQL plan baselines is to preserve the performance of corresponding SQL statements,…
Read moreLOG MINER in Oracle
Oracle LogMiner, a component of Oracle Database, provides a SQL interface for querying both live…
Read moreManual creation of SQL Profiles in Oracle Database
SQL Profiles are a powerful tool to improve performance of SQL queries in your Oracle…
Read moreResizing redo logs and standby Redologs in Dataguard
IN PRIMARY DATABASE :- ------------------------------------- Moving on to the standby database:- ------------------------------------- Scripts used in…
Read moreCrontab : Blocking session
Blocking sessions in Oracle are sessions which holds an exclusive lock on an object and…
Read moreHow To Run SQL Tuning Advisor
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning…
Read moreORA-04021: timeout occurred while waiting to lock object while dropping Materialized View.
A materialized view, or snapshot as they were previously known, is a table segment whose…
Read moreUnable to generate Listener Log in Prod RAC DB
Cause: Looks like ADR is having the issue. Solution: Added the below parameter in the…
Read moreMoving datafile from one location to another in Standby
Check the datafile location along with name: Set standby file management parameter to manual before…
Read moreORA-16047: DGID mismatch between destination setting and target database
Issue : ORA-16047: DGID mismatch between destination setting and target database Since LOG_ARCHIVE_DEST_3 is getting…
Read moreLinux Administration.
A Linux distribution is a collection of (usually open source) software on top of a…
Read moreBasic Performance and Tuning
As a DBA, you are responsible for the performance of your Oracle database. Typically, performance…
Read moreComparison Between Oracle Streams and GoldenGate
Staging Streams: Streams may store or stage changes in a database buffered queue. The benefit…
Read moreTransparent Data Encryption in Oracle
Transparent Data Encryption (TDE) enables you to encrypt sensitive data that you store in tables…
Read more“ORA-00059: Maximum Number Of DB_FILES Exceeded”
CAUSE ALTER TABLESPACE TB1 add datafile '+WHALE_DG1' size 10g autoextend on next 500M * ERROR…
Read moreUndo Tablespace
There are two types of Undo Modes in 12.2 1) Shared Undo - The Undo…
Read moreRenaming and Relocating Datafiles Online
Relocating an Online Data File Copying an Online Data File This example copies the data…
Read moreOracle Managed Files 11g & 12c
11g When OMF is enabled and If a datafile location is incorrect the file gets…
Read moreManaging Tablespace in CDB and PDB
Managing tablespace in container database is similar to non-container database. Provided you are logged in…
Read moreCommon user password change:
Common user password we can change from only cdb level .container class is optional.
Read moreOracle-maintained users password change
From oracle 12c onwards the default user’s account passwords have to change from cdb container.…
Read moreLockdown Profile:
From 12c onwards we have new feature called lockdown profile to control the PDB level…
Read more