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
Oracle Recovery 05 - How to use BBED to recovery miss-archivelog file?
Use bbed to skip the miss archivelog file to recover database.
Oracle Data Skew Basic knowledge
The test cases for data skew.
Not use Bind Variable Use Bind Variable Other cases