Can trcsess utility merge files pertaining to a user session scattered across different processes in a shared server configuration?
Is this tool have this function?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
TRCSESS is useful for consolidating the tracing of a particular session for performance or debugging purposes.
Yes, you can merge the scattered user session trace files using this tool and can get formatted out using TKPROF.
TKPROF can locate statements using the greatest resource. With baselines available, you can assess whether the resources used are reasonable given the work done.
Its usage and syntax are given in the following reference in details.