Home » RDBMS Server » Performance Tuning » Script to load Trace files errors to a Table (IBM AIX)
Script to load Trace files errors to a Table [message #590030] Sat, 13 July 2013 12:50 Go to next message
user81
Messages: 2
Registered: July 2013
Junior Member
Hi,

I need to create a script which can fetch the error related details from Trace files regularly (may be twice a day ) to

a custom table in DB. If anybody has created such kind of script, please share it with me Or if someone can provide me the

logic to pick the data from Trace files, it would be a great help. My Platform is IBM AIX.

Thanks
Re: Script to load Trace files errors to a Table [message #590048 is a reply to message #590030] Sat, 13 July 2013 13:15 Go to previous messageGo to next message
Michel Cadot
Messages: 59136
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which kind of error?

Regards
Michel
Re: Script to load Trace files errors to a Table [message #590053 is a reply to message #590048] Sat, 13 July 2013 13:54 Go to previous messageGo to next message
user81
Messages: 2
Registered: July 2013
Junior Member

Hi Michel,

Thanks for your reply. All the ORA- errors that keep getting recorded in these trace files.
Please let me know if you still have any doubts.

Thanks
Re: Script to load Trace files errors to a Table [message #590054 is a reply to message #590053] Sat, 13 July 2013 14:38 Go to previous message
Michel Cadot
Messages: 59136
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
find <trace file dir> -f '*trc' -exec grep -H ORA- {} \;


Regards
Michel
Previous Topic: How to enable AWR in oracle 10g
Next Topic: About NO_INDEX Hint
Goto Forum:
  


Current Time: Thu Sep 18 15:07:45 CDT 2014

Total time taken to generate the page: 0.09734 seconds