Skip to content

how to remove specific user sessions from oracle v$session table on dot net project logout #13

@pravinkharawade

Description

@pravinkharawade

In our dot net project user wise connection string is there. If 100 dedicated DB users (ie different connection string) login on system then 100 sessions get created.

I have used ClearPool and ClearAllPools method in dot net but again 1 session get created because of pooling.

Currently pooling is true in connection string and i want to keep it true only, because of performance.

On User logout i want to clear all session from V$session table.

Here I am using Visual Studio 2013 with Asp.Net C#.

Database - Oracle Database 11g Enterprise Edition

Database Connection Using ODP.NET Driver(Oracle.DataAccess.Client).

Please suggest.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions