Oracle Database - sorts (Disk)

Card Puncher Data Processing

About

sorts (Disk) is a statistic metric of autotrace that you can see in the autotrace statistics and confirm that Oracle use the temporary tablespace.




Discover More
Card Puncher Data Processing
Oracle Database - How to detect read from the temporary tablespace ?

How to detect read from the temporary tablespace ? Step followed : disable automatic PGA management by the server set the hash area size. and play with the sort area size In this example, the...
Card Puncher Data Processing
Oracle Database - Session Statistics (V )

The second part of the autotrace output are a part of the session statistics. V recursive_calls : Number of SQL...



Share this page:
Follow us:
Task Runner