Advertisement
Guest User

Untitled

a guest
Oct 20th, 2016
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. ssh $(id -u -n)@dbserver "java -jar ~/.m2/repository/net/sqlworkbench/sqlworkbench/117/sqlworkbench-117.jar -url=jdbc:oracle:thin:@dbserver:1521:name -driver=oracle.jdbc.OracleDriver "-driverjar=/home/$(id -u -n)/.m2/repository/com/oracle/ojdbc7/12.2.0.2/ojdbc7-12.2.0.2.jar" -username=USER -password=PW -displayResult=true -command='select substr(a.spid,1,9) pid, substr(b.sid,1,5) sid,substr(b.serial#,1,5) ser#, substr(b.machine,1,6) box, substr(b.username,1,10) username, substr(b.osuser,1 ,8) os_user, substr(b.program,1,30) program from v\$session b, v\$process a where b.paddr = a.addr and type='\"'\"'USER'\"'\"' and b.osuser='\"'\"'$(id -u -n)'\"'\"' order by spid;'"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement