Database Administration (MOSC)

MOSC Banner

Long term history of sessions : what would be the unique key ?

edited May 13, 2020 1:02AM in Database Administration (MOSC) 11 commentsAnswered

Hello all,

i want to evaluate the history of longer running sessions. I created an enrichted copy of v$active_session_history and i am looking for a logical primary key . I presume sid + serial + thread  together don't suffice.  I did not find , under which circumstances these values are recycled, but I am quite sure they are. AWR , ASH and friends are organized by time (snapshots) but I am interested in the 'biography' of some longer running sessions during their lifetime., which is sometimes days unfortunately..

Hmmmm. I hope this is somewaht clear ....

Thanks for listening

Norbert

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