Toad 10.1.1.8 code formatter

I’m running Beta at the moment, so apologies if this is new for 10.5

Ow, I see. No, this sub tab does not show where the wait is coming from.
image001.jpeg

Ow, I see. No, this sub tab does not show where the wait is coming from.
image001.jpeg

Ow, I see. No, this sub tab does not show where the wait is coming from.

Yeah, it sounds like that information is a bit harder to get to for this
particular type of Wait event as Rich commented earlier

Yes – “connecting as SYS for no good reason” tasks me J

Beeeeerrrrrrrrttttttttttttttt !!!

Well, I do not mind checking those locks being connected as SYSDBA.
v$lock definitely does not show those tyes of locks.

FWIW, I've (inadvertently) created a test situation and other tools like
Grid Control also are unable to drill down to the offender for this
particular lock.

However, I'm not keen on using Grid Control as a baseline for anything other
than perhaps when comparing to Milorganite...

Rich -- [TeamT]

Disclaimer: You gotta watch your step when you know the chips are down.

I’m having the same issue that RedToad mentioned. It all started after upgrading to version 10. When working with a package or procedure in the Editor, I right click, select Formatting Tools, Format Code, and the only thing that happens is that TOAD insert the line /* Formatted on 4/2/2010 10:00:03 PM (QP5 v5.139.911.3011) */ and none of the code is formatted.

I have gone thru the process of customizing the formatting options and they work fine only if I highlight a line of code. For example, in the editor if I highlight a SELECT statement and then do the formatting, it formats the line and only that line. If nothing is highlighted the only thing that happens is that the comment line is inserted at the top.

Any ideas?

Avilesw_750,

If your code contains CR/LF newlines (not pure LF) then QP5 version 5.139
won’t format it when it contains block comments. //

You’ll need QP5.dll version 5.142 or later.

Thanks,

Andre

Andre,
I’ve been searching for this answer and gave up many times. I almost gave up reading this thread. Thanks for the answer, removing Block comments did the trick. I’m surprised that this doesn’t affect more people.