parsing a 10046 event trace file
Is there any script (PERL?) that goes through the entire trace file of a 10046 event trace and gives me the object name and type the query waited?
I have 200000 lines in the trace file and it is cumbersome to manually run the query on DBA_SEGMENTS to find each object name.
WAIT #79: nam='db file sequential read' ela= 6410 p1=69 p2=55175 p3=1
WAIT #79: nam='db file sequential read' ela= 10123 p1=69 p2=53785 p3=1
WAIT #79: nam='db file sequential read' ela= 6809 p1=70 p2=45315 p3=1
WAIT #79: nam='db file sequential read' ela= 8008 p1=70 p2=44967 p3=1
WAIT #79: nam='db file sequential read' ela= 8098 p1=69 p2=65413 p3=1
WAIT #79: nam='db file sequential read' ela= 10810 p1=77 p2=183858 p3=1
WAIT #79: nam='db file sequential read' ela= 7107 p1=70 p2=58215 p3=1
WAIT #79: nam='db file sequential read' ela= 5288 p1=78 p2=81639 p3=1
WAIT #79: nam='db file sequential read' ela= 8365 p1=69 p2=79209 p3=1
WAIT #79: nam='db file sequential read' ela= 8504 p1=69 p2=78834 p3=1
WAIT #79: nam='db file sequential read' ela= 7483 p1=68 p2=92668 p3=1
WAIT #79: nam='db file sequential read' ela= 9715 p1=79 p2=92561 p3=1
WAIT #79: nam='db file sequential read' ela= 8007 p1=69 p2=99014 p3=1
WAIT #79: nam='db file sequential read' ela= 9276 p1=69 p2=98696 p3=1
WAIT #79: nam='db file sequential read' ela= 116871 p1=41 p2=214130 p3=1
WAIT #79: nam='db file sequential read' ela= 12584 p1=41 p2=220265 p3=1
WAIT #79: nam='db file sequential read' ela= 23042 p1=72 p2=250472 p3=1
WAIT #79: nam='db file sequential read' ela= 13008 p1=70 p2=100682 p3=1
WAIT #79: nam='db file sequential read' ela= 6752 p1=70 p2=98923 p3=1
WAIT #79: nam='db file sequential read' ela= 11643 p1=69 p2=126332 p3=1
WAIT #79: nam='db file sequential read' ela= 15265 p1=77 p2=151339 p3=1
WAIT #79: nam='db file sequential read' ela= 9945 p1=75 p2=11971 p3=1
WAIT #79: nam='db file sequential read' ela= 7662 p1=69 p2=130204 p3=1
WAIT #79: nam='db file sequential read' ela= 5251 p1=32 p2=192680 p3=1