SAP Knowledge Base Article - Preview

3047132 - Loading a transaction dump takes too long time to finish if it has run reorg rebuild and update statistics at source system

Symptom

If reorg rebuild and update statistics commands were not running at source system, load tran command finished in 1 minute.

Redo Statistics:
        Total operations considered for redo: 165424

                Recovery Pages Summary:
                        Getpage requests: 7891184
                        Getpage requests that found the I/O in progress: 5
                        Getpage requests with physical I/O: 69804

        Pass Started At: Feb 19 2021 11:45:11:663AM
        Pass Completed At: Feb 19 2021 11:46:06:416AM
        Pass Active For: 54753 milli seconds

But including that kind of commands, it took over 25 minutes.

Redo Statistics:
Total operations considered for redo: 1100118 Recovery Pages Summary: Getpage requests: 33757668 Getpage requests that found the I/O in progress: 2 Getpage requests with physical I/O: 193317 Pass Started At: Feb 19 2021 1:16:09:060PM Pass Completed At: Feb 19 2021 1:41:41:790PM Pass Active For: 1532730 milli seconds


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16 SP 03

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.