1 min read
A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based...
1 min read
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...
1 min read
From oracle 12c onwards the default user’s account passwords have to change from cdb container. container class is optional. sys...
1 min read
From 12c onwards we have new feature called lockdown profile to control the PDB level activities. It can be created...
2 min read
Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants 2) Roles Roles: Collection of...
2 min read
Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants 2) Roles Grants: oracle12c have...
3 min read
The redo log buffer is a circular buffer in the SGA that stores redo entries describing changes made to the database.A redo record is...
6 min read
The shared pool caches various types of program data.For example, the shared pool stores parsed SQL, PL/SQL code, system parameters, and data dictionary information....
2 min read
Macros Search macros are reusable chunks of Search Processing Language (SPL) that you can insert into other searches. Search macros can...
