Switchover to Physical Standby Database in Oracle
Once the standby database is configured and verified to be working properly, we can switch…
Read more2023
Basic Concepts of Index
Oracle uses two different index architectures: b-Tree indexes and bitmap indexes. Cluster indexes, bitmap join…
Read moreOracle Database Block Corruption
What is a data block corruption? Data block corruptions occur whenever data is not in…
Read moreThings to know before Upgrading Oracle 12c DB !!
Why there is a need to upgrade Oracle 12c Database? The most important reason to…
Read moreExport/Import Interview Questions-II
What is use of INDEXFILE option in imp? Will write DDLs of the objects in…
Read moreExport/Import Interview questions-I
What is use of CONSISTENT option in exp? When you export a table, you are…
Read moreORA-65011: Pluggable database does not exist.
Below is the error while I was upgrading my test environment. SQL> alter pluggable database…
Read moreWhat is redo log thread?
In Oracle Database, a redo log thread refers to a specific instance of redo log…
Read more“ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired”
Scenario 1: If the jobs are running too frequently, it is possible the queries are…
Read moreFull Table Scan (FTS) in Oracle
A full table scan reads all rows from a table, and then filters out those…
Read moreProtected: Sqlplus (Automation)
There is no excerpt because this is a protected post.
Read moreHugePages in Linux
Computer memory is managed in blocks of storage known as pages, which have a predetermined…
Read moreOracle XML Database (XDB) Installation on 12c – XDB invalid status
On 12c, Oracle XML DB is now a mandatory component of Oracle Database. You cannot…
Read moreComponent goes Invalid after applying a RU Patch , CATALOG / CATPROC
On : 19.18.0.0.0 version, Patching After applying a RU Patch , CATALOG / CATPROC Component…
Read moreScript to check Segments Generating Redo logs?
SELECT to_char(begin_interval_time,’YY-MM-DD HH24′) snap_time, dhso.object_name, sum(db_block_changes_delta) BLOCK_CHANGED FROM dba_hist_seg_stat dhss, dba_hist_seg_stat_obj dhso, dba_hist_snapshot dhs WHERE…
Read moreORA-09817: Write To Audit File Failed
ORACLE_HOME disk (filesystem) became full and caused an ASM error... Got the following errors in…
Read moreMonitoring System Performance Using SAR
SAR is used to collect, report or save system activity. SAR stands for System Activity…
Read moreHow to Use the top Command in Linux ??
The top utility is a commonly used tool for displaying system-performance information. It dynamically shows…
Read moreHow to Startup/Shutdown PDB’s ??
Traditional startup/shutdown command prior to 12c. Shutdown Command SHUTDOWN NORMAL SHUTDOWN IMMEDIATE SHUTDOWN ABORT Startup…
Read moreDB Opened In Restricted Mode Due To PDB Plug-in Violations Related To Datapatch
After performing database upgrade from 12.1.0.2.171017 to 12.2.0.1.171017, PDB is shown in RESTRICTED mode. PDB_PLUG_IN_VIOLATIONS…
Read moreFind Archive Log Gaps On Standby Database ??
Archivelog gap Log Gap Check Restore Archivelog from Backup Stop and Start MRP Services
Read moreCursor Sharing in Oracle
Private SQL area holds information about a parsed SQL statement and other session specific information…
Read moreSplunk Contents ….In Progress on below topics !!
Overview Benefits What can be done Different Instances Users (Interview Question) User Power User Admin…
Read moreOracle Single Client Access Name (SCAN)
Single Client Access Name (SCAN) is a feature used in Oracle Real Application Clusters environments…
Read moreWhat is a Materialized View?
Materialized views are query results that have been stored or "materialized" in advance as schema…
Read more