Page History
...
Precise for Oracle also lets you focus on and drill down to individual applications, SQL statements, and database objects in your system that are responsible for heavy consumption of system and database resources and to quickly find the definitive root cause of performance degradation.
In a multi-Tiered tiered application, you can extend the reach of Precise for Oracle by installing Precise for Database & Storage, which drills down into the storage layer behind the database Tier and the optional Interpoint extensions to see into the Tier in front of the database.
...
Insight gives you an end-to-end view of your applications performance, across all your Tiers. It helps you find the source of performance problems in multi-Tier tier applications by allowing you to compare the resource consumption of each Tier. In this way, you can answer the question “Where is my performance problem?” If Insight shows that the problem lies within Oracle, you can use Precise for Oracle to drill down further.
...
On the monitored server, Precise for Oracle consists of the following components:
- Precise Listener
- Precise for Oracle Collector
- Optional Collector extensions for Storage and ERP applications (not shown)
On the Precise server, Precise for Oracle consists of the following components:
- Precise FocalPoint
- Precise for Oracle FocalPoint
- Precise for Oracle Tuner
- PMDB FocalPoint
- Precise user interface including Precise for Oracle
Other Precise components can integrate with Precise for Oracle. These components can also be present on the Precise server:
...
See the Precise Installation Guide and the Precise Administration Guide.
| Anchor | ||||
|---|---|---|---|---|
|
There is one Precise Listener per physical server or domain for each installation of Precise. Its purpose is to handle communication with other Precise components, using TCP/IP. It listens on port 20702 by default. The Precise Listener handles all requests from the user interface and Precise for Oracle FocalPoint; no requests go directly to the Precise for Oracle Collector. If necessary, the Precise Listener runs a Data Retriever process to carry out the work.
| Anchor | ||||
|---|---|---|---|---|
|
There is one Precise for Oracle Collector per monitored Oracle instance. The Collector runs in the background, monitoring and recording all Oracle database activity on a 24 x 7 basis. It works using a sampling technique and thereby consumes fewer resources than a trace agent. The collected information is stored locally in historical files, which are subsequently transferred and loaded into the PMDB.
| Anchor | ||||
|---|---|---|---|---|
|
Optional Collector extensions are available. They provide additional information in certain applications, namely for storage and for Enterprise Resource Planning (ERP). Precise for Database & Storage correlates Oracle database activity with the I/O on the back-end storage. ERP extensions correlate Oracle database activity with front-end ERP users and transactions.
...
If ERP support is installed, the Collector provides detailed information on the activities and resource consumption of packaged application entities. Heavy users of Oracle resources, such as: ERP users, transactions, and reports can be identified. You can also drill down to the statements executed by them and the objects they accessed.
| Anchor | ||||
|---|---|---|---|---|
|
There is a single instance of the Precise FocalPoint for each installation of Precise. Precise FocalPoint is the management software for Precise. It manages and communicates with other FocalPoints, such as Precise for Oracle FocalPoint, PMDB FocalPoint, and the Precise Listener on monitored servers. Precise FocalPoint also contains the HTTP server used for the user interface.
| Anchor | ||||
|---|---|---|---|---|
|
There is a single instance of the Precise for Oracle FocalPoint for each installation of Precise. It performs the following major tasks:
- It is responsible for replying to user interface requests. Depending on the nature of the request, it will retrieve data from the PMDB or from the Collector using the Precise Listener or run a Tuner process to query the Oracle database itself.
- It periodically loads Collector data into the PMDB. According to the schedule defined in the PMDB, Precise for Oracle FocalPoint executes the Precise Listener on each monitored server to copy across the prepared historical activity files. They are then loaded into the PMDB.
- It periodically loads Oracle statistics, explain-plan data, schema changes, and database definition changes.
According to the schedule defined in the PMDB, Precise for Oracle FocalPoint runs a Tuner process to communicate with each monitored Oracle instance. - When Alerts is installed, it provides Alerts with Oracle-related metrics.
| Anchor | ||||
|---|---|---|---|---|
|
The Tuner process is only created when certain information from the monitored database is requested and lasts for the duration of the request. For example, if you want to view the explain plan of a SQL statement and see the definitions and statistics for the database objects involved, the Tuner is executed on the server to retrieve the relevant information from the Oracle Data Dictionary.
| Anchor | ||||
|---|---|---|---|---|
|
There is a single instance of the PMDB for each installation of Precise. It maintains the Oracle PMDB, in which most of the performance information is held.
| Anchor | ||||
|---|---|---|---|---|
|
Precise provides a Web-based graphical user interface (GUI). Client requests are sent to Precise FocalPoint using HTTP. The Precise GUI is accessed through a browser. After you log in as an authorized user, the Precise StartPoint page opens. From the StartPoint, you can access the Precise for Oracle user interface and all other Precise products.
...