OraFAQ Forum: Performance Tuning » Script to load Trace files errors to a Table

Home » RDBMS Server » Performance Tuning » Script to load Trace files errors to a Table (IBM AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Script to load Trace files errors to a Table [message #590030]

Sat, 13 July 2013 12:50

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

Report message to a moderator

Re: Script to load Trace files errors to a Table [message #590048 is a reply to message #590030]

Sat, 13 July 2013 13:15

Michel Cadot
Messages: 67650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Which kind of error?

Regards
Michel

Report message to a moderator

Re: Script to load Trace files errors to a Table [message #590053 is a reply to message #590048]

Sat, 13 July 2013 13:54

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

Report message to a moderator

Re: Script to load Trace files errors to a Table [message #590054 is a reply to message #590053]

Sat, 13 July 2013 14:38

Michel Cadot
Messages: 67650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

find <trace file dir> -f '*trc' -exec grep -H ORA- {} \;

Regards
Michel

Report message to a moderator

Previous Topic:	How to enable AWR in oracle 10g
Next Topic:	About NO_INDEX Hint

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 24 10:29:53 CST 2021