You may want to check out the oracle tool TRCANLZR * [ID 224270.1]* that I have found very useful. You basically run a script using sqlplus - as simple as that. It generates a html report with nice formatting and sorting. I don't remember if it has what you are looking for, but that is best you get, direct from oracle. -Madhu On Tue, Sep 20, 2011 at 10:46 AM, Dba DBA <oracledbaquestions@xxxxxxxxx>wrote: > I know their are vendors (like hotsos), that have products you can buy. The > company I work for is not going to buy a product. Anyone have anything more > advanced than tkrpof? Preferably one that will generate an explain plan > with > the logical and physical IO by row source (action in the explain plan) > without the query completing. We have some very complex queries. The > easiest > way for me to analyze a query is with a tkprof since I can see what parts > of > the query are using the most logical and physical IO. I don't want to let a > query run and run to wait for it to complete. > I do read the raw trace file and it is helpful up to a point. However, a > script to create a summary report similiar to tkprof would be very useful > or > anything else someone might have. > I have thought about writing my own. I would probably use awk. However, > before I do that, I was wondering if there are any out there already? Even > if you don't have one that does what i am looking for, I would be > interested > to see what is out there. I did a few google searches and I didn't find > anything. > > > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l