473,414 Members | 1,980 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,414 software developers and data experts.

Recursive SQL in a events 10046 trace file

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,mis=1,r=0,dep=0,og=4, tim=43164321789
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_id
from customer c join orders on c.cust_nbr = orders.cust_nbr
join salesperson s on orders.salesperson_id = s.salesperson_id
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,mis=1,r=0,dep=0,og=4,t im=43164556217
BINDS #3:
EXEC #3:c=10014,e=33290,p=0,cr=0,cu=0,mis=0,r=0,dep=0,o g=4,tim=43164688931
WAIT #3: nam='SQL*Net message to client' ela= 10 p1=1952673792 p2=1 p3=0
FETCH
#3:c=70101,e=66839,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,mis=0,r=3,dep=0,og=4, tim=43164823392
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.linkna me,o.subname,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,mis=1,r=0,dep=1,og=0,t im=43164909048
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,mis=0,r=0,dep=1,og=4, tim=43165043688
FETCH #4:c=0,e=117,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,ti m=43165056304
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,mis=0,r=0,dep=1,og=4, tim=43165132543
FETCH #4:c=0,e=116,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,ti m=43165145593
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,mis=0,r=0,dep=1,og=4, tim=43165240373
FETCH #4:c=0,e=119,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,ti m=43165253961
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,ti m=43165395645
BINDS #3:
EXEC #3:c=0,e=13838,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4, tim=43165477860
Jul 19 '05 #1
2 3401
Ron

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.net> wrote in message
news:lv********************@comcast.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,mis=1,r=0,dep=0,og=4, tim=43164321789
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_id
from customer c join orders on c.cust_nbr = orders.cust_nbr
join salesperson s on orders.salesperson_id = s.salesperson_id
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,mis=1,r=0,dep=0,og=4,t im=43164556217
BINDS #3:
EXEC #3:c=10014,e=33290,p=0,cr=0,cu=0,mis=0,r=0,dep=0,o g=4,tim=43164688931
WAIT #3: nam='SQL*Net message to client' ela= 10 p1=1952673792 p2=1 p3=0
FETCH
#3:c=70101,e=66839,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,mis=0,r=3,dep=0,og=4, tim=43164823392
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.linkna me,o.subname,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,mis=1,r=0,dep=1,og=0,t im=43164909048
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,mis=0,r=0,dep=1,og=4, tim=43165043688
FETCH #4:c=0,e=117,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,ti m=43165056304
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,mis=0,r=0,dep=1,og=4, tim=43165132543
FETCH #4:c=0,e=116,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,ti m=43165145593
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,mis=0,r=0,dep=1,og=4, tim=43165240373
FETCH #4:c=0,e=119,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,ti m=43165253961
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,ti m=43165395645
BINDS #3:
EXEC #3:c=0,e=13838,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4, tim=43165477860

Jul 19 '05 #2
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_id
from customer c join orders on c.cust_nbr = orders.cust_nbr
join salesperson s on orders.salesperson_id = s.salesperson_id
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.linkna me,o.subname,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*****@dbainfopower.com> wrote in message
news:i-********************@comcast.com...

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.net> wrote in message
news:lv********************@comcast.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,mis=1,r=0,dep=0,og=4, tim=43164321789
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_id
from customer c join orders on c.cust_nbr = orders.cust_nbr
join salesperson s on orders.salesperson_id = s.salesperson_id
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,mis=1,r=0,dep=0,og=4,t im=43164556217
BINDS #3:
EXEC #3:c=10014,e=33290,p=0,cr=0,cu=0,mis=0,r=0,dep=0,o g=4,tim=43164688931 WAIT #3: nam='SQL*Net message to client' ela= 10 p1=1952673792 p2=1 p3=0
FETCH
#3:c=70101,e=66839,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,mis=0,r=3,dep=0,og=4, tim=43164823392
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.linkna me,o.subname,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,mis=1,r=0,dep=1,og=0,t im=43164909048
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,mis=0,r=0,dep=1,og=4, tim=43165043688
FETCH #4:c=0,e=117,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,ti m=43165056304
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,mis=0,r=0,dep=1,og=4, tim=43165132543
FETCH #4:c=0,e=116,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,ti m=43165145593
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,mis=0,r=0,dep=1,og=4, tim=43165240373
FETCH #4:c=0,e=119,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,ti m=43165253961
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,ti m=43165395645
BINDS #3:
EXEC #3:c=0,e=13838,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4, tim=43165477860


Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
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 -...
25
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...
6
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...
2
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,...
9
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...
0
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 ?
1
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...
9
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...
10
beacon
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...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
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...
0
tracyyun
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...
0
isladogs
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...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.