Database Administration (MOSC)

MOSC Banner

Connection information

edited Jun 15, 2018 10:55AM in Database Administration (MOSC) 4 commentsAnswered
Hi,

I'm using Oracle 10.2.0.3.0 Understand that i could check the current connection  to the database by querying v$session:

select username, machine from v$session;

How do i query the connection history information? Does AWR snapshot has this information?

thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center