Purpose

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

View profiles

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.

Update profiles

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.

Grant permissions

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.

Cancel authorization

You can cancel the authorization of other users and revoke their access permissions on the profile at any time.

Delete profiles

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.

Profile details

1. Overview shows a profile from dimensions such as scale, session, risk, hotspot, complexity, and load.

Session: 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.