Home
About Us
Contact Us
Bookmark
Saved Bookmarks
Current Affairs
General Knowledge
Chemical Engineering
UPSEE
BSNL
ISRO
BITSAT
Amazon
ORACLE
Verbal Ability
→
Oracle Dba Troubleshooting Tutorial
→
Oracle Dba Troubleshooting Interview Questions in Oracle Dba Troubleshooting Tutorial
→
Explain Wait Events?
1.
Explain Wait Events?
Answer»
Wait
EVENT
occurs when a user
PROCESS
is kept waiting because of some
PROBLEM
, such as an I/O bottleneck or a busy CPU.
The information about wait event is
AVAILABLE
in the V$SYSTEM_WAIT and V$SESSION_WAIT dynamic performance
VIEWS
.
Show Answer
Discussion
No Comment Found
Post Comment
Related InterviewSolutions
How Can You Detect Block Corruption?
How Do You Handle Ora-01403: No Data Found Error?
What Are The Different Types Of Locking Modes?
Name A Few Places You Will Look To Get More Details On A Performance Issue?
Describe The Oracle Wait Interface?
How Can You Monitor Performance Of The Database Proactively?
Which Trace File Is Used For Performance Tuning And Why?
What Do The Db_file_sequential_read And Db_file_scattered_read Events Indicate?
What Do You Understand By Db File Scattered Read?
What Is The Main Reason For Block Corruption?
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply
Your experience on this site will be improved by allowing cookies. Read
Cookie Policy
Reject
Allow cookies