2 min read
When executing a Materialized View refresh an ORA-01555 is returned. This returns the following type of error either in the...
2 min read
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...
2 min read
MySQL Server - Version 5.1 and later The simplest way to find long running queries are to look at the...
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...
2 min read
Overview Alerts in Splunk are used to create notification or inform someone when a particular situation is met. It basically...
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...
1 min read
Writes modified blocks from the database buffer cache to the data files. The database writer process (DBWn) reads the database...
2 min read
MMON Performs many tasks related to manageability, including taking Automatic Workload Repository snapshots and performing Automatic Database Diagnostic Monitor analysis....
3 min read
Once an Archive Log is received or archived from a Standby Redo Log on the Standby Database, it is registered...
4 min read
The goal of SQL plan baselines is to preserve the performance of corresponding SQL statements, regardless of changes in the...
2 min read
Oracle LogMiner, a component of Oracle Database, provides a SQL interface for querying both live and archived redo log files. The...
15 min read
SQL Profiles are a powerful tool to improve performance of SQL queries in your Oracle Database. A SQL profile is a database...
6 min read
IN PRIMARY DATABASE :- 1) Check Instance details :- select status,instance_name,database_role from v$database,v$instance; ------------------------------------------------------------------------------------------------------------------------------------ 2) Check redo log and standby...
3 min read
Blocking sessions in Oracle are sessions which holds an exclusive lock on an object and doesn’t release it before another...
2 min read
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be used to improve performance. It...
