Skip to content

DBA'S UTILITY BELT

  • Begins
  • Aboutman
  • Utility Belt
  • UB Summary

Tag: AWS

AWS, Kill

Killing Sessions in RDS Oracle

6 de July de 201826 de April de 2018 matheusdba

“Holy RDS commands, DBAtman!”

ALTER SYSTEM KILL SESSION scripts not working anymore?
Create the @killrds.sql:

begin
rdsadmin.rdsadmin_util.kill(
sid => &sid,
serial => &serial);
end;
/

Na, na, na, na, na, na, na, na, na, na, na, na… DBATman!

Tagged AWS, Kill, SessionLeave 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