asrblogger, Author at ASRblogger

Optimizer in Oracle 19c

Optimizer-in-oracle19cDownload

asrblogger May 16, 2022No Comments

Change Archivelog Destination (FRA)

Scenario: If current Archivelog mountpoint is full then we want to change the Archivelog destination in the database. It can be done in up are running condition of DB .…

asrblogger May 4, 2022No Comments

DataGuard Oracle

ORA-01194: file 1 needs more recovery to be consistent

SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: ‘/u01/app/oracle/oradata/prod/system01.dbf' Suppose we are…

asrblogger May 1, 2022No Comments

Oracle

Cassandra Commands

cassandra -f [start commads] ./nodetool status [checking status] ./nodetool ring [depicts of the state of nodes] ./nodetool -h 192.168.0.101 clean [cleanup of keys that no longer belong to a particular…

asrblogger April 26, 2022No Comments

Oracle

ORA-00020: maximum number of processes (3000) exceeded

PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for all background processes such as locks, job queue processes, and…

asrblogger April 20, 2022No Comments

ASM Oracle

ASM Day to Day Life Scripts

To identify the number of diskgroup ,status from below query. select group_number,name from v$asm_diskgroup; select group_number, name, state, type from v$asm_diskgroup; Size of ASM Diskgroup SELECT NAME, STATE, TYPE, ROUND(TOTAL_MB…

asrblogger April 7, 2022No Comments

DataGuard Interview Questions

Important Parameters in Data Guard

DB_NAME On a primary database, specify the name used when the database was created. On a physical standby database, use the DB_NAME of the primary database. DB_UNIQUE_NAME Specify a unique…

asrblogger April 6, 2022No Comments

Oracle

Connect To Hung Database In Oracle

Oracle hangs only when he is waiting for a resource. It might be a software resource (a latch or lock), or you could be hung waiting for server resources (CPU,…

asrblogger April 6, 2022No Comments

SQL

Data Concurrency & Data Consistency.

Data Concurrency A requirement of a multiuser RDBMS is the control of data concurrency, which is the simultaneous access of the same data by multiple users. Without concurrency controls, users…

asrblogger March 30, 2022No Comments

Oracle

12.2 Index Advanced Compression “High”.

12.2 Index Advanced Compression “High” Let’s begin by creating a table and explicitly creating a NOCOMPRESS index in the WHALE tablespace: SQL> create table WHALE (id number, Slno number, name…