Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Who is running a long-run job....
Hi list..
Users have just complained about dropped performance, more than 10 times slower. This was due to one user was running a long-run job i.e importing a big table.
Is there a way to know who is currently running a long-run job ? Can we know how much resource (percentage of cpu, mem, etc) is being allocated for each user ?
Tia for any clue.
Aldi
Oracle DBA
![]() |
![]() |