Koen Verbeeck (12/4/2014)
I had to Google this, because I did not understand at least 9 words from that question. 😀
I had to Google as well, but for a different reason. I know that there is a tracce flag and I know when to use it - but I simply refuse to memorize meaningless four-digit numbers that are easily found.
DBAs should know that this trace flag exists and should know when (not) to use it, so that makes this a good question. But the requirement to give the exact number is a bit of a downer, because it forces people to use a search engine.
(Everyone who annswered this without doing a search should be ashamed for wasting brain capacity that can be used to memorize things that are not as easily found in a search engine)