select 'alter system kill session '''||sid||','||serial#||',@'||inst_id||''';' from gv$session where USERNAME='XXXX';
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
Subscribe to:
Posts (Atom)
Add Data file
************************************************** Database status Tablespace Usage ASM Disk Group Usage(RAC) Backup Filesystem Usage Alert...
-
************************************************** Database status Tablespace Usage ASM Disk Group Usage(RAC) Backup Filesystem Usage Alert...
-
Property Description Parameter type : Integer Default value : 1 Modifiable : ALTER SESSIO...
-
ORA-00900 invalid SQL statement Cause: The statement is not recognized as a valid SQL statement. This error can occur if the Procedural O...