ITPub博客

首先来参考一下oracle 11.2的新特性，递归查询http://www.oracle.com/technetwork/cn/articles/hartley-recursive-086819-zhs.html小试一下使用with递归来解决问题题目是啤酒 2元1瓶      4个瓶盖换1瓶      2个空瓶换1瓶10元可以喝几瓶---------------------------------------...

早上检查测试环境中的备份发现备份成功但有错误，rman日志如下：----------------------------------------------------------------Starting Control File and SPFILE Autobackup at 08-JUN-16piece handle=+FRADG/db/autobackup/2016_06_08/s_913946012.2577.913946015 comment=NONEFinished Control File and SPFILE...

DG 上 ORA-01157: cannot identify/lock data file 处理办法

oracle set event 的多种方法

以v$session为例1.       首先想到的是v$fixed_view_definition中对动态视图的定义然后可以看到查询的是GV$SESSION2.       在使用v$fixed_view_definition来查询GV$SESSION但是很可惜，这个时候发现definition显示不全3.&nb...

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...