The activity on an Oracle database changes according to many factors, including the number of users logged on to the database and the type of processing performed. Database performance can suffer at times of peak activity if there are not enough database resources available to handle that activity.
Use the Peak Processing Periods page to:
The result is a more precise prediction that relates only to the times when the database is heavily loaded.
Notes:
To open the page
Click Predictive Diagnostics | Identify the peak-activity periods of the database.
Control |
Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Show database processing activity for... |
Select Real Data (your database) or Sample Data (to experiment with). Note: Spotlight takes some time (typically about 10 days) to collect enough data to make valid predictions on the future performance of your Oracle instance. In the meantime use the prepared sample data to learn more about Predictive Diagnostics and how it works. | ||||||||||
Between...and... |
Select start and end dates for the analysis. The period of time should:
The default period is the previous seven days. The chosen period is shown in the Database Processing Activity chart on the right. | ||||||||||
Using... |
Select one or more metrics to represent the database activity. Throughput Metrics
|
This is a graphical view of the selected criteria. It shows the raw data for each metric selected when setting the criteria.
Notes:
- Zero represents the average value of all points in a data series.
- The scale on the Y-axis (-3 to 3) represents standard deviations away from that average.
Use the Peak Processing Periods table to select or create a weekly set of peak activity periods for your prediction.
Note: A period of "peak activity" will not always be a time when total activity is at its maximum. For example, users may set separate peak periods for online and batch processing:
Action |
Description |
---|---|
Set which peak period to use by default |
Locate the period (row) you want to use as default. Click the Default option. To display the peak period on the Database Processing Activity chart, select the corresponding Preview option. Use this to confirm visually that the period selected aligns with actual peak loads. |
Add a new time to an existing period |
Right-click a row in the table and select Add new time. Click each cell in the new row to edit that cell. |
Delete a time from an existing period |
Right-click a row in the table and select Remove time. |
Add a new period |
Click Define Period.
OR
Right-click in the table and select Add new processing period. |
Add a new period based on an existing period |
Click the down-arrow next to Define Period and select a period type from the list.
|
Delete a period |
Select a period in the table and click Remove Period.
OR
Right-click a period in the table and select Remove processing period. |
Revert to previous values |
Click Revert Changes.
|
The Peak Processing Period grid
Column |
Description |
---|---|
Processing Period |
A short description of what the processing period represents. This description is used on Predictive Diagnostics drilldown pages that use Peak Periods such as Impending Bottlenecks - Timed Statistics. |
Default |
The default period selected on Predictive Diagnostics drilldown pages that use Peak Periods such as Impending Bottlenecks - Timed Statistics. |
Start |
When the processing period starts. |
Finish |
When the processing period ends. Note: If the Finish day is set to a value earlier than the Start day, it is interpreted as the corresponding time on the following week. |
Preview |
Display this period in the Database Processing Activity chart. Tip: Use this to confirm visually that the period selected aligns with actual peak loads. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center