Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
 AQ$_PLSQL_NTFN ORA-01031: insufficient privileges  [new]
AlexVin
Member

Откуда: E-burg
Сообщений: 1055
oracle 12.1.0.2.1 на линухе

*** SERVICE NAME:(SYS$USERS)
*** MODULE NAME:(DBMS_SCHEDULER)
*** ACTION NAME:(AQ$_PLSQL_NTFN_ююю)
валятся в лог джобы ошибки.
как понять, на что не хватает грантов?
: Exception Occured, Error msg:
ORA-00604: error occurred at recursive SQL level 2
ORA-01031: insufficient privileges

триггерром AFTER servererror ошибка не ловится.
трейс тут

+

*** 2015-01-15 14:27:41.035
*** SESSION ID:(380.18727) 2015-01-15 14:27:41.035
*** CLIENT ID:() 2015-01-15 14:27:41.035
*** SERVICE NAME:(SYS$USERS) 2015-01-15 14:27:41.035
*** MODULE NAME:() 2015-01-15 14:27:41.035
*** CLIENT DRIVER:() 2015-01-15 14:27:41.035
*** ACTION NAME:() 2015-01-15 14:27:41.035

CLOSE #140416371021168:c=0,e=1,dep=2,type=0,tim=13836798423029
=====================
PARSING IN CURSOR #140416370933024 len=397 dep=1 uid=0 oct=47 lid=0 tim=13836798423233 hv=6589810 ad='98955ac0' sqlid='dmfjmxs0693bk'
declare
l_user constant varchar2(30) := 'USRUSR';
begin
-- if substr(SYS_CONTEXT('USERENV', 'ACTION'), 1, 14) = 'AQ$_PLSQL_NTFN' then
if user = 'SYS' then
execute immediate 'alter session set tracefile_identifier=''NTFN''';
execute immediate 'ALTER SESSION SET EVENTS ''10046 TRACE NAME CONTEXT FOREVER, LEVEL 12 ''';
end if;
exception when others then null;
end logon_trigger_trace;
END OF STMT
EXEC #140416370933024:c=1000,e=597,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,plh=0,tim=13836798423232
CLOSE #140416370933024:c=0,e=9,dep=1,type=1,tim=13836798423301
*** MODULE NAME:(DBMS_SCHEDULER) 2015-01-15 14:27:41.035
*** ACTION NAME:(AQ$_PLSQL_NTFN_1421314060) 2015-01-15 14:27:41.035

