################################################## DBI Profile Data (DBI::ProfileDumper::Apache 1.0) ################################################## Program : /dev/null Path : [ DBIprofile_Statement ] Total Records : 5 (showing 5, sorted by total) Total Count : 3898 Total Runtime : 1.368898 seconds #####[ 1 ]########################################################### Count : 2348 Total Time : 0.625598 seconds Longest Time : 0.066659 seconds Shortest Time : 0.000004 seconds Average Time : 0.000266 seconds Key 1 : #####[ 2 ]########################################################### Count : 1151 Total Time : 0.461348 seconds Longest Time : 0.109629 seconds Shortest Time : 0.000022 seconds Average Time : 0.000401 seconds Key 1 : SELECT ind_excl, ind_cgld, val_sgl, desc_sis, dth_vrfc_note, dth_crco, nom_prpt, ind_reqr_comp_desenv, ind_reqr_dirt_ctlg FROM TBGF0037 WHERE cod_sis=? #####[ 3 ]########################################################### Count : 3 Total Time : 0.225426 seconds Longest Time : 0.225036 seconds Shortest Time : 0.000083 seconds Average Time : 0.075142 seconds Key 1 : INSERT INTO TBGF0037 (cod_sis, ind_excl, ind_reqr_dirt_ctlg, val_sgl, ind_cgld, ind_reqr_comp_desenv, dth_crco, nom_prpt, dth_vrfc_note, desc_sis) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) #####[ 4 ]########################################################### Count : 5 Total Time : 0.045541 seconds Longest Time : 0.024365 seconds Shortest Time : 0.000024 seconds Average Time : 0.009108 seconds Key 1 : SELECT TBGF0037_seq.NEXTVAL from DUAL #####[ 5 ]########################################################### Count : 391 Total Time : 0.010985 seconds Longest Time : 0.001773 seconds Shortest Time : 0.000012 seconds Average Time : 0.000028 seconds Key 1 : SELECT cod_sis FROM TBGF0037 ################################################## ################################################## # TMON Insert Profile ################################################## Total Elapsed Time = 26.59694 Seconds User+System Time = 1.656940 Seconds Exclusive Times %Time ExclSec CumulS #Calls sec/call Csec/c Name 33.5 0.556 1.325 3443 0.0002 0.0004 Class::Accessor::__ANON__ 10.3 0.172 0.172 28807 0.0000 0.0000 Class::DBI::Column::__ANON__ 9.60 0.159 0.159 391 0.0004 0.0004 DBD::Oracle::st::_prepare 8.39 0.139 0.139 387 0.0004 0.0004 DBI::st::execute 7.79 0.129 0.909 3 0.0431 0.3029 Catalyst::Engine::Apache::MP13::Base::handler 4.59 0.076 0.233 387 0.0002 0.0006 DBIx::ContextualFetch::st::_untaint_execute 4.53 0.075 0.140 2 0.0376 0.0701 Class::DBI::retrieve_all 3.98 0.066 1.532 3471 0.0000 0.0004 Template::Stash::XS::get 2.72 0.045 0.295 387 0.0001 0.0008 DBD::Oracle::db::ping 2.35 0.039 0.039 384 0.0001 0.0001 DBI::st::fetchrow_array 2.29 0.038 0.038 391 0.0001 0.0001 DBI::_new_sth 1.81 0.030 0.030 3 0.0100 0.0100 Template::Context::include 1.75 0.029 0.029 383 0.0001 0.0001 Class::Date::string 1.75 0.029 0.029 384 0.0001 0.0001 DBI::st::finish 1.69 0.028 0.028 774 0.0000 0.0000 DBI::common::DESTROY ################################################## ################################################## DBI Profile Data (DBI::ProfileDumper::Apache 1.0) ################################################## Program : /dev/null Path : [ DBIprofile_Statement ] Total Records : 3 (showing 3, sorted by total) Total Count : 1957 Total Runtime : 0.615580 seconds #####[ 1 ]########################################################### Count : 1181 Total Time : 0.322572 seconds Longest Time : 0.052478 seconds Shortest Time : 0.000003 seconds Average Time : 0.000273 seconds Key 1 : #####[ 2 ]########################################################### Count : 579 Total Time : 0.286691 seconds Longest Time : 0.109583 seconds Shortest Time : 0.000024 seconds Average Time : 0.000495 seconds Key 1 : SELECT ind_excl, ind_cgld, val_sgl, desc_sis, dth_vrfc_note, dth_crco, nom_prpt, ind_reqr_comp_desenv, ind_reqr_dirt_ctlg FROM TBGF0037 WHERE cod_sis=? #####[ 3 ]########################################################### Count : 197 Total Time : 0.006317 seconds Longest Time : 0.001895 seconds Shortest Time : 0.000009 seconds Average Time : 0.000032 seconds Key 1 : SELECT cod_sis FROM TBGF0037 ################################################## # TMON List Profile ################################################## Total Elapsed Time = 9.674284 Seconds User+System Time = 0.934284 Seconds Exclusive Times %Time ExclSec CumulS #Calls sec/call Csec/c Name 44.3 0.414 0.774 1726 0.0002 0.0004 Class::Accessor::__ANON__ 16.7 0.156 0.156 14395 0.0000 0.0000 Class::DBI::Column::__ANON__ 8.56 0.080 0.080 194 0.0004 0.0004 DBD::Oracle::st::_prepare 5.03 0.047 0.944 1 0.0475 0.9443 Catalyst::Engine::Apache::MP13::Base::handler 4.28 0.040 0.040 193 0.0002 0.0002 DBI::st::execute 4.17 0.039 0.087 1 0.0388 0.0875 Class::DBI::retrieve_all 2.14 0.020 0.020 1 0.0200 0.0200 DynaLoader::bootstrap 2.14 0.020 0.020 1 0.0200 0.0200 DBD::Oracle::db::_login 2.14 0.020 0.020 193 0.0001 0.0001 DBD::_::db::prepare_cached 2.03 0.019 0.068 193 0.0001 0.0004 DBIx::ContextualFetch::st::_untaint_execute 1.82 0.017 0.878 1731 0.0000 0.0005 Template::Stash::XS::get 1.07 0.010 0.010 1 0.0100 0.0100 Template::Context::include 1.07 0.010 0.010 5 0.0020 0.0020 base::import 1.07 0.010 0.010 192 0.0001 0.0001 DBI::st::finish 1.07 0.010 0.010 192 0.0001 0.0001 Class::Date::string ##################################################