Scripts: Tablespace Report for Oracle 12c Multitenant Database

You can use this SQL script to report tablespace space details in 12c Multitenant database.

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.