CLOSE #140416447483896:c=0,e=2,dep=1,type=1,tim=13836798423495
=====================
PARSING IN CURSOR #140416371022544 len=37 dep=1 uid=0 oct=47 lid=0 tim=13836798423551 hv=295050286 ad='87e02400' sqlid='b9c6ffh8tc71f'
BEGIN dbms_output.enable(NULL); END;
END OF STMT
PARSE #140416371022544:c=0,e=31,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=0,tim=13836798423551
EXEC #140416371022544:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,plh=0,tim=13836798423610
CLOSE #140416371022544:c=0,e=6,dep=1,type=1,tim=13836798423637
=====================
PARSING IN CURSOR #140416371021448 len=40 dep=1 uid=0 oct=170 lid=0 tim=13836798423685 hv=1780980331 ad='96212c58' sqlid='59p1yadp2g6mb'
call DBMS_AQADM_SYS.REGISTER_DRIVER ( )
END OF STMT
PARSE #140416371021448:c=0,e=38,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=0,tim=13836798423685
=====================
PARSING IN CURSOR #140416369699048 len=42 dep=2 uid=0 oct=3 lid=0 tim=13836798424041 hv=3324291061 ad='bf7baef8' sqlid='brq600g3299zp'
SELECT INSTANCE_NUMBER FROM SYS.V$INSTANCE
END OF STMT
PARSE #140416369699048:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=2848324471,tim=13836798424041
EXEC #140416369699048:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=2848324471,tim=13836798424096
FETCH #140416369699048:c=0,e=57,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=1,plh=2848324471,tim=13836798424164
STAT #140416369699048 id=1 cnt=1 pid=0 pos=1 obj=0 op='MERGE JOIN CARTESIAN (cr=0 pr=0 pw=0 time=65 us cost=0 size=6000 card=100)'
STAT #140416369699048 id=2 cnt=1 pid=1 pos=1 obj=0 op='MERGE JOIN CARTESIAN (cr=0 pr=0 pw=0 time=50 us cost=0 size=60 card=1)'
STAT #140416369699048 id=3 cnt=1 pid=2 pos=1 obj=0 op='FIXED TABLE FULL X$KSUXSINST (cr=0 pr=0 pw=0 time=23 us cost=0 size=26 card=1)'
STAT #140416369699048 id=4 cnt=1 pid=2 pos=2 obj=0 op='BUFFER SORT (cr=0 pr=0 pw=0 time=22 us cost=0 size=34 card=1)'
STAT #140416369699048 id=5 cnt=1 pid=4 pos=1 obj=0 op='FIXED TABLE FULL X$KVIT (cr=0 pr=0 pw=0 time=11 us cost=0 size=34 card=1)'
STAT #140416369699048 id=6 cnt=1 pid=1 pos=2 obj=0 op='BUFFER SORT (cr=0 pr=0 pw=0 time=11 us cost=0 size=0 card=100)'
STAT #140416369699048 id=7 cnt=1 pid=6 pos=1 obj=0 op='FIXED TABLE FULL X$QUIESCE (cr=0 pr=0 pw=0 time=8 us cost=0 size=0 card=100)'
CLOSE #140416369699048:c=0,e=1,dep=2,type=3,tim=13836798424264
=====================
PARSING IN CURSOR #140416371126856 len=47 dep=2 uid=0 oct=3 lid=0 tim=13836798424478 hv=1023521005 ad='87fca598' sqlid='cb21bacyh3c7d'
select metadata from kopm$ where name='DB_FDO'
END OF STMT
PARSE #140416371126856:c=0,e=30,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=3452538079,tim=13836798424478
EXEC #140416371126856:c=0,e=13,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=3452538079,tim=13836798424525
FETCH #140416371126856:c=0,e=7,p=0,cr=2,cu=0,mis=0,r=1,dep=2,og=4,plh=3452538079,tim=13836798424544
STAT #140416371126856 id=1 cnt=1 pid=0 pos=1 obj=679 op='TABLE ACCESS BY INDEX ROWID KOPM$ (cr=2 pr=0 pw=0 time=9 us cost=1 size=108 card=1)'
STAT #140416371126856 id=2 cnt=1 pid=1 pos=1 obj=680 op='INDEX UNIQUE SCAN I_KOPM1 (cr=1 pr=0 pw=0 time=4 us cost=0 size=0 card=1)'
CLOSE #140416371126856:c=0,e=2,dep=2,type=0,tim=13836798424586
=====================
PARSING IN CURSOR #140416371125984 len=580 dep=2 uid=0 oct=3 lid=0 tim=13836798424887 hv=1621801003 ad='bf5d78d8' sqlid='gzf71xphapf1b'
select /*+ INDEX(TAB AQ$_AQ_SRVNTFN_TABLE_1_I) */ tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration ,tab.retry_count, tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid, tab.user_prop, tab.user_data from "SYS"."AQ_SRVNTFN_TABLE_1" tab where q_name = :1 and (state = :2 ) order by q_name, state, enq_time, step_no, chain_no, local_order_no for update skip locked
END OF STMT
PARSE #140416371125984:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=555787387,tim=13836798424886
BINDS #140416371125984:
Bind#0
oacdty=01 mxl=32(20) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=56 off=0
kxsbbbfp=7fb53bdb2330 bln=32 avl=20 flg=05
value="AQ_SRVNTFN_TABLE_Q_1"
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bdb2350 bln=22 avl=01 flg=01
value=0
EXEC #140416371125984:c=0,e=105,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=555787387,tim=13836798425147
FETCH #140416371125984:c=0,e=132,p=0,cr=4,cu=3,mis=0,r=1,dep=2,og=1,plh=555787387,tim=13836798425288
=====================
PARSING IN CURSOR #140416370011792 len=93 dep=2 uid=0 oct=7 lid=0 tim=13836798425352 hv=3278575206 ad='c15cbb98' sqlid='61cgh171qq5m6'
delete /*+ CACHE_CB("AQ_SRVNTFN_TABLE_1") */ from "SYS"."AQ_SRVNTFN_TABLE_1" where rowid = :1
END OF STMT
PARSE #140416370011792:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=2426698438,tim=13836798425351
BINDS #140416370011792:
Bind#0
oacdty=11 mxl=16(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=00 csi=00 siz=16 off=0
kxsbbbfp=7fb53bdb8104 bln=16 avl=16 flg=09
value=00024474.0000.0001
EXEC #140416370011792:c=0,e=158,p=0,cr=1,cu=7,mis=0,r=1,dep=2,og=1,plh=2426698438,tim=13836798425543
STAT #140416370011792 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE AQ_SRVNTFN_TABLE_1 (cr=1 pr=0 pw=0 time=115 us)'
STAT #140416370011792 id=2 cnt=1 pid=1 pos=1 obj=92872 op='TABLE ACCESS BY USER ROWID AQ_SRVNTFN_TABLE_1 (cr=1 pr=0 pw=0 time=6 us cost=1 size=117 card=1)'
=====================
PARSING IN CURSOR #140416370084536 len=322 dep=2 uid=0 oct=47 lid=0 tim=13836798425967 hv=3545476626 ad='bfd32988' sqlid='f7zggdz9p7bhk'
begin SYS.SCHEDULER$_JOB_EVENT_HANDLER(context => :1,reginfo => sys.aq$_reg_info(:2, :3, :4, :5, :6, :7),descr => sys.aq$_descriptor(:8, :9, :10, sys.msg_prop_t(:11, :12, :13, :14, :15, :16, :17, :18, sys.aq$_agent(:19, :20, :21), :22, :23), sys.aq$_ntfn_descriptor(:24), :25, :26), payload => :27, payloadl => :28); end;
END OF STMT
PARSE #140416370084536:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=0,tim=13836798425967
BINDS #140416370084536:
Bind#0
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#1
oacdty=01 mxl=128(49) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=128 off=0
kxsbbbfp=7fb53be817ac bln=128 avl=49 flg=09
value=""SYS"."SCHEDULER$_EVENT_QUEUE":"SCHED$_AGT2$_113""
Bind#2
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd6daa0 bln=22 avl=02 flg=05
value=1
Bind#3
oacdty=01 mxl=32(32) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb53be8175c bln=32 avl=32 flg=09
value="SYS.SCHEDULER$_JOB_EVENT_HANDLER"
Bind#4
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#5
oacdty=58 mxl=640(640) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0001 frm=00 csi=00 siz=664 off=0
toid ptr value=C148E090 length=16
00000000000000000000000000020011
kxsbbbfp=7fb53bd6d7f0 bln=640 avl=00 flg=15
Bind#6
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=640
kxsbbbfp=7fb53bd6da70 bln=22 avl=01 flg=01
value=0
Bind#7
oacdty=01 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb53be818cc bln=32 avl=30 flg=09
value=""SYS"."SCHEDULER$_EVENT_QUEUE""
Bind#8
oacdty=01 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb53be8188c bln=32 avl=16 flg=09
value="SCHED$_AGT2$_113"
Bind#9
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=7fb53be8184c bln=32 avl=16 flg=09
value=0CAE65D4BE2617A9E05393000C0A1C83
Bind#10
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=72 off=0
kxsbbbfp=7fb53bd6d790 bln=22 avl=01 flg=05
value=0
Bind#11
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7fb53bd6d7a8 bln=22 avl=01 flg=01
value=0
Bind#12
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=48
kxsbbbfp=7fb53bd6d7c0 bln=22 avl=03 flg=01
value=86400
Bind#13
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#14
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bddde78 bln=22 avl=01 flg=05
value=0
Bind#15
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#16
oacdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=8 off=0
kxsbbbfp=7fff25797500 bln=07 avl=07 flg=09
value="1/15/2015 9:27:36"
Bind#17
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bddee90 bln=22 avl=01 flg=05
value=0
Bind#18
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb53be8180c bln=32 avl=22 flg=09
value="SCHEDULER$_EVENT_AGENT"
Bind#19
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#20
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd6d760 bln=22 avl=01 flg=05
value=0
Bind#21
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#22
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=712 off=0
kxsbbbfp=7fb53bdddb70 bln=22 avl=02 flg=05
value=1
Bind#23
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7fb53bdddb88 bln=22 avl=01 flg=01
value=0
Bind#24
oacdty=123 mxl=640(640) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0001 frm=00 csi=00 siz=0 off=48
toid ptr value=C148E0A0 length=16
FD9ACFEBF6C248A9E043B6A9E80AFB6F
kxsbbbfp=7fb53bdddba0 bln=640 avl=00 flg=11
Bind#25
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=688
kxsbbbfp=7fb53bddde20 bln=22 avl=00 flg=01
Bind#26
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#27
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd7d638 bln=22 avl=01 flg=05
value=0
=====================
PARSING IN CURSOR #140416370263104 len=427 dep=3 uid=0 oct=3 lid=0 tim=13836798427049 hv=2299947350 ad='96b40cd8' sqlid='5ybur2u4jcuaq'
select tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration , tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid, tab.user_prop, tab.user_data from "SYS"."SCHEDULER$_EVENT_QTAB" tab where q_name = :1 and msgid = :2
END OF STMT
PARSE #140416370263104:c=0,e=29,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=1,plh=3250640613,tim=13836798427048
BINDS #140416370263104:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53be29f50 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53be29f70 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370263104:c=0,e=73,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=1,plh=3250640613,tim=13836798427189
FETCH #140416370263104:c=0,e=25,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=1,plh=3250640613,tim=13836798427223
STAT #140416370263104 id=1 cnt=1 pid=0 pos=1 obj=17384 op='TABLE ACCESS BY INDEX ROWID SCHEDULER$_EVENT_QTAB (cr=3 pr=0 pw=0 time=17 us cost=2 size=20874 card=1)'
STAT #140416370263104 id=2 cnt=1 pid=1 pos=1 obj=17387 op='INDEX UNIQUE SCAN SYS_C004400 (cr=2 pr=0 pw=0 time=6 us cost=1 size=0 card=1)'
EXEC #140416370084536:c=1000,e=1371,p=0,cr=14,cu=4,mis=0,r=0,dep=2,og=1,plh=0,tim=13836798427556
ERROR #140416370084536:err=1031 tim=13836798427567
=====================
PARSING IN CURSOR #140416370614808 len=397 dep=3 uid=0 oct=3 lid=0 tim=13836798427683 hv=814242814 ad='96b85e98' sqlid='gu3una4s8hqzy'
select tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration , tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid from "SYS"."SCHEDULER$_EVENT_QTAB" tab where q_name = :1 and msgid = :2
END OF STMT
PARSE #140416370614808:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=3250640613,tim=13836798427683
BINDS #140416370614808:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53be3ed08 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53be3ed28 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370614808:c=0,e=65,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=3250640613,tim=13836798427802
FETCH #140416370614808:c=0,e=11,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=4,plh=3250640613,tim=13836798427821
STAT #140416370614808 id=1 cnt=1 pid=0 pos=1 obj=17384 op='TABLE ACCESS BY INDEX ROWID SCHEDULER$_EVENT_QTAB (cr=3 pr=0 pw=0 time=12 us)'
STAT #140416370614808 id=2 cnt=1 pid=1 pos=1 obj=17387 op='INDEX UNIQUE SCAN SYS_C004400 (cr=2 pr=0 pw=0 time=7 us)'
BINDS #140416370614808:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53be3d8d8 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53be3d8f8 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370614808:c=0,e=77,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=3250640613,tim=13836798428177
FETCH #140416370614808:c=0,e=9,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=4,plh=3250640613,tim=13836798428196
CLOSE #140416370084536:c=0,e=8,dep=2,type=1,tim=13836798428300
=====================
PARSING IN CURSOR #140416370069808 len=8 dep=2 uid=0 oct=45 lid=0 tim=13836798428364 hv=2761672982 ad='0' sqlid='8sst43uk9rk8q'
ROLLBACK
END OF STMT
PARSE #140416370069808:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=0,plh=0,tim=13836798428364
XCTEND rlbk=1, rd_only=0, tim=13836798428394
=====================
PARSING IN CURSOR #140416370394096 len=447 dep=3 uid=0 oct=3 lid=0 tim=13836798428581 hv=1681367889 ad='bf9a8a00' sqlid='8ffh6kjk3g8uj'
select tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration ,tab.retry_count, tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid from "SYS"."AQ_SRVNTFN_TABLE_1" tab where q_name = :1 and msgid = :2 and deq_time is null for update nowait
END OF STMT
PARSE #140416370394096:c=0,e=25,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=1058480892,tim=13836798428580
BINDS #140416370394096:
Bind#0
oacdty=01 mxl=32(20) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc6a148 bln=32 avl=20 flg=05
value="AQ_SRVNTFN_TABLE_Q_1"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc6a168 bln=32 avl=16 flg=01
value=0795C28E325047CCE05393000C0ADE5D
EXEC #140416370394096:c=0,e=111,p=0,cr=4,cu=2,mis=0,r=0,dep=3,og=4,plh=1058480892,tim=13836798428744
FETCH #140416370394096:c=0,e=5,p=0,cr=0,cu=0,mis=0,r=1,dep=3,og=4,plh=1058480892,tim=13836798428760
STAT #140416370394096 id=1 cnt=1 pid=0 pos=1 obj=0 op='FOR UPDATE (cr=4 pr=0 pw=0 time=47 us)'
STAT #140416370394096 id=2 cnt=1 pid=1 pos=1 obj=92872 op='TABLE ACCESS BY INDEX ROWID AQ_SRVNTFN_TABLE_1 (cr=4 pr=0 pw=0 time=10 us)'
STAT #140416370394096 id=3 cnt=1 pid=2 pos=1 obj=92881 op='INDEX UNIQUE SCAN SYS_C0010025 (cr=3 pr=0 pw=0 time=5 us)'
=====================
PARSING IN CURSOR #140416370599168 len=85 dep=3 uid=0 oct=6 lid=0 tim=13836798428845 hv=2207236396 ad='904f1600' sqlid='g5m4j821szh9c'
update "SYS"."AQ_SRVNTFN_TABLE_1" set retry_count = retry_count + 1 where rowid = :1
END OF STMT
PARSE #140416370599168:c=0,e=25,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=1154522461,tim=13836798428845
BINDS #140416370599168:
Bind#0
oacdty=11 mxl=16(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=00 csi=00 siz=16 off=0
kxsbbbfp=7fff257925a0 bln=16 avl=16 flg=09
value=00024474.0000.0001
EXEC #140416370599168:c=0,e=88,p=0,cr=1,cu=1,mis=0,r=1,dep=3,og=4,plh=1154522461,tim=13836798428968
STAT #140416370599168 id=1 cnt=0 pid=0 pos=1 obj=0 op='UPDATE AQ_SRVNTFN_TABLE_1 (cr=1 pr=0 pw=0 time=46 us)'
STAT #140416370599168 id=2 cnt=1 pid=1 pos=1 obj=92872 op='TABLE ACCESS BY USER ROWID AQ_SRVNTFN_TABLE_1 (cr=1 pr=0 pw=0 time=5 us)'
CLOSE #140416370599168:c=0,e=2,dep=3,type=1,tim=13836798429007
EXEC #140416370069808:c=1000,e=661,p=0,cr=7,cu=13,mis=0,r=0,dep=2,og=0,plh=0,tim=13836798429049
CLOSE #140416370069808:c=0,e=1,dep=2,type=3,tim=13836798429064
: Exception Occured, Error msg:
ORA-00604: error occurred at recursive SQL level 2
ORA-01031: insufficient privileges
EXEC #140416369699048:c=0,e=11,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=2848324471,tim=13836798429149
FETCH #140416369699048:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=1,plh=2848324471,tim=13836798429194
CLOSE #140416369699048:c=0,e=1,dep=2,type=3,tim=13836798429216
STAT #140416371125984 id=1 cnt=1 pid=0 pos=1 obj=0 op='FOR UPDATE (cr=4 pr=0 pw=0 time=113 us)'
STAT #140416371125984 id=2 cnt=1 pid=1 pos=1 obj=92872 op='TABLE ACCESS BY INDEX ROWID AQ_SRVNTFN_TABLE_1 (cr=4 pr=0 pw=0 time=42 us cost=8 size=185496 card=12)'
STAT #140416371125984 id=3 cnt=1 pid=2 pos=1 obj=92883 op='INDEX RANGE SCAN AQ$_AQ_SRVNTFN_TABLE_1_I (cr=3 pr=0 pw=0 time=26 us cost=2 size=0 card=12)'
BINDS #140416371125984:
Bind#0
oacdty=01 mxl=32(20) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=56 off=0
kxsbbbfp=7fb53bdb2330 bln=32 avl=20 flg=05
value="AQ_SRVNTFN_TABLE_Q_1"
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bdb2350 bln=22 avl=01 flg=01
value=0
EXEC #140416371125984:c=0,e=94,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=555787387,tim=13836798429460
FETCH #140416371125984:c=0,e=81,p=0,cr=4,cu=3,mis=0,r=1,dep=2,og=1,plh=555787387,tim=13836798429549
BINDS #140416370011792:
Bind#0
oacdty=11 mxl=16(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=00 csi=00 siz=16 off=0
kxsbbbfp=7fb53bc68b4c bln=16 avl=16 flg=09
value=00024474.0000.0001
EXEC #140416370011792:c=0,e=139,p=0,cr=1,cu=7,mis=0,r=1,dep=2,og=1,plh=2426698438,tim=13836798429711
PARSE #140416370084536:c=0,e=12,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=0,tim=13836798429834
BINDS #140416370084536:
Bind#0
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#1
oacdty=01 mxl=128(49) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=128 off=0
kxsbbbfp=7fb53be5c62c bln=128 avl=49 flg=09
value=""SYS"."SCHEDULER$_EVENT_QUEUE":"SCHED$_AGT2$_113""
Bind#2
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd734e8 bln=22 avl=02 flg=05
value=1
Bind#3
oacdty=01 mxl=32(32) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb53be5c5dc bln=32 avl=32 flg=09
value="SYS.SCHEDULER$_JOB_EVENT_HANDLER"
Bind#4
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#5
oacdty=58 mxl=640(640) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0001 frm=00 csi=00 siz=664 off=0
toid ptr value=C148E090 length=16
00000000000000000000000000020011
kxsbbbfp=7fb53bd73238 bln=640 avl=00 flg=15
Bind#6
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=640
kxsbbbfp=7fb53bd734b8 bln=22 avl=01 flg=01
value=0
Bind#7
oacdty=01 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb53be5c74c bln=32 avl=30 flg=09
value=""SYS"."SCHEDULER$_EVENT_QUEUE""
Bind#8
oacdty=01 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb53be5c70c bln=32 avl=16 flg=09
value="SCHED$_AGT2$_113"
Bind#9
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=7fb53be5c6cc bln=32 avl=16 flg=09
value=0CAE65D4BE2617A9E05393000C0A1C83
Bind#10
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=72 off=0
kxsbbbfp=7fb53bd731d8 bln=22 avl=01 flg=05
value=0
Bind#11
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7fb53bd731f0 bln=22 avl=01 flg=01
value=0
Bind#12
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=48
kxsbbbfp=7fb53bd73208 bln=22 avl=03 flg=01
value=86400
Bind#13
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#14
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd704f8 bln=22 avl=01 flg=05
value=0
Bind#15
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#16
oacdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=8 off=0
kxsbbbfp=7fff25797500 bln=07 avl=07 flg=09
value="1/15/2015 9:27:36"
Bind#17
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd71510 bln=22 avl=01 flg=05
value=0
Bind#18
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb53be5c68c bln=32 avl=22 flg=09
value="SCHEDULER$_EVENT_AGENT"
Bind#19
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#20
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd731a8 bln=22 avl=01 flg=05
value=0
Bind#21
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#22
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=712 off=0
kxsbbbfp=7fb53bd701f0 bln=22 avl=02 flg=05
value=1
Bind#23
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7fb53bd70208 bln=22 avl=01 flg=01
value=0
Bind#24
oacdty=123 mxl=640(640) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0001 frm=00 csi=00 siz=0 off=48
toid ptr value=C148E0A0 length=16
FD9ACFEBF6C248A9E043B6A9E80AFB6F
kxsbbbfp=7fb53bd70220 bln=640 avl=00 flg=11
Bind#25
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=688
kxsbbbfp=7fb53bd704a0 bln=22 avl=00 flg=01
Bind#26
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#27
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd6d4b0 bln=22 avl=01 flg=05
value=0
BINDS #140416370263104:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc64f78 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc64f98 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370263104:c=0,e=66,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=1,plh=3250640613,tim=13836798430565
FETCH #140416370263104:c=0,e=20,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=1,plh=3250640613,tim=13836798430593
EXEC #140416370084536:c=0,e=850,p=0,cr=11,cu=4,mis=0,r=0,dep=2,og=1,plh=0,tim=13836798430758
ERROR #140416370084536:err=1031 tim=13836798430769
BINDS #140416370614808:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc63a98 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc63ab8 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370614808:c=1000,e=67,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=3250640613,tim=13836798430903
FETCH #140416370614808:c=0,e=10,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=4,plh=3250640613,tim=13836798430921
BINDS #140416370614808:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc63a98 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc63ab8 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370614808:c=0,e=55,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=3250640613,tim=13836798431175
FETCH #140416370614808:c=0,e=8,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=4,plh=3250640613,tim=13836798431191
CLOSE #140416370084536:c=0,e=6,dep=2,type=3,tim=13836798431281
XCTEND rlbk=1, rd_only=0, tim=13836798431332
BINDS #140416370394096:
Bind#0
oacdty=01 mxl=32(20) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc64f78 bln=32 avl=20 flg=05
value="AQ_SRVNTFN_TABLE_Q_1"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc64f98 bln=32 avl=16 flg=01
value=0795C28E325047CCE05393000C0ADE5D
EXEC #140416370394096:c=0,e=99,p=0,cr=4,cu=3,mis=0,r=0,dep=3,og=4,plh=1058480892,tim=13836798431585
FETCH #140416370394096:c=0,e=4,p=0,cr=0,cu=0,mis=0,r=1,dep=3,og=4,plh=1058480892,tim=13836798431600
PARSE #140416370599168:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=1154522461,tim=13836798431640
BINDS #140416370599168:
Bind#0
oacdty=11 mxl=16(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=00 csi=00 siz=16 off=0
kxsbbbfp=7fff25792ef0 bln=16 avl=16 flg=09
value=00024474.0000.0001
EXEC #140416370599168:c=0,e=66,p=0,cr=1,cu=1,mis=0,r=1,dep=3,og=4,plh=1154522461,tim=13836798431718
CLOSE #140416370599168:c=0,e=2,dep=3,type=3,tim=13836798431734
EXEC #140416370069808:c=0,e=442,p=0,cr=7,cu=14,mis=0,r=0,dep=2,og=0,plh=0,tim=13836798431772
CLOSE #140416370069808:c=0,e=1,dep=2,type=3,tim=13836798431785
: Exception Occured, Error msg:
ORA-00604: error occurred at recursive SQL level 2
ORA-01031: insufficient privileges
EXEC #140416369699048:c=0,e=11,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=2848324471,tim=13836798431849
FETCH #140416369699048:c=1000,e=40,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=1,plh=2848324471,tim=13836798431900
CLOSE #140416369699048:c=0,e=1,dep=2,type=3,tim=13836798431925
BINDS #140416371125984:
Bind#0
oacdty=01 mxl=32(20) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=56 off=0
kxsbbbfp=7fb53bdb2330 bln=32 avl=20 flg=05
value="AQ_SRVNTFN_TABLE_Q_1"
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bdb2350 bln=22 avl=01 flg=01
value=0
EXEC #140416371125984:c=0,e=62,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=555787387,tim=13836798432138
FETCH #140416371125984:c=0,e=62,p=0,cr=4,cu=3,mis=0,r=1,dep=2,og=1,plh=555787387,tim=13836798432209
BINDS #140416370011792:
Bind#0
oacdty=11 mxl=16(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=00 csi=00 siz=16 off=0
kxsbbbfp=7fb53bc6397c bln=16 avl=16 flg=09
value=00024474.0000.0001
EXEC #140416370011792:c=0,e=107,p=0,cr=1,cu=7,mis=0,r=1,dep=2,og=1,plh=2426698438,tim=13836798432340
PARSE #140416370084536:c=0,e=12,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=0,tim=13836798432458
BINDS #140416370084536:
Bind#0
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#1
oacdty=01 mxl=128(49) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=128 off=0
kxsbbbfp=7fb5407df55c bln=128 avl=49 flg=09
value=""SYS"."SCHEDULER$_EVENT_QUEUE":"SCHED$_AGT2$_113""
Bind#2
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd734e8 bln=22 avl=02 flg=05
value=1
Bind#3
oacdty=01 mxl=32(32) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb5407df50c bln=32 avl=32 flg=09
value="SYS.SCHEDULER$_JOB_EVENT_HANDLER"
Bind#4
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#5
oacdty=58 mxl=640(640) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0001 frm=00 csi=00 siz=664 off=0
toid ptr value=C148E090 length=16
00000000000000000000000000020011
kxsbbbfp=7fb53bd73238 bln=640 avl=00 flg=15
Bind#6
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=640
kxsbbbfp=7fb53bd734b8 bln=22 avl=01 flg=01
value=0
Bind#7
oacdty=01 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb5407df67c bln=32 avl=30 flg=09
value=""SYS"."SCHEDULER$_EVENT_QUEUE""
Bind#8
oacdty=01 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb5407df63c bln=32 avl=16 flg=09
value="SCHED$_AGT2$_113"
Bind#9
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=7fb5407df5fc bln=32 avl=16 flg=09
value=0CAE65D4BE2617A9E05393000C0A1C83
Bind#10
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=72 off=0
kxsbbbfp=7fb53bd731d8 bln=22 avl=01 flg=05
value=0
Bind#11
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7fb53bd731f0 bln=22 avl=01 flg=01
value=0
Bind#12
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=48
kxsbbbfp=7fb53bd73208 bln=22 avl=03 flg=01
value=86400
Bind#13
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#14
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd704f8 bln=22 avl=01 flg=05
value=0
Bind#15
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#16
oacdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=8 off=0
kxsbbbfp=7fff25797500 bln=07 avl=07 flg=09
value="1/15/2015 9:27:36"
Bind#17
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd71510 bln=22 avl=01 flg=05
value=0
Bind#18
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb5407df5bc bln=32 avl=22 flg=09
value="SCHEDULER$_EVENT_AGENT"
Bind#19
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#20
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd731a8 bln=22 avl=01 flg=05
value=0
Bind#21
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#22
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=712 off=0
kxsbbbfp=7fb53bd701f0 bln=22 avl=02 flg=05
value=1
Bind#23
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7fb53bd70208 bln=22 avl=01 flg=01
value=0
Bind#24
oacdty=123 mxl=640(640) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0001 frm=00 csi=00 siz=0 off=48
toid ptr value=C148E0A0 length=16
FD9ACFEBF6C248A9E043B6A9E80AFB6F
kxsbbbfp=7fb53bd70220 bln=640 avl=00 flg=11
Bind#25
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=688
kxsbbbfp=7fb53bd704a0 bln=22 avl=00 flg=01
Bind#26
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#27
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd6d4b0 bln=22 avl=01 flg=05
value=0
BINDS #140416370263104:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc60c68 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc60c88 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370263104:c=0,e=65,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=1,plh=3250640613,tim=13836798433160
FETCH #140416370263104:c=0,e=19,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=1,plh=3250640613,tim=13836798433187
EXEC #140416370084536:c=1000,e=824,p=0,cr=11,cu=4,mis=0,r=0,dep=2,og=1,plh=0,tim=13836798433340
ERROR #140416370084536:err=1031 tim=13836798433350
BINDS #140416370614808:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc5f788 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc5f7a8 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370614808:c=0,e=55,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=3250640613,tim=13836798433464
FETCH #140416370614808:c=0,e=8,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=4,plh=3250640613,tim=13836798433480
BINDS #140416370614808:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc5f788 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc5f7a8 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370614808:c=0,e=55,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=3250640613,tim=13836798433721
FETCH #140416370614808:c=0,e=9,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=4,plh=3250640613,tim=13836798433737
CLOSE #140416370084536:c=0,e=6,dep=2,type=3,tim=13836798433825
XCTEND rlbk=1, rd_only=0, tim=13836798433869
BINDS #140416370394096:
Bind#0
oacdty=01 mxl=32(20) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc60c68 bln=32 avl=20 flg=05
value="AQ_SRVNTFN_TABLE_Q_1"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc60c88 bln=32 avl=16 flg=01
value=0795C28E325047CCE05393000C0ADE5D
EXEC #140416370394096:c=0,e=103,p=0,cr=4,cu=3,mis=0,r=0,dep=3,og=4,plh=1058480892,tim=13836798434134
FETCH #140416370394096:c=0,e=4,p=0,cr=0,cu=0,mis=0,r=1,dep=3,og=4,plh=1058480892,tim=13836798434149
PARSE #140416370599168:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=1154522461,tim=13836798434188
BINDS #140416370599168:
Bind#0
oacdty=11 mxl=16(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=00 csi=00 siz=16 off=0
kxsbbbfp=7fff25792ef0 bln=16 avl=16 flg=09
value=00024474.0000.0001
EXEC #140416370599168:c=0,e=60,p=0,cr=1,cu=1,mis=0,r=1,dep=3,og=4,plh=1154522461,tim=13836798434260
CLOSE #140416370599168:c=0,e=2,dep=3,type=3,tim=13836798434276
EXEC #140416370069808:c=1000,e=447,p=0,cr=7,cu=14,mis=0,r=0,dep=2,og=0,plh=0,tim=13836798434314
CLOSE #140416370069808:c=0,e=0,dep=2,type=3,tim=13836798434326
: Exception Occured, Error msg:
ORA-00604: error occurred at recursive SQL level 2
ORA-01031: insufficient privileges
EXEC #140416369699048:c=0,e=10,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=2848324471,tim=13836798434387
FETCH #140416369699048:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=1,plh=2848324471,tim=13836798434436
CLOSE #140416369699048:c=0,e=1,dep=2,type=3,tim=13836798434457
16 янв 15, 12:04    [17126753]     Ответить | Цитировать Сообщить модератору
 Re: AQ$_PLSQL_NTFN ORA-01031: insufficient privileges  [new]
o)___
Guest
AlexVin
oracle 12.1.0.2.1 на линухе

*** SERVICE NAME:(SYS$USERS)
*** MODULE NAME:(DBMS_SCHEDULER)
*** ACTION NAME:(AQ$_PLSQL_NTFN_ююю)
валятся в лог джобы ошибки.
как понять, на что не хватает грантов?
: Exception Occured, Error msg:
ORA-00604: error occurred at recursive SQL level 2
ORA-01031: insufficient privileges

триггерром AFTER servererror ошибка не ловится.
трейс тут

+

*** 2015-01-15 14:27:41.035
*** SESSION ID:(380.18727) 2015-01-15 14:27:41.035
*** CLIENT ID:() 2015-01-15 14:27:41.035
*** SERVICE NAME:(SYS$USERS) 2015-01-15 14:27:41.035
*** MODULE NAME:() 2015-01-15 14:27:41.035
*** CLIENT DRIVER:() 2015-01-15 14:27:41.035
*** ACTION NAME:() 2015-01-15 14:27:41.035

CLOSE #140416371021168:c=0,e=1,dep=2,type=0,tim=13836798423029
=====================
PARSING IN CURSOR #140416370933024 len=397 dep=1 uid=0 oct=47 lid=0 tim=13836798423233 hv=6589810 ad='98955ac0' sqlid='dmfjmxs0693bk'
declare
l_user constant varchar2(30) := 'USRUSR';
begin
-- if substr(SYS_CONTEXT('USERENV', 'ACTION'), 1, 14) = 'AQ$_PLSQL_NTFN' then
if user = 'SYS' then
execute immediate 'alter session set tracefile_identifier=''NTFN''';
execute immediate 'ALTER SESSION SET EVENTS ''10046 TRACE NAME CONTEXT FOREVER, LEVEL 12 ''';
end if;
exception when others then null;
end logon_trigger_trace;
END OF STMT
EXEC #140416370933024:c=1000,e=597,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,plh=0,tim=13836798423232
CLOSE #140416370933024:c=0,e=9,dep=1,type=1,tim=13836798423301
*** MODULE NAME:(DBMS_SCHEDULER) 2015-01-15 14:27:41.035
*** ACTION NAME:(AQ$_PLSQL_NTFN_1421314060) 2015-01-15 14:27:41.035

CLOSE #140416447483896:c=0,e=2,dep=1,type=1,tim=13836798423495
=====================
PARSING IN CURSOR #140416371022544 len=37 dep=1 uid=0 oct=47 lid=0 tim=13836798423551 hv=295050286 ad='87e02400' sqlid='b9c6ffh8tc71f'
BEGIN dbms_output.enable(NULL); END;
END OF STMT
PARSE #140416371022544:c=0,e=31,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=0,tim=13836798423551
EXEC #140416371022544:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,plh=0,tim=13836798423610
CLOSE #140416371022544:c=0,e=6,dep=1,type=1,tim=13836798423637
=====================
PARSING IN CURSOR #140416371021448 len=40 dep=1 uid=0 oct=170 lid=0 tim=13836798423685 hv=1780980331 ad='96212c58' sqlid='59p1yadp2g6mb'
call DBMS_AQADM_SYS.REGISTER_DRIVER ( )
END OF STMT
PARSE #140416371021448:c=0,e=38,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=0,tim=13836798423685
=====================
PARSING IN CURSOR #140416369699048 len=42 dep=2 uid=0 oct=3 lid=0 tim=13836798424041 hv=3324291061 ad='bf7baef8' sqlid='brq600g3299zp'
SELECT INSTANCE_NUMBER FROM SYS.V$INSTANCE
END OF STMT
PARSE #140416369699048:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=2848324471,tim=13836798424041
EXEC #140416369699048:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=2848324471,tim=13836798424096
FETCH #140416369699048:c=0,e=57,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=1,plh=2848324471,tim=13836798424164
STAT #140416369699048 id=1 cnt=1 pid=0 pos=1 obj=0 op='MERGE JOIN CARTESIAN (cr=0 pr=0 pw=0 time=65 us cost=0 size=6000 card=100)'
STAT #140416369699048 id=2 cnt=1 pid=1 pos=1 obj=0 op='MERGE JOIN CARTESIAN (cr=0 pr=0 pw=0 time=50 us cost=0 size=60 card=1)'
STAT #140416369699048 id=3 cnt=1 pid=2 pos=1 obj=0 op='FIXED TABLE FULL X$KSUXSINST (cr=0 pr=0 pw=0 time=23 us cost=0 size=26 card=1)'
STAT #140416369699048 id=4 cnt=1 pid=2 pos=2 obj=0 op='BUFFER SORT (cr=0 pr=0 pw=0 time=22 us cost=0 size=34 card=1)'
STAT #140416369699048 id=5 cnt=1 pid=4 pos=1 obj=0 op='FIXED TABLE FULL X$KVIT (cr=0 pr=0 pw=0 time=11 us cost=0 size=34 card=1)'
STAT #140416369699048 id=6 cnt=1 pid=1 pos=2 obj=0 op='BUFFER SORT (cr=0 pr=0 pw=0 time=11 us cost=0 size=0 card=100)'
STAT #140416369699048 id=7 cnt=1 pid=6 pos=1 obj=0 op='FIXED TABLE FULL X$QUIESCE (cr=0 pr=0 pw=0 time=8 us cost=0 size=0 card=100)'
CLOSE #140416369699048:c=0,e=1,dep=2,type=3,tim=13836798424264
=====================
PARSING IN CURSOR #140416371126856 len=47 dep=2 uid=0 oct=3 lid=0 tim=13836798424478 hv=1023521005 ad='87fca598' sqlid='cb21bacyh3c7d'
select metadata from kopm$ where name='DB_FDO'
END OF STMT
PARSE #140416371126856:c=0,e=30,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=3452538079,tim=13836798424478
EXEC #140416371126856:c=0,e=13,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=3452538079,tim=13836798424525
FETCH #140416371126856:c=0,e=7,p=0,cr=2,cu=0,mis=0,r=1,dep=2,og=4,plh=3452538079,tim=13836798424544
STAT #140416371126856 id=1 cnt=1 pid=0 pos=1 obj=679 op='TABLE ACCESS BY INDEX ROWID KOPM$ (cr=2 pr=0 pw=0 time=9 us cost=1 size=108 card=1)'
STAT #140416371126856 id=2 cnt=1 pid=1 pos=1 obj=680 op='INDEX UNIQUE SCAN I_KOPM1 (cr=1 pr=0 pw=0 time=4 us cost=0 size=0 card=1)'
CLOSE #140416371126856:c=0,e=2,dep=2,type=0,tim=13836798424586
=====================
PARSING IN CURSOR #140416371125984 len=580 dep=2 uid=0 oct=3 lid=0 tim=13836798424887 hv=1621801003 ad='bf5d78d8' sqlid='gzf71xphapf1b'
select /*+ INDEX(TAB AQ$_AQ_SRVNTFN_TABLE_1_I) */ tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration ,tab.retry_count, tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid, tab.user_prop, tab.user_data from "SYS"."AQ_SRVNTFN_TABLE_1" tab where q_name = :1 and (state = :2 ) order by q_name, state, enq_time, step_no, chain_no, local_order_no for update skip locked
END OF STMT
PARSE #140416371125984:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=555787387,tim=13836798424886
BINDS #140416371125984:
Bind#0
oacdty=01 mxl=32(20) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=56 off=0
kxsbbbfp=7fb53bdb2330 bln=32 avl=20 flg=05
value="AQ_SRVNTFN_TABLE_Q_1"
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bdb2350 bln=22 avl=01 flg=01
value=0
EXEC #140416371125984:c=0,e=105,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=555787387,tim=13836798425147
FETCH #140416371125984:c=0,e=132,p=0,cr=4,cu=3,mis=0,r=1,dep=2,og=1,plh=555787387,tim=13836798425288
=====================
PARSING IN CURSOR #140416370011792 len=93 dep=2 uid=0 oct=7 lid=0 tim=13836798425352 hv=3278575206 ad='c15cbb98' sqlid='61cgh171qq5m6'
delete /*+ CACHE_CB("AQ_SRVNTFN_TABLE_1") */ from "SYS"."AQ_SRVNTFN_TABLE_1" where rowid = :1
END OF STMT
PARSE #140416370011792:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=2426698438,tim=13836798425351
BINDS #140416370011792:
Bind#0
oacdty=11 mxl=16(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=00 csi=00 siz=16 off=0
kxsbbbfp=7fb53bdb8104 bln=16 avl=16 flg=09
value=00024474.0000.0001
EXEC #140416370011792:c=0,e=158,p=0,cr=1,cu=7,mis=0,r=1,dep=2,og=1,plh=2426698438,tim=13836798425543
STAT #140416370011792 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE AQ_SRVNTFN_TABLE_1 (cr=1 pr=0 pw=0 time=115 us)'
STAT #140416370011792 id=2 cnt=1 pid=1 pos=1 obj=92872 op='TABLE ACCESS BY USER ROWID AQ_SRVNTFN_TABLE_1 (cr=1 pr=0 pw=0 time=6 us cost=1 size=117 card=1)'
=====================
PARSING IN CURSOR #140416370084536 len=322 dep=2 uid=0 oct=47 lid=0 tim=13836798425967 hv=3545476626 ad='bfd32988' sqlid='f7zggdz9p7bhk'
begin SYS.SCHEDULER$_JOB_EVENT_HANDLER(context => :1,reginfo => sys.aq$_reg_info(:2, :3, :4, :5, :6, :7),descr => sys.aq$_descriptor(:8, :9, :10, sys.msg_prop_t(:11, :12, :13, :14, :15, :16, :17, :18, sys.aq$_agent(:19, :20, :21), :22, :23), sys.aq$_ntfn_descriptor(:24), :25, :26), payload => :27, payloadl => :28); end;
END OF STMT
PARSE #140416370084536:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=0,tim=13836798425967
BINDS #140416370084536:
Bind#0
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#1
oacdty=01 mxl=128(49) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=128 off=0
kxsbbbfp=7fb53be817ac bln=128 avl=49 flg=09
value=""SYS"."SCHEDULER$_EVENT_QUEUE":"SCHED$_AGT2$_113""
Bind#2
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd6daa0 bln=22 avl=02 flg=05
value=1
Bind#3
oacdty=01 mxl=32(32) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb53be8175c bln=32 avl=32 flg=09
value="SYS.SCHEDULER$_JOB_EVENT_HANDLER"
Bind#4
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#5
oacdty=58 mxl=640(640) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0001 frm=00 csi=00 siz=664 off=0
toid ptr value=C148E090 length=16
00000000000000000000000000020011
kxsbbbfp=7fb53bd6d7f0 bln=640 avl=00 flg=15
Bind#6
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=640
kxsbbbfp=7fb53bd6da70 bln=22 avl=01 flg=01
value=0
Bind#7
oacdty=01 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb53be818cc bln=32 avl=30 flg=09
value=""SYS"."SCHEDULER$_EVENT_QUEUE""
Bind#8
oacdty=01 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb53be8188c bln=32 avl=16 flg=09
value="SCHED$_AGT2$_113"
Bind#9
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=7fb53be8184c bln=32 avl=16 flg=09
value=0CAE65D4BE2617A9E05393000C0A1C83
Bind#10
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=72 off=0
kxsbbbfp=7fb53bd6d790 bln=22 avl=01 flg=05
value=0
Bind#11
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7fb53bd6d7a8 bln=22 avl=01 flg=01
value=0
Bind#12
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=48
kxsbbbfp=7fb53bd6d7c0 bln=22 avl=03 flg=01
value=86400
Bind#13
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#14
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bddde78 bln=22 avl=01 flg=05
value=0
Bind#15
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#16
oacdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=8 off=0
kxsbbbfp=7fff25797500 bln=07 avl=07 flg=09
value="1/15/2015 9:27:36"
Bind#17
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bddee90 bln=22 avl=01 flg=05
value=0
Bind#18
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb53be8180c bln=32 avl=22 flg=09
value="SCHEDULER$_EVENT_AGENT"
Bind#19
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#20
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd6d760 bln=22 avl=01 flg=05
value=0
Bind#21
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#22
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=712 off=0
kxsbbbfp=7fb53bdddb70 bln=22 avl=02 flg=05
value=1
Bind#23
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7fb53bdddb88 bln=22 avl=01 flg=01
value=0
Bind#24
oacdty=123 mxl=640(640) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0001 frm=00 csi=00 siz=0 off=48
toid ptr value=C148E0A0 length=16
FD9ACFEBF6C248A9E043B6A9E80AFB6F
kxsbbbfp=7fb53bdddba0 bln=640 avl=00 flg=11
Bind#25
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=688
kxsbbbfp=7fb53bddde20 bln=22 avl=00 flg=01
Bind#26
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#27
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd7d638 bln=22 avl=01 flg=05
value=0
=====================
PARSING IN CURSOR #140416370263104 len=427 dep=3 uid=0 oct=3 lid=0 tim=13836798427049 hv=2299947350 ad='96b40cd8' sqlid='5ybur2u4jcuaq'
select tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration , tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid, tab.user_prop, tab.user_data from "SYS"."SCHEDULER$_EVENT_QTAB" tab where q_name = :1 and msgid = :2
END OF STMT
PARSE #140416370263104:c=0,e=29,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=1,plh=3250640613,tim=13836798427048
BINDS #140416370263104:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53be29f50 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53be29f70 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370263104:c=0,e=73,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=1,plh=3250640613,tim=13836798427189
FETCH #140416370263104:c=0,e=25,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=1,plh=3250640613,tim=13836798427223
STAT #140416370263104 id=1 cnt=1 pid=0 pos=1 obj=17384 op='TABLE ACCESS BY INDEX ROWID SCHEDULER$_EVENT_QTAB (cr=3 pr=0 pw=0 time=17 us cost=2 size=20874 card=1)'
STAT #140416370263104 id=2 cnt=1 pid=1 pos=1 obj=17387 op='INDEX UNIQUE SCAN SYS_C004400 (cr=2 pr=0 pw=0 time=6 us cost=1 size=0 card=1)'
EXEC #140416370084536:c=1000,e=1371,p=0,cr=14,cu=4,mis=0,r=0,dep=2,og=1,plh=0,tim=13836798427556
ERROR #140416370084536:err=1031 tim=13836798427567
=====================
PARSING IN CURSOR #140416370614808 len=397 dep=3 uid=0 oct=3 lid=0 tim=13836798427683 hv=814242814 ad='96b85e98' sqlid='gu3una4s8hqzy'
select tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration , tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid from "SYS"."SCHEDULER$_EVENT_QTAB" tab where q_name = :1 and msgid = :2
END OF STMT
PARSE #140416370614808:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=3250640613,tim=13836798427683
BINDS #140416370614808:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53be3ed08 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53be3ed28 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370614808:c=0,e=65,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=3250640613,tim=13836798427802
FETCH #140416370614808:c=0,e=11,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=4,plh=3250640613,tim=13836798427821
STAT #140416370614808 id=1 cnt=1 pid=0 pos=1 obj=17384 op='TABLE ACCESS BY INDEX ROWID SCHEDULER$_EVENT_QTAB (cr=3 pr=0 pw=0 time=12 us)'
STAT #140416370614808 id=2 cnt=1 pid=1 pos=1 obj=17387 op='INDEX UNIQUE SCAN SYS_C004400 (cr=2 pr=0 pw=0 time=7 us)'
BINDS #140416370614808:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53be3d8d8 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53be3d8f8 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370614808:c=0,e=77,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=3250640613,tim=13836798428177
FETCH #140416370614808:c=0,e=9,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=4,plh=3250640613,tim=13836798428196
CLOSE #140416370084536:c=0,e=8,dep=2,type=1,tim=13836798428300
=====================
PARSING IN CURSOR #140416370069808 len=8 dep=2 uid=0 oct=45 lid=0 tim=13836798428364 hv=2761672982 ad='0' sqlid='8sst43uk9rk8q'
ROLLBACK
END OF STMT
PARSE #140416370069808:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=0,plh=0,tim=13836798428364
XCTEND rlbk=1, rd_only=0, tim=13836798428394
=====================
PARSING IN CURSOR #140416370394096 len=447 dep=3 uid=0 oct=3 lid=0 tim=13836798428581 hv=1681367889 ad='bf9a8a00' sqlid='8ffh6kjk3g8uj'
select tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration ,tab.retry_count, tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid from "SYS"."AQ_SRVNTFN_TABLE_1" tab where q_name = :1 and msgid = :2 and deq_time is null for update nowait
END OF STMT
PARSE #140416370394096:c=0,e=25,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=1058480892,tim=13836798428580
BINDS #140416370394096:
Bind#0
oacdty=01 mxl=32(20) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc6a148 bln=32 avl=20 flg=05
value="AQ_SRVNTFN_TABLE_Q_1"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc6a168 bln=32 avl=16 flg=01
value=0795C28E325047CCE05393000C0ADE5D
EXEC #140416370394096:c=0,e=111,p=0,cr=4,cu=2,mis=0,r=0,dep=3,og=4,plh=1058480892,tim=13836798428744
FETCH #140416370394096:c=0,e=5,p=0,cr=0,cu=0,mis=0,r=1,dep=3,og=4,plh=1058480892,tim=13836798428760
STAT #140416370394096 id=1 cnt=1 pid=0 pos=1 obj=0 op='FOR UPDATE (cr=4 pr=0 pw=0 time=47 us)'
STAT #140416370394096 id=2 cnt=1 pid=1 pos=1 obj=92872 op='TABLE ACCESS BY INDEX ROWID AQ_SRVNTFN_TABLE_1 (cr=4 pr=0 pw=0 time=10 us)'
STAT #140416370394096 id=3 cnt=1 pid=2 pos=1 obj=92881 op='INDEX UNIQUE SCAN SYS_C0010025 (cr=3 pr=0 pw=0 time=5 us)'
=====================
PARSING IN CURSOR #140416370599168 len=85 dep=3 uid=0 oct=6 lid=0 tim=13836798428845 hv=2207236396 ad='904f1600' sqlid='g5m4j821szh9c'
update "SYS"."AQ_SRVNTFN_TABLE_1" set retry_count = retry_count + 1 where rowid = :1
END OF STMT
PARSE #140416370599168:c=0,e=25,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=1154522461,tim=13836798428845
BINDS #140416370599168:
Bind#0
oacdty=11 mxl=16(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=00 csi=00 siz=16 off=0
kxsbbbfp=7fff257925a0 bln=16 avl=16 flg=09
value=00024474.0000.0001
EXEC #140416370599168:c=0,e=88,p=0,cr=1,cu=1,mis=0,r=1,dep=3,og=4,plh=1154522461,tim=13836798428968
STAT #140416370599168 id=1 cnt=0 pid=0 pos=1 obj=0 op='UPDATE AQ_SRVNTFN_TABLE_1 (cr=1 pr=0 pw=0 time=46 us)'
STAT #140416370599168 id=2 cnt=1 pid=1 pos=1 obj=92872 op='TABLE ACCESS BY USER ROWID AQ_SRVNTFN_TABLE_1 (cr=1 pr=0 pw=0 time=5 us)'
CLOSE #140416370599168:c=0,e=2,dep=3,type=1,tim=13836798429007
EXEC #140416370069808:c=1000,e=661,p=0,cr=7,cu=13,mis=0,r=0,dep=2,og=0,plh=0,tim=13836798429049
CLOSE #140416370069808:c=0,e=1,dep=2,type=3,tim=13836798429064
: Exception Occured, Error msg:
ORA-00604: error occurred at recursive SQL level 2
ORA-01031: insufficient privileges
EXEC #140416369699048:c=0,e=11,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=2848324471,tim=13836798429149
FETCH #140416369699048:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=1,plh=2848324471,tim=13836798429194
CLOSE #140416369699048:c=0,e=1,dep=2,type=3,tim=13836798429216
STAT #140416371125984 id=1 cnt=1 pid=0 pos=1 obj=0 op='FOR UPDATE (cr=4 pr=0 pw=0 time=113 us)'
STAT #140416371125984 id=2 cnt=1 pid=1 pos=1 obj=92872 op='TABLE ACCESS BY INDEX ROWID AQ_SRVNTFN_TABLE_1 (cr=4 pr=0 pw=0 time=42 us cost=8 size=185496 card=12)'
STAT #140416371125984 id=3 cnt=1 pid=2 pos=1 obj=92883 op='INDEX RANGE SCAN AQ$_AQ_SRVNTFN_TABLE_1_I (cr=3 pr=0 pw=0 time=26 us cost=2 size=0 card=12)'
BINDS #140416371125984:
Bind#0
oacdty=01 mxl=32(20) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=56 off=0
kxsbbbfp=7fb53bdb2330 bln=32 avl=20 flg=05
value="AQ_SRVNTFN_TABLE_Q_1"
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bdb2350 bln=22 avl=01 flg=01
value=0
EXEC #140416371125984:c=0,e=94,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=555787387,tim=13836798429460
FETCH #140416371125984:c=0,e=81,p=0,cr=4,cu=3,mis=0,r=1,dep=2,og=1,plh=555787387,tim=13836798429549
BINDS #140416370011792:
Bind#0
oacdty=11 mxl=16(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=00 csi=00 siz=16 off=0
kxsbbbfp=7fb53bc68b4c bln=16 avl=16 flg=09
value=00024474.0000.0001
EXEC #140416370011792:c=0,e=139,p=0,cr=1,cu=7,mis=0,r=1,dep=2,og=1,plh=2426698438,tim=13836798429711
PARSE #140416370084536:c=0,e=12,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=0,tim=13836798429834
BINDS #140416370084536:
Bind#0
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#1
oacdty=01 mxl=128(49) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=128 off=0
kxsbbbfp=7fb53be5c62c bln=128 avl=49 flg=09
value=""SYS"."SCHEDULER$_EVENT_QUEUE":"SCHED$_AGT2$_113""
Bind#2
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd734e8 bln=22 avl=02 flg=05
value=1
Bind#3
oacdty=01 mxl=32(32) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb53be5c5dc bln=32 avl=32 flg=09
value="SYS.SCHEDULER$_JOB_EVENT_HANDLER"
Bind#4
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#5
oacdty=58 mxl=640(640) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0001 frm=00 csi=00 siz=664 off=0
toid ptr value=C148E090 length=16
00000000000000000000000000020011
kxsbbbfp=7fb53bd73238 bln=640 avl=00 flg=15
Bind#6
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=640
kxsbbbfp=7fb53bd734b8 bln=22 avl=01 flg=01
value=0
Bind#7
oacdty=01 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb53be5c74c bln=32 avl=30 flg=09
value=""SYS"."SCHEDULER$_EVENT_QUEUE""
Bind#8
oacdty=01 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb53be5c70c bln=32 avl=16 flg=09
value="SCHED$_AGT2$_113"
Bind#9
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=7fb53be5c6cc bln=32 avl=16 flg=09
value=0CAE65D4BE2617A9E05393000C0A1C83
Bind#10
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=72 off=0
kxsbbbfp=7fb53bd731d8 bln=22 avl=01 flg=05
value=0
Bind#11
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7fb53bd731f0 bln=22 avl=01 flg=01
value=0
Bind#12
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=48
kxsbbbfp=7fb53bd73208 bln=22 avl=03 flg=01
value=86400
Bind#13
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#14
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd704f8 bln=22 avl=01 flg=05
value=0
Bind#15
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#16
oacdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=8 off=0
kxsbbbfp=7fff25797500 bln=07 avl=07 flg=09
value="1/15/2015 9:27:36"
Bind#17
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd71510 bln=22 avl=01 flg=05
value=0
Bind#18
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb53be5c68c bln=32 avl=22 flg=09
value="SCHEDULER$_EVENT_AGENT"
Bind#19
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#20
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd731a8 bln=22 avl=01 flg=05
value=0
Bind#21
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#22
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=712 off=0
kxsbbbfp=7fb53bd701f0 bln=22 avl=02 flg=05
value=1
Bind#23
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7fb53bd70208 bln=22 avl=01 flg=01
value=0
Bind#24
oacdty=123 mxl=640(640) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0001 frm=00 csi=00 siz=0 off=48
toid ptr value=C148E0A0 length=16
FD9ACFEBF6C248A9E043B6A9E80AFB6F
kxsbbbfp=7fb53bd70220 bln=640 avl=00 flg=11
Bind#25
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=688
kxsbbbfp=7fb53bd704a0 bln=22 avl=00 flg=01
Bind#26
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#27
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd6d4b0 bln=22 avl=01 flg=05
value=0
BINDS #140416370263104:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc64f78 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc64f98 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370263104:c=0,e=66,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=1,plh=3250640613,tim=13836798430565
FETCH #140416370263104:c=0,e=20,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=1,plh=3250640613,tim=13836798430593
EXEC #140416370084536:c=0,e=850,p=0,cr=11,cu=4,mis=0,r=0,dep=2,og=1,plh=0,tim=13836798430758
ERROR #140416370084536:err=1031 tim=13836798430769
BINDS #140416370614808:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc63a98 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc63ab8 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370614808:c=1000,e=67,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=3250640613,tim=13836798430903
FETCH #140416370614808:c=0,e=10,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=4,plh=3250640613,tim=13836798430921
BINDS #140416370614808:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc63a98 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc63ab8 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370614808:c=0,e=55,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=3250640613,tim=13836798431175
FETCH #140416370614808:c=0,e=8,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=4,plh=3250640613,tim=13836798431191
CLOSE #140416370084536:c=0,e=6,dep=2,type=3,tim=13836798431281
XCTEND rlbk=1, rd_only=0, tim=13836798431332
BINDS #140416370394096:
Bind#0
oacdty=01 mxl=32(20) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc64f78 bln=32 avl=20 flg=05
value="AQ_SRVNTFN_TABLE_Q_1"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc64f98 bln=32 avl=16 flg=01
value=0795C28E325047CCE05393000C0ADE5D
EXEC #140416370394096:c=0,e=99,p=0,cr=4,cu=3,mis=0,r=0,dep=3,og=4,plh=1058480892,tim=13836798431585
FETCH #140416370394096:c=0,e=4,p=0,cr=0,cu=0,mis=0,r=1,dep=3,og=4,plh=1058480892,tim=13836798431600
PARSE #140416370599168:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=1154522461,tim=13836798431640
BINDS #140416370599168:
Bind#0
oacdty=11 mxl=16(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=00 csi=00 siz=16 off=0
kxsbbbfp=7fff25792ef0 bln=16 avl=16 flg=09
value=00024474.0000.0001
EXEC #140416370599168:c=0,e=66,p=0,cr=1,cu=1,mis=0,r=1,dep=3,og=4,plh=1154522461,tim=13836798431718
CLOSE #140416370599168:c=0,e=2,dep=3,type=3,tim=13836798431734
EXEC #140416370069808:c=0,e=442,p=0,cr=7,cu=14,mis=0,r=0,dep=2,og=0,plh=0,tim=13836798431772
CLOSE #140416370069808:c=0,e=1,dep=2,type=3,tim=13836798431785
: Exception Occured, Error msg:
ORA-00604: error occurred at recursive SQL level 2
ORA-01031: insufficient privileges
EXEC #140416369699048:c=0,e=11,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=2848324471,tim=13836798431849
FETCH #140416369699048:c=1000,e=40,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=1,plh=2848324471,tim=13836798431900
CLOSE #140416369699048:c=0,e=1,dep=2,type=3,tim=13836798431925
BINDS #140416371125984:
Bind#0
oacdty=01 mxl=32(20) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=56 off=0
kxsbbbfp=7fb53bdb2330 bln=32 avl=20 flg=05
value="AQ_SRVNTFN_TABLE_Q_1"
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bdb2350 bln=22 avl=01 flg=01
value=0
EXEC #140416371125984:c=0,e=62,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=555787387,tim=13836798432138
FETCH #140416371125984:c=0,e=62,p=0,cr=4,cu=3,mis=0,r=1,dep=2,og=1,plh=555787387,tim=13836798432209
BINDS #140416370011792:
Bind#0
oacdty=11 mxl=16(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=00 csi=00 siz=16 off=0
kxsbbbfp=7fb53bc6397c bln=16 avl=16 flg=09
value=00024474.0000.0001
EXEC #140416370011792:c=0,e=107,p=0,cr=1,cu=7,mis=0,r=1,dep=2,og=1,plh=2426698438,tim=13836798432340
PARSE #140416370084536:c=0,e=12,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=0,tim=13836798432458
BINDS #140416370084536:
Bind#0
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#1
oacdty=01 mxl=128(49) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=128 off=0
kxsbbbfp=7fb5407df55c bln=128 avl=49 flg=09
value=""SYS"."SCHEDULER$_EVENT_QUEUE":"SCHED$_AGT2$_113""
Bind#2
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd734e8 bln=22 avl=02 flg=05
value=1
Bind#3
oacdty=01 mxl=32(32) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb5407df50c bln=32 avl=32 flg=09
value="SYS.SCHEDULER$_JOB_EVENT_HANDLER"
Bind#4
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#5
oacdty=58 mxl=640(640) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0001 frm=00 csi=00 siz=664 off=0
toid ptr value=C148E090 length=16
00000000000000000000000000020011
kxsbbbfp=7fb53bd73238 bln=640 avl=00 flg=15
Bind#6
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=640
kxsbbbfp=7fb53bd734b8 bln=22 avl=01 flg=01
value=0
Bind#7
oacdty=01 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb5407df67c bln=32 avl=30 flg=09
value=""SYS"."SCHEDULER$_EVENT_QUEUE""
Bind#8
oacdty=01 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb5407df63c bln=32 avl=16 flg=09
value="SCHED$_AGT2$_113"
Bind#9
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=7fb5407df5fc bln=32 avl=16 flg=09
value=0CAE65D4BE2617A9E05393000C0A1C83
Bind#10
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=72 off=0
kxsbbbfp=7fb53bd731d8 bln=22 avl=01 flg=05
value=0
Bind#11
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7fb53bd731f0 bln=22 avl=01 flg=01
value=0
Bind#12
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=48
kxsbbbfp=7fb53bd73208 bln=22 avl=03 flg=01
value=86400
Bind#13
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#14
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd704f8 bln=22 avl=01 flg=05
value=0
Bind#15
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#16
oacdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=8 off=0
kxsbbbfp=7fff25797500 bln=07 avl=07 flg=09
value="1/15/2015 9:27:36"
Bind#17
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd71510 bln=22 avl=01 flg=05
value=0
Bind#18
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=7fb5407df5bc bln=32 avl=22 flg=09
value="SCHEDULER$_EVENT_AGENT"
Bind#19
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=01 csi=171 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#20
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd731a8 bln=22 avl=01 flg=05
value=0
Bind#21
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#22
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=712 off=0
kxsbbbfp=7fb53bd701f0 bln=22 avl=02 flg=05
value=1
Bind#23
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7fb53bd70208 bln=22 avl=01 flg=01
value=0
Bind#24
oacdty=123 mxl=640(640) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=0001 frm=00 csi=00 siz=0 off=48
toid ptr value=C148E0A0 length=16
FD9ACFEBF6C248A9E043B6A9E80AFB6F
kxsbbbfp=7fb53bd70220 bln=640 avl=00 flg=11
Bind#25
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=0 off=688
kxsbbbfp=7fb53bd704a0 bln=22 avl=00 flg=01
Bind#26
oacdty=23 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=11 fl2=0001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#27
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fb53bd6d4b0 bln=22 avl=01 flg=05
value=0
BINDS #140416370263104:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc60c68 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc60c88 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370263104:c=0,e=65,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=1,plh=3250640613,tim=13836798433160
FETCH #140416370263104:c=0,e=19,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=1,plh=3250640613,tim=13836798433187
EXEC #140416370084536:c=1000,e=824,p=0,cr=11,cu=4,mis=0,r=0,dep=2,og=1,plh=0,tim=13836798433340
ERROR #140416370084536:err=1031 tim=13836798433350
BINDS #140416370614808:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc5f788 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc5f7a8 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370614808:c=0,e=55,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=3250640613,tim=13836798433464
FETCH #140416370614808:c=0,e=8,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=4,plh=3250640613,tim=13836798433480
BINDS #140416370614808:
Bind#0
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc5f788 bln=32 avl=22 flg=05
value="SCHEDULER$_EVENT_QUEUE"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc5f7a8 bln=32 avl=16 flg=01
value=0CAE65D4BE2617A9E05393000C0A1C83
EXEC #140416370614808:c=0,e=55,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=3250640613,tim=13836798433721
FETCH #140416370614808:c=0,e=9,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=4,plh=3250640613,tim=13836798433737
CLOSE #140416370084536:c=0,e=6,dep=2,type=3,tim=13836798433825
XCTEND rlbk=1, rd_only=0, tim=13836798433869
BINDS #140416370394096:
Bind#0
oacdty=01 mxl=32(20) mxlc=00 mal=00 scl=00 pre=00
oacflg=12 fl2=0000 frm=01 csi=171 siz=64 off=0
kxsbbbfp=7fb53bc60c68 bln=32 avl=20 flg=05
value="AQ_SRVNTFN_TABLE_Q_1"
Bind#1
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0000 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fb53bc60c88 bln=32 avl=16 flg=01
value=0795C28E325047CCE05393000C0ADE5D
EXEC #140416370394096:c=0,e=103,p=0,cr=4,cu=3,mis=0,r=0,dep=3,og=4,plh=1058480892,tim=13836798434134
FETCH #140416370394096:c=0,e=4,p=0,cr=0,cu=0,mis=0,r=1,dep=3,og=4,plh=1058480892,tim=13836798434149
PARSE #140416370599168:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=1154522461,tim=13836798434188
BINDS #140416370599168:
Bind#0
oacdty=11 mxl=16(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=00 csi=00 siz=16 off=0
kxsbbbfp=7fff25792ef0 bln=16 avl=16 flg=09
value=00024474.0000.0001
EXEC #140416370599168:c=0,e=60,p=0,cr=1,cu=1,mis=0,r=1,dep=3,og=4,plh=1154522461,tim=13836798434260
CLOSE #140416370599168:c=0,e=2,dep=3,type=3,tim=13836798434276
EXEC #140416370069808:c=1000,e=447,p=0,cr=7,cu=14,mis=0,r=0,dep=2,og=0,plh=0,tim=13836798434314
CLOSE #140416370069808:c=0,e=0,dep=2,type=3,tim=13836798434326
: Exception Occured, Error msg:
ORA-00604: error occurred at recursive SQL level 2
ORA-01031: insufficient privileges
EXEC #140416369699048:c=0,e=10,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=2848324471,tim=13836798434387
FETCH #140416369699048:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=1,plh=2848324471,tim=13836798434436
CLOSE #140416369699048:c=0,e=1,dep=2,type=3,tim=13836798434457

А что в курсоре sqlid='8sst43uk9rk8q'?
16 янв 15, 12:40    [17126989]     Ответить | Цитировать Сообщить модератору
 Re: AQ$_PLSQL_NTFN ORA-01031: insufficient privileges  [new]
AlexVin
Member

Откуда: E-burg
Сообщений: 1055
так вот судя по трейсу ROLLBACK
16 янв 15, 12:57    [17127125]     Ответить | Цитировать Сообщить модератору
 Re: AQ$_PLSQL_NTFN ORA-01031: insufficient privileges  [new]
SeaGate
Member

Откуда: Новосибирск
Сообщений: 1635
AlexVin,

Вот это часть, соответствующая первой ORA-1031
PARSING IN CURSOR #140416370084536 len=322 dep=2 uid=0 oct=47 lid=0 tim=13836798425967 hv=3545476626 ad='bfd32988' sqlid='f7zggdz9p7bhk'
begin SYS.SCHEDULER$_JOB_EVENT_HANDLER(context => :1,reginfo => sys.aq$_reg_info(:2, :3, :4, :5, :6, :7),descr => sys.aq$_descriptor(:8, :9, :10, sys.msg_prop_t(:11, :12, :13, :14, :15, :16, :17, :18, sys.aq$_agent(:19, :20, :21), :22, :23), sys.aq$_ntfn_descriptor(:24), :25, :26), payload => :27, payloadl => :28); end;
END OF STMT
PARSE #140416370084536:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=0,tim=13836798425967
BINDS #140416370084536:

PARSING IN CURSOR #140416370263104 len=427 dep=3 uid=0 oct=3 lid=0 tim=13836798427049 hv=2299947350 ad='96b40cd8' sqlid='5ybur2u4jcuaq'
select tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration , tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid, tab.user_prop, tab.user_data from "SYS"."SCHEDULER$_EVENT_QTAB" tab where q_name = :1 and msgid = :2
END OF STMT

EXEC #140416370084536:c=1000,e=1371,p=0,cr=14,cu=4,mis=0,r=0,dep=2,og=1,plh=0,tim=13836798427556

ERROR #140416370084536:err=1031 tim=13836798427567

Если реврапнуть SCHEDULER$_JOB_EVENT_HANDLER (правда, я на 12.1.0.1 смотрел), то видно что доп диагностику можно включить путем установки события 27402 в уровень 128 ( точнее, проверяется так: BITAND(EVENT_27402_LEVEL,128)=128 )
Выборка из SCHEDULER$_EVENT_QTAB говорит о том, что DEQUEUE дальше по коду процедуры происходит.

Для полученного сообщения из очереди, если: SYS_CONTEXT('USERENV','CURRENT_USER') != MESSAGE.OBJECT_OWNER
То выполняется raise ORA-01031.
uid везде 0, т.е. current_user SYS. Предположу, что message.object_owner, полученный из SCHEDULER$_EVENT_QTAB <> 'SYS'
Для более детальной диагностики, рекомендую:
1. проверить message.object_owner в queue table SCHEDULER$_EVENT_QTAB
2. если 1 не поможет, то установить событие 27402 на уровне 128 + errorstack на ошибку 1031 уровня 3 и повторить выполнение с ними
19 янв 15, 05:52    [17135497]     Ответить | Цитировать Сообщить модератору
 Re: AQ$_PLSQL_NTFN ORA-01031: insufficient privileges  [new]
AlexVin
Member

Откуда: E-burg
Сообщений: 1055
1. проверить message.object_owner в queue table SCHEDULER$_EVENT_QTAB

в SCHEDULER$_EVENT_QTAB есть USER_DATA.OBJECT_OWNER - если это оно (message.object_owner), то вполне естественно, что там не sys, а владелец джобы, для которой срабатывает plsql нотификация - и тогда получается оракловая бага чтоль?
19 янв 15, 07:05    [17135537]     Ответить | Цитировать Сообщить модератору
 Re: AQ$_PLSQL_NTFN ORA-01031: insufficient privileges  [new]
SeaGate
Member

Откуда: Новосибирск
Сообщений: 1635
AlexVin,

в SCHEDULER$_EVENT_QTAB есть USER_DATA.OBJECT_OWNER - если это оно (message.object_owner), то вполне естественно, что там не sys, а владелец джобы, для которой срабатывает plsql нотификация - и тогда получается оракловая бага чтоль? 


Не могу сказать, т.к. не слишком владею предметом с AQ PLSQL нотификацией.
Судя по ACTION_NAME, это AQ PLSQL нотификация.
Последний раз, когда я проверял ее работу на 11.2.0.3, она не масштабировалась.
Рекомендую проверить гипотезу с current_user, после выполнить действия по пункту 2.
Можете предоставить пример, эмулирующий ошибку? Возможно, так будет понятнее, где искать причины.
19 янв 15, 08:06    [17135584]     Ответить | Цитировать Сообщить модератору
 Re: AQ$_PLSQL_NTFN ORA-01031: insufficient privileges  [new]
AlexVin
Member

Откуда: E-burg
Сообщений: 1055
установить событие 27402 на уровне 128 + errorstack на ошибку 1031 уровня 3


это так?
event='27402 trace name context forever, level 128'
?

а пример - просто прописал для пользовательских джобов email notifications
BEGIN
  DBMS_SCHEDULER.set_scheduler_attribute('email_server', 'localhost:25');
  DBMS_SCHEDULER.set_scheduler_attribute('email_sender', 'do_not_reply@mycompany.com');
END;

и DBMS_SCHEDULER.add_job_email_notification...
  events     =>  'job_started, job_succeeded');

и началось валиться в diag\trace, что в первом посте написал
(еще подозреваю, что могло повлиять, что база раскопирована холодным образом с другого хоста)
remove_job_email_notification всех уведомлений - рост очереди и появление ошибок прекращает.
хотя джоба AQ$_PLSQL_NTFN_ при этом продолжает висеть в running.
кстати, как она должна себя вести правильно - висеть всё время или таки перезапускаться?
на одном хосте - джоба отрабатывает раз в 10 минут по две минуты и завершается, потом стартует снова.
на трех других - висит с тех пор когда запущена (до месяца), если прибить, стартует и висит дальше опять бесконечно.
все эти базки раскопированы из одной
19 янв 15, 09:05    [17135673]     Ответить | Цитировать Сообщить модератору
 Re: AQ$_PLSQL_NTFN ORA-01031: insufficient privileges  [new]
SeaGate
Member

Откуда: Новосибирск
Сообщений: 1635
AlexVin,

Если email notification, то по этому поводу есть:
DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION FAILS WITH ORA-01031 INSUFFICIENT PRIVILEGES (Doc ID 1662941.1)
Где указан баг, подходящий под описание того, что у вас:
Bug 16438576 : DEQUEUE FAILS WITH ORA-1031, USER NOT ABLE TO SEND EMAIL NOTIFICATION
С базовым (без патча):
Bug 13892778 : DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION FAILS INSUFFICIENT PRIVILEGES

В references из 1662941.1 и в самом документе описывают возможные workaround.
В частности, о создании email notification из-под владельца заданий.
В баге 16438576 также в точности упоминается код с current_user, на который я обращал внимание.

По поводу того, что в одной БД работает, а в другой нет, то я бы посмотрел на предмет отличий в dba_scheduler_notifications, dba_scheduler_jobs.

AlexVin
event='27402 trace name context forever, level 128'

да, + еще нужно посмотреть errorstack 1031:
AlexVin
event='27402 trace name context forever, level 128'
event='1031 trace name errorstack level 3'

Это нужно сравнить с PL/SQL callstack из бага 16438576. Думаю, совпадет.
19 янв 15, 10:31    [17136023]     Ответить | Цитировать Сообщить модератору
 Re: AQ$_PLSQL_NTFN ORA-01031: insufficient privileges  [new]
AlexVin
Member

Откуда: E-burg
Сообщений: 1055
да, полечилось созданием "email notification из-под владельца заданий"
4 июн 15, 11:42    [17729338]     Ответить | Цитировать Сообщить модератору
Все форумы / Oracle Ответить