Database Administration (MOSC)

MOSC Banner

many inactive sessions triggered by module w3wp.exe

Hello,

I am running Oracle 19.3 on Windows Server 2019 Standard. The database shows there are about 160 inactive sessions and 1 active user session.

The IIS server (v6.0) is running on Windows Server 2003 SP2. There is only one w3wp.exe process running on the server.

I want to find out why there are so many inactive sessions. Are these valid sessions or left behind? I am new to Oracle. I don't know how to find out more related details.

Thank you.

Linda Tan

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center