Note:Patch Post Install Steps: This fix enhances the _trace_kqlidp parameter therefore please set this parameter to true to enable this fix._trace_kqlidp was probably introduced in 11.1 but this patch enhances the parameter. I wrote a simple test case that can be used to demonstrate the effect of _trace_kqlidp parameter.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | def tns_alias=orcl conn /@&tns_alias. drop user tc cascade ; grant connect to tc identified by tc; grant alter session, create procedure , create table to tc; conn tc/tc@&tns_alias. create table t(x int ) segment creation deferred; create or replace procedure p is begin for t_rec in ( select * from t) loop null ; end loop; end ; / alter session set "_trace_kqlidp" = true ; select status from obj where object_name= 'P' ; alter table t add y int ; select status from obj where object_name= 'P' ; |
1 2 3 4 5 6 7 8 9 10 | ksedsts()+1296<-kqlidp0()+12068<-atbdrv()+26728<-opiexe()+20544<-opiosq0()+5576<-kpooprx()+212<-kpoal8()+536<-opiodr()+1164<-ttcpip()+1104<-opitsk()+1664<-opiino()+924<-opiodr()+1164<-opidrv()+1032<-sou2o()+88<-opimai_real()+504<-ssthrdmain()+316<-main()+316 <-_start()+380Fine-grain delta dump for unit TC.T - Change bit vector 0: -23, -16, - Change bit vector 1:Empty - Change bit vector 2:Empty - Shift table :Empty kqlidp0: 964375 ( CURSOR TC.T) (Parent: 0) [ROOT] kqlidp0:. 964376 ( PROCEDURE TC.P) (Parent:964375) [ADDED TO QUEUE] kqlidp0:. 964376 ( PROCEDURE TC.P) (Parent:964375) [INVALIDATE] |
1 2 3 4 5 6 7 8 9 10 11 12 | INVALIDATION: Current SQL follows alter table t add y int ksedsts()+392<-kqlidp0()+11984<-atbdrv()+6728<-opiexe()+22596<-opiosq0()+3928<-kpooprx()+196<-kpoal8()+656<-opiodr()+1100<-ttcpip()+972<-opitsk()+1820<-opiino()+920<-opiodr()+1100<-opidrv()+932<-sou2o()+112<-opimai_real()+756<-ssthrdmain()+456<-main()+320<-_start()+300 Fine-grain delta dump for unit TC.T - Change bit vector 0: -23, -16, - Change bit vector 1:Empty - Change bit vector 2:Empty - Shift table :Empty kqlidp0: 91877 ( CURSOR TC.T) (Parent: 0) [ROOT] kqlidp0:. 91878 ( PROCEDURE TC.P) (Parent:91877) [ADDED TO QUEUE] kqlidp0:. 91878 ( PROCEDURE TC.P) (Parent:91877) [INVALIDATE] |
Tue Sep 16 10:16:50 2014 INVALIDATION performed by ospid=21919. Please see tracefile.
Комментариев нет:
Отправить комментарий
Примечание. Отправлять комментарии могут только участники этого блога.