Databases Reference
In-Depth Information
How it works...
In step 2, we retrieve information about the sorts executed on the database from
instance startup, from the dynamic performance views. The results are differentiated
between in-memory and on-disk sorts. An example of the execution of this query is
shown in the next screenshot:
In step 3, we retrieve information on temporary tablespaces, showing used and free
database blocks, while in step 4 we retrieve the same information expressed in extents
instead of database blocks. In the next screenshot, we can see the results for both:
