Hi All
Hope Everyone is doing Well !!
i was trying to figure if there is any way to find out that why a query is long running or could given any idea what are can improved.
For Example :- if we took a query or Pl/sql block and it kept running for a long time and oracle says its ong running .. so do we have any common query that we could pass the sql id and that could show us the area due to that query is running slow.
Can i have the idea on it