OraFAQ Forum: SQL & PL/SQL » oracle session leak

Home » SQL & PL/SQL » SQL & PL/SQL » oracle session leak (oracle 12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle session leak [message #651327]

Sun, 15 May 2016 22:06

gorants
Messages: 85
Registered: May 2014
Location: ATL

Member

Hello experts,

Can you please help me understanding DB session leak. i know v$session there will be sessions with active/inactive.

Based on sessions growing how do i know following.

1. current DB is not sized with number of process to handle incoming sessions

2. DB sessions leak happening

3. When does sessions become inactive? will inactive become active ? when does inactive sessions get closed.

Appreciate your inputs.

Report message to a moderator

Re: oracle session leak [message #651328 is a reply to message #651327]

Sun, 15 May 2016 22:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>3. When does sessions become inactive? will inactive become active ? when does inactive sessions get closed.
Assume that you log into the Oracle database using sqlplus.
When the database is waiting for you to send it a command, the session is INACTIVE
While the DB is processing the SQL, the session is ACTIVE.
After the database has sent you the results, the session is once again INACTIVE
The session is closed when you EXIT or terminate the client session.

Report message to a moderator

Re: oracle session leak [message #651330 is a reply to message #651328]

Sun, 15 May 2016 22:31

gorants
Messages: 85
Registered: May 2014
Location: ATL

Member

Thanks BS, 3 point was very clear to understand.

Appreciate your insights on 1st and 2nd.

Report message to a moderator

Re: oracle session leak [message #651332 is a reply to message #651330]

Sun, 15 May 2016 22:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>1. current DB is not sized with number of process to handle incoming sessions
Oracle throws error

>2. DB sessions leak happening
Results from application bug

Report message to a moderator

Previous Topic:	Regular expression: letter category?
Next Topic:	NUMBER to HEX, HEX to NUMBER

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 12:25:35 CDT 2024