Scripts: Tablespace Report for Oracle 12c Multitenant Database
You can use this SQL script to report tablespace space details in 12c Multitenant database.
Month: May 2019
Wait Event: buffer deadlock
Buffer Deadlock is very typical wait event and not so much seen in database. But when you are encountering with this mysterious wait then you would see the effect of wait and performance bottleneck of the server.