Since Monday all these statements hang and complete very slowly. I thought for fragmentation and I created a new tablespace. In the beginning it was fine, but then it started to behave the same way. What could be the reason? I have very high CPU (98-99) and memory usage of 90-95. What could I do to improve the performance?
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.