Versions Compared

Old Version 13

changes.mady.by.user Pamela Totas (Deactivated)

Saved on

compared with

New Version 14

changes.mady.by.user Nancy Cohn (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

System Management Center allows you to gather information about the Oracle database tables in your environment.

Table of Contents
printablefalse

What do you want to know?

  • Which Oracle tables have more than 5 indexes?
  • Which Oracle tables are missing a primary key?
  • How can I find out tablespace information for a specific Oracle table?

Which Reports are Available?

To monitor database tables:

  1. In System Management Center, select and run system queries with the oracle - table keywords.
    Select and run queries - Oracle tableImage Modified
  2. To customize how the report information is displayed, click the Print button drop down to print, or click the Export button drop down and select the file type to export query reports.
  3. To return to the Queries workspace, click the Queries bottom tab.