Finding Package running behind a concurrent request

Finding Package running behind a concurrent request


SystemAdministrator>concurrent>Program>define>Search


Search for the concurrent request
Ok
Copy Executable name
Systemadministrator>concurrnet>Program>Executable


Enter <F11>
Paste in executable field
Enter <Ctrl+F11>
Executable File Name is the name of Package


Regards
Soban Ali

Comments

  1. Hello Ali,

    At this step you can run the following SQL script to trap the full package source :

    SQL> conn apps/***
    SQL> set lines 1000 pages 0 trimspool on
    SQL> select text from dba_source where name='' and type='PACKAGE BODY' order by line
    SQL>.
    SQL> spool MYPACKsource.txt
    SQL>/
    SQL> spool off

    regards
    Lotfi C.

    ReplyDelete

Post a Comment

Popular posts from this blog

RMAN backup Status (Remaining Time and Percentage)

EBS R12.2 Autoconfig Failed. Resolved

Cleaning nodes in EBS databae.