Application Transformer for VMware Tanzu allows you to get insight of 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.
- Download the Oracle Instant DB Client.
- Add Third Party Artifacts.
- Download JDK 1.8 to run JAR files and Add Third Party Artifacts.
- Upload JOOQ Enterprise edition.
- Download JOOQ Enterprise edition from https://www.jooq.org/download/.
- Extract the file.
- 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
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 .