Slide
‹#› of 37
Connection Pooling (2)
uTemporary tables cleanup
procedure p_truncate
is
v_exist_yn varchar2(1);
Begin
select 'Y' into v_exist_yn
u from v$session s, v$tempseg_usage u
where s.audsid =
SYS_CONTEXT('USERENV','SESSIONID')
u and
s.saddr = u.session_addr
u and
u.segtype = 'DATA'
u and rownum = 1;
for c in (select table_name from
user_table
where temporary = 'Y‘
and duration = 'SYS$SESSION')
loop
execute immediate 'truncate table
'||c.table_name;
u end loop;
uend;
