[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 615
  • Last Modified:

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

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?
0
sakthikumar
Asked:
sakthikumar
  • 2
  • 2
1 Solution
 
Gerwin Jansen, EE MVETopic Advisor Commented:
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?
0
 
sdstuberCommented:
if you have your packages and procedures instrumented you should be able to determine it fairly easily from your logs.

you can trace sessions to capture activity
0
 
sakthikumarAuthor Commented:
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?
0
 
sdstuberCommented:
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.
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
Just curious: how did you solve the issue?
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now