4 min read
The goal of SQL plan baselines is to preserve the performance of corresponding SQL statements, regardless of changes in the...
Month: April 2023
4 min read
2 min read
Oracle LogMiner, a component of Oracle Database, provides a SQL interface for querying both live and archived redo log files. The...
15 min read
SQL Profiles are a powerful tool to improve performance of SQL queries in your Oracle Database. A SQL profile is a database...
6 min read
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
Blocking sessions in Oracle are sessions which holds an exclusive lock on an object and doesn’t release it before another...
2 min read
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 Enterprise Backup provides enterprise-grade backup and recovery for MySQL. It delivers hot, online, non-blocking backups on multiple platforms including...
1 min read
A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based...
4 min read
Cause: Looks like ADR is having the issue. Solution: Added the below parameter in the both the nodes and restarted...
3 min read
$ 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
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...
3 min read
What is Apache Cassandra? ▪ NoSQL database ▪ Schema-free ▪ Very fast ‘write’ ▪ Cassandra is designed to handle big...
1 min read
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
This content is password protected. To view it please enter your password below: Password:
9 min read
A Linux distribution is a collection of (usually open source) software on top of a Linux kernel. A distribution (or...
8 min read
/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...
7 min read
As a DBA, you are responsible for the performance of your Oracle database. Typically, performance problems result from unacceptable response...
5 min read
Staging Streams: Streams may store or stage changes in a database buffered queue. The benefit is that changes are stored...
5 min read
Transparent Data Encryption (TDE) enables you to encrypt sensitive data that you store in tables and tablespaces. After the data...
1 min read
CAUSE ALTER TABLESPACE TB1 add datafile '+WHALE_DG1' size 10g autoextend on next 500M * ERROR at line 1: ORA-00059: maximum...
2 min read
There are two types of Undo Modes in 12.2 1) Shared Undo - The Undo tablespace is common, it is...
1 min read
Relocating an Online Data File SQL> ALTER DATABASE MOVE DATAFILE '/rman_backup/backup/datafile1' TO '+DATA'; Database altered. Copying an Online Data File...
1 min read
11g When OMF is enabled and If a datafile location is incorrect the file gets created in dbs location SQL> show...
3 min read
Managing tablespace in container database is similar to non-container database. Provided you are logged in as a privileged user and...
1 min read
Common user password we can change from only cdb level .container class is optional. CDB container: ==================================== SQL> show con_name...
