<div>
You can monitor the sessions with for example SQL Devoper and observe the last statement executed, this can be a single statement or a procedure call. What are you looking for exactly?
</div>


You can monitor the sessions with for example SQL Devoper and observe the last statement executed, this can be a single statement or a procedure call. What are you looking for exactly?

<div>
I dont know which procedure/package is called.<br />
<br />
I will try with trace sessions.<br />
<br />
But any v$views available, through which I can find out?
</div>


I dont know which procedure/package is called.

I will try with trace sessions.

But any v$views available, through which I can find out?

<div>
if you don't see it in v$sql, then no, not really<br />
<br />
do you have your procedures intrumented?<br />
if not, it's never too late to start.
</div>


if you don't see it in v$sql, then no, not really

do you have your procedures intrumented?
if not, it's never too late to start.

<div>
Just curious: how did you solve the issue?
</div>


Just curious: how did you solve the issue?

<div>
<div class="content wysiwyg-content">
I Wanted to know which DB procedure / package is called in java code when running a java Application.<br />
<br />
I am running a java application which calls backend procedures / packages.<br />
<br />
Is there any way to get the name of the procedure / package that is called in java code?<br />
<br />
Can I able to find out in v$sql... or some other views?
</div>
</div>


I Wanted to know which DB procedure / package is called in java code when running a java Application.

I am running a java application which calls backend procedures / packages.

Is there any way to get the name of the procedure / package that is called in java code?

Can I able to find out in v$sql... or some other views?

I Want to know which DB procedure / package is called in java code when running a java Application

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.