Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Gathering historical Session Information

724046Feb 2 2010 — edited Feb 3 2010

Hey,

Anyone ever tried to gather information on historical session information? What I am trying to do is look back at either 7 days or last 30 days and collect information of what SQL was run, how many times they logged in, how long was each of there sessions (were they short or long), etc, etc.

I don't need this all in one view but I am prepared to pull it all together to do a trend analysis for my group. Any help and or scripts out there? Anyone ran into something similar?

Any help please would be much appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 3 2010

Added on Feb 2 2010

#general-database-discussions

7 comments

1,337 views