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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
|
<HTML><HEAD><TITLE>Session Manager</TITLE></HEAD><BODY>
<H1>Session Manager</H1>
This tool is used to manage the connections made to the database.<P>
<IMG SRC=images/session.png><P>
The session tool consists of a toolbar, a list displaying the connections currently open to
the database and at the bottom a tabbed pane where you can investigate a specific connection
to the database.<P>
<H2>Toolbar</H2>
The toolbar contain the following commands.<P>
<TABLE>
<TR><TD VALIGN=top><B>
Refresh</B></TD><TD VALIGN=top>
Refresh the view from the database.</TD></TR>
<TR><TD VALIGN=top><B>
Enable timed statistics</B></TD><TD VALIGN=top>
Enable timed statistics for the currently selected session.</TD></TR>
<TR><TD VALIGN=top><B>
Disable timed statistics</B></TD><TD VALIGN=top>
Disable timed statistics for the currently selected session.</TD></TR>
<TR><TD VALIGN=top><B>
Disconnect session</B></TD><TD VALIGN=top>
Disconnect the currently selected session. You will be asked if you allow the current
transaction to finish before kicking the session out or not.</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>
Change connection</B></TD><TD VALIGN=top>
Change the connection to administrate storage for.</TD></TR>
</TABLE><P>
<H2>Inspecting a session</H2>
When you select a session the following information is available in the tabbed pane at the
bottom of the window.<P>
<TABLE>
<TR><TD VALIGN=top><B>
Statistics</B></TD><TD VALIGN=top>
The session statistics available for the session. You will get more statistics if you enable
timed statistics through the toolbar. There are also two charts displaying waitstates and
I/O for the selected session.</TD></TR>
<TR><TD VALIGN=top><B>
Connection info</B></TD><TD VALIGN=top>
Information about the connection and versions of the components used.</TD></TR>
<TR><TD VALIGN=top><B>
Pending locks</B></TD><TD VALIGN=top>
What locks this session is currently waiting for.</TD></TR>
<TR><TD VALIGN=top><B>
Locked objects</B></TD><TD VALIGN=top>
The objects currently locked by this session.</TD></TR>
<TR><TD VALIGN=top><B>
Current statement</B></TD><TD VALIGN=top>
The statement that is currently being executed. See <A HREF=common.html#sga>SGA statement</A>
for information about the statement.
</TD></TR>
<TR><TD VALIGN=top><B>
Previous statement</B></TD><TD VALIGN=top>
The next to last statement being executed by the session. See <A HREF=common.html#sga>SGA
statement</A> for information about the statement.</TD></TR>
<TR><TD VALIGN=top><B>
Open cursors</B></TD><TD VALIGN=top>
This contains a list of all the cursors currently held open by the session. When a statement
is selected in the list you can investigate it using the normal <A HREF=common.html#sga>SGA
statement</A> view.</TD></TR>
</TABLE>
</BODY>
</HTML>
|