Category: Technical
How to turn on/off pop ups in Internet Explorer 8
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…
How to find/kill the locked objects in an oracle database
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…
How to find out maximum open cursors and no of cursors open in Oracle
The maximum number of open cursors in an oracle database can be determined by the following query select name, value from v$parameter where name like ‘open-cursors’ the value for open_cursors parameter refers to maximum number of open cursors allowed. The below query can be used to determine number of open cursors for the current session.…