Database Administration (MOSC)

MOSC Banner

spent significant time on hot block (IOT table

edited Aug 28, 2014 9:27AM in Database Administration (MOSC) 4 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center