Session Clear

 Select 'alter system kill session '''|| sid_serial#||''''||chr(010)||'/' from locked_objects_info_vu

Where status='INACTIVE'

/

Select * From v$session

Where blocking_session is not null

/

Select 'alter system kill session '''|| sid||','||serial# ||''''||chr(010)||'/' 

From v$session 

Where blocking_session is not null

/

select program,count(*)

from v$session

group by  program

order by  2 desc

/

Select * from v$resource_limit where resource_name = 'processes'

/

Select 

ROUND((ROUND(104793.147*140,2)*65)/100,2)/18 From dual  

/

Select 'alter system kill session '''|| sid||','||serial#||''''||chr(010)||'/' 

from  v$session

where program is null and status = 'INACTIVE'

/