|Oracle Enterprise Manager Concepts Guide
Part Number A88770-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.
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.
In order to use e-Business Management tools for Oracle Enterprise Manager, your system must have the capability to manage Apache and iAS web servers with basic events and limited monitoring and reporting functionality.
The Oracle Diagnostics Pack contains the following applications:
In addition to the basic UpDown event tests provided for all targets administered in the Enterprise Manager Console, the Diagnostics Pack provides a library of advanced event tests to automatically detect excessive resource use, performance degradation, and other problem situations.
The key to a smooth running system is to resolve problems before they turn into crises. These advanced event tests allow you to focus on the causes of a problem before the symptoms become serious. In addition, with the paging and e-mail support provided by Enterprise Manager, you can be notified of any problems with the system wherever you happen to be.
The Event System within Oracle Enterprise Manager assists the DBA with automatic problem detection and correction. Using the Event System, the DBA can establish boundary thresholds for warnings and critical conditions within the network environment for problem monitoring.
The Enterprise Manager base product comes with a set of event tests called base event tests. These event tests consist of UpDown event tests that check whether a database, listener, or node is available. More comprehensive monitoring is available through Advanced Event Tests. These event tests are packaged with the Oracle Diagnostics Pack and are classified under the following categories:
The Oracle Advanced Event Tests for the database target type are grouped into the following categories:
The UpDown Listener Event Test checks whether the listener on the node being monitored is available. The Startup Listener job task can be set up as a fixit job for automatically correcting the problem.
This test checks whether the Microsoft SQL Server being monitored is running.
The node event tests include the following categories with several different event tests in each area:
The Oracle e-Business Management Tools Advanced Event tests are provided for lights-out event monitoring and problem detection of the HTTP Server.
Oracle Performance Manager is an Oracle Enterprise Manager application that allows you to monitor the performance of the database and its related applications and operating systems in real time. It allows system and database administrators to monitor performance statistics for Oracle database servers, web servers, Oracle concurrent managers, operating systems, and other managed targets. Performance Manager also allows you to record statistics and play them back at a later time.
You can display these statistics in a number of formats including horizontal and vertical tables, strip charts, horizontal and vertical bar charts, and pie charts. You can also drill down for more detail on some predefined charts.
Since Performance Manager is integrated with Oracle Capacity Planner, you can also drill down to an historical view of the displayed data. The drilldown to historical data allows you to quickly compare the current real time value with the historical average to provide you with a better understanding of the meaning of the current value.
Performance Manager integrates Event system thresholds with charts so that events and charts share common performance thresholds you can set from either monitoring point. This provides consistent monitoring of thresholds across Enterprise Manager and allows access to graphical and historical diagnostics information from the Event system. You can investigate event notifications by launching charts, historical data and diagnostic advice directly from the Event Viewer. Performance Manager charts incorporate event notification through chart threshold state indicators.
You can use activity diagnostic charts such as TopSessions for finding and troubleshooting high impact sessions. These charts provide graphical performance data to help you diagnose a problem session or SQL statement.
The same data collection mechanism used by Performance Manager to sample real-time data is also used to collect historical performance and resource consumption data. The Diagnostics Pack uses Capacity Planner to analyze performance data to help you diagnose problems using historical information and project your future capacity needs.
In Performance Manager, historical data can be gathered for the targets you monitor. The collection can be customized, allowing you to select any subset of statistics to collect and the interval at which these statistics should be sampled. The data collection mechanism provides roll up capabilities, where data is automatically aggregated at the end of each hour, day, week, or month. This data collection mechanism also allows you to set up data expiration policies so you can fully control the amount of storage needed for the historical data.
Once the data is gathered, you can use Capacity Planner to chart the historical data for the purposes of identifying trends and predicting future hardware requirements for the system. You can also extrapolate to a particular point in time or work back from a particular target value and find when a specific level of usage is expected to occur. These charts can be customized, allowing you to get the data you need and to view data from multiple sources (for example, CPU and disk) on a single, unified chart.
You can also publish historical data to a website where administrators and system administrators can view data that is periodically updated.
You can use Performance Manager to assist you in identifying performance bottlenecks within your system and database environment. The TopSessions chart displays database sessions that are contributing most heavily to database activity.You can display various details for these sessions, including the SQL statements, and resource usage.
You can obtain an overview of session activity by displaying the top sessions sorted by a statistic of your choosing. For any given session you can then drill down for more detail, or if you choose, you can terminate the session using the Kill Session option.
The TopSessions chart provides a methodology for identifying and correcting certain database performance problems. For example, when sudden file I/O load is detected, you can first identify the sessions contributing most to the problem and then isolate the executing SQL statements in user applications for those sessions. You can then analyze the SQL explain plans for those SQL statements to determine how best to resolve the problem.
Once populated with data, the TopSessions chart includes a multi-column list of summary information for each session connected to the database instance or for each of the top n sessions as measured by the selected sort statistic.
You can also access the TopSessions chart from the Enterprise Manager console by selecting TopSessions from the Diagnostics Pack tool drawer. You can access information about individual sessions via drill downs from this chart.
Trace is a general-purpose tracing mechanism that collects data for any software product enabled with Trace Application Programming Interface (API) calls, such as the Oracle server. You can use Trace to collect a wide variety of data, such as performance statistics, diagnostic data, system resource usage, and business transaction details.
Data Viewer allows you to view formatted data collected by Trace. Data Viewer handles the complex task of extracting data and aggregating key server performance metrics on a large Trace collection. Once you select a Trace collection, you can have Data Viewer compute SQL or Wait statistics or both.
The Oracle e-Business Management Tools (hereafter referred to as e-Business Tools) are a set of applications that enable centralized management of the complete e-Business infrastructure including the client, middle-tier HTTP servers, and database. The e-Business Tools provide a seamless monitoring, reporting, and diagnostics of the e-Business middle-tier HTTP servers.
The following HTTP servers are supported in Enterprise Manager release 9.0.1:
Release 9.0.1 of the e-Business Tools focuses on operational management which includes the reporting on, and the monitoring of the HTTP servers. All the components are controlled from and fully integrated into the Enterprise Manager Console.
The monitoring features of the HTTP servers include:
HTTP server targets are recognized on all nodes in the system. The supported HTTP server targets are the Apache HTTP server and the Oracle iAS HTTP Listener. The Startup/Shutdown of the HTTP is automated.
The middle-tier HTTP server I/O and HTTP server processes are monitored in real time. The e-Business Tools advanced event tests are provided for lights-out event monitoring and problem detection of the HTTP server. The two types of event tests associated with the HTTP server are UpDown event test and Threshold event tests. The HTTP Server UpDown event test checks whether the Apache HTTP server being monitored is running. The threshold event tests are triggered by user-specified metrics.
Basic events include threshold and up/down events.
Events can be customized to track the status of any monitored metric.
The Apache Server Access Log Traffic report provides an overview of the daily, weekly, and monthly statistics of activity on the HTTP server. Data for this report is extracted from the Apache server log files and is viewed in HTML format.
The Apache server log files can be configured by the administrator to determine their refresh rate. The amount of data displayed in the report is dependent upon the amount of data in the log files.
The Log Analysis Report job task analyzes the access log file for the HTTP server target and generates a report. The output is an HTML file that contains various statistics.
This section describes the HTTP Server charts and chart groups available in Oracle Performance Manager. Some of these charts provide the ability to perform administrative tasks, for example, server utilization.
The HTTP Server charts are divided into classes. The classes are:
The Performance Overview class provides chart groups that describe high-level activity.
The I/O class provides charts that describe I/O activity.
The Server Utilization class provides charts that describe server activity.
The Oracle Tuning Pack contains seven applications to help users tune all aspects of their database environment; from identifying and correcting problem SQL statements to adjusting the instance parameters for the database.
The Oracle Tuning Pack enables users to proactively tune their database environment. The applications within the Oracle Tuning Pack can be used to:
Oracle Tuning Pack includes the following applications that cover the complete spectrum of Oracle tuning:
Oracle Expert is a software tool for optimizing the performance of your database environment. Oracle Expert assists with the initial configuration of a database and with the collection and evaluation of performance characteristics of existing databases.
Oracle Expert automates the process of collecting and analyzing performance tuning data and provides expert database tuning recommendations. Additionally, Oracle Expert generates scripts that assist with the implementation of tuning recommendations.
Oracle Expert provides many advantages. Oracle Expert:
Oracle Expert also serves as:
The Oracle Index Tuning wizard is a software application that identifies tables with inefficient indexes and makes recommendations which will improve access to those tables.
The Index Tuning wizard:
The Index Tuning wizard is intended for use with the Oracle cost-based optimizer. The recommendations made by the Index Tuning wizard will optimize index usage for the Oracle cost-based optimizer. Therefore, you should not use the Index Tuning wizard for those schemas where rule-based optimization is used.
You can use the Index Tuning wizard to proactively maintain optimal indexes for your database. You should run the Index Tuning wizard regularly to evaluate whether index changes should be made to improve SQL query performance. The Index Tuning wizard may recommend adding new indexes, changing existing indexes, or changing the type of an index.
You should also use the Index Tuning wizard when one of the following situations occurs:
Any of these factors may impact the indexing decisions for the database.
One of the primary benefits of the SQL language is its flexibility; you can achieve the same result by taking any of a number of different approaches. Although each approach might return the same result, performance varies dramatically depending on the database environment, structure of indexes and the access paths chosen by the Oracle optimizer.
While efficient SQL statements can help maintain peak database performance, inefficient statements can cause slow performance. In many cases, tuning your SQL statements can increase overall performance by 100% or more.
Tuning SQL, however, has not been easy in the past. It involves collecting and analyzing information, and requires expert knowledge and experience. Tuning a SQL statement requires:
Oracle SQL Analyze provides you with the tools to collect information about the database environment and schema objects, analyze SQL performance, identify and compare different optimizer approaches, and edit SQL statements for optimal performance--in some cases, automatically.
Benefits of Oracle SQL Analyze are listed below:
Oracle SQL Analyze in 9i introduces two new features that enhance the information you can use to tune your databases, and help automate the tuning process:
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 segment name, the ID of the block in the extent, the ID of the extent, the size (in blocks) of the extent, and the full name and path of the datafile which is the physical location of the extent.
Another key feature of the Tablespace Map is the Tablespace Analysis tool. A Tablespace Analysis can detect potential space management problems. Once a Tablespace Analysis has been performed, a Tablespace Analysis report is created and provides a detailed listing of any detected problems and marks the problematic segments with a warning or alert flag.
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.
The Reorg Wizard gives you three reorganization options:
The wizard performs reorganizations within the Oracle database and does not use external data handling operations. Reorganizations can be performed within the target tablespace or by temporarily using space in another tablespace.
The Reorg Wizard evaluates the reorganization operations and generates an Impact Report and reorganization script, which can be reviewed prior to execution.
Reorganizations can be performed immediately or can be scheduled at a later time, perhaps during off-peak hours. In either case, the reorganization will be run by an Enterprise Manager job using the Oracle Intelligent Agent.
The Enterprise Manager Console, Oracle Management Server and Agent are required to perform reorganizations with the Reorg Wizard. The Agent must be running on the same node as the database being reorganized.
Certain database reorganization operations can be time-consuming and will impact the availability of objects being reorganized. Use database object reorganization selectively. For example, tablespace reorganizations can often be avoided by reorganizing only selected tables and indexes.
The Outline Management is an advanced Oracle9i application that allows you to manage stored outlines directly using a GUI-based tool. Specifically you can browse, sort, delete, and edit outlines with this tool. The tool uses the editing and management features of Oracle's plan stability functionality. Plan stability prevents certain database environment changes from affecting the performance characteristics of applications. Such changes include changes in optimizer statistics, changes to the optimizer mode settings, and changes to parameters affecting the sizes of memory structures, such as SORT_AREA_SIZE and BITMAP_MERGE_AREA_SIZE. Plan stability is most useful when you cannot risk any performance changes in an application.
Plan stability preserves execution plans in stored outlines. Oracle can create a public or private stored outline for one or all SQL statements. The optimizer then generates equivalent execution plans from the outlines when you enable the use of stored outlines. You can group outlines into categories and control which category of outlines Oracle uses to simplify outline administration and deployment.
The plans Oracle maintains in stored outlines remain consistent despite changes to your system's configuration or statistics. Using stored outlines also stabilizes the generated execution plan if the optimizer changes in subsequent Oracle releases.
Plan stability also facilitates migration from the rule-based optimizer to the cost-based optimizer when you upgrade to a new Oracle release.
Outline Editor is an advanced Oracle9i application that allows the user to control the optimizer behavior by modifying the optimizer mode, join order, or index usage without having to change the statement in the application code.
When you create an outline, hints are added to the database which are used by the optimizer when executing the SQL statement. The outline affects the execution plan of the SQL text because the optimizer uses the hints stored in the outline to execute the SQL. The Outline Editor application window shows the SQL text of the outline and the graphical layout of the outline's execution plan. The execution plan is the set of steps Oracle uses to execute a statement and includes the access method for each table that the statement accesses, the join methods used, and an ordering of the tables (the join order.)
With the Outline Editor, you can change the outline's join order (simply select an outline step from the graphical display and drag it to another location), access methods, and other outline properties to optimize its performance. Note that changes to an outline may result in invalid hints to the optimizer. The optimizer may revert your changes if the changes are unacceptable. It is important to note that these changes will not be applied to the outline until the changes have been validated. It is also important to note that these changes will not be available to other users until the outline has been saved. You will not see the updated outline in Outline Management until the outline has been saved with a unique name and Outline Management has been refreshed.
In addition to editing outlines with the Outline Editor, you can also create new outlines. The Outline Editor allows you to create an outline or create an outline that is like another outline.
The Oracle Change Management Pack is a group of integrated applications used to track and make changes to database object definitions. The Oracle Change Management Pack is a component of Oracle Enterprise Manager.
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:
The Create Baseline application guides you through the process of capturing a database (or a subset of a database) in a form that is readable by other Oracle Change Management Pack applications. Create Baseline lets you specify the set of database object definitions to capture, captures those definitions in their current state at the time of the capture operation, and displays the baseline in the Baseline Viewer.
Create Baseline can capture object definitions in both of the following forms:
The Baseline Viewer displays baselines created with Create Baseline. You can also use Baseline Viewer to generate a SQL DDL script for the baseline if you did not generate one when the baseline was captured.
The Compare Database Objects application guides you through the steps of selecting two sets of object definitions for a comparison. The object definitions can be selected from current database definitions or they can be selected from baselines created earlier with Create Baseline. Differences that are found between the two sets of object definitions are displayed in the Comparison Viewer.
The result of comparing two sets of object definitions using Compare Database Objects is called a comparison. You can view a comparison, name it, and save it in the Comparison Viewer. You can also generate a report in HTML format about the results of a comparison.
After two sets of object definitions have been compared, you can use the Synchronization Wizard to modify one set of definitions (with the exception of baselines, which are read-only and cannot be modified) to match the other set of definitions.
After two sets of object definitions have been compared and the comparison results are displayed in the Comparison Viewer, you can use the Synchronization Wizard to modify one set of definitions (with the exception of baselines, which are read-only and cannot be modified) to match the other set of definitions. For each selected object definition in the source, if an object definition of the same name and type already exists at the target database, the target object will be modified to match the source definition. If a selected object definition in the source does not exist at the target database, it will be created. The Synchronization Wizard does all the work of determining and ordering the individual steps that must be carried out to perform this requested synchronization, taking object definition dependencies into account.
The DB Quick Change application guides you through the process of making one or more changes to a single database object definition. You indicate changes to object definitions by directly manipulating their representation on property sheets similar to those in the Oracle Enterprise Manager Console. The DB Quick Change versions of these property sheets allow you to make some changes that cannot be made using the Console (for example, changing the name of a column in a table).
DB Quick Change does all the work of determining and ordering the individual steps that must be carried out to perform your requested operations, taking object definition dependencies into account.
The DB Alter application guides you through the process of making changes to one or more object definitions in one or more databases. You indicate changes to object definitions by directly manipulating their representation on property sheets similar to those in the Oracle Enterprise Manager Console. The DB Alter versions of these property sheets allow you to make some changes that cannot be made using the Console (for example, changing the name of a column in a table).
When you specify a group of changes to several database object definitions, DB Alter does all the work of determining and ordering the individual steps that must be carried out to perform your requested operations, taking object definition dependencies into account.
The specified changes can be applied at the source database and at other databases.
The DB Propagate application guides you through the steps of selecting one or more object definitions from a database, then reproducing those definitions in a target schema within the source database or in one or more target databases. For each selected object definition in the source database, if an object definition of the same name and type already exists at the target database, the target definition will be modified to match the source definition. If a selected object definition in the source database does not exist at the target database, it will be created.
DB Propagate does all the work of determining and ordering the individual steps that must be carried out to perform your requested operations, taking object definition dependencies into account.
The Plan Editor application allows you to create, modify, and deploy a single change plan. The change plan can modify or reproduce database object definitions in one or more databases.
You can also create change plans with Synchronization Wizard, DB Alter, DB Quick Change, and DB Propagate. However, these applications differ from Plan Editor because each of them is designed to create a change plan with specific types of change requests that make specific types of changes.
Plan Editor is a more flexible change plan tool. You can use Plan Editor to create and modify a change plan that includes any type of change request and which can make a wider variety of changes.
The other applications use components from the Plan Editor interface in a framework that guides you through the application's task. As you use the other Oracle Change Management Pack applications, you become familiar with the components that Plan Editor uses to accomplish different tasks.
Oracle Standard Management Pack is a management pack designed for smaller enterprises that use the Oracle Workgroup Server or Oracle9i. 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 targets.
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 targets. 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 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 can be 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.
Oracle Enterprise Security Manager is a component of the Oracle Advanced Security Option and manages Oracle9i 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 Oracle9i Database Servers. Upon authenticating an Enterprise User, Oracle9i 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 Oracle9i Text 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. Oracle9i Text's search techniques make text a standard datatype in the Oracle server which you can create, modify, and delete. Additionally, with Oracle9i text, new text-based developments or extensions to existing applications are easy and cost-effective to build with standard SQL tools.
With Oracle9i 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. Oracle9i Text also supports basic full-text searches in most languages supported by the Oracle database.
Oracle9i Text allows the database administrator to create and manage Oracle9i 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 Real Clusters Management enables the administration of databases that use the Oracle Real Clusters option. Once discovered, Real Clusters Databases appear in the Databases folder of the Console's navigator panel alongside single-instance databases.
Real Clusters behave similarly to single-instance databases, allowing the full power of the Schema, Security and Storage applications to be applied to Real Cluster databases. The database administrator can start up, shut down, or check the status of Real Cluster databases, as well as see the status of Real Clusters and the progress of Real Cluster operations by node and target.
Real Cluster startup and shutdown job tasks allow Real Clusters to be started and stopped as part of scheduled jobs. Database job tasks, such as Run DBA Script, can be executed on Real Cluster instances. All database event tests can be registered on Real Cluster instances.
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 Forms Server Manager allows you to control and monitor Forms Listener, Forms Server, Load Balancer Server, and Load Balancer Client. The tool provides the following functionality:
You can use Oracle Policy Manager to administer Oracle Label Security. The navigator tree lists policies, along with their labels, authorizations, and protected objects. The detail view shows a property sheet in which labels are specified.
See the online help for instructions on how to use this graphical user interface.
Oracle OLAP Services is an Oracle9i database installation option that provides tools for developing and deploying internet-based business intelligence applications. OLAP (Online Analytical Processing) products provide services that support complex statistical, mathematical, and financial calculations within a multidimensional data model.
Oracle OLAP Services consists of the following components:
For information on OLAP Services, see Oracle9i OLAP Services Concepts and Administration Guide. For information on Oracle's Java API for OLAP, see Oracle9i OLAP Services Developer's Guide to the Oracle OLAP API. For information on data warehousing, see Oracle9i Data Warehousing Guide.
The Cube Viewer is a tool within OLAP Management that enables you to browse the data associated with OLAP metadata. A cube is a logical organization of multidimensional data.
Oracle Net Manager is a graphical user interface tool that combines configuration abilities with Oracle Names component control to provide an integrated environment for configuring and managing Oracle Net. It can be used on either the client or server.
You can use Oracle Net Manager to configure the following network components:
If an Oracle Names server is configured, you can start, stop, tune, or gather statistics for it with Oracle Net Manager.
Oracle Data Guard Manager is an easy-to-use Oracle Enterprise Manager application. It provides the monitoring, control, and automation necessary to manage a Data Guard configuration, including the primary and standby databases, and the log transport and log apply services.
When you use Data Guard Manager to control and monitor configurations, you dramatically reduce the time and complexity required to implement standby database solutions.
Oracle 9i LogMiner is a relational utility that helps you analyze online or archived log files to evaluate all updates to a database. With LogMiner Viewer, you can easily