System Monitor Process (SMON) : Oracle Background Process.
SMON Performs critical tasks such as crash recovery when the instance is started following a…
Read more2023
Upgrade the database time zone (TZ) file using the DBMS_DST package in 19c.
After upgrading database from 12c to 19c, you may need to upgrade database time zone…
Read moreDatabase Writer Process (DBWn) : Oracle Background Process
Writes modified blocks from the database buffer cache to the data files. The database writer…
Read moreManageability 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 moreMEB Backup & Restore in MySQL
MySQL Enterprise Backup provides enterprise-grade backup and recovery for MySQL. It delivers hot, online, non-blocking…
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 moreApache Cassandra Performance Tuning
What is Apache Cassandra? ▪ NoSQL database ▪ Schema-free ▪ Very fast ‘write’ ▪ Cassandra…
Read moreCassandra import & export
Cassandra.csv file data: Create keyspace and create tables and then importing the data form local…
Read moreProtected: Cassandra Data Modelling
There is no excerpt because this is a protected post.
Read moreLinux Administration.
A Linux distribution is a collection of (usually open source) software on top of a…
Read moreMySQL HA DR Setup
/etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.56.10 mysql-prim.localdomain mysql-prim 192.168.56.11…
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 more