Database Reference
In-Depth Information
Figure 4-19. The Top Actions table shows the most time-consuming components aggregated by service, module, and
action name
The Total Sample Count value displayed by Enterprise Manager tells you how many active session history
samples were used to build the chart you're looking at. For example, Figure 4-18 is based on 3,103 samples.
Note
You have to look for components that are responsible for a large part of the activity also when considering the
activity displayed by a table like Top Sessions or Top Actions. For example, although according to Figure 4-18 no
session is responsible for more than 2% of the activity, Figure 4-19 shows that few modules/actions are responsible for
most of the load. Hence, independently of whether the Top SQL tables points out something interesting, you might
want to review those modules/actions as well.
To display the data aggregated according to a specific dimension without Enterprise Manager, you can use one of
the following scripts: ash_top_sessions.sql , ash_top_services.sql , ash_top_modules.sql , ash_top_actions.sql ,
ash_top_clients.sql , ash_top_files.sql , ash_top_objects.sql , and ash_top_plsql.sql . The dimension they
work on is clearly mentioned in the script name. Note that all scripts require two parameters as input (in the following
case, beginning and end timestamps) to specify the period which the data is to be displayed for. The following two
examples show the output generated with the ash_top_sessions.sql and ash_top_actions.sql scripts that are
equivalent to Figure 4-18 and Figure 4-19 :
SQL> @ash_top_sessions.sql 2014-02-04_19:10:02.174 2014-02-04_19:15:02.174
Activity% DB Time CPU% UsrIO% Wait% Session Id User Name Program
--------- ------- ---- ------ ----- ---------- --------- ----------------
1.7 52 9.6 90.4 0.0 232 SOE JDBC Thin Client
1.7 52 3.8 96.2 0.0 16 SOE JDBC Thin Client
1.6 49 4.1 95.9 0.0 136 SOE JDBC Thin Client
1.5 48 6.3 93.8 0.0 156 SOE JDBC Thin Client
1.5 47 4.3 93.6 2.1 170 SOE JDBC Thin Client
1.5 46 10.9 89.1 0.0 127 SOE JDBC Thin Client
1.5 46 6.5 93.5 0.0 74 SOE JDBC Thin Client
1.5 46 8.7 89.1 2.2 162 SOE JDBC Thin Client
 
 
Search WWH ::




Custom Search