We may need to find the database growth for different periods in the past. This Article provides the queries to find the monthly database growth OR Segments growth OR Specific…

Below Are the differences b/w exp/imp vs Datapump 1. Datapump operates on a group of files called dump file sets. However, normal export operates on a single file. 2. Datapump…

When executing a Materialized View refresh an ORA-01555 is returned.  This returns the following type of error either in the alert.log : ERROR at line 1: ORA-12048: error encountered while…

Refreshing a Materialized View via the Oracle job scheduler reports the following errors, however manual refresh succeeds. *** SERVICE NAME:(SYS$USERS) 2006-12-04 14:12:37.936 *** SESSION ID:(23.10780) 2006-12-04 14:12:37.936 *** 2006-12-04 14:12:37.936…

Oracle's Distributed Database Option provides the ability to perform transactions spanning multiple networked databases. As in standalone databases, transactions may block each other as they try to exclusively access database…

You can use Oracle OPatch utility to check all the Oracle Patches applied in Oracle database. opatch utility is located under $ORACLE_HOME/OPatch directory. Run the opatch lsinventory command to get…

You can query the v$session_longops view to find long-running queries and you can query the AWR to find historical queries (if you have purchased the AWR packs).. The Oracle data…

To find stale objects and the last analyzed date for tables and indexes in an Oracle Database, you can query the data dictionary views DBA_TAB_STATISTICS, DBA_IND_STATISTICS, and DBA_OBJECTS. Stale statistics…

Temporary Tablespaces A temporary tablespace does exist on a permanent basis as do other tablespaces, such as the System and Sysaux tablespaces. However, the data in a temporary tablespace is…