What is a Materialized View?
Materialized views are query results that have been stored or "materialized" in advance as schema…
Read moreOracle
ORA-04031: unable to allocate bytes of shared memory
What is the shared pool ? Oracle keeps SQL statements, packages, object information and many…
Read moreRMAN Retention Policy Based On Redundancy Policy
When you are taking backups regularly to a specified disk then after some period of…
Read morePrerequisite check “CheckActiveFilesAndExecutables” failed.
While trying to rollback the conflicting patch 18893947 applying patch 21967332 Following executables are active…
Read moreUndo retention time with autoextend on and autoextend off in Oracle
The undo tablespace can have many datafiles, but if it has at least 1 datafile…
Read moreHow to Monitor the Progress of a Materialized View Refresh ??
Determine if a Specific MVIEW is Being Refreshed: Determine if a Refresh Group is Being…
Read moreData Guard Protection Mode.
Maximum Protection Mode 1. No data loss 2. Redo has to be written to both…
Read moreORA-16401, ORA-16055 : How to Drop and recreate SRL From Standby Database??
It has been seen in cases where ORA-16401 and ORA-16055 reported in primary alert log…
Read moreHow To Automatic Kill Inactive Sessions using Resource Manager
Database server crashed after memory on server used by inactive sessions The Following Example used…
Read moreMonthly Growth of the Database
We may need to find the database growth for different periods in the past. This…
Read moreDifference Between exp/imp vs Datapump (expdp/impdp)
Below Are the differences b/w exp/imp vs Datapump 1. Datapump operates on a group of…
Read moreORA-1555 During Materialized View Create or Refresh
When executing a Materialized View refresh an ORA-01555 is returned. This returns the following type…
Read moreORA-12012 ORA-12008 ORA-942 Materialized view Job Fails
Refreshing a Materialized View via the Oracle job scheduler reports the following errors, however manual…
Read moreOracle Database Locking Mechanism – 2
Oracle's Distributed Database Option provides the ability to perform transactions spanning multiple networked databases. As…
Read moreCheck the Patch Applied to the Oracle Database
You can use Oracle OPatch utility to check all the Oracle Patches applied in Oracle…
Read moreOracle Clusterware Startup Sequence
What is Oracle Clusterware – RAC ? Oracle Clusterware enables servers to communicate with each…
Read moreHow to find long running sessions in Oracle?
You can query the v$session_longops view to find long-running queries and you can query the…
Read moreHow to find Stale object and last analyzed for tables/indexes ?
To find stale objects and the last analyzed date for tables and indexes in an…
Read moreOverview of Oracle Temporary Tablespace (Creating/Resizing)
Temporary Tablespaces A temporary tablespace does exist on a permanent basis as do other tablespaces,…
Read moreHow to Stop Auto Refresh of Materialized View ??
A materialized view create with the automatic refresh can not be alter to stop refreshing.…
Read moreBlock Change Tracking: RMAN Performance
Oracle RMAN was able to take incremental backups already in 9i. However, prior to introduction…
Read moreHow to use IMPDP with transform=disable_archive_logging:y
DISABLE_ARCHIVE_LOGGING From 12c, during Import operations we can disable archive logging, hence no redo will…
Read moreScript to identify SQL generating Redo
SELECT when, sql, SUM(sx) executions, sum (sd) rows_processed FROM ( SELECT to_char(begin_interval_time,’YYYY_MM_DD HH24′) when, dbms_lob.substr(sql_text,4000,1)…
Read moreSystem Monitor Process (SMON) : Oracle Background Process.
SMON Performs critical tasks such as crash recovery when the instance is started following a…
Read moreUpgrade the database time zone (TZ) file using the DBMS_DST package in 19c.
After upgrading database from 12c to 19c, you may need to upgrade database time zone…
Read more