Blogmines

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

In EditPlus text editor after editing any files a backup file gets created by default with .bak as extension . And this file may not be required for every one and if you want to disable the option of creating the backup then you need to do the following

Click Preferences option and the following dialog box would be displayed. And un select Create backup file when saving option.