Skip to content

DBA'S UTILITY BELT

  • Begins
  • Aboutman
  • Utility Belt
  • UB Summary

Category: Session

Instance, Session

Listing Sessions Connected by SID

11 de May de 201811 de May de 2018 matheusdba

“Holy wrong way to connect, DBAtman!”
Yeah Robin, let’s catch those criminals!

robinbatman60s

When organizing your service names, it’s useful to know if there is any session connecting by SID, right?

It can be done with:

select distinct machine,username,inst_id from gv$session 
where service_name = 'SYS$USERS';

Na, na, na, na, na, na, na, na, na, na, na, na… DBAtman!

Leave a comment

Where is…

Categories

  • ASM (4)
  • AWS (1)
  • Database (3)
  • Database Link (1)
  • Files – TBS|DTFs|DBFiles (1)
  • Indexes (1)
  • Instance (2)
  • Jobs (1)
  • Kill (2)
  • Lock (1)
  • Objects (1)
  • RAC (1)
  • Session (1)
  • Shellscripts (3)
  • SQPlus (2)
  • Statistics (1)
  • Table (1)
  • Temp (1)

Tags

all databases ASM AWS block Database datafie dblink dbms_auto_task_admin disk disks Jobs Kill list Lock maintenance jobs object procedure psid RAC rowid Session shell spid
Create a website or blog at WordPress.com
  • Follow Following
    • dbatman.blog
    • Already have a WordPress.com account? Log in now.
    • dbatman.blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...