Monthly Archives: July 2016

filter(NULL IS NOT NULL)

“filter(NULL IS NOT NULL)” in explain plan usually means what CBO found a conflict between your WHERE-clause predicates and declarative constraints on the tables involved. example – And if constraints are validated, Oracle does not physically touch the Object at … Continue reading

Posted in Oracle, SQL | Tagged , , , | Leave a comment

Roll forward oracle database restored from storage snapshot

Most people use storage snapshots with Oracle DB these days. Its easy to restore DB to discrete point of time, i.e. to snapshots time. Here is a method of rolling forward the DB to any needed point of time using … Continue reading

Posted in Oracle, Systems | Tagged , , , , , , , , , , , , , | Leave a comment