/usr/lib/oracle/xe/app/oracle/admin/XE/udump/xe_ora_5482.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: 5482, image: oracle@seat (TNS V1-V3)

*** ACTION NAME:() 2009-08-18 23:19:56.969
*** MODULE NAME:(SQL*Plus) 2009-08-18 23:19:56.969
*** SERVICE NAME:(SYS$USERS) 2009-08-18 23:19:56.969
*** SESSION ID:(29.110) 2009-08-18 23:19:56.969
=====================
PARSING IN CURSOR #1 len=35 dep=0 uid=36 oct=42 lid=36 tim=1221318747040367 hv=3545163288 ad='2d3b1620'
alter session set sql_trace = true 
END OF STMT
EXEC #1:c=0,e=599,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1221318747040357
=====================
PARSING IN CURSOR #3 len=52 dep=0 uid=36 oct=47 lid=36 tim=1221318747041432 hv=1029988163 ad='2d3b1324'
BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;
END OF STMT
PARSE #3:c=0,e=121,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1221318747041424
EXEC #3:c=0,e=848,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=1,tim=1221318747042489
=====================
PARSING IN CURSOR #3 len=1208 dep=0 uid=36 oct=47 lid=36 tim=1221318747046148 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=578,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1221318747046137
=====================
PARSING IN CURSOR #1 len=37 dep=1 uid=36 oct=3 lid=36 tim=1221318747048014 hv=1263932083 ad='2d3968e0'
SELECT * FROM HOSTNAME_MAPPING_ARRAY 
END OF STMT
PARSE #1:c=0,e=91,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=1221318747048006
EXEC #1:c=0,e=155,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=1221318747048285
FETCH #1:c=0,e=289,p=0,cr=3,cu=0,mis=0,r=8,dep=1,og=1,tim=1221318747048636
EXEC #3:c=1908118,e=1911505,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=1,tim=1221318748958260
=====================
PARSING IN CURSOR #4 len=52 dep=0 uid=36 oct=47 lid=36 tim=1221318748959993 hv=1029988163 ad='2d3b1324'
BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;
END OF STMT
PARSE #4:c=0,e=49,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1221318748959985
EXEC #4:c=0,e=260,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=1221318748960451
=====================
PARSING IN CURSOR #4 len=36 dep=0 uid=36 oct=42 lid=36 tim=1221318748963642 hv=2321248321 ad='2d398968'
alter session set sql_trace = false 
END OF STMT
PARSE #4:c=0,e=117,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1221318748963633
EXEC #4:c=0,e=256,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1221318748963998