Why is Query Rewrite not happening on my Materialized Views?

You have designed the model and implemented the dimensions and fact tables. Data is clean. You have implemented all the required PK-FK relationships, created required indexes, gathered statistics and built the required materialized views. The analytic design team have completed report and issues SQL query! Oops… You expected the response time of < 10 seconds,… Read More Why is Query Rewrite not happening on my Materialized Views?

Assigning primary key value using Oracle Sequence

Many applications define tables with primary key which is populated using values from database sequence. There are several posts on the net that describe these techniques with some links listed below as references. In ADF applications there are several approaches to implement assignment of primary key values. 1. Using Groovy Expression in Entity class. 2.… Read More Assigning primary key value using Oracle Sequence

Transaction Backout – Oracle Flashback Technology

Oracle introduced Flashback Technology many years back (9i), and with version 11g TRANSACTION_BACKOUT capability was introduced. This is a very powerful feature, which allows a developer or DBA to BACKOUT specific committed transactions. This feature leverages UNDO and supplemental log data to identify the DML changes involved in a specific transaction and the other dependent… Read More Transaction Backout – Oracle Flashback Technology