How can we identify the resources for which the sessions are waiting?
Answer / Pradeep Kumar Sonkar
You can use the 'v$session_wait' view to identify the resources for which sessions are waiting. This view contains data about active sessions and their current wait events.
| Is This Answer Correct ? | 0 Yes | 0 No |
Mention what is olr?
What is tkprof and how can we use it?
Why do we need to rebuild indexes?
Mention what are the tools provided in oracle enterprise manager?
What is the purpose of scan?
What happens if you keep split brain syndrome in rac unresolved? How it can be resolved?
Mention what is split brain syndrome in rac?
Mention what are the key characteristics of rac or why to use rac?
How is rman better than user-managed backup recovery process?
Mention what are the benefits of oracle rac?
Mention what is oracle real application clusters?
What is the function of grid naming service used in oracle rac