When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
- 1 Answers
- 682 Views
- I also Faced
- E-Mail Answers
Answer / Abhijit Kumar Sinha
High disk sorts in v$sysstat indicate that the database is performing many sorts on disk, which can be a performance bottleneck. This can often be improved by optimizing queries with sorting requirements, using indexes, or increasing system resources such as memory and CPU. Reducing disk sorts requires careful analysis of the underlying SQL statements and potential restructuring of data access patterns.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is pct free/pct used/pct increase parameter in segment? What is growth factor?
Explain the wait events in statspack report 'db scattered read'?
What does a senior database administrator do?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
How can I learn oracle dba?
What is explain plan and how is it used?
What is oracle dba role?
Why do we need a database?
Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
What are the different types of backup available in the oracle?
What are the possible ways to gain information regarding the control file?
What exactly does a dba do?
Oracle General 
