View and kill of Oracle current session (number of connections) (process)

1. View Oracle Current session (number of connections) (process)

SELECT sid,serial#,process,logon_time,username,program,status, "' | | sid| | ', ' | | serial#| | "

From V$session
WHERE USERNAME = ' opxx '--User name
and program = ' aspnet_wp.exe '--connector
ORDER by Logon_time DESC

2. Kill session (number of connections) (process)

Executes after multiple kill statements are generated.

Select ' Alter system kill session ' | | Sid | | ', ' | | serial# | | '; '

From V$session
WHERE USERNAME = ' Opxx '
and program = ' aspnet_wp.exe '
ORDER by Logon_time DESC

View and kill of Oracle current session (number of connections) (process)