Ravi Shankar – Page 43 – Tweaking Apps

How to turn on/off pop ups in Internet Explorer 8

July 8, 2009 By Ravi Shankar 2 Comments

Internet Explorer 8 has settings for blocking pop ups that appearing while accessing a website. Using this setting you can turn on or off a pop up, specify the sites where you want allow pop up to appear. To access Pop-up Blocker, click on Tools menu -> Options -> select Privacy tab in Internet Options dialog box.

On checking/un checking the Turn on Pop-up Blocker you enable or disable Pop ups. And on clicking settings button the following dialog would be displayed

Using IE8 Pop-up Blocker settings you can specify the listed of sites that can be allowed Pop-ups and also provides options for changing the Notifications and blocking level.

How to find/kill the locked objects in an oracle database

March 5, 2008 By Ravi Shankar Leave a Comment

The below query can be used for determining the if any object locked in an oracle database.

select   c.owner, c.object_name, c.object_type, b.sid, b.serial#,
   b.status, b.osuser, b.machine
from
   v$locked_object a , v$session b, dba_objects c
where
   b.sid = a.session_id
and a.object_id = c.object_id;

And if you need to kill any session you can use the below query to do the same.