| Oracle Enterprise Manager Concepts Guide |  Library |
 Product |
 Contents |
 Index |
| Oracle Enterprise Manager Concepts Guide | Library |
Product |
Contents |
Index |
This chapter covers the following topics:
The main window displays a multi-column list that includes a row for each current lock in the database. The information displayed in the columns includes:
Provision of only high-level monitoring statistics is insufficient for meaningful performance tuning. Ideally, you should be able to gather the specific detailed information you need to tune and adjust a database system. Oracle Performance Monitor provides that function. You can
In addition to these useful monitoring capabilities, Oracle TopSessions 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.
To find out more about a given tablespace or datafile, you can drill down to display how storage has been allocated for its segments. Clicking on a segment in a segment list displays the extents in the tablespace or datafile storing data for that segment. Should data storage for a segment be fragmented, you can defragment it. You can also use the coalescing feature of Oracle Tablespace Manager to join adjacent free blocks.
Two Oracle Corporation products are currently enabled for Oracle Trace collection:
Oracle Trace provides a graphical Oracle Trace Manager application to create, schedule, and administer Oracle Trace collections for host products containing the Oracle Trace API. You can store data collected by Oracle Trace in Oracle database tables for access by SQL reporting tools and other products.
Oracle Trace has an Application Programming Interface (API) that contains data collection service calls. Software developers can use the Oracle Trace API to pre-configure their products for Oracle Trace data collection. Users of a product containing the Oracle Trace API calls, such as Oracle Server release 7.3, can then automatically use Oracle Trace to collect data about specific events that occur in that product.
Most Oracle Trace users will be performing collections for products that already include the Oracle Trace API. Therefore, most users only need to be familiar with the data that can be collected for the host product and how to use the Oracle Trace Collection Manager application to create and administer data collections.
Examples of the integration of other Oracle applications into Enterprise Manager are:
The Replication Manager improves access to information about the replication environment and helps the administrator better manage replication tasks.
Oracle Media Server provides a complete set of services for the delivery of multimedia applications, such as video-on-demand, home shopping, video teleconferencing, interactive learning, and personalized newspapers-all without sacrificing the open portability that is the hallmark of Oracle Corporation.
Most modules of the Oracle Media Server--from the sophisticated content management, customer tracking, and customer billing services, to the highly scalable multimedia stream serve--rare portable to virtually any hardware or operating system environment, allowing customers to develop a system on hardware from one vendor, and then later move it to a completely different system without any application reprogramming. This important capability allows you to swap in the most cost-effective and high-performance components at any point in time to save money, increase capability, and prevent vendor "lock-in." Portability at all levels-back-end video servers, application servers, networks, set-top boxes, and their associated operating systems -means that compatibility will never be an issue and your investment will never be lost.
All Oracle modules are based on standards, where they exist, from the relevant interactive television standards organizations such as ANSI, ISO, MPEG, and DAVIC, all of which Oracle actively participates in, among others.
A parallel server has the following characteristics:
Applications that access the database can run on the same nodes as instances of a parallel server or on separate nodes, using the client-server architecture. A parallel server can be part of a distributed database system. Distributed transactions access the data in a remote database in the same manner, regardless of whether the datafiles are owned by an Oracle Server (in exclusive mode) or a parallel server (in exclusive or parallel mode).
Other non-Oracle processes can run on each node of the system, or you can dedicate the entire system or part of the system to Oracle.
For example, a parallel server and its applications might occupy three nodes of a five-node configuration, while the other two nodes are used for non-Oracle applications.
The Oracle WebServer, included in Release 7.3 and available as an add-on option to earlier releases of the Oracle7 Server, enables developers to build powerful Web applications using a familiar environment: stored procedures written in PL/SQL,TM Oracle's procedural extension to SQL.
The Oracle WebServer is a comprehensive solution that provides the portability, scalability, and support for many concurrent users needed to power large Web sites. The integrated environment is based on three components: the Oracle Web Listener, the Oracle Web Agent, and the Oracle7 Server. Hypertext links in any HTML (HyperText Markup Language) document can now point directly to an Oracle stored procedure, allowing the Oracle7 Server to build dynamic HTML documents "on the fly."
All components of the Oracle WebServer are fully configurable and manageable through a collection of HTML forms and online, context-sensitive help. These administration pages allow an administrator to quickly configure additional Web Listeners and Web Agents or change attributes of existing services with the click of a button.
|
Prev Next |
 Copyright © 1996 Oracle Corporation. All Rights Reserved. |
Library |
Product |
Contents |
Index |