Another 10053 trace viewer : Best of the Best …

Posted by FatDBA on October 21, 2021

Finally, I’ve got a working copy of my favorite 10053 optimizer trace viewer from one of my connection. This one was written by Sergei Romanenko. I love it because it allows direct jumps to the most important parts of the trace and also uses highlighter to improve the readability of the trace and optionally formats the final query after transformations. It’s pretty easy to use, and you can directly search the keywords within these big thumping traces. And you can also wrap your text and can also format the final query.

Click here to download!

This is how the interface looks like.

Hope It Helped!
Prashant Dixit

This entry was posted on October 21, 2021 at 5:06 PM and is filed under Uncategorized. Tagged: Database, oracle, performance, troubleshooting. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

17 Responses to “Another 10053 trace viewer : Best of the Best …”

Saibal Ghosh said

October 23, 2021 at 5:16 PM
This seems a really nifty tool to get the information you really need…thanks Prashant!

Reply
- FatDBA said
  
  December 26, 2021 at 9:37 AM
  Yeah, I used it a lot in one of my recent assignment and impressed with the output and the formatting when dealing with behemoth 53 traces 🙂
  
  Reply
Oraora said

November 22, 2021 at 9:38 PM
Everything is fine, but it does not read some trace files, it does not load large files at all. Why is this happening?

Reply
- FatDBA said
  
  November 23, 2021 at 9:02 AM
  Not sure, ideally it should. Working fine at my end even for files more than 20 Mb in size.
  
  What is the size of your trace file, version of the Oracle DB, Any error it throws for you ?
  
  Reply
  - Oraora said
    
    November 24, 2021 at 8:46 PM
    I don’t get any errors, I just load a 30GB file and nothing opens for me.
Vimal Shukla said

August 6, 2022 at 6:13 AM
Can you please approve my request for downloading this tool from google drive.

Reply
- FatDBA said
  
  August 9, 2022 at 6:25 PM
  Hi Vimal, its approved.
  
  Reply
  - Vimal ShuklaVimal said
    
    August 24, 2022 at 5:50 AM
    Thanks Prashant.I am able to download now.
prathamesh Patil said

September 22, 2022 at 12:33 AM
Can you please approve my request for downloading this tool from google drive.

Reply
- FatDBA said
  
  September 22, 2022 at 6:02 AM
  Done!
  
  Reply
  - prathamesh Patil said
    
    September 22, 2022 at 9:04 AM
    Thanks Prashant.
Kal said

October 16, 2022 at 12:18 PM
Can you please approve my request for downloading this tool from google drive.

Reply
Debasis said

June 30, 2023 at 1:23 PM
Could you please approve to download

Reply
- FatDBA said
  
  June 30, 2023 at 2:07 PM
  done
  
  Reply
  - Debasis said
    
    July 1, 2023 at 12:38 AM
    Could you please help me how to use it or any reference blog. Because I tried to opening the trace file in this tool but nothing was showing.
Krish Jimmy (Oracle ACE) said

November 27, 2023 at 8:12 AM
Hi Prashanth,

Could you please approve the request to download the tool.

Regards,
Krishjimmy

Reply
Krish Jimmy (Oracle ACE) said

November 27, 2023 at 8:13 AM
Hi Prashanth,

Thanks for sharing nice tool. Appreciate it. Could you please approve the request to download the tool.

Regards,
Krishjimmy

Reply

Tales From A Lazy Fat DBA

Its all about Databases, their performance, troubleshooting & much more …. ¯\_(ツ)_/¯

Likes