u012952442的博客

CREATE OR REPLACE FUNCTION create_code (p_code varchar2,p_length number) return VARCHAR2 as PRAGMA AUTONOMOUS_TRANSACTION;  v_count number; v_code varchar2(40); v_lock code_base%rowtype; begin

with t as  (select '打包' t， to_char(q.provider_code || '共' || count(1) || '个包裹') n     from rnrsbrand.query_auction q    where q.status in (2, 3)    group by q.provider_code   union   select '捆包'

1、按物理读 读取磁盘次数   select s.SQL_FULLTEXT,s.DISK_READS/s.EXECUTIONS  from v$sqlarea s where s.EXECUTIONS >0 and s.DISK_READS >1000   order by s.DISK_READS/s.EXECUTIONS desc   2.、按内存消耗   select s.SQL

1、   oracle sys_context()函数 select sys_context('USERENV','AUTHENTICATION_TYPE') from dual;--用户的认证类型 select sys_context('USERENV','BG_JOB_ID') from dual;--当前指定id的会话是否为oracle后台程序建立，不是则返回null sele