2 Replies Latest reply: Sep 30, 2011 12:15 AM by Sohil RSS

    Regarding Max Active Sesssions During Day

    Sohil
      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
          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
            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.