SQL Performance (MOSC)

MOSC Banner

Hi Team, Would like to consolidate the list of trace files generation for schema level of tracing 10

edited Sep 6, 2016 11:44AM in SQL Performance (MOSC) 5 commentsAnswered

Hi Team,

Would like to consolidate the list of trace files generation for schema level tracing for 10046 level 12. I lost using trcsess utility.

trcsess output=output.trc *AZ_DEV_PMD_600*.trc

oracle.ss.tools.trcsess.SessTrcException: SessTrc-00002: Session Trace Usage error: Wrong parameters passed.

trcsess [output=<output file name >]  [session=<session ID>] [clientid=<clientid>] [service=<service name>] [action=<action name>] [module=<module name>] <trace file names>

output=<output file name> output destination default being standard output.

session=<session Id> session to be traced.

Session id is a combination of session Index & session serial number e.g. 8.13.

clientid=<clientid> clientid to be traced.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center