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…

A materialized view create with the automatic refresh can not be alter to stop refreshing. In order to do that you must break the dbms_job that was created in order…

Oracle RMAN was able to take incremental backups already in 9i. However, prior to introduction of Oracle 10g block change tracking (BCT), RMAN had to scan the whole datafile to…

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) exec_delta, sum(rows_processed_delta) rows_proc_delta FROM dba_hist_sqlstat dhss, dba_hist_snapshot dhs, dba_hist_sqltext dhst…