If you have situation when partition elimination/pruning does not work, here are couple effective tricks to fix it. 1. If query derives partition key from sub-query, for example (query where sale_date is a partition key): Replace sub-query with DETERMINISTIC function: In most cases it should not be differences between sub-query and function. But there are […]
Choice of Tool New Relic http://newrelic.com/plugins/3legs/113Monitor Cassandra statistics using the 3legs plugin. Metrics include Read and Write latency (global and per host), Cache statistics, Pending compactions, flushes and more. Datastax – OpsCenter http://www.datastax.com/documentation/opscenter/4.1/pdf/opscuserguide41.pdfDataStax OpsCenter is a visual management and monitoring solution for Apache Cassandra and DataStax Enterprise.The DataStax agents are installed on the Real-time (Cassandra), […]
There are several problem common problems with Juniper SSL VPN on support of Linux clients: 1.Most 64-bit platforms are not supported.2.Junos Pulse SSL VPN does not support Linux at all. Best way to cover problem “1” is:http://ubuntuforums.org/showthread.php?p=11189826#post11189826There is also well known mad-scientist way but its more complex. Problem “2” is a bit more involved. In […]
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. But its easy to explain. First check if DB is below 11.2.0.3 DB it […]
Its Unix 101 statement, but I have heard it wrong so many time, so decided to put a blog for it. If in OLTP environment, per ‘top’ %wa (IOWAIT) is major contributor for CPU busy, adding CPU would not help. There is no need for more CPU. Period. ************** %wa IS PERCENTAGE WHAT COUNT TO […]
High Index Clustering factor is popular problem in SQL world.The most known solution for it – rebuild table ordering by columns what are in the index.But in real world, with table size growing exponentially its not always practical or possible to do it. Here is one way to avoid index clustering problem by SQL optimization.. […]