Обои Оракуля Ж))

*** ACTION NAME:(Test Window - Script for procedu) 2006-05-21 16:38:29.770
*** MODULE NAME:(PL/SQL Developer) 2006-05-21 16:38:29.770
*** SERVICE NAME:(ITBDH) 2006-05-21 16:38:29.770
*** SESSION ID:(38.33246) 2006-05-21 16:38:29.770
=====================
PARSING IN CURSOR #2 len=309 dep=0 uid=44 oct=42 lid=44 tim=3376600055 hv=1118600677 ad='1d8650f0'
--alter session set tracefile_identifier = 'KKKMBM3'
alter session set events '10046 trace name context forever, level 12'
/*begin
  -- Call the procedure
  ms_sql_rulez(p_id_dimension => :p_id_dimension);
end;
*/
--select * from tmp_mbm_source
--select * from mbm_dimelement de where de.ip_source=16173410
END OF STMT
EXEC #2:c=0,e=136,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=3376600046
WAIT #2: nam='SQL*Net message to client' ela= 5 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=3376605197
WAIT #2: nam='SQL*Net message from client' ela= 32915 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=3376638317
=====================
PARSING IN CURSOR #4 len=61 dep=0 uid=44 oct=47 lid=44 tim=3376638686 hv=356401299 ad='19cefe3c'
begin :id := sys.dbms_transaction.local_transaction_id; end;
END OF STMT
PARSE #4:c=0,e=45,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=3376638680
BINDS #4:
kkscoacd
 Bind#0
  oacdty=01 mxl=4000(4000) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=01 csi=171 siz=4000 off=0
  kxsbbbfp=050bc95c  bln=4000  avl=00  flg=05
WAIT #4: nam='SQL*Net message to client' ela= 4 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=3376640127
EXEC #4:c=0,e=950,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=3376640283
WAIT #4: nam='SQL*Net message from client' ela= 962 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=3376641432
=====================
PARSING IN CURSOR #2 len=73 dep=0 uid=44 oct=47 lid=44 tim=3376641761 hv=2674323898 ad='1a324ff8'
begin
  sys.dbms_output.get_line(line => :line, status => :status);
end;
END OF STMT
PARSE #2:c=0,e=43,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=3376641755
BINDS #2:
kkscoacd
 Bind#0
  oacdty=01 mxl=4000(4000) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=01 csi=171 siz=4000 off=0
  kxsbbbfp=050bc95c  bln=4000  avl=00  flg=05
 Bind#1
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=01 fl2=1000000 frm=00 csi=00 siz=24 off=0
  kxsbbbfp=050bdcf0  bln=22  avl=00  flg=05
WAIT #2: nam='SQL*Net message to client' ela= 4 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=3376643807
EXEC #2:c=0,e=1360,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=3376643959
WAIT #2: nam='SQL*Net message from client' ela= 868 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=3376645029