ITPub博客

ANALYZE TABLE emp VALIDATE STRUCTURE;  --验证表结构ANALYZE TABLE emp VALIDATE STRUCTURE CASCADE;  --验证表结构，同时验证相关依赖的对象，索引等ANALYZE TABLE emp VALIDATE STRUCTURE CASCADE FAST;  --快速验证，优化检查算法ANALYZE TABLE emp VALIDATE STRUCTURE CASCADE ONLINE; --同时存...

select *  from (select acc_id, max(tran_dt) tran_dt          from a         where tran_cd = '103'         group by acc_id) z where exists (select null &...

pax 压缩大于8G的文档，tar只能压缩<8G的，pax替换路径，-s:^/:./:g 变为相对路径AIX Version 7Copyright IBM Corporation, 1982, 2012.login: tuxedo2tuxedo2's Password: ********************************************************************************        &n...

SQL> select * from v$log;GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------- ------------ --------------1 1 72 52428800 5...

iptables -t filter -A INPUT -p tcp --dport 22 -j LOG --log-prefix "port:22"tail -f /var/log/message

linuxattacker@bt:~$ echo $PS1\[\e]0;\u@\h: \w\a\]${debian_chroot:+($debian_chroot)}\u@\h:\w\$attacker@bt:~$ attacker@bt:~$ uname -aLinux bt 3.2.6 #1 SMP Fri Feb 17 10:40:05 EST 2012 i686 GNU/Linuxattacker@bt:~$ uname -nbtattacker@bt:~$ unameLinuxAIXexport PS1="[$LOGNAME@`uname -n...

SELECT UNIQUE me.ELEM_NAME, mf.FILE_NAME  FROM V$MAP_FILE_IO_STACK fs, V$MAP_FILE mf, V$MAP_ELEMENT me WHERE mf.FILE_MAP_IDX = fs.FILE_MAP_IDX   AND me.ELEM_IDX = fs.ELEM_IDX   AND me.ELEM_NAME = '/dev/vx/rdmp/c2t1d1s2';-- query file_name, element_nameWITH fv AS...