rasti.hil@hilandco.com +41 79 367-9677

Search This Blog

Ora-01940 how to kill session


select s.sid, s.serial#, s.status, p.spid
from v$session s, v$process p
where upper(s.username) = upper('USERNAME')
and p.addr (+) = s.paddr;

alter system kill session '<s.sid>,<s.serial#>';

Linux add a swap file howto

Procedure to add a swap file
1.

su - root

2.

dd if=/dev/zero of=/swapfile1 bs=1M count=1000

3.

mkswap /swapfile1

4.

swapon /swapfile1

5.

vi /etc/fstab
/swapfile1 swap swap defaults 0 0

6.

free -m