#wait event

Db file sequential read wait event in Oracle

How to tune the DB file sequential read wait event in AWR What is sequential Read?A sequential read is usually a single-block read typically used when reading indexes, although it is possible to see sequential reads for more than one block. For reduce the db file sequential read wait event various tuning aspects will need to lookup like tuning the SQL statements, checking indexes selectivity…