Tweaking Apps
Renaming a folder in Windows operating system can be done by right clicking on the folder and selecting Rename from the context menu.
But if you want to rename number of files then the above process would be time consuming. The quickest way of renaming a folder is to use Windows Keyboard shortcut. Select the folder and press F2 and this would allow us to rename the folder.
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.
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.
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
Now if you navigate to History menu –> Recently Closed tabs section will be disabled as shown below.
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.
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;
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