|
Home > Archive > Sybase Database > March 2006 > Proc getting recompiled.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Proc getting recompiled.
|
|
| jcolins 2006-03-16, 7:23 am |
| How do know my procedure getting recompiled?
| |
| Rob Verschoor 2006-03-16, 8:23 pm |
|
"jcolins" < r_josephcollins@redi
ffmail.com> wrote in message
news:54a770f639b8fe8
2fc7c3e4a4776b178@lo
calhost.talkaboutdatabases.com...
> How do know my procedure getting recompiled?
You can tell in different ways, for example by enabling traceflag 302 -- if
there's 302 output, the proc is recompiled. You can also look at
monCachedProcedures.
HTH,
Rob
-------------------------------------------------------------
Rob Verschoor
Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase
Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------
| |
| jcolins 2006-03-17, 3:23 am |
| thanks.
| |
| Terence Chen 2006-03-17, 3:23 am |
| Alternatively, enable trace 214 where ouput will indicate recompilation occurs.
1> exec proc_a
2> go
Execution required recompilation with status of:
(0x00001000 (MULT_RECOMPILE), 0x00000010 (SCHEMACT), 0x00000002 (RECOMPILE)),
for procname = proc_a, procid = 486293001, dbid = 2
at statement = 1, line = 1
c1 c2
----------- -----------
10 10
(1 row affected)
-Terence
"jcolins" < r_josephcollins@redi
ffmail.com> wrote in message
news:54a770f639b8fe8
2fc7c3e4a4776b178@lo
calhost.talkaboutdatabases.com...
> How do know my procedure getting recompiled?
>
|
|
|
|
|