Re: Login per sec by module

Hi All ,

Thanks for your suggestion ,

In our environment , listener log is disabled , since it has huge connection coming in , on average login per sec for per instance is ~150.

Now situation is CPU is used almost 100% during batch run ,and these batch run has huge login and log out .

we are trying to achieve two things :
1. get connection management historical data, since we feel it is due to huge login , system is reaching to 100 % so trend of it would help us to relate
2. Implementing a workaround which helped , but we need to figure out which modules need to add in it ,hence needed login per sec module wise

Regards,
Krishna

On Mon, 18 Oct 2021 at 14:20, Ilmar Kerm <ilmar.kerm_at_gmail.com> wrote:

> If by "module" you mean "service", then:
> select * from gv$service_stats where stat_name='logons cumulative';
> I sample it regularly and then calculate logons per time unit from there.
>
> On Mon, Oct 18, 2021 at 8:07 AM Krishnaprasad Yadav <
> chrishna0007_at_gmail.com> wrote:
>
>> Hi Experts ,
>>
>> Is there any way to find out login per sec of specific modules from the
>> database .
>>
>> It will be great if someone share some lights on this
>>
>> Regards,
>> Krishna
>>
>>
>>
>
> --
> Ilmar Kerm
>

--
http://www.freelists.org/webpage/oracle-l