7/18/2023 0 Comments Praey for the gods all totemsThe Cursor Dashboardįor overall cursor performance, the cursor dashboard shows the following metrics: Includes CPU time, IO time, and wait timeĪs for the accumulated wait summary, the DB CPU time ratio could also be used as a health check for an application that is transactional.Time spent in the database by foreground sessions.Then there is the DB CPU time ratio indicator which according to the official documentation are the database operations as a percentage of CPU activity. There are also accumulated metrics for the top cursors (or SQL statements) still cached. In a transactional application, cursors should be reused by different sessions when possible. If there are several SQL statements that are critical and are the most used, then it’s easy to calculate a performance metric. One day, if a critical SQL statement uses, say, 10k I/O over 10 executions for an average of 1k I/O per execution, then the next day the average is 100k then that would be cause for further investigation because the efficiency is less.Ĭursor performance is most helpful for applications that are transactional in nature. The memory capacity dashboard gives a snapshot of: There are two capacity summaries: one for memory, and another for storage. There are also indicators for the storage capacity of 3 types of files: The second dashboard is for storage capacity, and there are workload graphs of: The memory capacity dashboard indicates the level of workload being experienced by the database. The utilization metrics are really comparing the allocated file size with the usage size within the file. In the above screenshot, there are utilization percentages against the data files, temporary files, and undo files. Those percentages are comparing the utilization of the allocated file, and don’t consider files that can auto-extend.Ī file that can auto-extend will often have a utilization close to 100%. I say that SQL Developer should be renamed the SQL Dash boarder! About the Author There you are! For dashboards, you don’t need to look much farther than SQL Developer. Paul Guerin is an international consultant that specializes in Oracle Database. Paul is based from a global delivery center in South East Asia but has clients from Australia, Europe, Asia, and North America. Moreover, he has presented at some of the world’s leading Oracle conferences, including Oracle Open World 2013. Since 2015, his work has been featured in the IOUG Best Practices Tip Booklet, and in publications from AUSOUG, Oracle Technology Network, and Oracle Developers (Medium).
0 Comments
Leave a Reply. |