3 min read
Materialized views are query results that have been stored or "materialized" in advance as schema objects. The FROM clause of...
Oracle
3 min read
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...
1 min read
Refreshing a Materialized View via the Oracle job scheduler reports the following errors, however manual refresh succeeds. *** SERVICE NAME:(SYS$USERS)...
4 min read
Oracle's Distributed Database Option provides the ability to perform transactions spanning multiple networked databases. As in standalone databases, transactions may...
2 min read
You can use Oracle OPatch utility to check all the Oracle Patches applied in Oracle database. opatch utility is located...
7 min read
What is Oracle Clusterware – RAC ? Oracle Clusterware enables servers to communicate with each other, so that they appear...
7 min read
You can query the v$session_longops view to find long-running queries and you can query the AWR to find historical queries...
2 min read
To find stale objects and the last analyzed date for tables and indexes in an Oracle Database, you can query...
6 min read
Temporary Tablespaces A temporary tablespace does exist on a permanent basis as do other tablespaces, such as the System and...
1 min read
A materialized view create with the automatic refresh can not be alter to stop refreshing. In order to do that...
4 min read
Oracle RMAN was able to take incremental backups already in 9i. However, prior to introduction of Oracle 10g block change...
1 min read
DISABLE_ARCHIVE_LOGGING From 12c, during Import operations we can disable archive logging, hence no redo will be generated for the whole...
1 min read
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) sql, dhss.instance_number inst_id, dhss.sql_id, sum(executions_delta)...
1 min read
SMON Performs critical tasks such as crash recovery when the instance is started following a failure, dead transaction recovery, and...
3 min read
After upgrading database from 12c to 19c, you may need to upgrade database time zone file version. This step is...
