What does text in red mean in Profiler?

[Jim Czuprynski]

I've just started using the Profiler actively, and it's a great tool! Already found some "bad" code.

Does anyone know why some of the values in the Text column show up in red? I don't see any obvious correlation with what's returned except that all the text for a Unit is highlighted. The documentation doesn't tell me what it means, either, and there are no apparent settings in Preference for this. I am flummoxed. Any help would be most welcome!

 

[Christo Kutrovsky]

I think it has to do with missing or modified code...

 

[Jim Czuprynski]

Thanx for the reply. Not sure this makes sense, tho, since the code I ran was definitely "there." Wonder if perhaps it means the code is at the end of the chain, i.e., it's been called by some other object, but no other object calls it.

I'll take a look at my tests on my return on Friday and let you know.

 

[Marco Kalter]

Red means that the PL/SQL source code that is displayed was (re)compiled after creating the profile report. This means that the actual code may no longer match with the line numbers that Oracle has reported.