Handy tkprof sql creating script using bash shell unix, linux with oracle environment

Posted by Jiltin     Tags: , , , , 10 December, 2008    12,023 views    (0) Comment

Oracle gives you this program called TKProf that reads your trace file and spits out somewhat meaningful output. My favorite option to tkprof is sort=prsela,fchela,exeela. This sorts the statements from longest running to shortest running. I prefer this format because I can concentrate on the top two or three statements for the most impact. By tracing, I mean capturing all the SQL in a user’s session, or a SQL trace. As you can tell from the Oracle Performance Tuning Guide and Read Full Article (Click here)...

Categories : 11i DBA Scripts, 11i Scripts, Scripts Oracle, Scripts Unix Tags : , , , ,