RE: Profiling Java Stored Procedures
Date: Tue, 17 Mar 2015 11:12:54 -0400
Message-ID: <82D67D213EB2744C8CBF9BE50C615F6501104F05_at_NSTMC708PEX.ubsamericas.net>
I had done something like this sometime back but cant find the details now
Did a quick check with uncle Google and came across this – hopefully it helps
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:45027262935845
Additionally the MOS doc may be helpful
Where Does System.Out.Println Go When Using JSP In OJVM? (Doc ID 781200.1)
Regards
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield
Sent: Tuesday, March 17, 2015 6:18 AM
To: ORACLE-L
Subject: Profiling Java Stored Procedures
Morning/Afternoon/Evening all
We recently had a situation where a stored procedure was performing slowly in one environment but quickly in a second. Naturally the dba looking at this issue traced the session, only to discover that the time was all attributed to an exec call for a stored procedure. It turns out that this stored procedure is in fact a java stored procedure.
Is it possible to profile the execution of java stored procedures in the same way that one can profile a pl/sql procedure. The documentation suggests that it probably is, if the java class was compiled with debug information (it probably wasn't).
Even better are there any reliable examples of this on the web that I could look at.
FWIW this particular piece of code does some CPU intensive work that doesn't modify data, so the choice of a JSP looks reasonable.
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Please visit our website at
http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html
for important disclosures and information about our e-mail
policies. For your protection, please do not transmit orders
or instructions by e-mail or include account numbers, Social
Security numbers, credit card numbers, passwords, or other
personal information.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 17 2015 - 16:12:54 CET