v$session logs [message #575391] |
Tue, 22 January 2013 18:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
reym21
Messages: 241 Registered: February 2010 Location: Philippines
|
Senior Member |
![vyer.atarom@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
Gurus,
Good day.
Is there a way where I can check users/IPs who connect to the database
in a specific time 2 days ago?
Thanks in advance.
|
|
|
Re: v$session logs [message #575392 is a reply to message #575391] |
Tue, 22 January 2013 18:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136107.jpg) |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
>Is there a way where I can check users/IPs who connect to the database
listener.log file contains a record of every connection request that it received; which includes originating client (but not user)
[Updated on: Tue, 22 January 2013 18:55] Report message to a moderator
|
|
|
|
|
|
Re: v$session logs [message #575396 is a reply to message #575395] |
Tue, 22 January 2013 20:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136107.jpg) |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
>what's the use of incrementing the port number?
no two client can utilize the same port, so each client connection gets their own dedicated port.
|
|
|