Armed with my new O'Reilly book Optimizing Oracle Performance I have been
trying to get a better understanding of how Oracle works.
The book makes the statement, " A database cal with dep=n + 1 is the
recursive child of the first subsequent dep=n database call listed in the
SQL data stream. The book gives a few examples, and in trying it out it
seemed to work until I tried the following SQL. My question are why does
this not keep with the model? and how does one then account for this
situation:
Dump file c:\oracle\admin \to5\udump\to5_ ora_296_2004-02-15a.trc
Sun Feb 15 20:55:22 2004
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
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
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: to5
Redo thread mounted by this instance: 1
Oracle process number: 12
Windows thread id: 296, image: ORACLE.EXE
*** 2004-02-15 20:55:22.224
*** SESSION ID:(14.178) 2004-02-15 20:55:22.124
APPNAME mod='SQL*Plus' mh=3669949024 act='' ah=4029777240
=============== ======
PARSING IN CURSOR #3 len=69 dep=0 uid=60 oct=42 lid=60 tim=43164454230
hv=2004533713 ad='7157ec60'
alter session set events '10046 trace name context forever, level 12'
END OF STMT
EXEC #3:c=0,e=19923, p=0,cr=0,cu=0,m is=1,r=0,dep=0, og=4,tim=431643 21789
WAIT #3: nam='SQL*Net message to client' ela= 8 p1=1952673792 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 5029 p1=1952673792 p2=1 p3=0
=============== ======
PARSING IN CURSOR #3 len=238 dep=0 uid=60 oct=3 lid=60 tim=43164556233
hv=4211298066 ad='7157da00'
select distinct c.name, s.name, s.salesperson_i d
from customer c join orders on c.cust_nbr = orders.cust_nbr
join salesperson s on orders.salesper son_id = s.salesperson_i d
where c.name = 'Crimson Medical Inc.'
order by s.name, c.NAME
END OF STMT
PARSE #3:c=0,e=2204,p =0,cr=0,cu=0,mi s=1,r=0,dep=0,o g=4,tim=4316455 6217
BINDS #3:
EXEC #3:c=10014,e=33 290,p=0,cr=0,cu =0,mis=0,r=0,de p=0,og=4,tim=43 164688931
WAIT #3: nam='SQL*Net message to client' ela= 10 p1=1952673792 p2=1 p3=0
FETCH
#3:c=70101,e=66 839,p=0,cr=2900 ,cu=0,mis=0,r=1 ,dep=0,og=4,tim =43164785732
WAIT #3: nam='SQL*Net message from client' ela= 754 p1=1952673792 p2=1 p3=0
WAIT #3: nam='SQL*Net message to client' ela= 7 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=13248, p=0,cr=0,cu=0,m is=0,r=3,dep=0, og=4,tim=431648 23392
WAIT #3: nam='SQL*Net message from client' ela= 3669 p1=1952673792 p2=1 p3=0
STAT #3 id=1 cnt=4 pid=0 pos=1 obj=0 op='SORT UNIQUE (cr=2900 r=0 w=0
time=67115 us)'
STAT #3 id=2 cnt=48 pid=1 pos=1 obj=0 op='NESTED LOOPS (cr=2900 r=0 w=0
time=66511 us)'
STAT #3 id=3 cnt=1440 pid=2 pos=1 obj=0 op='NESTED LOOPS (cr=1458 r=0 w=0
time=40438 us)'
=============== ======
PARSING IN CURSOR #4 len=116 dep=1 uid=0 oct=3 lid=0 tim=43164909064
hv=431456802 ad='70797038'
select
o.owner#,o.name ,o.namespace,o. remoteowner,o.l inkname,o.subna me,o.dataobj#,o .
flags from obj$ o where o.obj#=:1
END OF STMT
PARSE #4:c=0,e=1018,p =0,cr=0,cu=0,mi s=1,r=0,dep=1,o g=0,tim=4316490 9048
BINDS #4:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24
offset=0
bfp=093dbb5c bln=22 avl=04 flg=05
value=39030
EXEC #4:c=0,e=73894, p=0,cr=0,cu=0,m is=0,r=0,dep=1, og=4,tim=431650 43688
FETCH #4:c=0,e=117,p= 0,cr=3,cu=0,mis =0,r=1,dep=1,og =4,tim=43165056 304
STAT #3 id=4 cnt=1440 pid=3 pos=1 obj=39030 op='TABLE ACCESS FULL ORDERS
(cr=16 r=0 w=0 time=5866 us)'
BINDS #4:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24
offset=0
bfp=093dbb5c bln=22 avl=04 flg=05
value=39034
EXEC #4:c=0,e=50695, p=0,cr=0,cu=0,m is=0,r=0,dep=1, og=4,tim=431651 32543
FETCH #4:c=0,e=116,p= 0,cr=3,cu=0,mis =0,r=1,dep=1,og =4,tim=43165145 593
STAT #3 id=5 cnt=1440 pid=3 pos=2 obj=39034 op='TABLE ACCESS BY INDEX ROWID
SALESPERSON (cr=1442 r=0 w=0 time=21449 us)'
STAT #3 id=6 cnt=1440 pid=5 pos=1 obj=39035 op='INDEX UNIQUE SCAN
SALESPERSON_PK (cr=2 r=0 w=0 time=7068 us)'
BINDS #4:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24
offset=0
bfp=093dbb5c bln=22 avl=04 flg=05
value=39013
EXEC #4:c=0,e=53716, p=0,cr=0,cu=0,m is=0,r=0,dep=1, og=4,tim=431652 40373
FETCH #4:c=0,e=119,p= 0,cr=3,cu=0,mis =0,r=1,dep=1,og =4,tim=43165253 961
STAT #3 id=7 cnt=48 pid=2 pos=2 obj=39013 op='TABLE ACCESS BY INDEX ROWID
CUSTOMER (cr=1442 r=0 w=0 time=18732 us)'
STAT #3 id=8 cnt=1440 pid=7 pos=1 obj=39014 op='INDEX UNIQUE SCAN
CUSTOMER_PK (cr=2 r=0 w=0 time=7059 us)'
=============== ======
PARSING IN CURSOR #3 len=55 dep=0 uid=60 oct=42 lid=60 tim=43165395660
hv=4110456808 ad='71571ff0'
alter session set events '10046 trace name context off'
END OF STMT
PARSE #3:c=0,e=520,p= 0,cr=0,cu=0,mis =1,r=0,dep=0,og =4,tim=43165395 645
BINDS #3:
EXEC #3:c=0,e=13838, p=0,cr=0,cu=0,m is=0,r=0,dep=0, og=4,tim=431654 77860
2  3416 
Hello Oxmart,
Can you please clarify why do you think recursive depth is not right?
CURSOR #4 seem to be recursive SQL with the depth of 1.
Regards,
Ron
DBA Infopower http://www.dbainfopower.com
Standard disclaimer: http://www.dbainfopower.com/dbaip_ad...isclaimer.html
"Oxmard" <sh******@no-spam.comcast.ne t> wrote in message
news:lv******** ************@co mcast.com... Armed with my new O'Reilly book Optimizing Oracle Performance I have been
trying to get a better understanding of how Oracle works.
The book makes the statement, " A database cal with dep=n + 1 is the
recursive child of the first subsequent dep=n database call listed in the
SQL data stream. The book gives a few examples, and in trying it out it
seemed to work until I tried the following SQL. My question are why does
this not keep with the model? and how does one then account for this
situation:
Dump file c:\oracle\admin \to5\udump\to5_ ora_296_2004-02-15a.trc
Sun Feb 15 20:55:22 2004
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
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
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: to5
Redo thread mounted by this instance: 1
Oracle process number: 12
Windows thread id: 296, image: ORACLE.EXE
*** 2004-02-15 20:55:22.224
*** SESSION ID:(14.178) 2004-02-15 20:55:22.124
APPNAME mod='SQL*Plus' mh=3669949024 act='' ah=4029777240
=============== ======
PARSING IN CURSOR #3 len=69 dep=0 uid=60 oct=42 lid=60 tim=43164454230
hv=2004533713 ad='7157ec60'
alter session set events '10046 trace name context forever, level 12'
END OF STMT
EXEC #3:c=0,e=19923, p=0,cr=0,cu=0,m is=1,r=0,dep=0, og=4,tim=431643 21789
WAIT #3: nam='SQL*Net message to client' ela= 8 p1=1952673792 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 5029 p1=1952673792 p2=1
p3=0 =============== ======
PARSING IN CURSOR #3 len=238 dep=0 uid=60 oct=3 lid=60 tim=43164556233
hv=4211298066 ad='7157da00'
select distinct c.name, s.name, s.salesperson_i d
from customer c join orders on c.cust_nbr = orders.cust_nbr
join salesperson s on orders.salesper son_id = s.salesperson_i d
where c.name = 'Crimson Medical Inc.'
order by s.name, c.NAME
END OF STMT
PARSE #3:c=0,e=2204,p =0,cr=0,cu=0,mi s=1,r=0,dep=0,o g=4,tim=4316455 6217
BINDS #3:
EXEC #3:c=10014,e=33 290,p=0,cr=0,cu =0,mis=0,r=0,de p=0,og=4,tim=43 164688931
WAIT #3: nam='SQL*Net message to client' ela= 10 p1=1952673792 p2=1 p3=0
FETCH
#3:c=70101,e=66 839,p=0,cr=2900 ,cu=0,mis=0,r=1 ,dep=0,og=4,tim =43164785732
WAIT #3: nam='SQL*Net message from client' ela= 754 p1=1952673792 p2=1
p3=0 WAIT #3: nam='SQL*Net message to client' ela= 7 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=13248, p=0,cr=0,cu=0,m is=0,r=3,dep=0, og=4,tim=431648 23392
WAIT #3: nam='SQL*Net message from client' ela= 3669 p1=1952673792 p2=1
p3=0 STAT #3 id=1 cnt=4 pid=0 pos=1 obj=0 op='SORT UNIQUE (cr=2900 r=0 w=0
time=67115 us)'
STAT #3 id=2 cnt=48 pid=1 pos=1 obj=0 op='NESTED LOOPS (cr=2900 r=0 w=0
time=66511 us)'
STAT #3 id=3 cnt=1440 pid=2 pos=1 obj=0 op='NESTED LOOPS (cr=1458 r=0 w=0
time=40438 us)'
=============== ======
PARSING IN CURSOR #4 len=116 dep=1 uid=0 oct=3 lid=0 tim=43164909064
hv=431456802 ad='70797038'
select
o.owner#,o.name ,o.namespace,o. remoteowner,o.l inkname,o.subna me,o.dataobj#,o . flags from obj$ o where o.obj#=:1
END OF STMT
PARSE #4:c=0,e=1018,p =0,cr=0,cu=0,mi s=1,r=0,dep=1,o g=0,tim=4316490 9048
BINDS #4:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24
offset=0
bfp=093dbb5c bln=22 avl=04 flg=05
value=39030
EXEC #4:c=0,e=73894, p=0,cr=0,cu=0,m is=0,r=0,dep=1, og=4,tim=431650 43688
FETCH #4:c=0,e=117,p= 0,cr=3,cu=0,mis =0,r=1,dep=1,og =4,tim=43165056 304
STAT #3 id=4 cnt=1440 pid=3 pos=1 obj=39030 op='TABLE ACCESS FULL ORDERS
(cr=16 r=0 w=0 time=5866 us)'
BINDS #4:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24
offset=0
bfp=093dbb5c bln=22 avl=04 flg=05
value=39034
EXEC #4:c=0,e=50695, p=0,cr=0,cu=0,m is=0,r=0,dep=1, og=4,tim=431651 32543
FETCH #4:c=0,e=116,p= 0,cr=3,cu=0,mis =0,r=1,dep=1,og =4,tim=43165145 593
STAT #3 id=5 cnt=1440 pid=3 pos=2 obj=39034 op='TABLE ACCESS BY INDEX
ROWID SALESPERSON (cr=1442 r=0 w=0 time=21449 us)'
STAT #3 id=6 cnt=1440 pid=5 pos=1 obj=39035 op='INDEX UNIQUE SCAN
SALESPERSON_PK (cr=2 r=0 w=0 time=7068 us)'
BINDS #4:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24
offset=0
bfp=093dbb5c bln=22 avl=04 flg=05
value=39013
EXEC #4:c=0,e=53716, p=0,cr=0,cu=0,m is=0,r=0,dep=1, og=4,tim=431652 40373
FETCH #4:c=0,e=119,p= 0,cr=3,cu=0,mis =0,r=1,dep=1,og =4,tim=43165253 961
STAT #3 id=7 cnt=48 pid=2 pos=2 obj=39013 op='TABLE ACCESS BY INDEX ROWID
CUSTOMER (cr=1442 r=0 w=0 time=18732 us)'
STAT #3 id=8 cnt=1440 pid=7 pos=1 obj=39014 op='INDEX UNIQUE SCAN
CUSTOMER_PK (cr=2 r=0 w=0 time=7059 us)'
=============== ======
PARSING IN CURSOR #3 len=55 dep=0 uid=60 oct=42 lid=60 tim=43165395660
hv=4110456808 ad='71571ff0'
alter session set events '10046 trace name context off'
END OF STMT
PARSE #3:c=0,e=520,p= 0,cr=0,cu=0,mis =1,r=0,dep=0,og =4,tim=43165395 645
BINDS #3:
EXEC #3:c=0,e=13838, p=0,cr=0,cu=0,m is=0,r=0,dep=0, og=4,tim=431654 77860
The way I had understood the traces to display was due to the way Oracle
dealt with recursive SQL.
If you have an SQL statement that needs to do two actions, for example an
insert that fires a trigger that updates some row in another table. Before
the insert can finish the trigger must finish. So in this case
insert dep 0
|
trigger dep 1
|
update dep 2
The impression I got was when looking at the events 10046 trace data one
would see:
Parsing in Cursor .... dep=2 ...
.....
....
Parsing in Cursor ..... dep=1 ...
....
....
Parsing in Cursor .... dep=0....
In a number of SQL's I did see this pattern, however in the trace data I
provided this was not the case:
PARSING IN CURSOR #3 len=238 dep=0 uid=60 oct=3 lid=60 tim=43164556233
hv=4211298066 ad='7157da00'
select distinct c.name, s.name, s.salesperson_i d
from customer c join orders on c.cust_nbr = orders.cust_nbr
join salesperson s on orders.salesper son_id = s.salesperson_i d
where c.name = 'Crimson Medical Inc.'
order by s.name, c.NAME
END OF STMT
followed by:
PARSING IN CURSOR #4 len=116 dep=1 uid=0 oct=3 lid=0 tim=43164909064
hv=431456802 ad='70797038'
select
o.owner#,o.name ,o.namespace,o. remoteowner,o.l inkname,o.subna me,o.dataobj#,o .
flags from obj$ o where o.obj#=:1
END OF STMT
this case seems to be backwards from the way I thought it should work.
"Ron" <su*****@dbainf opower.com> wrote in message
news:i-*************** *****@comcast.c om...
Hello Oxmart,
Can you please clarify why do you think recursive depth is not right?
CURSOR #4 seem to be recursive SQL with the depth of 1.
Regards,
Ron
DBA Infopower
http://www.dbainfopower.com
Standard disclaimer:
http://www.dbainfopower.com/dbaip_ad...isclaimer.html
"Oxmard" <sh******@no-spam.comcast.ne t> wrote in message
news:lv******** ************@co mcast.com... Armed with my new O'Reilly book Optimizing Oracle Performance I have
been trying to get a better understanding of how Oracle works.
The book makes the statement, " A database cal with dep=n + 1 is the
recursive child of the first subsequent dep=n database call listed in
the SQL data stream. The book gives a few examples, and in trying it out it
seemed to work until I tried the following SQL. My question are why does
this not keep with the model? and how does one then account for this
situation:
Dump file c:\oracle\admin \to5\udump\to5_ ora_296_2004-02-15a.trc
Sun Feb 15 20:55:22 2004
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
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
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: to5
Redo thread mounted by this instance: 1
Oracle process number: 12
Windows thread id: 296, image: ORACLE.EXE
*** 2004-02-15 20:55:22.224
*** SESSION ID:(14.178) 2004-02-15 20:55:22.124
APPNAME mod='SQL*Plus' mh=3669949024 act='' ah=4029777240
=============== ======
PARSING IN CURSOR #3 len=69 dep=0 uid=60 oct=42 lid=60 tim=43164454230
hv=2004533713 ad='7157ec60'
alter session set events '10046 trace name context forever, level 12'
END OF STMT
EXEC #3:c=0,e=19923, p=0,cr=0,cu=0,m is=1,r=0,dep=0, og=4,tim=431643 21789
WAIT #3: nam='SQL*Net message to client' ela= 8 p1=1952673792 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 5029 p1=1952673792 p2=1
p3=0 =============== ======
PARSING IN CURSOR #3 len=238 dep=0 uid=60 oct=3 lid=60 tim=43164556233
hv=4211298066 ad='7157da00'
select distinct c.name, s.name, s.salesperson_i d
from customer c join orders on c.cust_nbr = orders.cust_nbr
join salesperson s on orders.salesper son_id = s.salesperson_i d
where c.name = 'Crimson Medical Inc.'
order by s.name, c.NAME
END OF STMT
PARSE #3:c=0,e=2204,p =0,cr=0,cu=0,mi s=1,r=0,dep=0,o g=4,tim=4316455 6217
BINDS #3:
EXEC
#3:c=10014,e=33 290,p=0,cr=0,cu =0,mis=0,r=0,de p=0,og=4,tim=43 164688931 WAIT #3: nam='SQL*Net message to client' ela= 10 p1=1952673792 p2=1 p3=0
FETCH
#3:c=70101,e=66 839,p=0,cr=2900 ,cu=0,mis=0,r=1 ,dep=0,og=4,tim =43164785732
WAIT #3: nam='SQL*Net message from client' ela= 754 p1=1952673792 p2=1
p3=0 WAIT #3: nam='SQL*Net message to client' ela= 7 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=13248, p=0,cr=0,cu=0,m is=0,r=3,dep=0, og=4,tim=431648 23392
WAIT #3: nam='SQL*Net message from client' ela= 3669 p1=1952673792 p2=1
p3=0 STAT #3 id=1 cnt=4 pid=0 pos=1 obj=0 op='SORT UNIQUE (cr=2900 r=0 w=0
time=67115 us)'
STAT #3 id=2 cnt=48 pid=1 pos=1 obj=0 op='NESTED LOOPS (cr=2900 r=0 w=0
time=66511 us)'
STAT #3 id=3 cnt=1440 pid=2 pos=1 obj=0 op='NESTED LOOPS (cr=1458 r=0
w=0 time=40438 us)'
=============== ======
PARSING IN CURSOR #4 len=116 dep=1 uid=0 oct=3 lid=0 tim=43164909064
hv=431456802 ad='70797038'
select
o.owner#,o.name ,o.namespace,o. remoteowner,o.l inkname,o.subna me,o.dataobj#,o . flags from obj$ o where o.obj#=:1
END OF STMT
PARSE #4:c=0,e=1018,p =0,cr=0,cu=0,mi s=1,r=0,dep=1,o g=0,tim=4316490 9048
BINDS #4:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1
size=24 offset=0
bfp=093dbb5c bln=22 avl=04 flg=05
value=39030
EXEC #4:c=0,e=73894, p=0,cr=0,cu=0,m is=0,r=0,dep=1, og=4,tim=431650 43688
FETCH #4:c=0,e=117,p= 0,cr=3,cu=0,mis =0,r=1,dep=1,og =4,tim=43165056 304
STAT #3 id=4 cnt=1440 pid=3 pos=1 obj=39030 op='TABLE ACCESS FULL ORDERS
(cr=16 r=0 w=0 time=5866 us)'
BINDS #4:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1
size=24 offset=0
bfp=093dbb5c bln=22 avl=04 flg=05
value=39034
EXEC #4:c=0,e=50695, p=0,cr=0,cu=0,m is=0,r=0,dep=1, og=4,tim=431651 32543
FETCH #4:c=0,e=116,p= 0,cr=3,cu=0,mis =0,r=1,dep=1,og =4,tim=43165145 593
STAT #3 id=5 cnt=1440 pid=3 pos=2 obj=39034 op='TABLE ACCESS BY INDEX
ROWID SALESPERSON (cr=1442 r=0 w=0 time=21449 us)'
STAT #3 id=6 cnt=1440 pid=5 pos=1 obj=39035 op='INDEX UNIQUE SCAN
SALESPERSON_PK (cr=2 r=0 w=0 time=7068 us)'
BINDS #4:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1
size=24 offset=0
bfp=093dbb5c bln=22 avl=04 flg=05
value=39013
EXEC #4:c=0,e=53716, p=0,cr=0,cu=0,m is=0,r=0,dep=1, og=4,tim=431652 40373
FETCH #4:c=0,e=119,p= 0,cr=3,cu=0,mis =0,r=1,dep=1,og =4,tim=43165253 961
STAT #3 id=7 cnt=48 pid=2 pos=2 obj=39013 op='TABLE ACCESS BY INDEX
ROWID CUSTOMER (cr=1442 r=0 w=0 time=18732 us)'
STAT #3 id=8 cnt=1440 pid=7 pos=1 obj=39014 op='INDEX UNIQUE SCAN
CUSTOMER_PK (cr=2 r=0 w=0 time=7059 us)'
=============== ======
PARSING IN CURSOR #3 len=55 dep=0 uid=60 oct=42 lid=60 tim=43165395660
hv=4110456808 ad='71571ff0'
alter session set events '10046 trace name context off'
END OF STMT
PARSE #3:c=0,e=520,p= 0,cr=0,cu=0,mis =1,r=0,dep=0,og =4,tim=43165395 645
BINDS #3:
EXEC #3:c=0,e=13838, p=0,cr=0,cu=0,m is=0,r=0,dep=0, og=4,tim=431654 77860
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Marcin Kielar |
last post by:
hello
i'm searching for algorithm able to detect and resolve conflicts
during recursive event propagation.
I'd like to implement small message passing framework without using
message queue - messages
would be delivered by simple method calls. This leads to recursive
message ordering instead of
natural one - and thus sometimes may cause...
|
by: Mike MacSween |
last post by:
Regular viewers may want to turn off now.
This will be an orchestral management system. Musicians and other staff
being booked/paid for jobs.
A job may contain other jobs, e.g:
World Tour contains
US leg and Europe leg (and others)
US leg contains State tours (and others)
|
by: Sgt. Sausage |
last post by:
NOTE: I'm new to c#, but not to programming.
For reasons unimportant to the discussion below, I need to be able
to dynamically, at run time, discover the set of all objects listening to
another object's events.
Given some jRandomType, I've figured out how to get the Events
themselves via reflection and GetEvents/EventInfo. This will give...
|
by: Xaviero |
last post by:
Is it possible to see what events are being traced. Such as
datagird_editCommand or linkbutton_click etc. I have the trace enabled but
that only gives info such as beginInit, LoadViewstate, ProcessPostData etc.
|
by: Nathan Sokalski |
last post by:
I have a very simple UserControl which contains an Image and a Label, which
I use to display an image with a caption. I am using this control inside a
DataList, setting the two Public variables using attributes in the *.aspx
page. Everything displays great for the initial load, but whenever I try to
add or delete an item (I have controls to do...
| | |
by: Michal Valent |
last post by:
this is ProcessRequestMain
from
System.Web.UI.Page
Assembly: System.Web, Version=2.0.0.0
the question is how can one custom server control make its events fired
earlier than Page_Load event ?
|
by: maildmz |
last post by:
Goodafternoon,
I have got a minimum Mongrel instance running (see ruby code) and i am
hitting it with an Ajax request using Prototype. (see javascript code)
I get the 'onLoading' event, but the other events never fire. I am
getting the response because I can see the response from the Mongrel
server in my net monitor (Firebug). But the...
|
by: pereges |
last post by:
Hello I need some ideas for designing a recursive function for my ray
tracing program.
The idea behind ray tracing is to follow the electromagnetic rays from
the source, as they hit the object.The object is triangulated. The
rays can undergo multiple reflections, diffractions etc of the same
object i.e. a ray hits a surface of the object,...
|
by: beacon |
last post by:
Hi everybody,
This is probably going to sound unorthodox, but I have to log records that are deleted...I know, go figure.
Anyway, I have a form with a (continuous) subform, and on the subform I have a command button, called cmdDelete, that launches a dialog form, called frmDeleteCurrentRecord, where the user has to enter their name and a...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
