All Products
Search
Document Center

Manage a database profile

Last Updated: Mar 30, 2021

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.

Creae Profile

  1. Log on to the ADAM console.

  2. In the left-side navigation pane, click Evaluate DB.

  3. In the upper-left corner of the Create Source DB Profile tab, click Create Profile.Create

  4. In the Create Profile dialog box, specify the profile name and click Upload to upload a data file. Then, click Create.Upload

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. Details

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. performance

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. Append

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.Append Profile

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.

Notice

Use the authorization feature with caution. You are liable for data disclosures caused by improper authorization.

Grant permissions on the profile

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. Authorize

Profile details

Overview
The overview page provides the statistics of a profile by scale, session, risk, hotspot, complexity, and load. Description
  • 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.

Performance
This metric shows the transactions per second (TPS), queries per second (QPS), CPU usage, and load of the database. Performance
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). Capacity
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. Source DB Profile
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. OtherDimensions
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. Object Detalis

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.View Object Detalis

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. Enter