Oracle7 Server Manager User's Guide

Library

Product

Contents

Index

Viewing Schema Objects

This chapter describes how to use Server Manager to view information about schema objects in your database. This chapter assumes that you have read Chapter 2, "Overview of the Administration Manager," and are familiar with the interface elements of the Administration Manager.

The information in the Schema drawer is for viewing only. From the Schema drawer, you cannot create, alter, or drop any schema objects. You can create, alter, or drop schema objects using the SQL Worksheet. For a description of the SQL Worksheet, see Chapter 9, "The SQL Worksheet."

This chapter describes the Schema drawer's folders:

Constraints · Snapshots

Triggers · Snapshot Logs

Packages · Optimizer

Links · Explain Plans

Synonyms

The Constraints Folder

When you click the Constraints folder tab, the Constraints folder opens and the Constraint object list appears. The Constraint object list contains information about the integrity constraints defined on the tables in the database.

Integrity constraints prevent invalid data from being entered into database tables. An integrity constraint is declared on one or more columns in a table, and defines a rule for the data in those columns. For information about data integrity and declarative constraints, see the Oracle7 Server Concepts.

The following figure illustrates the Constraint object list.

Figure 7 - 1. Constraint Object List

Constraint Object List

The columns of the Constraint object list are described below:

Table Name

Table owner and table name.

Constraints

Number of constraints defined on the table.

Enabled

Number of constraints currently enabled in the table.

Disabled

Number of constraints currently disabled in the table.

The Triggers Folder

When you click the Triggers folder tab, the Triggers folder opens and the Trigger object list appears. The Trigger object list contains information about triggers defined on tables in the database.

A trigger is PL/SQL code that is implicitly executed when inserting, updating, or deleting data in a table. For information about triggers, see the Oracle7 Server Concepts and the Oracle7 Server Application Developer's Guide.

The following figure illustrates the Trigger object list.

Figure 7 - 2. Trigger Object List

Trigger Object List

The columns of the Trigger object list are described below:

Trigger

Trigger owner and trigger name.

Table

Owner and name of table on which the trigger is defined.

Type

When the trigger fires: Before/After Statement or Before/After Each Row.

Event

Type of statements that fire the trigger: Insert, Update, and/or Delete.

Status

Status of the trigger: Enabled or Disabled.

When

Condition that must be true for the trigger to fire (only applies to row triggers).

The Packages Folder

When you click the Packages folder tab, the Packages folder opens and the Package object list appears. The Package object list contains information about stored procedures, functions, and packages.

A procedure or function is a set of SQL or PL/SQL statements that perform a specific task. A package is a group of related functions, procedures, cursors, and variables. For information about stored procedures, functions, and packages, see the Oracle7 Server Concepts and the Oracle7 Server Application Developer's Guide. For information on PL/SQL, see the PL/SQL User's Guide and Reference.

The following figure illustrates the Packages object list.

Figure 7 - 3. Package Object List

Package Object List

The columns of the Package object list are described below:

Name

Object owner and name of the object.

Type

Type of object: Function, Package, Package Body, or Procedure.

Status

Status of the object: Valid or Invalid (needs to be recompiled).

Modified

Date the object was last modified as the result of a DDL (Data Definition Language) command, including GRANT and REVOKE.

The Links Folder

When you click the Links folder tab, the Links folder opens and the Link object list appears. The Link object list contains information about the database links defined in the database.

A database link allows you to access a remote database. For information about database links, see the Oracle7 Server Concepts.

The following figure illustrates the Link object list.

Figure 7 - 4. Link Object List

Link Object List

The columns of the Link object list are described below:

DB Link

Name of the database link.

Owner

Owner of the database link.

Username

Name of the user to log in as on the remote database.

Host

SQL*Net service name for the remote database.

Created

Date on which the link was created.

The Synonyms Folder

When you click the Synonyms folder tab, the Synonyms folder opens and the Synonym object list appears. The Synonym object list contains information about the synonyms defined in the database.

A synonym is an alias for a table, view, snapshot, sequence, procedure function, package, or another synonym. For information about synonyms, see the Oracle7 Server Concepts.

The following figure illustrates the Synonym object list.

Figure 7 - 5. Synonym Object List

Synonym Object List

The columns of the Synonym object list are described below:

Synonym Name

Name of the synonym.

Owner

Owner of the synonym.

Object Name

