Help Center/ Database and Application Migration UGO/ FAQs/ Evaluation Project/ What Is the Impact of the Collection on the Source Database?
Updated on 2024-11-07 GMT+08:00
View PDF
Share

What Is the Impact of the Collection on the Source Database?

  • When a UGO evaluation task connects to the source database to collect objects, the execution time of the SELECT or ALTER statement in the source Oracle database increases by about 0.1s.
  • The following table describes the impact on the source database performance.
    Table 1 Impact on the source database performance

    Source Database Type

    Configuration

    CPU Usage

    Memory Usage

    I/O Usage

    Application Query Impact

    Oracle database without application load

    vCPUs: 48

    Memory: 188 GB

    Storage: 511 GB

    0.04% -> 17.03%

    1.5% -> 2.56%

    0.1% -> 2.8%

    N/A

    Oracle database with application load simulated in TPC-H

    vCPUs: 48

    Memory: 188 GB

    Storage: 511 GB

    0.04% -> 19.63%

    1.52% -> 2.54%

    0.1% -> 10.2%

    Increased by 5%
    • Source: Lab test data. The specific impact depends on the actual situation.
    • The TPC-H is a well-known benchmark used by many database vendors. It consists of a suite of business oriented ad-hoc queries and concurrent data modifications. The queries and the data populating the database have been chosen to have broad industry-wide relevance.
Parent topic: Evaluation Project