Hi, Thanks for Devel::NYTProf 3.
I have a daemon process which sits in DBI->execute for long periods of time because it has called Oracle's dbms_alert.waitany to wait for an alert. Once some procedure issues an alert the execute unblocks, we find out what alert was issued and then call another procedure to obtain work to do. Running Devel::NYTProf on this daemon we get > 95% of the time in DBI->execute blocked in waitany :-( - this makes it more difficult to home in on the areas needing attention. I tried setting usecputime=1 but got huge numbers like this: 111 1 1 2186934044s 4876069979s XXX::Data::Generation::refreshXXXLists and yet the daemon ran for around 5 minutes for that run. I looked for different clocks as recommended in usecputime but I only have: /usr/include/bits/time.h:# define CLOCK_REALTIME 0 /usr/include/bits/time.h:# define CLOCK_MONOTONIC 1 /usr/include/bits/time.h:# define CLOCK_PROCESS_CPUTIME_ID 2 /usr/include/bits/time.h:# define CLOCK_THREAD_CPUTIME_ID 3 and none of these help. I tried running with start=no and calling enable_profile and disable_profile but the problem is that the code outside of the waitany unblocking is in various loops and every time enable_profile is called a new nytprof.out file is created (losing me all the previous data). There is no place I can put the enable_profile/ disable_profile which is not in a loop. Is there any way around this?
-- You've received this message because you are subscribed to the Devel::NYTProf Development User group. Group hosted at: http://groups.google.com/group/develnytprof-dev Project hosted at: http://perl-devel-nytprof.googlecode.com CPAN distribution: http://search.cpan.org/dist/Devel-NYTProf To post, email: [email protected] To unsubscribe, email: [email protected]