Owner and name of the object referenced by the synonym.

DB Link

Name of database link used in a synonym for a remote object.

The Optimizer Folder

When you click the Optimizer folder tab, the Optimizer folder opens and the Optimizer object list appears. The Optimizer object list contains information about the optimizer statistics generated for objects in the database. The Optimizer object list shows whether statistics have been generated for tables, clusters, and indexes in the database.

The Oracle optimizer chooses the execution plan for a SQL statement. When using the cost-based approach, the optimizer can utilize statistics for the objects accessed in the SQL statement. You generate these statistics using the ANALYZE command.

For information about the optimizer and generating statistics, see the Oracle7 Server Concepts and the ANALYZE command in the Oracle7 Server SQL Reference.

The following figure illustrates the Optimizer object list.

Figure 7 - 6. Optimizer Object List

Optimizer Object List

The columns of the Optimizer object list are described below:

Object

The owner and name of the object.

Object Type

Object type: Table, Cluster, or Index.

Statistics?

Whether or not statistics have been generated for the object.

The Explain Plans Folder

When you click the Explain Plans folder tab, the Explain Plans folder opens and the Explain Plan object list appears. The Explain Plan object list contains a list of the SQL statements that have execution plans stored in the table PLAN_TABLE.

You can use the EXPLAIN PLAN command to generate the execution plan for a particular SQL statement. The execution plan is stored in a table, which by default is called PLAN_TABLE. For information about execution plans and the EXPLAIN PLAN command, see the Oracle7 Server Concepts, the Oracle7 Server Application Developer's Guide, and the Oracle7 Server SQL Reference.

The following figure illustrates the Explain Plan object list.

Figure 7 - 7. Explain Plan Object List

Explain Plan Object List

The columns of the Explain Plan object list are described below:

Statement ID

Identifier for the SQL statement (can be null).

Timestamp

Date the EXPLAIN PLAN command was executed for the statement.

Attention: The information displayed in the Explain Plan object list is from the table named PLAN_TABLE belonging to the schema SYS. Server Manager does not display information from any other plan tables. If SYS does not own a PLAN_TABLE or if you do not have access to SYS.PLAN_TABLE, you cannot open the Explain Plans folder.

Additional Information: You can run the script UTLXPLAN.SQL to create a PLAN_TABLE. The location of the script UTLXPLAN.SQL is platform dependent. For information about running UTLXPLAN.SQL, see your operating system-specific Oracle documentation.

The Snapshots Folder

When you click the Snapshots folder tab, the Snapshots folder opens and the Snapshot object list appears. The Snapshot object list contains information about the snapshots created in the database.

A snapshot contains the results of a query of one or more tables or views. The queried tables or views are called the master tables of the snapshot and are often located on remote databases. The snapshot is stored in a table, and can be queried by way of a view defined on the table.

For information about snapshots, see the Oracle7 Server Concepts and the Oracle7 Server Application Developer's Guide.

The following figure illustrates the Snapshot object list.

Figure 7 - 8. Snapshot Object List

Snapshot Object List

The columns of the Snapshot object list are described below:

Snapshot

Owner of the snapshot and the name of the view associated with the snapshot.

Master

Owner and name of the snapshot's master table.

Link

Whether or not a database link to the master site is used in the snapshot specification.

Refresh

Date of the last refresh (at the master site).

Type

Type of refresh for automatic refreshes: Complete, Fast, or Force.

Query

Original query defining the snapshot.

Attention: You cannot sort the Snapshot object list on the Query column.

The Snapshot Logs Folder

When you click the Snapshot Logs folder tab, the Snapshot Logs folder opens and the Snapshot Log object list appears. The Snapshot Log object list contains information about the snapshot logs created in the database.

A snapshot log is a table associated with the master table of a snapshot. The snapshot log contains information about changes made to its associated master table. The information in the snapshot log is used to refresh the snapshot. For information about snapshot logs, see the Oracle7 Server Concepts and the Oracle7 Server Administrator's Guide.

The following figure illustrates the Snapshot Log object list.

Figure 7 - 9. Snapshot Log Object List

Snapshot Log Object List

The columns of the Snapshot Log object list are described below:

Table Being Logged

Owner of the snapshot log and master table of the log.

Last Refreshed

Date snapshot was last refreshed (one date for each snapshot defined on the master table).

Prev Next

Library

Product

Contents

Index