spent significant time on hot block (IOT table
Finding 5: Buffer Busy - Hot Block Impact is 10.86 active sessions, 31.5% of total activity. --------------------------------------------------------- A hot data block with concurrent read and write activity was found. The block belongs to segment "SYS.RESTRICT_LOGON_LOG" and is block 89614 in file 496. Recommendation 1: Application Analysis Estimated benefit is 10.85 active sessions, 31.5% of total activity. -------------------------------------------------------------------- Action Investigate application logic to find the cause of high concurrent read and write activity to the data present in this block. Related Object Database block with object number 27213039, file number 496 and block number 89614. Rationale The SQL statement with SQL_ID