Ravi Shankar – Page 44 – Tweaking Apps

How to import a certificate in Google Chrome

July 8, 2010 By Ravi Shankar 3 Comments

A SSL certificate can be imported in Google Chrome using option menu. Click on the wrench icon –> options –> Navigate to Under the Hood tab

Scroll down to Security section and click on the Manage certificates button

Click on the import button and use the Certificate import wizard to import a certificate

Click Next and using Browse button locate the certificate file with a .cer or .cert as file extensions.

Click Next to continue with Certificate Import Wizard

Specify the location of the Certificate Store

And click Finish to complete the process.

How to turn off pop up blocker in Google Chrome

July 5, 2010 By Ravi Shankar 2 Comments

Google Chrome has an inbuilt pop up blocker feature. The default option is set is Do not allow any site to show pop-ups. You can disable pop up blocker in Google Chrome using Options menu similar to ie8 pop up blocker

Click on the Options menu

And navigate to Under the Hood tab and Click on the Content settings button

In the Content settings window, navigate to Pop-ups tab and select Allow all sites to show pop-ups under the Pop-up Settings.

How to clear or disable recently closed tab section in Firefox

June 15, 2010 By Ravi Shankar 4 Comments

Firefox displays the recently closed tabs under History menu –> Recently Closed Tabs.

If you want to clear or disable the recently closed tabs section then you can do the following

In the Firefox address bar type about:config
If you get the below warning message then click on the I’ll be careful, I promise button

Type browser.sessionstore.max_tabs_undo in Filter text box

Set the value for browser.sessionstore.max_tabs_undo to 0 and click OK to confirm the changes

Now if you navigate to History menu –> Recently Closed tabs section will be disabled as shown below.

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.

alter system kill session sid,serial;

How to find out maximum open cursors and no of cursors open in Oracle

March 4, 2008 By Ravi Shankar Leave a Comment

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.

SELECT
sid,user_name, COUNT(*) "Cursors per session"
FROM v$open_cursor
GROUP BY sid,user_name

« Previous Page