ITPub博客

http://www.ssc.stn.sh.cn/html/zsk/ITyw/2012-04/5819.html

http://www.ssc.stn.sh.cn/html/zsk/ITyw/2012-04/5819.html

--16进制转10进制,用to_number,里面的参数是16进制的数据,且参数用单引号括起SQL> select to_number('ff','xx') from dual; TO_NUMBER('FF','XX')--------------------     &...

 --查询某个sql对应事务产生的undo数据块select sid, action, module  from v$session where type = 'USER'   AND SCHEMANAME = 'SYS';select vt.used_ublk  from v$transact...

http://space.itpub.net/35489/viewspace-683646

http://space.itpub.net/8984272/viewspace-619964

create or replace procedure proc_bulk_table(x  char(1))as  v_number pls_integer;  v_cnt pls_integer;  v_begin pls_integer;  v_receive char(1);  begin  &...

调试存储过程时,发现产品表中许多列的值可能为null,导致not exists产生结果与所期不符测试如下--构建两个同样表结构的表SQL> desc t_null_column;         &n...

oracle hint1,hint类型   1,适用于单表，如:index和use_nl   2,用于多表,如：leading,use_nl(table1 table2)其实是use_nl(table1)和use_nl(table2)的缩写   3,用于查询块：如...

SQL> select * from t_source;                           &n...

http://blog.csdn.net/wadekobe9/article/details/7738955

http://blog.csdn.net/onemetre/article/details/6525348

SQL> select * from t_order;                           &nb...

　调试某一存储过程时，在plsql developer　debug调试执行时，20多分钟都执行不完，后分析如下： 1,查询调试会话运行存储过程的对应sqlselect sid,serial#,event,status,sql_id,prev_sql_id,action,mod...

16:40:43 SQL> insert into t_direct_table select level from dual connect by level<=1e6; 1000000 rows inserted Executed in 1.108 seconds 16:41:11 SQL> insert into t_direct_table s...

1,v$sqlarea存储由sql_address及hash_value确定的library cache的父游标的信息　　　1,存储内存中,解析，准备执行的sql语句      2,执行过的存储吗2,v$sql存储由sql_address及hash...

SQL> show userUSER 为 "SYS"SQL> alter system flush buffer_cache;系统已更改。SQL> alter system flush shared_pool;系统已更改。SQL> set time on21:51:31 SQL> set timing on21:51:34 SQL> merge /*+ u...

测

http://www.dbtan.com/2009/11/buffer-cache-principle-and-use.html 小结：非常好

http://www.dbtan.com/2009/11/binding-variable-and-cursor_sharing.html 小结：1,柱状图2,绑定变量,peeking3,cursor_sharing:force,similar,exact4,version count,5,cursor x on pin ...