A database profile is used to evaluate a source database. The database profile helps you monitor the status of your source database. When you migrate or transform the source database, you can search for the database based on the database profile.
Create a profile
Log on to the Data Management (DMS) console V5.0.
In the top navigation bar, move the pointer over DTS. Choose Heterogeneous Database Migration(ADAM) > Database Evaluation.
Click the Source DB Profile tab. In upper-left corner of the Source DB Profile tab, click Create Profile.
In the Create Profile panel, set the Profile Name, Type, and Report Language Type parameters. Click Upload to upload a data file. Then, click Create.
NoteThe database profile is expected to be created in 1 minute to 30 minutes. The time depends on the collected data of the source database.
If the database profile enters the Complete state, the database profile is created.
View the profile
On the Source DB Profile tab, find the database profile that you want to view and click Details in the Actions column.
View the overview
On the Overview tab, you can view the overview of the database profile.
Basic Information
Session: the connection status of the database. The higher the value is, the more sessions are established to the database.
Complexity: the complexity of the database. The complexity is evaluated based on the collected information about the source database, such as the scenarios in which the source database is used. The higher the value, the more complex the database.
Risk: the risk level of the database. The higher the value is, the more likely the database is exposed to performance risks related to SQL statements or objects.
Hotspot: indicates whether the database contains objects that are frequently accessed. The higher the value is, the more objects are frequently accessed.
Scale: the scale of database resources. The higher the value, the larger the database scale.
Load: the performance of the database. The higher the value, the larger the load of the database.
Main Objects
This section displays the distribution of object types in the source database.
You can also click Download Report in the lower part of the page to download the database profile.
View the details
Performance
This metric shows the transactions per second (TPS), queries per second (QPS), CPU utilization, and load of the database.
Capacity
This metric shows the capacity ranking of database schemas and the capacity proportion of different object types such as table, index, and large object (LOB).
Oracle Features
This metric shows features used by your source database in a tree diagram and a table. The tree diagram provides two levels to list all the features collected from the database. If you click a feature, the objects that use the feature are listed in a table. You can search for features by entering a condition in the search box.
External Dependency
This metric shows database links and link details. You must revise schemas when you transform databases that contain external dependencies.
Other Dimensions
This metric shows special tables and SQL statements, such as tables without primary keys, high growth tables, and SQL statements with aggregate functions. You can click View in the Actions column to view details.
Object Details
This metric shows object information from different dimensions, such as object feature tags, relationships such as association and dependency, and features contained in objects. You can click View Object Details in the Actions column to view details.
In the Basic Information section of the View Object Details dialog box, you can view the basic information and DDL statements of the object. In the Details section, you can view the analysis data provided by ADAM, such as the features, referenced objects, dependent objects, and features of the object.
Object Search
The Object Search feature allows you to search for objects when you transform databases and applications. Exact matches, fuzzy matches, and type-based matches are supported. You can combine different filter conditions to search for objects in the database profile. You can search for objects by schema, DDL, object type, or tag. You can also view the dependencies and tags of objects.
On the Details tab, you can view the details of the database profile.
You can view the details of only the profiles of Oracle databases.
Other operations
Operation | Description | Procedure |
|---|---|---|
Update the profile | You can create multiple versions for a database profile. If the data in a source database is changed after a database profile is created, you can append a new data file to the database profile. |
The system automatically generates a new version of the database profile based on all data files. |
Grant permissions on the profile |
Notice Use the authorization feature with caution. You are liable for data disclosures caused by improper authorization. |
Note To obtain the UID, you can move your pointer over the |
Delete the profile | You can delete a profile that is no longer needed. After you delete the profile, evaluation projects that are generated based on the profile are automatically deleted. |
|
icon in the upper-right corner of the Data Management (DMS) console. What to do next
Select a profile and click Next: Select Destination Database to go to the Select Destination DB tab. For more information, see Select a destination database.