Showing posts with label script to kill the session in Oracle RAC. Show all posts
Showing posts with label script to kill the session in Oracle RAC. Show all posts

Wednesday, 22 February 2017

script to kill the session in Oracle RAC

select 'alter system kill session '''||sid||','||serial#||',@'||inst_id||''';' from gv$session  where USERNAME='XXXX';

Add Data file

 ************************************************** Database status Tablespace Usage ASM Disk Group Usage(RAC) Backup Filesystem Usage Alert...