4 min read
TX lock contention is an application coding, design and usage problem and can ONLY be fixed by changing application code...
Oracle
4 min read
1 min read
In case if we want to identify duplicates rows of a table and want to remove them from a table. ...
3 min read
Once the standby database is configured and verified to be working properly, we can switch over to the standby database...
6 min read
Oracle uses two different index architectures: b-Tree indexes and bitmap indexes. Cluster indexes, bitmap join indexes, function-based indexes, reverse key...
3 min read
Block-Corruption-RecoveryDownload What is a data block corruption? Data block corruptions occur whenever data is not in its expected state. Data...
3 min read
Why there is a need to upgrade Oracle 12c Database? The most important reason to upgrade 12c is to enjoy...
2 min read
What is use of INDEXFILE option in imp? Will write DDLs of the objects in the dumpfile into the specified...
9 min read
What is use of CONSISTENT option in exp? When you export a table, you are guaranteed that the contents of...
2 min read
Below is the error while I was upgrading my test environment. SQL> alter pluggable database application CODDY begin upgrade '1.3'...
3 min read
In Oracle Database, a redo log thread refers to a specific instance of redo log processing within the database. Redo...
3 min read
Scenario 1: If the jobs are running too frequently, it is possible the queries are not releasing the lock and...
2 min read
A full table scan reads all rows from a table, and then filters out those rows that do not meet...
1 min read
This content is password protected. To view it please enter your password below: Password:
3 min read
Computer memory is managed in blocks of storage known as pages, which have a predetermined size that depends on the...
3 min read
On 12c, Oracle XML DB is now a mandatory component of Oracle Database. You cannot uninstall it, and if Oracle...
3 min read
On : 19.18.0.0.0 version, Patching After applying a RU Patch , CATALOG / CATPROC Component goes Invalid with lot of...
1 min read
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 dhs.snap_id = dhss.snap_id AND dhs.instance_number...
2 min read
ORACLE_HOME disk (filesystem) became full and caused an ASM error... Got the following errors in the alert log file: ORA-01148:...
4 min read
SAR is used to collect, report or save system activity. SAR stands for System Activity Report. SAR is used to...
3 min read
Traditional startup/shutdown command prior to 12c. Shutdown Command SHUTDOWN NORMAL SHUTDOWN IMMEDIATE SHUTDOWN ABORT Startup Command STARTUP STARTUP NOMOUNT STARTUP...
2 min read
After performing database upgrade from 12.1.0.2.171017 to 12.2.0.1.171017, PDB is shown in RESTRICTED mode. SQL> show pdbs; CON_ID CON_NAME OPEN...
1 min read
Archivelog gap set pagesize 320 set linesize 200 set wrap off select thread#, sequence#, applied,to_char(first_time,’mm/dd/yy hh24:mi:ss’) first,to_char(next_time, ‘mm/dd/yy hh24:mi:ss’) next,to_char(completion_time,...
4 min read
Private SQL area holds information about a parsed SQL statement and other session specific information for processing. When a server...
5 min read
Single Client Access Name (SCAN) is a feature used in Oracle Real Application Clusters environments that provides a single name...
3 min read
Materialized views are query results that have been stored or "materialized" in advance as schema objects. The FROM clause of...
