Current Position:Home > How do I find out what I'm doing in a package ? v$sql ? etc.

How do I find out what I'm doing in a package ? v$sql ? etc.

Update:11-30Source: network consolidation
I'm running Linux and trying to find out at what point a process is at.
It is running a procedure in a package, lets say. Package_main.main(). If I join v$session to any of v$sql,v$sqlarea,v$sqltext all I get is the sql text relating to the "package_main.main()" call. I want to find out what point in the PL/SQL statck the execution is : what view should I be looking at ?
johnnie d

The Best Answer

I believe the problem you are describing has been identified as a design feature for 10g+. I have not spent any time looking at the issue.
If you do not need immediate access but want to see what a session was doing you might be able to turn on sql trace for an active session and then review the trace file after you have allowed the trace to run long enough to capture what SQL is being executed.
Being that all SQL would have a child cursor there should be a way to tie sql from within pl/sql being executed to the session executing the stored code. I just have not looked into this. Maybe someone else has.
HTH -- Mark D Powell --
  • Problem with threads in j2me Update:10-11

    im using jdk 1.6 with java wtk 2.1 ya i know.. 2.1 is a jdk1.4 source but im using souce as 1.4 during compiliation so thats not the prob this is my code package org.learn; import javax.microedition.midlet.MIDlet; import javax.microedition.lcdui.Aler

  • Problem with threads... Update:10-11

    HI friends... I am trying to make a server with a logging facility... Let me explain the schema of the process... 1. the server starts as a thread and listens on port 9999 for any client. 2. when a client is accepted a PROCESS thread is started and t

  • It hangs when I login DB Update:10-11

    It has no response when I try to login database. I cancel the login since I don't have any choices SQL> connect apps/apps ^CERROR: ORA-00604: error occurred at recursive SQL level 1 ORA-01013: user requested cancel of current operation But it is ok i

  • MSI Forum Lock Ups Update:10-11

    Hey guys wondering where i have been the last couple of days??, you guessed wrong i was not with my girlfriend (well at least no during daytime :D ) I was trying to LOGIN IN THE F*****G FORUM :O  ?( Markoul p.s. At least it seems now we are goin

  • Eclipse Community Forums Update:10-11

    Hi, I have a problem using Xtext generated ecore files in both Eclipse and standalone Java. In a nutshell, Xtext generates relative ecore references which work fine in Eclipse for platform:/resource URIs which make it seem like all projects are sibli

  • Open Interface Rejects - SQL Report Update:10-11

    Hi guys, I'm trying to help out some folks in AP with an easier access to view Open Interface rejects. I already knew the relation between AP_INVOICES_INTERFACE and AP_INTERFACE_REJECTIONS was INVOICE_ID AND PARENT_ID (respectively). Now I've seen th

  • Wrong 'mini dvi to video' adapter for my 12" Powerbook 1.33 Update:10-11

    I recently bought the M9319 mini dvi - video adapter for my 12" Powerbook 1.33 to find that the mini dvi on the adapter is a different size to the one on the computer and the adapters supplied with the computer. I've been doing a bit of research into

  • Error in cast a variable Update:10-11

    these are few lines from my long STORED PROCEDURE actually i am new to oracle 11g please declare v_s nvarchar2(10); p_RN nvarchar2(10); begin v_s := v_s || cast(p_RN as nvarchar2(10)); - ERROR IS COMING IN THIS LINE end; error ORA-06550: line 5, colu

  • Error while Creating Presentation variable Update:10-11

    Hi,I am new to OBIEE I am facing this error: "A numeric value was expected (received "max("Sales Measures".Dollars)"). Error Details Error Codes: EHWH2A7E" 1.I am using paint rpd.I want to use presentation variable. 2.So i to

  • SSRS Expression Month at a glance Update:10-11

    I have a report that I am trying to regress the payment sums out month by month. I know how to do this in SQL, but no idea in SSRS. Below is what I would like the table to look like. Year                             Month                  Total Payme