1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to find query which in taking time for execution

Discussion in 'Oracle Apps Technical' started by Tanmay Gupta, Apr 10, 2019.

  1. Tanmay Gupta

    Tanmay Gupta Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Noida
    How to find query which in taking time for execution
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    777
    Likes Received:
    148
    Trophy Points:
    830
    Location:
    Russian Federation
    On db, may to using a some of view from db dictionary,with dependent of conditions by your task.
    For example : v$sql,v$sqlarea.