/usr/lib/oracle/xe/app/oracle/admin/XE/udump/xe_ora_5568.trc
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
System name:	Linux
Node name:	seat
Release:	2.6.28-11-generic
Version:	#42-Ubuntu SMP Fri Apr 17 01:57:59 UTC 2009
Machine:	i686
Instance name: XE
Redo thread mounted by this instance: 1
Oracle process number: 20
Unix process pid: 5568, image: oracle@seat (TNS V1-V3)

*** ACTION NAME:() 2009-08-18 23:20:35.876
*** MODULE NAME:(SQL*Plus) 2009-08-18 23:20:35.876
*** SERVICE NAME:(SYS$USERS) 2009-08-18 23:20:35.876
*** SESSION ID:(29.114) 2009-08-18 23:20:35.876
=====================
PARSING IN CURSOR #1 len=35 dep=0 uid=36 oct=42 lid=36 tim=1221318785035675 hv=3545163288 ad='2d3b1620'
alter session set sql_trace = true 
END OF STMT
EXEC #1:c=0,e=611,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1221318785035666
=====================
PARSING IN CURSOR #3 len=52 dep=0 uid=36 oct=47 lid=36 tim=1221318785036864 hv=1029988163 ad='2d3b1324'
BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;
END OF STMT
PARSE #3:c=0,e=123,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1221318785036856
EXEC #3:c=0,e=935,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=1,tim=1221318785038009
=====================
PARSING IN CURSOR #3 len=1208 dep=0 uid=36 oct=47 lid=36 tim=1221318785041890 hv=2117980860 ad='2d3c4bc8'
declare
  v_start            number                                    ;
  v_hostalias        hostname_mapping_array.hostalias%type     ;
  v_enterprise_id    hostname_mapping_array.enterprise_id%type ;
  v_hostname         varchar2(255)                             ;
Begin
  v_hostalias      :=  'BIS-INTERN' ;
  v_enterprise_id  :=  1            ;
  dbms_output.put_line('Beginn des Prozess ARRAY, der die Tabelle benutzt');
  v_start  := dbms_utility.get_time;
  for i in 1 .. 100000
  loop
    v_hostname       := bis_utils_array.get_host_url(v_hostalias, v_enterprise_id);
  end loop ;
  dbms_output.put_line('Ende des Prozess ARRAY. Zeit verbraucht : ' ||
                       round( (dbms_utility.get_time-v_start)/100, 2 ) ||
                       ' seconds' );
  dbms_output.put_line('Beginn des Prozess ARRAY, der die Tabelle benutzt');
  v_start  := dbms_utility.get_time;
  for i in 1 .. 100000
  loop
    v_hostname       := bis_utils_array.get_host_url(v_hostalias, v_enterprise_id);
  end loop ;
  dbms_output.put_line('Ende des Prozess ARRAY. Zeit verbraucht : ' ||
                       round( (dbms_utility.get_time-v_start)/100, 2 ) ||
                       ' seconds' );
End ;
END OF STMT
PARSE #3:c=0,e=212,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1221318785041882
=====================
PARSING IN CURSOR #1 len=37 dep=1 uid=36 oct=3 lid=36 tim=1221318785044106 hv=1263932083 ad='2d3968e0'
SELECT * FROM HOSTNAME_MAPPING_ARRAY 
END OF STMT
PARSE #1:c=0,e=97,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=1221318785044097
EXEC #1:c=0,e=162,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=1221318785044391
FETCH #1:c=0,e=305,p=0,cr=3,cu=0,mis=0,r=8,dep=1,og=1,tim=1221318785044735
EXEC #3:c=1920120,e=1894956,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=1,tim=1221318786937206
=====================
PARSING IN CURSOR #4 len=52 dep=0 uid=36 oct=47 lid=36 tim=1221318786937968 hv=1029988163 ad='2d3b1324'
BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;
END OF STMT
PARSE #4:c=0,e=48,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1221318786937959
EXEC #4:c=0,e=259,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=1221318786938422
=====================
PARSING IN CURSOR #4 len=36 dep=0 uid=36 oct=42 lid=36 tim=1221318786940963 hv=2321248321 ad='2d398968'
alter session set sql_trace = false 
END OF STMT
PARSE #4:c=0,e=110,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1221318786940956
EXEC #4:c=0,e=263,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1221318786941878