Estoy haciendo una prueba con el sistema , estoy tirando un proceso de lanzar outbound para un orden especifica, pero antes deje bloqueada la orden en la tabla tdsls045 con el ttaad4100 , el proceso se me quedo pegado como es evidente, pero mi duda es cuanto tiempo deberia permanecer asi???, lo que yo se, es que después de un tiempo te bota el programa, pero lleva bastante y no pasa nada..... será por el tiempo de espera de la base de datos?... puedo chequear eso??? :confused:

If you translate this to english with google it comes out very funny.

I can't tell exactly what you mean, it's either locking or performance..
you might get somewhere with an ORAPROF

Dave

Thanks, but.... that you mean with a ORAPROF? ... a DBA?

ORAPROF is a way to trace oracle queries in the database.

for example setting:

-- -set ORAPROF=0

in your BW configuration section will create a file called "oraprof"
in your $BSE/tmp or home directory.

the file has query times, etc.

(of course a DBA would be useful as well!) =)

Dave

In BaaN in the "BW configuration" I put the command -- -set ORAPROF=0 , this I generate in my HOME a file “oraprof” which generates to log of sentences oracle, the file is very great, but my question is if this serves me to obtain data about algun problem with the data base or with the application, hopefully that knows this. Perhaps est nonaid in anything.


Here this part of the file oraprof:



------ Profiling value exceeded -----

<pguerrer><tdilce202m000>:2005-11-10[10:21:11.257]:

Time (multi_exec) : 0.000836 seconds

SQL statement:

SELECT /*+ FIRST_ROWS INDEX(a ttdilc401613$idx2) */ a.t$runn,a.t$koor,a.t$orno,a.t$pono,a.t$clot,a.t$cntr,a.t$cprj,a.t$cwar,a.t$date,a.t$fla1$o,a.t$fla2$o,a.t$gene$e,a.t$item,a.t$loca,a.t$ponb,a.t$proc,a.t$qstr,a.t$qsts,a.t$sera,a.t$serb,a.t$stun FROM baan.ttdilc401613 a WHERE (a.t$koor = :1 OR (a.t$cprj >= :2) AND (a.t$cprj <= :3)) AND (a.t$item >= :4) AND (a.t$item <= :5) AND (a.t$cntr >= :6) AND (a.t$cntr <= :7) AND (a.t$cwar >= :8) AND (a.t$cwar <= :9) AND a.t$proc != :10 AND a.t$runn = :11 AND a.t$koor = :12 AND a.t$orno = :13 ORDER BY 1,2,3,4,19,20

-------------------------------------

------ Profiling value exceeded -----

<pguerrer><tdilce202m000>:2005-11-10[10:21:11.258]:

Time (multi_fetch) : 0.000044 seconds

SQL statement:

SELECT /*+ FIRST_ROWS INDEX(a ttdilc401613$idx2) */ a.t$runn,a.t$koor,a.t$orno,a.t$pono,a.t$clot,a.t$cntr,a.t$cprj,a.t$cwar,a.t$date,a.t$fla1$o,a.t$fla2$o,a.t$gene$e,a.t$item,a.t$loca,a.t$ponb,a.t$proc,a.t$qstr,a.t$qsts,a.t$sera,a.t$serb,a.t$stun FROM baan.ttdilc401613 a WHERE (a.t$koor = :1 OR (a.t$cprj >= :2) AND (a.t$cprj <= :3)) AND (a.t$item >= :4) AND (a.t$item <= :5) AND (a.t$cntr >= :6) AND (a.t$cntr <= :7) AND (a.t$cwar >= :8) AND (a.t$cwar <= :9) AND a.t$proc != :10 AND a.t$runn = :11 AND a.t$koor = :12 AND a.t$orno = :13 ORDER BY 1,2,3,4,19,20

-------------------------------------

Those queries are fine. look for one taking greater than 1 second.

Dave

So set

ORAPROF=1.0

Now you get queries longer than 1 sec.

Dick

This forum is English only. Please translate your original post to English!