Once monthly we run a report of which we have nearly 100,000 records. It takes a long time and the performance is very slow when we run this report.
When I run the SQL trace for the session for the schema in which the report is executed, the size of the trace file becomes very big and so I put off the SQL trace. Please help me to solve this issue.
You can always format a partial trace file with tkprof, and the resulting report may reveal the problem. If it doesn't, I'd suggest that you direct your trace files to a directory on a disk with plenty of room, so that you can trace the entire operation. The tkprof utility can handle enormous trace files with no problem.
Dig deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.