1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
<HTML><HEAD><TITLE>SGA Trace</TITLE></HEAD><BODY>
<H1>SGA Trace</H1>
This tool is used investigate the statements available in the SGA.<P>
<IMG SRC=images/sgatrace.png><P>
The session tool consists of a toolbar, a list of SGA statements and finally at the
bottom a <A HREF=common.html#sga>SGA statement</A> view.<P>
<H2>Toolbar</H2>
The toolbar contain the following controls.<P>
<TABLE>
<TR><TD VALIGN=top><B>
Update</B></TD><TD VALIGN=top>
Update the view from the database.</TD></TR>
<TR><TD VALIGN=top><B>
Schema</B></TD><TD VALIGN=top>
The user schema to extract statements for.</TD></TR>
<TR><TD VALIGN=top><B>
Refresh time</B></TD><TD VALIGN=top>
A list where you can select the interval between automatic updates.</TD></TR>
<TR><TD VALIGN=top><B>
Type</B></TD><TD VALIGN=top>
What type of statements you want to examine. Can either be <B>SGA</B> to investigate all entries of the SGA or <B>Long operations</B>
to check long operations in the database (Databases must have timed statistics enabled to generate entries for long operations).</TD></TR>
<TR><TD VALIGN=top><B>
Change connection</B></TD><TD VALIGN=top>
Change the connection to administrate storage for.</TD></TR>
</TABLE><P>
Don't forget you can sort the view by selecting a column header in the SGA list.
</BODY>
</HTML>
|