Re: Login per sec by module
From: Ilmar Kerm <ilmar.kerm_at_gmail.com>
Date: Mon, 18 Oct 2021 10:50:39 +0200
Message-ID: <CAKnHwtfGOcLYS9m5QCNridSdiTgsMeukpPmM4ORicMJbrbJ5HA_at_mail.gmail.com>
Date: Mon, 18 Oct 2021 10:50:39 +0200
Message-ID: <CAKnHwtfGOcLYS9m5QCNridSdiTgsMeukpPmM4ORicMJbrbJ5HA_at_mail.gmail.com>
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
Received on Mon Oct 18 2021 - 10:50:39 CEST