Problem solve
Get help with specific problems with your technologies, process and projects.
Handling a large trace file
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 I run the SQL trace for the session, the size of the trace file becomes very big. Please help me to solve this issue.
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
-
![]()
UK government reveals more insight into imminent contact-tracing app
By: Joe O’Halloran
-
![]()
Government scraps Public Health England
By: Lis Evenstad
-
![]()
Police chiefs working with Public Health England on contact-tracing security
By: Alex Scroxton
-
![]()
Test and Trace has not passed data protection impact assessment
By: Alex Scroxton
Start the conversation
0 comments