2023 – Page 4

1 min read

System Monitor Process (SMON) : Oracle Background Process.

asrblogger

SMON Performs critical tasks such as crash recovery when the instance is started following a failure, dead transaction recovery, and...

3 min read

Oracle

Upgrade the database time zone (TZ) file using the DBMS_DST package in 19c.

asrblogger

After upgrading database from 12c to 19c, you may need to upgrade database time zone file version. This step is...

1 min read

Oracle

Database Writer Process (DBWn) : Oracle Background Process

asrblogger

Writes modified blocks from the database buffer cache to the data files. The database writer process (DBWn) reads the database...

2 min read

Oracle

Manageability Monitor Process (MMON) and Manageability Monitor Lite Process (MMNL) : Oracle Background Process

asrblogger

MMON Performs many tasks related to manageability, including taking Automatic Workload Repository snapshots and performing Automatic Database Diagnostic Monitor analysis....

3 min read

FAL (Fetch Archive Log) Gap Resolution

asrblogger

Once an Archive Log is received or archived from a Standby Redo Log on the Standby Database, it is registered...

4 min read

Oracle

Query is picking a bad execution plan , fix it using Oracle baselines ?

asrblogger

The goal of SQL plan baselines is to preserve the performance of corresponding SQL statements, regardless of changes in the...

2 min read

Oracle

LOG MINER in Oracle

asrblogger

Oracle LogMiner, a component of Oracle Database, provides a SQL interface for querying both live and archived redo log files. The...

focused mechanic repairing compressor hose in workshop

15 min read

Manual creation of SQL Profiles in Oracle Database

asrblogger

SQL Profiles are a powerful tool to improve performance of SQL queries in your Oracle Database. A SQL profile is a database...

tailor measuring shoulder of mannequin in light studio

6 min read

Resizing redo logs and standby Redologs in Dataguard

asrblogger

IN PRIMARY DATABASE :- 1) Check Instance details :- select status,instance_name,database_role from v$database,v$instance; ------------------------------------------------------------------------------------------------------------------------------------ 2) Check redo log and standby...

3 min read

Oracle

Crontab : Blocking session

asrblogger

Blocking sessions in Oracle are sessions which holds an exclusive lock on an object and doesn’t release it before another...

2 min read

How To Run SQL Tuning Advisor

asrblogger

When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be used to improve performance. It...

4 min read

MySQL

MEB Backup & Restore in MySQL

asrblogger

MySQL Enterprise Backup provides enterprise-grade backup and recovery for MySQL. It delivers hot, online, non-blocking backups on multiple platforms including...

1 min read

Oracle

ORA-04021: timeout occurred while waiting to lock object while dropping Materialized View.

asrblogger

A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based...

4 min read

Unable to generate Listener Log in Prod RAC DB

asrblogger

Cause: Looks like ADR is having the issue. Solution: Added the below parameter in the both the nodes and restarted...

railings around hatch on asphalt carriageway

3 min read

Moving datafile from one location to another in Standby

asrblogger

$ ps -ef|grep pmon oracle 2113 1 0 Sep20 ? 00:54:32 ora_pmon_prod1 oracle 30032 29996 0 08:50 pts/0 00:00:00 grep...

2 min read

ORA-16047: DGID mismatch between destination setting and target database

asrblogger

Issue : ORA-16047: DGID mismatch between destination setting and target database alert.log alter database register logfile '/opt/data/oracle3/prod101/FRA/prod101/archivelog/2019_12_01/o1_mf_1_190698_gy5z61jw_.arc' There are 1...

modern computer placed near server racks

3 min read

Cassandra

Apache Cassandra Performance Tuning

asrblogger

What is Apache Cassandra? ▪ NoSQL database ▪ Schema-free ▪ Very fast ‘write’ ▪ Cassandra is designed to handle big...

1 min read

Cassandra

Cassandra import & export

asrblogger

Cassandra.csv file data: car_make,car_model,start_year,id,first_name,last_name,department BMW,Saloon,2011,1,Johny,Depp,IT AUDI,Saloon,2013,2,Meryl,Streep,HR LEXUS,Sports,2011,3,Brad,Pitt,IT AUDI,Sports,2012,4,Tom,Hanks,FI BMW,Compact,2012,5,Angelina,Jolie,FI BMW,Saloon,2011,6,Tom,Cruise,HR AUDI,Compact,2013,7,Scarlett,Johansson,IT LEXUS,Compact,2013,8,Matt,Damon,IT NISSAN,Saloon,2013,9,Julia,Roberts,FI BMW,Saloon,2011,10,Nicole,Kidman,HR NISSAN,Compact,2012,11,George,Clooney,HR AUDI,Saloon,2012,12,Dwayne,Johnson,IT AUDI,Sports,2011,13,Natalie,Portman,FI Create keyspace and...

1 min read

Cassandra

Protected: Cassandra Data Modelling

asrblogger

This content is password protected. To view it please enter your password below: Password:

9 min read

Linux Administration.

asrblogger

A Linux distribution is a collection of (usually open source) software on top of a Linux kernel. A distribution (or...

8 min read

MySQL

MySQL HA DR Setup

asrblogger

/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 mysql-dr.localdomain mysql-dr User to install...