Pages: 2
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Page 1 Preview
the function used compute the amount increase each

The function used compute the amount increase each row data


In Listing 16-4, you see another valuable SQL query; it provides the distribution of DB time for each available time period. It is a fairly long query, but you can download the text from the Source Code section of the Apress web site (���������������������). You have to specify a range of snapshots; the appropriate range can be obtained from the �������������� table. As I explained earlier in this chapter, the distribution of DB time is precisely the information you need to tune the database. CPU time is obtained from the ������������� table, while the wait times for each type of event are obtained from the ������������������ table. The classifications in the ������������ view are used to group events into categories such as Application, Concurrency, Commit, User IO, and System IO. The ����� operator is used to convert rows into columns; this makes it easy to perform further analysis on the data. The ��� function is used to compute the amount of increase in each row of data. Finally, we divide CPU time and wait time by the length of the observed interval to compute average active sessions for each category of time.





You are viewing 1/3rd of the document.Purchase the document to get full access instantly

Immediately available after payment
Both online and downloadable
No strings attached
How It Works
Login account
Login Your Account
Place in cart
Add to Cart
send in the money
Make payment
Document download
Download File

Uploaded by : Brett O'Loughlin

PageId: ELI31D341F