Skip to main content

Posts

Kill the Ads, Save the Bandwidth.

Remember the time when your browsing is like a breeze, pages appear almost instantly and reading mail is... reading mail without distraction of little animation called ads at the side of your browser. Well those days are over as advertisement plays an important role in getting revenue and for some, thats how they make the site running. Sometimes ads are good as 'second opinion' when you are shopping online, but too much of it will clouds your decision and might end up buying unnecessary thing. For the organization, unnecessary ads will consume the bandwidth thus affecting productivity. So, how to control this ? If Firefox is your number one browser then fear not, ads filtering is very easy to setup. Just follow these simple steps :

Search oracle 'ghost' or hang connection with sql.

Here's a quick sql on how to search for session details including their running sql. The sql statement is as below : select a.terminal, a.program, a.username, to_char((a.last_call_et/3660),990.99) LastCall, a.logon_time, a.sql_hash_value, decode(a.sql_hash_value,'0',null,(select b.sql_text from v$sql b where b.hash_value = a.sql_hash_value and rownum = 1)) SQL_statement from v$session a where a.terminal like '%' order by 4 desc; a.terminal - machine name a.program - what program taht make connection to our database. LastCall - last time this connection make an sql call. The column is in seconds so we devide with 3660 to convert it to hours. a.logon_time - logon time for this particular connection. a.sql_hash_value - the key to link between v$sql & v$session. Just for checking purpose. SQL_statement - sql statement called by this connection. So, basically this sql will retrieve all connections sorted by 'LastCall' since i w...

Biomagnetic Healing.

The power of the magnet is one of the most basic powers in nature. We know that magnetism itself was an ingredient in the primordial soup from which the universe and our planet came forth. Magnetism is the force that keeps order in the galaxy, allowing stars and planets to spin at significant velocities. And in a sense, our own planet's magnetic field is responsible for protecting all life on earth. more...