Oracle Enterprise Manager Concepts Guide Release 2.1 A75684-01 |
|
Oracle Enterprise Manager's functionality can be extended further by adding one or more optional management packs. Combined with Oracle Enterprise Manager's console and framework, these specialized application packs offer integrated solutions for monitoring system bottlenecks, optimizing and tuning system performance, managing system changes, and planning for increases in resource utilization of your entire information system environment.
The following optional system management packs are available for use with Oracle Enterprise Manager:
Integrated into the Oracle Enterprise Manager Console are the following applications for added value in enterprise management. These applications are included with Oracle Enterprise Manager. (An asterisk indicates that the beta version of the product is released with version 2.1 of Oracle Enterprise Manager.)
The sections below describe each of the Oracle system management packs and integrated applications.
The Oracle Diagnostics Pack is a useful set of sophisticated, yet easy-to-use tools for managing the health of your system, including automatically detecting problems, diagnosing problems, and planning for the future. By using the tools in Oracle Diagnostics Pack, you can make significant gains in productivity, manageability, and database performance.
The Oracle Diagnostics Pack contains the following applications:
Total performance monitoring must include the ability to monitor remote systems that may not always be accessible from a graphical monitor. The Oracle Enterprise Manager Event Management System uses Intelligent Agents to monitor managed nodes for potential problem occurrences. These problem occurrences, called "events", which are comprised of pre-defined tests, are registered with the Event Management System for detection by Intelligent Agents.
The Oracle Diagnostics Pack takes event management a step further by adding a set of additional pre-defined tests, called Oracle Advanced Events, to the Event Management System. These tests can be used with standard Oracle Enterprise Manager tests to comprise events used in monitoring the system for problem occurrences.
Oracle Advanced Events provide the following features:
Oracle Advanced Events provides the following types of monitoring:
Performance monitoring covers a range of database performance considerations such as I/O rates, cache performance, and response time.
Space-management monitoring allows the user to monitor Oracle storage metrics such as the maximum number of extents allowable for a specific segment or the outer limits of contiguous free space. Oracle Advanced Events can also be used to monitor tables for fast growth trends and to monitor databases for potential space management problems such as opportunities to rebuild indexes.
Resource-usage monitoring can spot important database resource issues, such as the maximum number of users, processes, and locks, and datafile size limits. Additionally, with Oracle Advanced Events, managed nodes can be monitored for excessive CPU utilization, load or paging problems, and disk capacity problems.
Audit monitoring monitors specified database user connections. For example, an alert is displayed when a particular database user connection, specified by the username filter argument, has been detected.
User-defined SQL monitoring allows you to define your own SQL scripts that evaluate event tests. You can add SQL-based events to the Event Library for future use and/or editing as you would with any other event. Within the SQL script, you provide a datapoint that is used as a return value for comparison with the Alert and Warning Threshold values. With a User-defined SQL Event Test, you specify the operator, alert threshold, warning threshold, number of occurrences, and SQL script. The specified operator is used to compare the return value from the script with the supplied thresholds to determine the event condition. After the specified number of occurrences is met, the event is triggered.
Database Fault monitoring monitors for severe problems that require immediate action.
Oracle Advanced Events can be customized with user-defined thresholds and monitoring intervals. The user can establish an event-metric threshold or an occurrence threshold. The user also can specify how often the Event Management System should check for the existence of an exceeded, event-metric threshold.
Advanced Event tests can be grouped together to form reusable, logical configurations of pre-defined events. For example, an event could be defined for "SGA Monitoring," and could include event tests such as Library Cache Hit %, Buffer Cache Hit %, and the Data Dictionary Cache Miss %. Once the Event is created, it can be registered or launched for use on any of the database services managed by Oracle Enterprise Manager.
The Event Management System also allows the administrator to decide when and how to be notified of a problem. The administrator can be contacted by console alert (with view permissions), page, or e-mail. Third-party systems, such as the HP Openview product, can be notified by creating a Simple Network Management Protocol (SNMP) trap.
For more information about SNMP, see the Oracle SNMP Support Reference Guide.
In addition to alerting the administrator, Oracle Advanced Events can be configured to automatically correct a problem. Pre-determined fixit jobs, which are created by the administrator using the Oracle Enterprise Manager Job System can be set to occur when an event threshold is reached. For example, a fixit job could be created to increase the size of a datafile as a corrective action in response to an alert situation for the Datafile Limit event.
Sustaining high performance and availability in an Oracle database requires careful system monitoring. Top performance is achieved through a balance of many factors, such as effectively using memory, minimizing disk input/output (I/O), and avoiding resource contention. Oracle Performance Manager is a tool that allows you to focus on the key metrics of your database, so that you can easily monitor the factors that most affect database performance.
Oracle Performance Manager provides real-time graphical views of performance data collected from Oracle databases, non-Oracle databases (such as SQL Server) and the host operating system. This data is collected by a data collection service, which is an extension of the Intelligent Agent that resides on the managed node containing the database. Performance statistics are displayed by Oracle Performance Manager in real-time graphical views for monitoring and analyzing. Views include pre-defined or user-defined tables and charts that can be automatically refreshed at user-defined intervals. When a performance problem is detected, the user can drill down into charts linked to the view to find the source of the problem by examining finer details.
Oracle Performance Manager's large collection of pre-defined charts and tables are organized into performance monitoring groups which include:
Each group allows easy access to key metrics for that performance category. For example, the memory group includes pre-defined charts for database buffers, library and dictionary cache performance, memory sort performance, parse ratios, and a tabular presentation of all cached SQL statements.
A chart's activity can also be recorded and played back at your convenience for analyses at a later date. Chart recordings are stored in the Oracle Enterprise Manager Repository.
Additionally, users can define their own real-time charts by using the powerful graphical presentation capabilities of Oracle Performance Manager with their own database monitoring scripts. User-defined charts can be created for virtually any data in your database. Oracle Performance Manager provides dialog boxes for entering the SQL to retrieve the data, defining operations to be performed on the data, and selecting the type of chart best suited to graphically display the data. User-defined charts are stored in the Oracle Enterprise Manager Repository.
Performance Manager also allows you to focus on the most resource-intensive parts of your system causing performance bottlenecks. This "top" database information can be viewed in "top" charts such as Top Datafiles.
Integrated into Performance Manager are the lock monitor charts, which monitor database locks and contention. While database locks are necessary to ensure data integrity, they must be managed to prevent unnecessary data-access blocking. Lock Manager helps identify troublesome locking situations and provides a graphical display which includes details such as the locking user, lock type, object locked, and mode held and mode requested. Sessions blocking and waiting are displayed in a graphical tree view for easy analysis. If necessary, locked sessions can be terminated by Lock Manager's "kill session" feature.
Some of the most commonly used monitoring and diagnostics charts are accessible directly from the Oracle Enterprise Manager Console. For example, you can select a database in the Navigator window and use the right mouse menu, tool menu, or diagnostics tool drawer to launch a Performance Overview chart for the database. Similarly, you can also launch a Lock Monitor chart directly from the console to immediately diagnose lock contention problems.
Performance problems detected by Oracle Performance Manager can be corrected using other tools in the Oracle Diagnostics Pack, as well as tools in the Oracle Tuning Pack, Change Management Pack, and DBA Management Pack.
Oracle Capacity Planner is a tool for collecting, storing, and analyzing historical performance data collected from Oracle databases, non-Oracle databases (such as SQL Server) and the host operating system, enabling you to plan for future resource needs. This data is collected by a data collection service, which is an extension of the Intelligent Agent that resides on the managed node containing the database.
With Oracle Capacity Planner, you first specify the type of performance data you want to collect, the interval of the collections, the load schedule, and the data management policy. Oracle Capacity Planner's in-depth analyses and reports allow you to then explore the data, format it into easy-to-use graphs and reports, and analyze the data to predict future resource needs.
While viewing real-time data in charts, you can also drill down to historical data and related tools. For example, while looking at a chart showing current file I/O, you might notice that one disk is more active than expected. By right-mouse clicking the chart, you can view the past I/O for that disk. The data is presented in an easy-to-read chart, allowing you to see trends or pinpoint times of unusual activity. You can also view maximum, minimum, and average values overlaid on the data.
Oracle Capacity Planner also allows you to connect to the historical database and view the performance metrics available for each node and service. Capacity Planner includes pre-defined performance metrics which are categorized into categories of available types of database and operating system statistics, such as CPU usage, file I/O, and "top" sessions (the most resource-intensive sessions at a given point in time). These pre-defined sets make it easy to find the performance metrics that you wish to collect. You can also define your own customized statistics to collect.
Browsing a tree listing or navigator in the historical database, you select the node or database of interest and the specific type of performance data for viewing. Oracle Capacity Planner then displays the data in easy-to-read graphs or tables, allowing you to build in-depth reports to chronicle the performance of your system over time.
In addition to helping you browse historical performance data, Oracle Capacity Planner helps you interpret the data by taking any performance metric and extrapolating to a point in the future. For instance, you can extrapolate to a particular value (e.g. when will my disk be 75% full?) or to a point in time (e.g. how full will my disk be on November 1, 2001?). The extrapolation analyses are plotted on graphs, making them easy to interpret and add to a report if desired.
Oracle TopSessions provides the ability to pinpoint database sessions causing the greatest impact on performance. The top "N" sessions can be identified in real time based upon performance impact factors such as resource usage, open cursors, user transactions, and block changes.
Once a problem session is identified, Oracle TopSessions can be used to drill down into the session to examine detailed statistics on session activity such as cache processing, redo activity, SQL processing, and lock contention. Selected SQL statements and explain plans can then be displayed for analysis. Oracle TopSessions also allows the database administrator to take action by easily terminating problem sessions.
Most data used in performance monitoring applications is collected based on sampling techniques collected at pre-set intervals regardless of the activity of the system being monitored. While efficient, statistically valid, and ideal for many performance monitoring applications, data samples collected at pre-set intervals are not suitable for applications that require precise data. Applications requiring precise data need Oracle Trace, which collects data for each and every key occurrence in a product being monitored, providing an entire census of occurrence data rather than a sample of data. Collecting data for each and every occurrence allows performance problems detected through sampling techniques to be pinpointed to specific occurrences of a software product's execution.
Oracle Trace is a flexible, highly efficient tracing mechanism for collecting precise database occurrence statistics from Oracle products as well as end-user and third-party applications. Oracle Trace includes an open API (Application Program Interface) which is used to monitor occurrences in any software product.
Software products that are recognized by Oracle Trace during occurrence-based data collection are programmed with Oracle Trace API calls. When a specific occurrence occurs on an API-instrumented application during a scheduled Trace collection, the occurrence invokes an Oracle Trace API call. Oracle Trace recognizes the occurrence and collects the data.
Information collected by Oracle Trace can include:
Oracle Trace Manager is a tool for administering Oracle Trace data collected from API-instrumented products. Oracle Trace Manager runs on the Oracle Enterprise Manager Console and uses Intelligent Agents to search Oracle directories on managed nodes for products using the Oracle Trace API. Once discovered, the products and their nodes are displayed for the user in the Oracle Trace navigator for collection scheduling with the Job Scheduling System.
Data collected in Oracle Trace Manager typically are large volumes of valuable information that can be used for troubleshooting and tuning products, but can also be unwieldy to process and sort. Oracle Trace Data Viewer is a tool that sorts and processes large Oracle Trace data collections, extracting and aggregating key metrics, and presenting the information in pre-defined data views selected by the user who can then perform analysis on the data.
When you select a data view, the Oracle Trace Data Viewer automatically locates and presents the collection for processing and presentation. You can also drill down as needed into the view to get additional details about the data. Examples of pre-defined data views include Average Elapsed Time per SQL statement, Logical Reads to Rows Processed Ratio, and Rows Fetched to Fetch Count Ratio. You can also define your own data views using a convenient wizard.
The Oracle Tuning Pack optimizes performance in the database environment by identifying and tuning major database and application bottlenecks such as inefficient SQL, poor database structures, and improper use of resources. Oracle Tuning Pack's advanced tools focus on tuning the highest-impact database performance areas, such as:
Oracle Tuning Pack optimizes database performance by helping the database administrator to collect, evaluate, and implement tuning changes that impact database performance.
Oracle Tuning Pack includes the following applications that cover the complete spectrum of Oracle tuning:
An essential follow-through to performance monitoring is database tuning. Database tuning ensures that you are getting maximum database performance and maximum use of the system resources supporting your database.
However, because the nature of database tuning is complex, time-consuming, and requires specialized skills and adherence to a structured methodology, database tuning is often dealt with only when unpredictable problems arise instead of on a consistent basis.
Oracle Tuning Pack meets the need of consistent database tuning by providing an automated performance tuning application, Oracle Expert. Oracle Expert can be used on a periodic, proactive basis to discover Oracle tuning opportunities and to create scripts to correct any problems that have been identified.
Oracle Expert provides flexible and focused tuning in three categories:
After collecting tuning data, Oracle Expert stores the data and any other information supplied by the user into the Oracle Expert repository for analysis by the rules inference engine. The patented object-oriented rules inference engine is designed to perform complex database tuning analysis and contains hundreds of rules for tuning an Oracle database. Oracle Expert then evaluates this data, looking for tuning opportunities and produces a set of recommendations for tuning improvements listed in the order of performance gain impact.
If the user accepts Oracle Expert's tuning recommendation, a script is generated to implement the recommendation. Many of the scripts can be implemented immediately or customized by the user. A detailed report of the collected data and the analysis process can also be created on request by the user.
Oracle Expert can also share tuning data with Oracle SQL Analyze, which is another tool in the Oracle Tuning Pack (discussed below). This shared data is stored in Oracle Tuning Pack's SQL History, which stores all data gathered by Oracle Expert and Oracle SQL Analyze. By sharing tuning data, Oracle Expert and Oracle SQL Analyze do not need to gather system data that has already been gathered and stored in SQL History.
Missing or inappropriate indexes can often cause serious performance problems for an application. To quickly identify and correct index problems, the Oracle Tuning Pack includes a wizard to guide you step-by-step through the process of tuning indexes. The wizard uses the analyzing capabilities and intelligence built into the Oracle Tuning Pack to both recommend optimal indexing strategies and to implement the tuning recommendations.
Inefficient SQL statements can cause database performance problems in even the best-tuned databases. To complement the database tuning features of Oracle Expert, the Oracle Tuning pack provides Oracle SQL Analyze, an application for analyzing and tuning individual SQL statements.
Oracle SQL Analyze provides a workbench for identifying and tuning problematic SQL statements which are causing the greatest impact on database performance. SQL Analyze identifies the SQL statements executing on the database and evaluates the statements based on user-selected criteria, such as resource usage and I/O's per statement. Once a problem SQL statement is identified, it can be dragged and dropped from the database library cache to the SQL Analyze tuning window for evaluation and tuning.
Under one of two optimizer modes - cost-based or rule-based - Oracle SQL Analyze examines the SQL statement to determine what the optimal execution path for the statement would be. For statements retrieving data from multiple tables, the optimizer figures out the optimal table join methods, join orders, and access paths based on such factors as available indexes, the order of tables and columns in the statement, and statistics on the cardinality of objects referenced in the statement.
When using the cost-based optimizer to control the execution plan, the user can use SQL "hints". The use of SQL hints can be valuable for specific queries where the developer is aware of details that may not be available to the optimizer.
The SQL statement's execution path is displayed through an explain plan which provides a list of the operations involved in the statement's execution. After generating one or more explain plans for a SQL statement, you can use SQL Analyze to examine the plan, the order of operations, and relevant statistics for objects used in the plan.
Because explain plans can be confusing to interpret, (the hierarchical order of operations listed in the explain plan is not the order of execution) SQL Analyze makes the execution order clear by providing a graphical step-by-step explanation of the statement's operations which the user can walk through. With this step-by-step explanation, the user can see how the statement will execute and what step each operation is performing.
After the explain plan is reviewed and interpreted, the next step is testing the performance of the statement under various optimizer modes. SQL Analyze allows you to easily execute the statement one or more times to measure performance, such as the elapsed time that it takes to perform the query, the CPU time, and the number of logical and physical reads. SQL Analyze also takes advantage of the new query progress monitoring capability of Oracle8i, allowing you to track the progress of a SQL statement executed from SQL Analyze.
All SQL metrics can be displayed for comparison by highlighting the desired SQL object in the navigator. When you select a SQL object, a table of performance metrics for each comparison is displayed for each optimizer. SQL Analyze also provides "split view" screen options which allow side-by-side comparison of two different SQL statements, or two different optimizer modes for the same statement. Comparing explain plans and performance statistics throughout the tuning cycle allows the user to quickly gauge the relative performance of several different approaches for obtaining the same result set.
Getting the best performance from a database's application SQL requires more than tuning individual SQL statements; it also requires identifying database storage problems. To meet these needs, the Oracle Tuning Pack includes Oracle Tablespace Map, a tool for monitoring tablespace usage.
The Tablespace Map provides a complete picture of the characteristics of all tablespaces associated with a particular Oracle database. These characteristics include analysis status, segment type, segment name, number of extents, and the total size of the extent in blocks. You can display all segments for a tablespace or all segments for a datafile.
The Tablespace Map also provides an allocation map which illustrates the organization of a tablespace's segments. This map displays an overview of the sequential allocation of space for segment extents within a selected tablespace or datafile. Within the tablespace map, it is possible to select an individual extent and see the ID of the block in the extent, the ID of the extent, and the full name and path of the datafile which is the physical location of the extent.
To correct database storage problems, Oracle Tuning Pack provides the Reorg Wizard, which can help you maintain a well performing database by correcting space usage problems. Over time, database performance can be affected by problems such as row chaining and/or migration and index stagnation. The Reorg Wizard can eliminate space problems by reorganizing database space usage and allowing you to change an object's storage settings and location.
An important task of database administrators is preparing for and reacting to change. Because business needs and requirements can change quickly, adjustments and enhancements are often required for business applications and their supporting databases. DBAs need the ability to respond to these changes quickly and effectively.
Oracle Change Management Pack is a set of easy-to-use tools for managing complex changes in the Oracle Server and database objects. While tracking and implementing changes has typically been a very expensive and difficult process, Oracle Change Management Pack greatly reduces the time and costs associated with managing the implications of changing business needs and requirements.
Managing change in an Oracle environment can mean managing the evolution of schema objects and the database environment. Changes to applications can require changes in the definitions of particular objects like tables or triggers. Over the lifetime of a database, changes may need to be made to the characteristics of a tablespace or a set of users. Oracle Change Management Pack can manage all of these types of changes.
With Oracle Change Management Pack, you can track changes by capturing the definitions of a set of database objects and comparing the object definitions in one schema or database to another. You can also compare object definitions in a schema or database to a previously-captured state (baseline) of the same schema or database - or compare two baselines.
Change Management Pack also keeps track of versions of baselines, comparisons, and changes. For example, you could capture repeated versions of a baseline for keeping track of an evolving schema like a meta-data backup.
In addition to tracking changes, Oracle Change Management Pack allows you to implement changes. After comparing two sets of object definitions, you can implement changes by synchronizing database definitions with those of a baseline or another database; or you can create one or more object definitions on multiple databases that are copies of the definitions in another database. You can also change object definitions by simply specifying the changes to make.
To make changes, Oracle Change Management Pack generates scripts that are run against database object definitions. When a script is generated, you have the ability to view and edit the script, execute it whenever you like or schedule a time for the script to be executed, and optionally to roll back the changes. Oracle Change Management Pack also provides an impact report which the administrator can evaluate before making the changes.
In the following section, some of the major capabilities of Oracle Change Management Pack are described.
Change Manager is a central application for managing your work in Oracle Change Management Pack. The tree view on the left of the application's interface displays baselines, comparisons, and plans. With the detail view on the right, you can launch other wizards and tools.
The following functionality can be accessed from Change Manager:
DB Capture is a wizard that guides you through the process of capturing the definitions of a database (or subset of a database) in the form of a baseline for other Change Management Pack applications to use. The captured definitions can also be stored in a SQL DDL statement for creating definitions in a new database or as input to CASE tools that accept SQL DDL input.
For example, DB Capture could capture a baseline of the current state of object, schema, or database definitions, then use DB Diff later to compare the baseline to the same object, schema, or database definition.
DB Diff is a wizard that guides you through the steps of selecting two sets of object definitions and comparing them. The object definitions can be from current databases or from a baseline created earlier with DB Capture. The comparisons can be saved and also written to a report.
You can also use DB Diff's Synchronization Wizard to modify one set of definitions to match the other set of definitions (with the exception of baselines, which are read-only).
For example, DB Diff's Synchronization Wizard could be used to synchronize the current schema or database with a previously captured baseline of the schema or database. The resulting effect would be that any changes made to the schema or database since the baseline was captured are rolled back.
DB Quick Change guides you through the process of making one or more changes (a "quick change") to a single definition of a database object. Multiple changes can be executed as a unit.
DB Alter guides you through the process of making changes to one or more object definitions in one or more databases. Multiple changes in a database are executed as a unit.
DB Propagate guides you through the steps of selecting one or more object definitions from a database, then reproducing those definitions in a destination schema within the source database, or in one or more destination databases.
DB Propagate simplifies such tasks as:
DB Search is a search capability for specifying or locating objects based on characteristics of their names. For example, if you know that all your test tables contain the string "TEST", and you need to know how many test tables you have, you can search for all tables or objects with names containing that string. DB Search can be used on its own as a search facility, or with other applications in the pack. For example, DB Search can be used when using DB Capture for specifying that your baseline contain all objects with names containing the string "TEST".
Plan Manager lets you view, edit, and execute plans that you have created in Oracle Change Management Pack.
By using Oracle Change Management Pack to manage change, administrators can respond quickly to new requirements, eliminate errors or loss of data when making changes, minimize downtime, and maximize productivity.
Oracle Standard Management Pack is a management pack designed for smaller enterprises that use the Oracle Workgroup Server or Oracle 8i. This pack combines many of the diagnostic, tuning, and change management functionalities of Oracle Diagnostics Pack, Oracle Tuning Pack, and Oracle Change Management Pack into one easy-to-use application suitable for the smaller business enterprise. Oracle Standard Management Pack monitors and diagnoses problems, tunes high impact indexes, and tracks and compares changes in the Oracle environment.
Oracle Standard Management Pack is comprised of the following applications for managing the Oracle Environment:
The Oracle Management Pack for Oracle Applications is a set of advanced tools for monitoring and diagnosing your Oracle Applications environment and planning for future resource needs. The pack extends the existing database management capabilities of Oracle Enterprise Manager to the middle-tier application subsystem of Oracle Applications, namely the Concurrent Processing Servers. The pack builds on the Oracle Enterprise Manager host and database management framework and incorporates Oracle Applications within its managed services.
The Management Pack for Oracle Applications includes the following diagnostic applications for optimum Oracle Applications management:
The Management Pack for Oracle Applications displays Concurrent Processing Servers on the Oracle Enterprise Manager Console. The console provides central administration of a distributed application system, allowing administrators to notify each other if any of the servers go down, and schedule jobs and monitor events on the application subsystems.
Oracle Management Pack for SAP R/3 is a set of applications for monitoring, diagnosing, and planning in the SAP R/3 environment. This pack extends the advanced tools in Oracle Enterprise Manager for monitoring the SAP R/3 environment, diagnosing problems, and planning for future needs.
The Management Pack for SAP R/3 builds on the Oracle Enterprise Manager host and database management framework, and manages the SAP R/3 system as one of its managed services. The pack displays R/3 application servers in the navigator and map views. Jobs and events, including Management Pack for SAP R/3 Advanced Events, are similarly integrated.
Oracle Management Pack for SAP R/3 contains the following applications:
Oracle Performance Manager - This tool recognizes multiple instances of R/3 and displays real-time data of R/3 application servers, buffers, and work processes in an easy-to-interpret, consolidated graphical view.
Oracle Capacity Planner - This tool collects R/3 metrics and diagnoses problems through correlation and trending of the collected information to determine future resource requirements.
Oracle Advanced Events - This extension to the Oracle Enterprise Manager event management system allows lights-out event monitoring and problem detection of the entire R/3 applications system.
The applications listed below are integrated with Oracle Enterprise Manager for added value in managing your Oracle environment, and are installed with Oracle Enterprise Manager if your environment requires them. The applications can be accessed from the Oracle Enterprise Manager Navigator pane and/or the console application drawers, or from your operating system. (An asterisk indicates that the current release of the product is beta.)
Oracle Applications Manager is a tool that provides administrative and diagnostic capabilities for concurrent processing in Oracle Applications. The Oracle Applications Manager console provides a single point of administration for concurrent managers and requests on multiple Oracle Applications instances.
Using the console, you can monitor the status of all concurrent managers in an Oracle Applications instance, as well as details for all processes and requests. You can start and stop managers, cancel or put holds on requests that have not yet run, and define new managers.
Oracle Enterprise Security Manager is a component of the Oracle Advanced Security Option and manages Oracle 8i Enterprise User Security. The application allows administrators to manage enterprise-level role authorization among multiple databases simultaneously.
Enterprise Users are created and centrally managed in an LDAP Directory Server. They use digital certificates and Secure Sockets Layer (SSL) to achieve Single Sign-On to multiple Oracle8i Database Servers. Upon authenticating an Enterprise User, Oracle 8i will search for its role authorizations in the Directory. Such role authorizations are known as, "Enterprise Roles".
Enterprise Security Manager allows multiple administrators to define "Enterprise Domains" of servers that share a common set of Enterprise Roles. The tool also allows administrators to create Enterprise Users and then manage their Enterprise Roles within these domains. All information on Enterprise Domains, Databases, Enterprise Roles, and Enterprise Users is stored securely in a Directory, for example Oracle Internet Directory.
The Oracle8i interMedia Text application (the text-management component of the Oracle interMedia product) is a text-search system for managing and searching for text in the Oracle database. This application helps you manage and search for text in the database as quickly and easily as any other type of data. Oracle interMedia Text's search techniques make text a standard datatype in the Oracle server which you can create, modify, and delete. Additionally, with Oracle8i interMedia text, new text-based developments or extensions to existing applications are easy and cost-effective to build with standard SQL tools.
With Oracle8i interMedia Text, you can search for data in any Oracle database application that uses text - from search-enabling a comments field in an existing application to implementing large-scale document management systems dealing with multiple document formats and complex search criteria. Oracle8i interMedia Text also supports basic full-text searches in most languages supported by the Oracle database.
Oracle8i interMedia Text allows the database administrator to create and manage interMedia Text indexes used for text querying. Text servers, which poll for new documents not yet indexed can also be started when connecting to a database through the Oracle Management Server.
Oracle Parallel Server Management enables the administration of databases that use the Oracle Parallel Server option. Once discovered, Parallel Server Databases appear in the Databases folder of the console's navigator panel alongside single-instance databases.
Parallel Servers behave similarly to single-instance databases, allowing the full power of the Schema, Security and Storage applications to be applied to parallel server databases. The database adminstrator can start up, shut down, or check the status of parallel server databases, as well as see the status of parallel servers and the progress of parallel server operations by node and service.
Parallel server startup and shutdown job tasks allow parallel servers to be started and stopped as part of scheduled jobs. Database job tasks, such as Run DBA Script, can be executed on parallel server instances. All database event tests can be registered on parallel server instances.
Oracle Replication Manager enables an administrator to quickly set up, configure, and manage an Oracle Replication environment. Specifically, Replication Manager provides a comprehensive wizard to prepare a database for supporting multimaster and/or snapshot replication. Once set up, additional wizards help you replicate schema objects using either multimaster or a combination of multimaster/snapshot replication. After you have configured your replication environment, you can use the Oracle Enterprise Manager Navigator tree and property pages to monitor and modify your replication environment.
Oracle Spatial Index Advisor helps you analyze and tune spatial indexes on data. Using this application, you can analyze the effectiveness of spatial indexes defined on spatial data. The Advisor lets you see if indexes are properly defined for optimum query performance. The application also provides an understanding of the distribution of data through visual inspection.
A spatial index is a set of database tiles. With Oracle Spatial Index Advisor, the database administrator specifies the size and number of tiles in a database. The geometric coverage of the tiles has a direct impact on query performance. The Advisor allows the user to see the interaction of the tiles with the geometric coverage and to issue queries against the data to see how typical queries will perform.
Oracle Directory Manager is a Java-based tool for administering most functional areas of Oracle Internet Directory and its related processes. Using Oracle Directory Manager, you can connect to directory servers; manage configuration parameters; add, modify, and delete entries, attributes, and object classes; set up access control policies; configure security; and view and modify replication agreements.
Oracle Distributed Access Manager is a tool for monitoring and administering Oracle's heterogeneous distributed environments. Non-Oracle systems, such as Sybase, Informix, DB2, and SQL Server are transparently integrated into an Oracle distributed environment using Oracle's transparent gateway technology (i.e., Heterogeneous Services).
Distributed Access Manager monitors gateways configured for non-Oracle systems. It displays all the gateway instances that have been registered with the database to which the tool is connected. For active gateway instances the user can browse the details of each gateway session.
For each active gateway session, Distributed Access Manager provides the name of the Oracle client session that created the gateway connection, the name and location of the gateway process, and the list of gateway initialization parameters used to modify the gateway behavior.
Oracle Developer Server Forms Manager allows you to control and monitor Forms Listener, Forms Server, Load Balancer Server, and Load Balancer Client. The tool provides the following functionality:
Oracle Applications Server Manager helps you manage your web site and the Oracle Applications Server. This tool discovers all Oracle Appliction Servers installed on managed nodes and allows you to view and manipulate the components and features of the server and your web site.
Oracle Applications Server is the middle tier in a three tier web server. The client tier is a generic browser such as Netscape or Internet Explorer, the middle tier is the Oracle Applications Server, and the third tier is usually a dedicated database. The middle tier Oracle Applications Server handles communication with all the clients. It can also execute custom application logic that accesses and/or manipulates database data and displays it to the client in the desired format.
|
![]() Copyright © 2000 Oracle Corporation. All Rights Reserved. |
|