Re: Trigger not firing!!!!!!!!!!(URGENT)
- From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- To: <Rich.Jesse@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Jun 2005 16:46:01 +0200
Tested with jdbc connection, autocommit set to false and still get the
session logged:
"dbarepo1_ora_14093.trc" [Read only] 128 lines, 6969 characters
/app/oracle/admin/dbarepo1/udump/dbarepo1_ora_14093.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /app/oracle/product/9i
System name: SunOS
Node name: ess038
Release: 5.8
Version: Generic_117350-02
Machine: sun4u
Instance name: dbarepo1
Redo thread mounted by this instance: 1
Oracle process number: 11
Unix process pid: 14093, image: oracle@ess038 (TNS V1-V3)
*** SESSION ID:(12.170) 2005-06-09 16:41:02.908
APPNAME mod='JDBC Thin Client' mh=0 act='' ah=0
=====================
PARSING IN CURSOR #2 len=69 dep=2 uid=0 oct=42 lid=0 tim=7019944001801
hv=3889376138 ad='2ee32c3c'
alter session set events '10046 trace name context
forever,level 12'
END OF STMT
EXEC #2:c=0,e=163,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=4,tim=7019944000248
=====================
PARSING IN CURSOR #2 len=77 dep=2 uid=0 oct=2 lid=0 tim=7019944154180
hv=3939809092 ad='2dcbfa40'
INSERT into sys.log_info
values(sysdate,ora_client_ip_address,ora_login_user)
END OF STMT
PARSE
#2:c=30000,e=134565,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=4,tim=7019944154162
BINDS #2:
EXEC #2:c=0,e=33656,p=0,cr=1,cu=7,mis=0,r=1,dep=2,og=4,tim=7019944188157
=====================
PARSING IN CURSOR #1 len=182 dep=1 uid=0 oct=47 lid=0 tim=7019944188394
hv=3630331862 ad='2ee43b80'
BEGIN
execute immediate
'alter session set events ''10046 trace name context
forever,level 12'' ';
insert into sys.log_info
values(sysdate,ora_client_ip_address,ora_login_user);
END;
END OF STMT
EXEC
#1:c=30000,e=189320,p=0,cr=1,cu=7,mis=1,r=1,dep=1,og=4,tim=7019944188379
WAIT #0: nam='log file sync' ela= 26316 p1=223 p2=0 p3=0
WAIT #0: nam='SQL*Net message to client' ela= 4 p1=1952673792 p2=1 p3=0
WAIT #0: nam='SQL*Net message from client' ela= 4051 p1=1952673792 p2=1 p3=0
WAIT #0: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
WAIT #0: nam='SQL*Net message from client' ela= 13865 p1=1952673792 p2=1
p3=0
WAIT #0: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
WAIT #0: nam='SQL*Net message from client' ela= 207565 p1=1952673792 p2=1
p3=0
WAIT #1: nam='SQL*Net message to client' ela= 7 p1=1952673792 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 35272 p1=1952673792 p2=1
p3=0
=====================
PARSING IN CURSOR #1 len=43 dep=0 uid=24 oct=42 lid=24 tim=7019944500355
hv=3570694802 ad='2ee55f14'
ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN'
END OF STMT
PARSE #1:c=0,e=1360,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=7019944500339
BINDS #1:
XCTEND rlbk=0, rd_only=1
EXEC #1:c=0,e=334,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=7019944500928
WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1952673792 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 9697 p1=1952673792 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=43 dep=0 uid=24 oct=42 lid=24 tim=7019944511528
hv=2707901715 ad='2ee54a84'
ALTER SESSION SET NLS_TERRITORY = 'AMERICA'
END OF STMT
PARSE #1:c=0,e=433,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=7019944511515
BINDS #1:
XCTEND rlbk=0, rd_only=1
EXEC #1:c=0,e=297,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=7019944512161
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 3147 p1=1952673792 p2=1 p3=0
=====================
PARSING IN CURSOR #2 len=37 dep=1 uid=0 oct=3 lid=0 tim=7019944524544
hv=3468666020 ad='2de2fce4'
select text from view$ where rowid=:1
END OF STMT
PARSE #2:c=0,e=129,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=7019944524531
BINDS #2:
bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=16
offset=0
bfp=feb6cf8c bln=16 avl=16 flg=05
value=00001230.0009.0001
EXEC #2:c=0,e=311,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=7019944525180
FETCH #2:c=0,e=122,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=7019944525399
STAT #2 id=1 cnt=1 pid=0 pos=1 obj=62 op='TABLE ACCESS BY USER ROWID VIEW$
(cr=1 r=0 w=0 time=78 us)'
=====================
PARSING IN CURSOR #1 len=76 dep=0 uid=24 oct=3 lid=24 tim=7019944681261
hv=1702556642 ad='2ee53530'
SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'
END OF STMT
PARSE #1:c=0,e=165536,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=7019944681246
BINDS #1:
XCTEND rlbk=0, rd_only=1
EXEC #1:c=0,e=12151,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=7019944693717
WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1952673792 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 4802 p1=1952673792 p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 69313 p1=1952673792 p2=1
p3=0
WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1952673792 p2=1 p3=0
FETCH #1:c=0,e=22269,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=7019944790717
WAIT #1: nam='SQL*Net message from client' ela= 19554 p1=1952673792 p2=1
p3=0
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1952673792 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 3322 p1=1952673792 p2=1 p3=0
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=0 op='MERGE JOIN (cr=0 r=0 w=0
time=22143 us)'
STAT #1 id=2 cnt=99 pid=1 pos=1 obj=59 op='FIXED TABLE FULL X$KSPPCV (cr=0
r=0 w=0 time=827 us)'
STAT #1 id=3 cnt=1 pid=1 pos=2 obj=0 op='FILTER (cr=0 r=0 w=0 time=20801
us)'
STAT #1 id=4 cnt=1 pid=3 pos=1 obj=0 op='SORT JOIN (cr=0 r=0 w=0 time=20711
us)'
STAT #1 id=5 cnt=1 pid=4 pos=1 obj=58 op='FIXED TABLE FULL X$KSPPI (cr=0 r=0
w=0 time=20216 us)'
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 827 p1=1952673792 p2=1 p3=0
WAIT #0: nam='SQL*Net message to client' ela= 2 p1=1952673792 p2=1 p3=0
WAIT #0: nam='SQL*Net message from client' ela= 1909 p1=1952673792 p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1952673792 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 4226 p1=1952673792 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=21 dep=0 uid=24 oct=3 lid=24 tim=7019944822981
hv=2974566807 ad='2ee4fe7c'
select null from dual
END OF STMT
PARSE #1:c=0,e=950,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=7019944822968
BINDS #1:
EXEC #1:c=0,e=98,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=7019944823283
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 1072 p1=1952673792 p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 4515 p1=1952673792 p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1952673792 p2=1 p3=0
FETCH #1:c=0,e=231,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=7019944829608
WAIT #1: nam='SQL*Net message from client' ela= 2684 p1=1952673792 p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1952673792 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 24350 p1=1952673792 p2=1
p3=0
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=222 op='TABLE ACCESS FULL OBJ#(222) (cr=3
r=0 w=0 time=155 us)'
Cheers
Dimitre Radoulov
ETNØTEAM
--
//www.freelists.org/webpage/oracle-l
Other related posts:
