Skip to content
  • Home
  • BLOG
    • Articles
    • Cloud
    • Database
    • DevOps Tools
    • Fusion Middleware
    • News
    • Operating system
    • Others
    • Scripts
  • ABOUT ME
  • CONTACT Me
Osama Mustafa وَمَا تَوْفِيقِي إِلَّا بِاللَّهِ

Technology Geek

For the people who think differently Welcome aboard

Tag: Username Session

Active Sessions in Oracle Database

Posted on July 1, 2012December 23, 2018 by Osama Mustafa in Database
Just Save This Sql As Script And Run it :

  1. SELECT SID, Serial#, UserName, Status, SchemaName, Logon_Time
  2. FROM V$Session
  3. WHERE
  4. Status=‘ACTIVE’ AND
  5. UserName IS NOT NULL;

Enjoy

Thank you
Osama mustafa

Tagged Active Session, oracle, Oracle Blog ., Osama, Osama blog, Osama mustafa, Osama mustafa blog, osama oracle, Session, SID Session, Username Session, v$sessionLeave a comment

Follow me on Twitter

My Tweets

Follow Me

  • X
  • LinkedIn
  • YouTube
  • Instagram
Blog at WordPress.com.
  • Subscribe Subscribed
    • Technology Geek
    • Join 72 other subscribers
    • Already have a WordPress.com account? Log in now.
    • Technology Geek
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar