WebWait event: DB file sequential read I am using a database link to connect from one 9i database to another 9i database. I am frequently getting 'db file sequential read' wait event at the linked server. Due to that all my queries are having a slow response.I tried to find the table that is causing the sequential read, it has 56 http://www.dba-oracle.com/m_db_file_sequential_read.htm
DB file sequential read (%) - Oracle
Weblog file single write. Search online. DBmarlin is a next-generation database monitoring and acceleration product developed by Application Performance Ltd (AP). AP are a UK company who specialise in monitoring and improving the performance and quality of applications … WebJul 18, 2007 · control file sequential read 475 0 1 3 0.7 latch free 173 11 0 3 0.2 ... If each of them waits 0.5 seconds - you'll have recorded 50 seconds of log file sync wait, and 0.5 seconds of wait by lgwr on the send request to the remote site. suggest you look at your data guard configuration and ensure you have it set up optimally. new pde5 inhibitor
Reason for "control file sequential read" waits? - Oracle Forums
WebControl files are central to the way Oracle keeps track of the current state of each of the necessary database files. This tracking includes tablespace files, online and archived transaction logs and temporary files. Any time the database needs to know the state of … http://www.dba-oracle.com/art_dbazine_waits.htm WebWait Events Oracle log file sequential read log file sequential read Short Description Waiting for the read from this logfile to return. This is used to read redo records from the log file. Search online If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page. intro to business midterm quizlet