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

Posted on 2012-09-08
Last Modified: 2012-09-11
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?
Question by:sakthikumar
    LVL 37

    Expert Comment

    by:Gerwin Jansen
    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?
    LVL 73

    Accepted Solution

    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

    Author Comment

    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?
    LVL 73

    Expert Comment

    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.
    LVL 37

    Expert Comment

    by:Gerwin Jansen
    Just curious: how did you solve the issue?

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now