nactive

[81]Hi Is there anyway with which i can find tha...... RUCHI TANEJA Jan
[82]As you neither feedback, nor thank, not rate in ...... Michel Cadot
[83]Hi Michael Its not like that.I really admire ...... RUCHI TANEJA
[84]I don't believe that Oracle has a way to keep trac...... Tim Boles
[85]Hello, if your new application release doesn't ...... Bruno Vroman

Subject: inactive session detail
Os info: linux
Oracle info: 11gr2
Message: Hi
Is there anyway with which i can find that how many inactive sessions
were there on database past one month.
My need is to find out the comparison of session connected to
database.Actually application has patched their new release after which
we observed that there are connections at database from application
user not getting released and become inactive..and at any point of time
there are many inactive sessions.So the release upgraded past one
month.Now i want a logical reasoning demanded by management that is
this behaviour observed after upgraded version of application.So i want
to check history for inactive sessions.


Subject: Re: inactive session detail
Message:
As you neither feedback, nor thank, not rate in your previous topics, I
don't see any reason to help you now.
Regards
Michel


Subject: Re: inactive session detail
Message: Hi Michael
Its not like that.I really admire this form and people over here.You
can also see i had been less active on this form for too long.
But it's a great and good help from you people specially user.I always
keen to get answers on my request.Please reply i will keep rating a
factor in my mind and assure you not to miss same for now and future.


Subject: Re: inactive session detail
Message: I don't believe that Oracle has a way to keep track of
"inactive" sessions. You do have the DBA_HIST_ACTIVE_SESS_HISTORY view
but as the name states it is for "ACTIVE" SESSIONS. When you run an AWR
report it does show the number of sessions for that period. So I will
be really surprised if there is any way that this is tracked. If you
think about...why would Oracle care about inactive sessions.


Subject: Re: inactive session detail
Message: Hello,
if your new application release doesn't close connections (that were
closed by previous release), then your database should soon be "out of
processes"...
But more interesting than inactive sessions (it is very common for most
sessions to be inactive most of the time and for example in our main
database we have usually less than 5 active user sessions at any given
time although there are about 1000 user sessions in the database) you
should maybe look at the total workload in your database.
So I would rather compare the number of active sessions now and in the
past, to see for example if the new release consumes more resources
than the previous one to perform the "same work" (day to day
application tasks) -increase of the average number of active sessions,
increase of "DB time" / "Elapsed time". Compare also other metrics from
various AWR reports (like the amount of IO) to have an idea of the
change.
This should be more meaningful than comparing the number of inactive
sessions -except if there is really an issue with connections remaining
open when they should be closed, but in this case they wouldn't consume
resource, they would "simply" exhaust the number of potential sessions
and this would block new sessions.
Best regards,
Bruno Vroman.