What is SPLUNK?
Splunk is a software platform to search, analyse & visualize the machine generated data gathered…
Read moreMay 2022
Part 3: Constraints (Primary Key) in SQL
Primary Key Constraints A primary key constraint designates a column as the primary key of…
Read moreConnect String
This property specifies connection information used to connect to an Oracle database. The Oracle installer…
Read moreGrid Restart (HAS) & Clusterware (CRS)
Identify if Grid ASM is Cluster ware or High Availability Solution Check in OS Platform…
Read moreOptimizer in Oracle 19c
Optimizer-in-oracle19cDownload
Read moreChange Archivelog Destination (FRA)
Scenario: If current Archivelog mountpoint is full then we want to change the Archivelog destination…
Read moreORA-01194: file 1 needs more recovery to be consistent
SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194:…
Read more