Re: Login per sec by module

have you looked at the listener log?

I don't know if it would be possible to find the answer there (I've never checked) but if the calling program has used some OCI calls to set the session environment (i.e. including module) before connecting then maybe some part of the connect string will include that information.

Regards
Jonathan Lewis.

On Mon, 18 Oct 2021 at 07:47, Krishnaprasad Yadav <chrishna0007_at_gmail.com> wrote:

> Hi Nenad,
>
> Thanks for sharing , but yes this could worsen it .
>
> Regards,
> Krishna
>
>
> On Mon, 18 Oct 2021 at 12:13, Noveljic Nenad <nenad.noveljic_at_vontobel.com>
> wrote:
>
>> Hi Krishna,
>>
>>
>>
>> You can set a logon trigger to capture v$session.module for a short time.
>> Notice that this might aggravate the existing problem.
>>
>>
>>
>> Best regards,
>>
>>
>>
>> Nenad
>>
>>
>>
>> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
>> Behalf Of *Krishnaprasad Yadav
>> *Sent:* Montag, 18. Oktober 2021 08:08
>> *To:* Oracle L <oracle-l_at_freelists.org>
>> *Subject:* Login per sec by module
>>
>>
>>
>> **** E-Mail from outside Vontobel:* Do not click on links or open
>> attachments unless you know the content is safe. ***
>>
>> 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
>>
>>
>>
>>
>>
>

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