A database profile is used to evaluate a source database,helps you monitor the status of your source Oracle database.When you migrate and transform a source database, you can search for the database based on the database profile.
Log on to the ADAM console.
In the left-side navigation pane, click Evaluate DB.
In the upper-left corner of the Create Source DB Profile tab, click Create Profile.
In the Create Profile dialog box, specify the profile name and click Upload to upload a data file. Then, click Create.
View the profile
After the profile of the source database is analyzed, you can click Details in the Actions column to view the profile details. A database profile is analyzed in 1 to 30 minutes. The required time depends on the collected information of the source database.
Click Details in the Actions column. On the profile details page, you can view the performance, capacity, Oracle features, and external dependencies of the source database.
Update a profile
You can create multiple versions for a profile of a source database. If the information of a source database is changed after a profile is created, you can append a new data file to the profile.
In the profile list, select the profile to be updated. Click Append in the Actions list. This way, you can append a new data file to the profile. Advanced Database & Application Migration (ADAM) generates a new version of the profile based on all the data files.
Grant permissions on the profile
ADAM allows you to authorize other users to access your profile. The validity period of the access permissions is one month. Authorized users can view the profile and create new projects based on the profile.
Use the authorization feature with caution. You are liable for data disclosures caused by improper authorization.
Revoke permissions on the profile
You can revoke permissions on the profile from other users.
Delete a profile
If you delete a profile, all analysis data of the profile are also deleted. Move the pointer over the More icon in the Actions column and click Delete.
- The overview page provides the statistics of a profile by scale, session, risk, hotspot, complexity, and load.
Session: indicates the connection status of the database. The higher the value is, the more sessions are established to connect to the database.
Risk: indicates 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 has objects that are frequently accessed. The higher the value is, the more objects are frequently accessed.
Scale: indicates the scale of database resources. The higher the value, the larger the database scale.
Load: indicates the running performance of the database. The higher the value, the larger the running load of the database.
- This metric shows the transactions per second (TPS), queries per second (QPS), CPU usage, and load of the database.
- 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 Oracle features 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 have the feature are listed on the table. You can search for features by entering a condition in the search box. This shows all Oracle features used by your source database before you migrate the database.
- External dependencies
- 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 the details.
- Object details
- This metric shows object information from different dimensions, such as object feature tags, relationships such as association and dependency, and Oracle 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 Oracle features of the object.
- Object search
- You can search for objects by schema, DDL, object type, or tag. You can also view the dependencies and tags of objects. Exact matches, fuzzy matches, and type-based matches are supported. You can combine different filter conditions to search for Oracle objects in the profile. The object search feature allows you to search for objects when you transform databases and applications.