Hi,
I couldn't understand what type of alert log file and trace files u need. But we generate trace file when we enable tracing of sessions of database wide tracing, by specifying certain init parameters.
OR by alerting the sql session and enabling tracing.
Please let me know in detail what kind of trace files u need.
Thanks