Accessing data in memory is much faster than accessing data in the disk. It is a memory area to store database data/blocks so future access on the same data can be fulfilled from memory. ST04 database performance overview screen: Similarly there is another factor which is in-memory sort ratio this should have higher values for the better system performance. Soft parse ratio max value is 1 which is not possible because at least once the SQL is hard parsed and then soft parsed in its next executions.īut this must be as close as possible to 1 for a healthy system or better system performance. DD(data dictionary) cache quality should be more than 99%, similarly the SQL area get ratio. It should be less than 0.1% of total sorts. Busy time & CPU time ratio 60:40 ratio. Read/User Call 30means expensive SQL statements].
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |