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
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...
4 min read
The top utility is a commonly used tool for displaying system-performance information. It dynamically shows administrators which processes are consuming processor and...
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...
1 min read
Overview Benefits What can be done Different Instances Users (Interview Question) User Power User Admin Mode (Interview Question) Fast Smart...
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...
2 min read
Components: The primary components in the Splunk architecture are Forwarders, the Indexers and the Search Head. Forwarders:The forwarder is an...
2 min read
What is the shared pool ? Oracle keeps SQL statements, packages, object information and many other items in an area...
3 min read
When you are taking backups regularly to a specified disk then after some period of time the backup disk will...
1 min read
While trying to rollback the conflicting patch 18893947 applying patch 21967332 $ opatch rollback -id 18893947 Oracle Interim Patch Installer...
2 min read
The undo tablespace can have many datafiles, but if it has at least 1 datafile with autoextend=on then the tablespace...
2 min read
Determine if a Specific MVIEW is Being Refreshed: column owner format a15 column username format a15 column mview format a15...
2 min read
Maximum Protection Mode 1. No data loss 2. Redo has to be written to both Primary redo logs and standby...
6 min read
It has been seen in cases where ORA-16401 and ORA-16055 reported in primary alert log when redo log switch is...
2 min read
Database server crashed after memory on server used by inactive sessions The Following Example used to illustrate the scenario for...
2 min read
We may need to find the database growth for different periods in the past. This Article provides the queries to...
2 min read
Below Are the differences b/w exp/imp vs Datapump 1. Datapump operates on a group of files called dump file sets....
2 min read
When executing a Materialized View refresh an ORA-01555 is returned. This returns the following type of error either in the...
