Author Archives: alexeymoseyev

How to make partition elimination/pruning to work

The blog was moved to: http://www.avmconsulting.net/single-post/2016/11/19/How-to-make-partition-eliminationpruning-to-work Check us out on http://avmconsulting.net Advertisements

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

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

Junos Pulse VPN client on Linux. Two phase auth. 64bit. How to make it all work.

There are several problem common problems with Juniper SSL VPN on support of Linux clients: Most 64-bit platforms are not supported. Junos Pulse SSL VPN does not support Linux at all. Best way to cover problem “1” is: http://ubuntuforums.org/showthread.php?p=11189826#post11189826 There … Continue reading

Posted in Linux, Systems, Ubuntu | Tagged , , , , , , , , , , , , | 10 Comments

Lost control file, So what?

Recently got involved in couple conversations regarding common “RULE OF THUMB” about backing up control file, and double backup of control file backup etc.. I guess its good thing to do, its does not take much space anyway, but if … Continue reading

Posted in Oracle, SQL | Tagged , , , , , , , | 2 Comments

ORA-01555 on standby

If you see “ORA-01555: snapshot too old” from Select what is been run on Physical standby, but same select runs on primary just fine,¬†and all relevant init.ora parameters and undo tablespace are exactly identical between primary and standby,- its odd. … Continue reading

Posted in Oracle, SQL | Tagged , , , , , | 4 Comments

VIP is not reachable after failover

If VIP was failed over from one host in subnet to another via manually running “ifconfig down” on one host and “ifconfig up” on another, you can see case when VIP become unreachable from outside of subnet. the problem should … Continue reading

Posted in Linux, Systems | Tagged , , , , , | 2 Comments