This discussion is archived
2 Replies Latest reply: Sep 29, 2011 10:15 PM by Sohil RSS

Regarding Max Active Sesssions During Day

Sohil Newbie
Currently Being Moderated
Dear Friends,

How can i find Maximum active sessions during a day, in v$session it shows current status.

Will ASH report help in this?

Thanks
  • 1. Re: Regarding Max Active Sesssions During Day
    839439 Pro
    Currently Being Moderated
    Sohil wrote:
    Dear Friends,

    How can i find Maximum active sessions during a day, in v$session it shows current status.

    Will ASH report help in this?

    Thanks
    check the below link :

    http://stackoverflow.com/questions/162255/how-to-check-the-maximum-number-of-allowed-connections-to-an-oracle-database

    Hope this help


    --neeraj                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
  • 2. Re: Regarding Max Active Sesssions During Day
    Sohil Newbie
    Currently Being Moderated
    Thanks Neeraj for help.

    But it's shows me total number of connection from v$session, actually i want to find the max active sessions count reached during day.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points