jis117的专栏

[code="sql"] -- Create database link create public database link HPC2 connect to xx identified by xx using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.71.150....

[code="sql"] create or replace function f_user_qr_qrycalloutuser ( i_in_querytype in number, str_o_result out varchar2 ) return sys_refcursor is cur_result sys_refcursor; begi...

[code="sql"] declare jobno integer; begin dbms_job.submit(job =>jobno , what =>'p_ivr_deleteoutboundinfo;', next_date => trunc(...

[code="sql"] 军规一：【恰当控制事务大小，commit不要过于频繁。】 军规二：【在OLTP系统中一定要注意使用绑定变量。】 军规三：【在OLTP系统中一定要注意复杂的多表关联不宜超过4个，关联十分复杂时，需要拆分成多个步骤，防止执行计划不正确。】 军规四：【合理收集统计信息，固定住SQL的执行计划。】 军规五：【尽量避免使用XA事务，在RAC环境中要避免XA事务跨节点操作。...

[code="sql"] show parameter disk_asynch_io; [/code] [code="sql"] oracle@SUSE185:~> sqlplus SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 15 17:07:15 2014 Copyright (c) 1982, 2011, Ora...

[code="sql"] set serverout on; DECLARE CURSOR c_dept IS select distinct a.username, b.profile, b.resource_name, b.limit from dba_users a, dba_profiles b where a.profile = b.profile and a.profile...

[code="sql"] select TO_DATE('01/01/1970', 'MM/DD/YYYY') + r.starttime / 86400000 + TO_NUMBER(SUBSTR(TZ_OFFSET(sessiontimezone), 1, 3)) / 24 into startdate select...

[code="text"] oracle给查询的条件建立索引后如何使用啊 2013-04-17 08:41 拳卧撑8 | 分类：数据库DB | 浏览323次 select * from A where b=‘’,c='';我给b和c建立了组合索引程序使用索引啊 程序oracle优化器认索引效率更高时会自动调用索引也显式调用索引 select /*+index(A,索引名)*...