Oracle Session Tips
Check the session’s information.
SQL> select b.MACHINE, b.PROGRAM , count(*) from v$process a, v$session b where a.ADDR = b.PADDR and b.USERNAME is not null group by b.MACHINE , b.PROGRAM order by count(*) desc;
MACHINE PROGRAM COUNT(*)
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------ ----------
iZwz92mfhsio3n38nswnocZ JDBC Thin Client 1
izwz9fw6w9bctb8caet90bz sqlplus@izwz9fw6w9bctb8caet90bz (TNS V1-V3) 1
SQL>
SQL> select username,count(username) from v$session where username is not null group by username
2 ;
USERNAME COUNT(USERNAME)
------------------------------------------------------------ ---------------
APPS 1
SYS 1
SQL>
Session:
select * from v$session where username is not null;
Process:
select count(*) from v$process;
To be continue….
Have a good life! 2018/07 via LinHong
Tar命令常用选项
见图:

举例:
tar命令解压时,去除目录结构加上–strip-components N
如: 压缩文件aa.tar 中文件信息为 d1/d2/d3/eg.txt
运行 tar -xvf aa.tar --strip-components 1
结果:d2/d3/eg.txt
如果运行 tar -xvf aa.tar --strip-components 3
解压结果为: eg.txt
rlwrap is a ‘readline wrapper’, a small utility that uses the GNUreadline library to allow the editing of keyboard input for any command