Application Transformer for VMware Tanzu allows you to get insight of your Oracle database.

You can view the count and details of following entities in your Oracle database.

  • DATABASE LINKS

  • DB ALLOCATED SIZE (GB)

  • DB USED SIZE (GB)

  • DB USED SIZE for DATA (GB)

  • FUNCTIONS AND PROCEDURES IN PACKAGES

  • INDEXES

  • MATERIALIZED VIEWS

  • NOT-DEFAULT PARAMETERS

  • PACKAGES

  • PGA (Program Global Area )

  • PROCEDURES
  • SGA

  • SQLAREA statements

  • TABLES
  • TRIGGERS
  • VIEWS

Prerequisites

Note: Currently, you can use this feature on Linux machine only.
  • The Linux machine must have the GNU C Library (glibc) version 2.17 or later.
  • You must have Oracle 11 or later versions of the database on the Linux machine.
  • You must have Oracle Instant DB client to connect with the database.
    1. Download the Oracle Instant DB Client.
    2. Add Third Party Artifacts.
  • Download JDK 1.8 to run JAR files and Add Third Party Artifacts.
  • Upload JOOQ Enterprise edition.
    1. Download JOOQ Enterprise edition from https://www.jooq.org/download/.
    2. Extract the file.
    3. Upload the following JAR files. See Add Third Party Artifacts.
      • reactive-streams.x.x.x.jar
      • r2dbc-spi-x.x.x.RELEASE.jar
      • jooq-x.x.x.jar
        Note: You must select all these files together during upload. If you upload the files individually, you get an error.

Procedure

  1. Click Discovery, and add the application that has Oracle database.
  2. Click Analyze on the main menu, and expand the application name.
    You see the Oracle database details, under Analyzable section.
  3. Click the Analyze option on the component details section.
    Oracle database data analyze wizard opens.
  4. Enter the database details.
    1. The port on which you have deployed Oracle. Example: 1521.
    2. Oracle Client that you uploaded
    3. JAR files
    4. JDK files
    5. Targeted schema where you want to analyze. you can add multiple schemas using the comma-separated names.
    6. Credentials to connect to the database. Ensure that the credentials has access to the specified schemas. Example, DBA account.
  5. Review the database details and click Confirm.

Results

  • You see the DB Analysis task status under Recent Tasks pane. Based on your database size, the process might take a few hours. You can also cancel analysis task from Tasks pane.
  • You see the DB Analysis status report in Discovery > Components.