Facebook Twitter Instagram
    Facebook Twitter Instagram
    Techtown
    • General
    • Text Editors
      • Notepad++
      • Sublime Text
    • Resources
      • Books
    • Write for Us
    Techtown
    Home » General » Query to get current executing statement in Oracle concurrent program
    General

    Query to get current executing statement in Oracle concurrent program

    By SandiNo Comments1 Min Read
    Share
    Facebook Twitter LinkedIn Pinterest Email

    Use below query to get the current executing statement in Oracle Apps concurrent programs.

    SELECT va.sql_text
          ,va.module
      FROM APPS.fnd_concurrent_requests fcr
          ,V$SESSION vs
          ,V$SQLAREA va
     WHERE fcr.oracle_session_id = vs.audsid
       AND vs.sql_hash_value = va.hash_value
       AND fcr.request_id = <request_id>;

    Table Information

    • fnd_concurrent_requests:- This table holds the history of all submitted program in Oracle Apps like request id, request start, request completion time, parameter, etc.
    • V$SESSION :- This is V$ views in Oracle which holds session information.
    • V$SQLAREA:- This V$ view in Oracle hold SQL information in the database.
    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email
    Previous ArticleXAMPP Control Panel – Manage/Configure Apache, MySQL, FileZilla, Tomcat, Mercury
    Next Article How to use Excel Spreadsheet to generate SQL statements
    Sandi
    • Website
    • Twitter

    I am Oracle Certified Associate(OCA) working in Oracle Domain since last 15 Years. Started this blog to share knowledge about different Technologies mostly focussing on Oracle.

    Related Posts

    An Introduction to E-commerce Platforms: Choosing the Right One for Your Business Introduction

    Essential Tools for Email Marketing Success: A Comprehensive Guide

    The Basics of SEO for Small Businesses: A Comprehensive Guide

    Add A Comment

    Comments are closed.

    Latest Posts

    An Introduction to E-commerce Platforms: Choosing the Right One for Your Business Introduction

    Essential Tools for Email Marketing Success: A Comprehensive Guide

    The Basics of SEO for Small Businesses: A Comprehensive Guide

    How to Choose the Right Project Management Software

    Subscribe to Updates

    Get the latest creative news from FooBar about art, design and business.

    About Techtown

    A Technology Township
    A place to find good articles for Oracle Database, SQL, PL/SQL, XML Publisher, Oracle E-Business Suite, Oracle Application Express(APEX), WordPress, Joomla and Drupal, Any general topics which is interesting

    Facebook Twitter Instagram Pinterest
    • Chrome
    • XAMPP
    • Forums
    • Notepad++
    • Privacy Policy
    • About Me
    © 2023 ThemeSphere. Designed by ThemeSphere.

    Type above and press Enter to search. Press Esc to cancel.

    x