How to find query which in taking time for execution

  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:
    778
    Likes Received:
    149
    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.