- Database profiles provide basic data from which to evaluate databases.
- Database profiles help you better understand your source Oracle databases.
- Database profiles allow you to search for source database information to guide database
migration and transformation.
After the analysis of source database profile is complete, you can click Details in
the Actions column corresponding to the profile to go to the profile details page.
It can take about 1 to 30 minutes to analyze a database profile. The amount of time
it takes to process a profile is related to how much data was collected from the database.
The profile details page is as follows.
On the profile details page, you can view analysis data from tabs such as Performance,
Capacity, Complexity, and External Dependencies.
You can manage multiple versions of source database profiles. There may be times when
you cannot complete data collection. To resolve this problem, ADAM allows you to add
a new collection file to the existing database profile. After you upload a collection
file to the existing database profile, the system will generate a new profile.
You can click Append in the Actions column corresponding to the profile to which you
want to add data.
The configuration methods of these parameters are the same as those of parameters
for creating database profiles.
ADAM allows you to authorize other users to access your profile. The validity period
of the authorization is one month. Authorized users can view the profile and create
new projects based on the profile. Use the authorization feature with caution. The
licensor is liable for any disclosures of profiles caused by improper authorization.
You can cancel the authorization of other users and revoke their access permissions
on the profile at any time.
You can delete profiles that you no longer need. All analysis data of the profiles
is also deleted.
Move the pointer over the More icon in the Actions column corresponding to a profile
and click Delete in the shortcut menu.
1. Overview shows a profile from dimensions such as scale, session, risk, hotspot, complexity,
: indicates the database connection status. A higher score indicates that more sessions
are connected to the database at the same time. Risk
: indicates whether the database has performance risks in executing SQL statements
or performing object-related operations. A higher score indicates a higher probability
of risk. Hotspot
: indicates whether the database has frequently accessed objects. A higher score indicates
that database objects are more frequently accessed. Scale
: indicates the scale of database resources. A higher score indicates a larger scale
of the database. Load
: indicates the operational performance of the database. A higher score indicates
a higher load capacity of the database. 2. Performance
shows TPS, QPS, CPU utilization, and load information of the database.3. Capacity
shows the capacity ranking of database schemas and the capacity proportion of different
object types such as table, index, and LOB.4. Oracle Features
shows details of level-1 and level-2 Oracle features. The section on the left side
of the tab lists all the features that are collected from the database in the form
of a tree diagram. Click a feature, and the database objects that have the feature
are listed on the right section of the tab. You can search for databases by entering
any field in the search box. This helps you know which Oracle features your source
database uses so that you can have a preliminary understanding of database transformation.
5. External Dependencies
shows database links and link details. Cross-database queries must be taken into
account when you transform databases that contain external dependencies.
6. Other Dimensions
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 corresponding to an object to view its details.7. Object Details
shows object information for different dimensions, such as object feature tags, object
associations (dependent objects and tables with foreign keys), and Oracle features
contained in the object.
You can click View in the Actions column corresponding to an object to view its details
without referring to the database to which the object belongs. On the Object Details
page, the Basic Information section displays the basic information of the object and
detailed DDL statements. The Detailed Information section displays the analyzed data
provided by ADAM, such as the characteristics, dependencies, and Oracle features of
the object. 8. Advanced Search (Panoramic Search)
allows you to search for objects by object schema, DDL statement, type, or tag, and
enables you to view the associations and tags of objects. Exact match, fuzzy match,
and type-based match are supported. You can combine different feature as a filtering
condition to search for Oracle objects in a profile. This feature allows you to search
for target objects when you transform databases and applications.