Oracle Measurement Tool
Database statistics provide information about the type of database load and the resources being used by the database. To effectively measure database performance, statistics must be available. Oracle Database generates many types of cumulative statistics for the system, sessions, segments, services, and individual SQL statements. Cumulative values for statistics are generally accessible using dynamic performance views, or V$ views. When analyzing database performance in any of these scopes, look at the change in statistics (delta value) over the period you are interested in. Specifically, focus on the difference between the cumulative values of a statistic at the start and the end of the period.
This section describes some of the more important database statistics that are used to measure the performance of Oracle Database:. Time model statistics use time to identify quantitative effects about specific actions performed on the database, such as logon operations and parsing. The most important time model statistic is database time, or DB time. This statistic represents the total time spent in database calls and is an indicator of the total instance workload. DB time is measured cumulatively from the time of instance startup and is calculated by aggregating the CPU and wait times of all sessions not waiting on idle wait events (non-idle user sessions).
Note: Because DB time is calculated by combining the times from all non-idle user sessions, it is possible that the DB time can exceed the actual time elapsed after the instance started. For example, an instance that has been running for 30 minutes could have four active user sessions whose cumulative DB time is approximately 120 minutes. When tuning an Oracle database, each component has its own set of statistics. To look at the system as a whole, it is necessary to have a common scale for comparisons. Many Oracle Database advisors and reports thus describe statistics in terms of time. Ultimately, the objective in tuning an Oracle database is to reduce the time that users spend in performing an action on the database, or to simply reduce DB time.
Time model statistics are accessible from the V$SESSTIMEMODEL and V$SYSTIMEMODEL views. Any session that is connected to the database and is waiting for an event that does not belong to the Idle wait class is considered an active session. Oracle Database samples active sessions every second and stores the sampled data in a circular buffer in the shared global area (SGA). The sampled session activity is accessible using the V$ACTIVESESSIONHISTORY view. Each session sample contains a set of rows and the V$ACTIVESESSIONHISTORY view returns one row for each active session per sample, starting with the latest session sample rows.
Because the active session samples are stored in a circular buffer in the SGA, the greater the system activity, the smaller the number of seconds of session activity that can be stored. This means that the duration for which a session sample is displayed in the V$ view is completely dependent on the level of database activity. Because the content of the V$ view can become quite large during heavy system activity, only a portion of the session samples is written to disk. By capturing only active sessions, a manageable set of data can be captured with its size being directly related to the work being performed, rather than the number of sessions allowed on the system. Active Session History (ASH) enables you to examine and perform detailed analysis on both current data in the V$ACTIVESESSIONHISTORY view and historical data in the DBAHISTACTIVESESSHISTORY view, often avoiding the need to replay the workload to trace additional performance information.
ASH also contains execution plan information for each captured SQL statement. You can use this information to identify which part of SQL execution contributed most to the SQL elapsed time. The data present in ASH can be rolled up in various dimensions that it captures, including:.
SQL identifier of SQL statement. SQL plan identifier and hash value of the SQL plan used to execute the SQL statement. SQL execution plan information.
Object number, file number, and block number. Wait event identifier and parameters. Session identifier and session serial number. Module and action name.
Client identifier of the session. Service hash identifier. Consumer group identifier You can gather this information over a specified duration into an ASH report. Active session history sampling is also available for Active Data Guard physical standby instances and Oracle Automatic Storage Management (Oracle ASM) instances. On these instances, the current session activity is collected and displayed in the V$ACTIVESESSIONHISTORY view, but not written to disk.
Wait events are statistics that are incremented by a server process or thread to indicate that it had to wait for an event to complete before processing could continue. Wait event data reveals various symptoms of problems that might be impacting performance, such as latch contention, buffer contention, and I/O contention. To enable easier high-level analysis of wait events, Oracle Database groups events into the following classes:. Administrative.
Application. Cluster. Commit. Concurrency. Configuration. Idle.
Network. Other. Scheduler.
System I/O. User I/O The wait classes are based on a common solution that usually applies to fixing a problem with the particular wait event. For example, exclusive TX locks are generally an application-level issue and HW locks are generally a configuration issue. The following list includes common examples of wait events in some of the wait classes:. Application: locks waits caused by row level locking or explicit lock commands. Commit: waits for redo log write confirmation after a commit. Idle: wait events that signify the session is inactive, such as SQL.Net message from client.
Network: waits for data to be sent over the network. User I/O: wait for blocks to be read off a disk Wait event statistics for a database instance include statistics for both background and foreground processes. Because tuning is typically focused in foreground activities, overall database instance activity is categorized into foreground and background statistics in the relevant V$ views to facilitate tuning. The V$SYSTEMEVENT view shows wait event statistics for the foreground activities of a database instance and the wait event statistics for the database instance. The V$SYSTEMWAITCLASS view shows these foreground and wait event statistics at the instance level after aggregating to wait classes.
V$SESSIONEVENT and V$SESSIONWAITCLASS show wait event and wait class statistics at the session level. When initially examining performance data, you can formulate potential interpretations of the data by examining the database statistics.
Oracle Measurement Tool
To ensure that your interpretation is accurate, cross-check with other data to establish if a statistic or event is truly relevant. Because foreground activities are tunable, it is recommended to first analyze the statistics from foreground activities before analyzing the statistics from background activities.
The following sections provide tips for interpreting the various types of database statistics to measure database performance:. Setting TIMEDSTATISTICS to TRUE at the instance level directs the database to gather wait time for events, in addition to available wait counts. This data is useful for comparing the total wait time for an event to the total elapsed time between the data collections. For example, if the wait event accounts for only 30 seconds out of a 2-hour period, then very little performance improvement can be gained by investigating this event, even if it is the highest ranked wait event when ordered by time waited. However, if the event accounts for 30 minutes of a 45-minute period, then the event is worth investigating.
For information about wait events, see '. Note: Timed statistics are automatically collected for the database if the initialization parameter STATISTICSLEVEL is set to TYPICAL or ALL. If STATISTICSLEVEL is set to BASIC, then you must set TIMEDSTATISTICS to TRUE to enable collection of timed statistics. Note that setting STATISTICSLEVEL to BASIC disables many automatic features and is not recommended. If you explicitly set DBCACHEADVICE, TIMEDSTATISTICS, or TIMEDOSSTATISTICS, either in the initialization parameter file or by using ALTERSYSTEM or ALTER SESSION, then the explicitly set value overrides the value derived from STATISTICSLEVEL. If TIMEDSTATISTICS is set to FALSE, then the amount of time spent waiting for an event is not available.
Therefore, it is only possible to order wait events by the number of times each event was waited for. Although the events with the largest number of waits might indicate a potential bottleneck, they might not be the main bottleneck. This situation can happen when an event is waited for a large number of times, but the total time waited for that event is small. Conversely, an event with fewer waits might be a bigger bottleneck if the wait time accounts for a significant proportion of the total wait time.
Pong Screen Saver is an animated screen saver that brings the classic arcade game play of 'Pong' to your Windows 95/98/NT computer as a screen saver! We got a new computer for Christmas. It is windows 7, 64 bit. I have some older games (Myst, Reader Rabbitt, Fisher Price Pirate Ship (and a Discovery Farm game), and. Pong Game is a site dedicated to the good old pong game, you can find few versions of the game along with basic information and history. Plasma Pong, free and safe. Windows 98; Windows 98 SE. Although if I did I'm sure it would be very much like Plasma Pong. The game takes the old classic and. Windows 98 pong games. Pong, Atari-like computer game. Presenting the modern version of Pong for Windows built with DirectX. The game runs on Windows 98, 2000.
Without the wait times to use for comparison, it is difficult to determine whether a wait event is worth investigating. When interpreting computed statistics (such as rates, statistics normalized over transactions, or ratios), verify the computed statistic with the actual statistic counts. This comparison can confirm whether the derived rates are really of interest because small statistic counts usually can discount an unusual ratio. For example, on initial examination, a soft-parse ratio of 50% generally indicates a potential area for tuning. If, however, there was only one hard parse and one soft parse during the data collection interval, then the soft-parse ratio would be 50%, even though the statistic counts show this is not impacting performance. In this case, the ratio is not important due to the low raw statistic counts.
Scripting on this page enhances content navigation, but does not change the content in any way.