- 博客(5)
- 收藏
- 关注
转载 V$SQLTEXT,V$SQL,V$SQLAREA的区别
<br />v$sqltext<br />存储的是完整的SQL,SQL被分割<br /><br />SQL> desc v$sqltext<br />Name Null? Type<br />----------------------------------------- -------- ----------------------------<br />ADDRESS
2010-11-25 20:15:00 494
原创 Oracle读书列表
<br />--读过的<br />oracle expert one on one<br /> <br />--在读的<br />troubleshooting oracle performance <br /> <br />--将要读的<br />Optimizing oracle performance
2010-11-22 21:43:00 461
原创 常用到的query
<br />how to have one session id in oracle:<br />SQL> select sys_context('USERENV','sid') from dual; <br />HOw to have the lock of this session<br />select s.osuser,l.id1,l.id2,l.lmode,l.request,l.block,l.type <br />from v$session s, v$lock l <
2010-11-04 16:32:00 887
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人