 
| Subject: | |
| From: | |
| Reply To: | |
| Date: | Mon, 2 Mar 1998 13:40:50 PST8 |
| Content-Type: | text/plain |
| Parts/Attachments: |
|
|
Excuse the bandwidth...
The following trace was taken using 'Glance/xl' and shows a process that
goes through a large number of transaction entries in our database. The
process runs for quite a few hours and it is hoped that the following
trace may help determine where it is spending much of its time.
While the process goes through a million plus entries I just feel that
20+ hours is just too much. Can anyone hazard a guess?
Thanks.
--------------------------------------------------
NM 3) SP=4184cb40 RP=a.002d4710 queue_for_pages+$21c
NM 4) SP=4184c940 RP=a.002e8e0c prefetch_+$50c
NM 5) SP=4184c840 RP=a.00584760 sm_hard_prefetch+$63c
NM 6) SP=4184c300 RP=a.0058509c disc_sm_prefetch+$58c
NM 7) SP=4184c180 RP=a.00586008 disc_sm_start_read+$124
NM 8) SP=4184bfc0 RP=a.00585ed0 ?disc_sm_start_read+$8
export stub: 2b1.00d5c600 setupsmcb_312+$22c
NM 9) SP=4184bf00 RP=2b1.00d5cc90 get'free'list'buffer_314+$1ec
NM a) SP=4184be98 RP=2b1.00d5d45c ti_getblock+$200
NM b) SP=4184be48 RP=2b1.00d89f04 get'block_314+$f4
NM c) SP=4184bd40 RP=2b1.00d8a57c get'record_315+$4f4
NM d) SP=4184bce0 RP=2b1.00d908c4 findchainhead_332+$294
NM e) SP=4184bc88 RP=2b1.00d91230 putdtlentry_333+$298
NM f) SP=4184bc28 RP=2b1.00d961a0 putdetail_337+$2f98
NM 10) SP=4184bbe0 RP=2b1.00d97c14 nmdbput+$15fc
NM 11) SP=4184bb80 RP=2b1.00d33e8c dbput+$180
NM 12) SP=41848480 RP=2b1.418482cc $RECOVER_END+$4096225c
Press RETURN to continue (or enter a GLANCE command):
Procedure Trace for Pin 245 is:
PC=a.0015d70c enable_int+$2c
NM* 0) SP=4184ccc0 RP=a.012a4868 notify_dispatcher.prep_for_swap_in+$1c8
NM 1) SP=4184ccc0 RP=a.012a5ab8 notify_dispatcher+$254
NM 2) SP=4184cc40 RP=a.0129f3c4 add_to_locality+$548
NM 3) SP=4184cb40 RP=a.002d4710 queue_for_pages+$21c
NM 4) SP=4184c940 RP=a.002e8e0c prefetch_+$50c
NM 5) SP=4184c840 RP=a.00584760 sm_hard_prefetch+$63c
NM 6) SP=4184c300 RP=a.0058509c disc_sm_prefetch+$58c
NM 7) SP=4184c180 RP=a.d1acf880 $RECOVER_END
Press RETURN to continue (or enter a GLANCE command):
Procedure Trace for Pin 245 is:
PC=a.0015d70c enable_int+$2c
NM* 0) SP=4184ccc0 RP=a.012a4868 notify_dispatcher.prep_for_swap_in+$1c8
NM 1) SP=4184ccc0 RP=a.012a5ab8 notify_dispatcher+$254
NM 2) SP=4184cc40 RP=a.0129f3c4 add_to_locality+$548
NM 3) SP=4184cb40 RP=a.002d4710 queue_for_pages+$21c
NM 4) SP=4184c940 RP=a.002e8e0c prefetch_+$50c
NM 5) SP=4184c840 RP=a.00584760 sm_hard_prefetch+$63c
NM 6) SP=4184c300 RP=a.0058509c disc_sm_prefetch+$58c
NM 7) SP=4184c180 RP=a.d1acf880 $RECOVER_END
Press RETURN to continue (or enter a GLANCE command):
Procedure Trace for Pin 245 is:
PC=a.0015d70c enable_int+$2c
NM* 0) SP=41849698 RP=a.012a4868 notify_dispatcher.prep_for_swap_in+$1c8
NM 1) SP=41849698 RP=a.012a5ab8 notify_dispatcher+$254
NM 2) SP=41849618 RP=a.0129f3c4 add_to_locality+$548
NM 3) SP=41849518 RP=a.002d4710 queue_for_pages+$21c
NM 4) SP=41849318 RP=a.002e8e0c prefetch_+$50c
NM 5) SP=41849218 RP=a.00584760 sm_hard_prefetch+$63c
NM 6) SP=41848cd8 RP=a.0058509c disc_sm_prefetch+$58c
NM 7) SP=41848b58 RP=a.00586008 disc_sm_start_read+$124
NM 8) SP=41848998 RP=a.00585ed0 ?disc_sm_start_read+$8
export stub: 2b1.00d5c6b4 setupsmcb_312+$2e0
NM 9) SP=418488d8 RP=2b1.00d5cc90 get'free'list'buffer_314+$1ec
NM a) SP=41848870 RP=2b1.00d5d45c ti_getblock+$200
NM b) SP=41848820 RP=2b1.00d640dc ti'bmfindrecord+$27c
NM c) SP=41848718 RP=2b1.00d7ac2c nmdbfind+$b1c
NM d) SP=41848620 RP=2b1.00d31ca8 dbfind+$180
NM e) SP=41848478 RP=2b1.00d31b04 ?dbfind+$8
Press RETURN to continue (or enter a GLANCE command):
Procedure Trace for Pin 245 is:
PC=a.0015d70c enable_int+$2c
NM* 0) SP=4184ccc0 RP=a.012a4868 notify_dispatcher.prep_for_swap_in+$1c8
NM 1) SP=4184ccc0 RP=a.012a5ab8 notify_dispatcher+$254
NM 2) SP=4184cc40 RP=a.0129f3c4 add_to_locality+$548
NM 3) SP=4184cb40 RP=a.002d4710 queue_for_pages+$21c
NM 4) SP=4184c940 RP=a.002e8ef8 prefetch_+$5f8
NM 5) SP=4184c840 RP=a.00584760 sm_hard_prefetch+$63c
NM 6) SP=4184c300 RP=a.0058509c disc_sm_prefetch+$58c
NM 7) SP=4184c180 RP=a.d1acf880 $RECOVER_END
Press RETURN to continue (or enter a GLANCE command):
Procedure Trace for Pin 245 is:
PC=a.0015d70c enable_int+$2c
NM* 0) SP=41849698 RP=a.012a4868 notify_dispatcher.prep_for_swap_in+$1c8
NM 1) SP=41849698 RP=a.012a5ab8 notify_dispatcher+$254
NM 2) SP=41849618 RP=a.0129f3c4 add_to_locality+$548
NM 3) SP=41849518 RP=a.002d4710 queue_for_pages+$21c
NM 4) SP=41849318 RP=a.002e8e0c prefetch_+$50c
NM 5) SP=41849218 RP=a.00584760 sm_hard_prefetch+$63c
NM 6) SP=41848cd8 RP=a.0058509c disc_sm_prefetch+$58c
NM 7) SP=41848b58 RP=a.00586008 disc_sm_start_read+$124
NM 8) SP=41848998 RP=a.00585ed0 ?disc_sm_start_read+$8
export stub: 2b1.00d5c6b4 setupsmcb_312+$2e0
NM 9) SP=418488d8 RP=2b1.00d5cc90 get'free'list'buffer_314+$1ec
NM a) SP=41848870 RP=2b1.00d5d45c ti_getblock+$200
NM b) SP=41848820 RP=2b1.00d640dc ti'bmfindrecord+$27c
NM c) SP=41848718 RP=2b1.00d7ac2c nmdbfind+$b1c
NM d) SP=41848620 RP=2b1.00d31ca8 dbfind+$180
NM e) SP=41848478 RP=2b1.00d31b04 ?dbfind+$8
export stub: 2b1.001b6860 BB_DBFIND+$70
NM f) SP=41848378 RP=2b1.001b5f88 ?BB_DBFIND+$8
export stub: ee8.0001a608
NM 10) SP=41848338 RP=ee8.0001d3dc
NM 11) SP=41846168 RP=ee8.00000000
(end of NM stack)
Press RETURN to continue (or enter a GLANCE command):
Procedure Trace for Pin 245 is:
PC=a.0015d70c enable_int+$2c
NM* 0) SP=41849698 RP=a.012a4868 notify_dispatcher.prep_for_swap_in+$1c8
NM 1) SP=41849698 RP=a.012a5ab8 notify_dispatcher+$254
NM 2) SP=41849618 RP=a.0129f3c4 add_to_locality+$548
NM 3) SP=41849518 RP=a.002d4710 queue_for_pages+$21c
NM 4) SP=41849318 RP=a.002e8ef8 prefetch_+$5f8
NM 5) SP=41849218 RP=a.00584760 sm_hard_prefetch+$63c
NM 6) SP=41848cd8 RP=a.00000000
(end of NM stack)
Press RETURN to continue (or enter a GLANCE command):
Procedure Trace for Pin 245 is:
PC=a.0015d70c enable_int+$2c
NM* 0) SP=41849698 RP=a.012a4868 notify_dispatcher.prep_for_swap_in+$1c8
NM 1) SP=41849698 RP=a.012a5ab8 notify_dispatcher+$254
NM 2) SP=41849618 RP=a.0129f3c4 add_to_locality+$548
NM 3) SP=41849518 RP=a.002d4710 queue_for_pages+$21c
NM 4) SP=41849318 RP=a.002e8e0c prefetch_+$50c
NM 5) SP=41849218 RP=a.00584760 sm_hard_prefetch+$63c
NM 6) SP=41848cd8 RP=a.0058509c disc_sm_prefetch+$58c
NM 7) SP=41848b58 RP=a.00586008 disc_sm_start_read+$124
NM 8) SP=41848998 RP=a.00585ed0 ?disc_sm_start_read+$8
export stub: 2b1.00d5c6b4 setupsmcb_312+$2e0
NM 9) SP=418488d8 RP=2b1.00d5cc90 get'free'list'buffer_314+$1ec
NM a) SP=41848870 RP=2b1.00d5d45c ti_getblock+$200
NM b) SP=41848820 RP=2b1.00d640dc ti'bmfindrecord+$27c
NM c) SP=41848718 RP=2b1.00d7ac2c nmdbfind+$b1c
NM d) SP=41848620 RP=2b1.00d31ca8 dbfind+$180
NM e) SP=41848478 RP=2b1.00d31b04 ?dbfind+$8
export stub: 2b1.001b6860 BB_DBFIND+$70
NM f) SP=41848378 RP=2b1.001b5f88 ?BB_DBFIND+$8
export stub: ee8.000102d8
NM 10) SP=41848338 RP=ee8.0001d3dc
NM 11) SP=41846168 RP=ee8.00000000
(end of NM stack)
Press RETURN to continue (or enter a GLANCE command):
Procedure Trace for Pin 245 is:
PC=a.0015d70c enable_int+$2c
NM* 0) SP=41849698 RP=a.012a4868 notify_dispatcher.prep_for_swap_in+$1c8
NM 1) SP=41849698 RP=a.012a5ab8 notify_dispatcher+$254
NM 2) SP=41849618 RP=a.0129f3c4 add_to_locality+$548
NM 3) SP=41849518 RP=a.002d4710 queue_for_pages+$21c
NM 4) SP=41849318 RP=a.002e8e0c prefetch_+$50c
NM 5) SP=41849218 RP=a.00584760 sm_hard_prefetch+$63c
NM 6) SP=41848cd8 RP=a.0058509c disc_sm_prefetch+$58c
NM 7) SP=41848b58 RP=a.00586008 disc_sm_start_read+$124
NM 8) SP=41848998 RP=a.00585ed0 ?disc_sm_start_read+$8
export stub: 2b1.00d5c6b4 setupsmcb_312+$2e0
NM 9) SP=418488d8 RP=2b1.00d5cc90 get'free'list'buffer_314+$1ec
NM a) SP=41848870 RP=2b1.00d5d45c ti_getblock+$200
NM b) SP=41848820 RP=2b1.00000000
(end of NM stack)
Press RETURN to continue (or enter a GLANCE command):
Procedure Trace for Pin 245 is:
PC=a.0015d70c enable_int+$2c
NM* 0) SP=41849698 RP=a.012a4868 notify_dispatcher.prep_for_swap_in+$1c8
NM 1) SP=41849698 RP=a.012a5ab8 notify_dispatcher+$254
NM 2) SP=41849618 RP=a.0129f3c4 add_to_locality+$548
NM 3) SP=41849518 RP=a.002d4710 queue_for_pages+$21c
NM 4) SP=41849318 RP=a.002e8ef8 prefetch_+$5f8
NM 5) SP=41849218 RP=a.00584760 sm_hard_prefetch+$63c
NM 6) SP=41848cd8 RP=a.00000000
(end of NM stack)
Press RETURN to continue (or enter a GLANCE command):
Procedure Trace for Pin 245 is:
PC=a.0015d70c enable_int+$2c
NM* 0) SP=41849698 RP=a.012a4868 notify_dispatcher.prep_for_swap_in+$1c8
NM 1) SP=41849698 RP=a.012a5ab8 notify_dispatcher+$254
NM 2) SP=41849618 RP=a.0129f3c4 add_to_locality+$548
NM 3) SP=41849518 RP=a.002d4710 queue_for_pages+$21c
NM 4) SP=41849318 RP=a.002e8e0c prefetch_+$50c
NM 5) SP=41849218 RP=a.00584760 sm_hard_prefetch+$63c
NM 6) SP=41848cd8 RP=a.0058509c disc_sm_prefetch+$58c
NM 7) SP=41848b58 RP=a.00586008 disc_sm_start_read+$124
NM 8) SP=41848998 RP=a.00585ed0 ?disc_sm_start_read+$8
export stub: 2b1.00d5c6b4 setupsmcb_312+$2e0
NM 9) SP=418488d8 RP=2b1.00d5cc90 get'free'list'buffer_314+$1ec
NM a) SP=41848870 RP=2b1.00d5d45c ti_getblock+$200
NM b) SP=41848820 RP=2b1.00d640dc ti'bmfindrecord+$27c
NM c) SP=41848718 RP=2b1.00d7ac2c nmdbfind+$b1c
NM d) SP=41848620 RP=2b1.00d31ca8 dbfind+$180
NM e) SP=41848478 RP=2b1.00d31b04 ?dbfind+$8
export stub: 2b1.001b6860 BB_DBFIND+$70
NM f) SP=41848378 RP=2b1.001b5f88 ?BB_DBFIND+$8
export stub: ee8.0001a608
NM 10) SP=41848338 RP=ee8.0001d3dc
NM 11) SP=41846168 RP=ee8.00000000
(end of NM stack)
Press RETURN to continue (or enter a GLANCE command):
Procedure Trace for Pin 245 is:
PC=a.0015d70c enable_int+$2c
NM* 0) SP=4184c708 RP=a.012a4868 notify_dispatcher.prep_for_swap_in+$1c8
NM 1) SP=4184c708 RP=a.012a5ab8 notify_dispatcher+$254
NM 2) SP=4184c688 RP=a.002e8ef8 prefetch_+$5f8
NM 3) SP=4184c588 RP=a.84d28000 $RECOVER_END
Press RETURN to continue (or enter a GLANCE command):
Procedure Trace for Pin 245 is:
PC=a.0015d70c enable_int+$2c
NM* 0) SP=4184ccc0 RP=a.012a4868 notify_dispatcher.prep_for_swap_in+$1c8
NM 1) SP=4184ccc0 RP=a.012a5ab8 notify_dispatcher+$254
NM 2) SP=4184cc40 RP=a.0129f3c4 add_to_locality+$548
NM 3) SP=4184cb40 RP=a.002d4710 queue_for_pages+$21c
NM 4) SP=4184c940 RP=a.002e8ef8 prefetch_+$5f8
NM 5) SP=4184c840 RP=a.00584760 sm_hard_prefetch+$63c
NM 6) SP=4184c300 RP=a.0058509c disc_sm_prefetch+$58c
NM 7) SP=4184c180 RP=a.d1acf880 $RECOVER_END
Press RETURN to continue (or enter a GLANCE command):
----------------------------------------------------
|
|
|
