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...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.