Select A.Name, B. Extents, B.rsize, B.xActs, B. Waits, B.Gets, B.Optsize, B.StatusFrom V $ ROLLNAME A, V $ ROLLSTAT BWHERE A.USN = B.USN
If the XACTS (active transaction) is greater than 1, it means that the returns are stronger, and the number of returns will be increased.
If Waits is greater than 1, it also means that it is necessary to increase the number of returns.
