a query running and not executing but all others queries are running sucessfully
a query running and not executing but all others queries are running successfully and sometimes this query doesn't show on EM but showing on TOAD, and when a query run first time it running pretty fast within seconds but after first time its taking 35 to 30 minutes to execute. i have database version 11.2.0.3 and its 2 node RAC environment.
Top SQL with Top Row Sources
| SQL ID | PlanHash | Sampled # of Executions | % Activity | Row Source | % RwSrc | Top Event | % Event | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 9vj1mawwgghmq | 2927918901 | 1 | 100.00 | INDEX - UNIQUE SCAN | 83.25 | CPU + Wait for CPU | 83.25 | SELECT COALESCE(X.TAG, 0)TAG, ... |
9vj1mawwgghmq | 2927918901 | 1 | 100 | HASH JOIN | 14.96 | CPU + Wait for CPU |
0