What Is Db File Sequential Read Wait Event?

1.	What Is Db File Sequential Read Wait Event?
Answer» The db file sequential read wait event PERFORMS single block read operations against indexes, TABLES, control files, rollback segments and data file headers. It has THREE parameters: file#, firstblock# and block count. The db file sequential read wait event performs single block read operations against indexes, tables, control files, rollback segments and data file headers. It has three parameters: file#, firstblock# and block count.

Answer»

The db file sequential read wait event PERFORMS single block read operations against indexes, TABLES, control files, rollback segments and data file headers.

It has THREE parameters:

file#, firstblock# and block count.

The db file sequential read wait event performs single block read operations against indexes, tables, control files, rollback segments and data file headers.

It has three parameters:

file#, firstblock# and block count.

Discussion

No Comment Found

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?

What Is Db File Sequential Read Wait Event?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment