CODEWITHSUNDEEP
oracle-databaseoracle11gdatabase-administration
krishna
krishna

Reputation: 185

Unclosed connection in Oracle database

Problem: Oracle database is having unclosed connections. We need DBA setting to kill the connecions ,not sessions , many connections are from same user , but have to kill only the connections which are not used , idle connections which are not running any sql query against the database. Is there any setting in Oracle DBA to do this ? If particular connection is not used for some time for running query(say 20 min), then it should be automatically killed or released that connection. Please help. Thanks, krishna, [email protected]

Upvotes: 0

Views: 306

Answers (1)

user123664
user123664

Reputation:

Yes, you can use Oracle Database Resource Manager to do that. Of course, your dba should set this up for you to work. See Idle Time Limit in the docu. Make sure that there is a dedicated resource consumer group for this kind of sessions.

Upvotes: 1

Related Questions