What Is the Impact of the Migration 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
Query Statement Execution Time
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.
Migration Project FAQs
- Why Is There No Available Evaluation Project During Migration Project Creation?
- When Should I Use the Conversion Config Function?
- What Should I Do If SQL Modifications Failed to Be Saved During Object Correction?
- Why Is a Name Error Reported During Database Migration?
- How Do I Solve ERROR: syntax error at or near "@"?
- What Is the Impact of the Migration on the Source Database?
- What Are the Impacts of GUC Parameter Settings of GaussDB on Migration?
- Why Is the Number of Indexes Different After Oracle Data is Migrated to GaussDB?
- What Should I Do If There Are ctid, xc_node_id, and tableoid Columns in GaussDB?
- Why Is Data Inconsistent When SELECT Statements Without ORDER BY Are Used for Query in Distributed GaussDB?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore