Oracle Database Notes

Saturday, 13 September 2014

History of Past of Sessions

select T2.username,count(T2.username)
FROM gv$active_session_history t
,dba_users t2
WHERE
t.SAMPLE_TIME between to_timestamp('02/22/2014 20:30:00','MM/DD/YYYY HH24:MI:SS') and
to_timestamp('02/22/2014 20:35:00','MM/DD/YYYY HH24:MI:SS')
and t.user_id = t2.user_id
group by T2.username
order by count(T2.username)
;
Posted by Shilpa Rani at 00:39
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2023 (9)
    • ►  April (9)
  • ►  2016 (10)
    • ►  April (6)
    • ►  January (4)
  • ►  2015 (27)
    • ►  September (1)
    • ►  August (6)
    • ►  July (20)
  • ▼  2014 (19)
    • ▼  September (16)
      • Monitoring and Maintainence of Jobs
      • Full Database Refresh Using Export Dump
      • OEM Unreachable
      • Flashback Area Full
      • Max sessions/processes limit Reaching/Reached
      • Database Availability Alert Checks
      • Procedure to add space to tablespace
      • History of Past of Sessions
      • Undo Tablespace Management
      • Temporary Tablespace Management
      • Connected Sessions:Details
      • Tablespace: Free space management
      • ASH and AWR Performance Tuning Scripts
      • List Objects being accessed by a particular SID
      • List all recent DDL modifications
      • Size of db
    • ►  August (2)
    • ►  February (1)
  • ►  2013 (12)
    • ►  December (7)
    • ►  September (3)
    • ►  May (2)

About Me

Shilpa Rani
View my complete profile
Simple theme. Powered by Blogger.