ORA-1555 During Materialized View Create or Refresh
When executing a Materialized View refresh an ORA-01555 is returned. This returns the following type…
Read moreasrblogger
ORA-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 moreHow To Find Queries Taking Longer Than N Seconds in MYSQL ?
MySQL Server - Version 5.1 and later The simplest way to find long running queries…
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 moreReports and Alerts in SPLUNK
Overview Alerts in Splunk are used to create notification or inform someone when a particular…
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 moreDatabase Writer Process (DBWn) : Oracle Background Process
Writes modified blocks from the database buffer cache to the data files. The database writer…
Read moreManageability Monitor Process (MMON) and Manageability Monitor Lite Process (MMNL) : Oracle Background Process
MMON Performs many tasks related to manageability, including taking Automatic Workload Repository snapshots and performing…
Read moreFAL (Fetch Archive Log) Gap Resolution
Once an Archive Log is received or archived from a Standby Redo Log on the…
Read moreQuery is picking a bad execution plan , fix it using Oracle baselines ?
The goal of SQL plan baselines is to preserve the performance of corresponding SQL statements,…
Read moreLOG MINER in Oracle
Oracle LogMiner, a component of Oracle Database, provides a SQL interface for querying both live…
Read moreManual creation of SQL Profiles in Oracle Database
SQL Profiles are a powerful tool to improve performance of SQL queries in your Oracle…
Read moreResizing redo logs and standby Redologs in Dataguard
IN PRIMARY DATABASE :- ------------------------------------- Moving on to the standby database:- ------------------------------------- Scripts used in…
Read moreCrontab : Blocking session
Blocking sessions in Oracle are sessions which holds an exclusive lock on an object and…
Read moreHow To Run SQL Tuning Advisor
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning…
Read more