Scripts: Tablespace Report for Oracle 12c Multitenant Database

  • 2019/05/30
  • Cloud, ORACLE 9i-23ai
  • 312 views
  • 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

  • 2019/05/18
  • ORACLE 9i-23ai
  • 1,161 views
  • 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.

阅读全文