Database Reference
In-Depth Information
PROFILER=TRUE
PFREQ=5
SESSIONS=W
LEVEL=2
CPU=Y
PROFILE_TOP=Y
PROFILE_VMSTAT =Y
PROFILE_IOSTAT=Y
Hang Detection
Similar to the high-level connection properties defined earlier, there are parameters for a specific collector. Hang
detection properties are defined in the
hangDetect.properties
file.
AUTO_HANG_DETECT = TRUE
indicates if LTOM should capture statistics when the server goes
into a hang state.
•
HFREQ: < >
indicates the frequency in which to collect hang related hang detection statistics.
•
The remaining three parameters in this section relate to the O/S-level matrix to be collected using OS provided
utilities. They include
VMSTAT
,
IOSTAT
, and
TOP
.
Session Recorder
Session recorder properties are defined in the sessionRecorder.properties file.
SESSION_RECORDER =
when set to
TRUE
enables session recorder to collect session information.
•
SFREQ=
defines the frequency in which snapshots should be collected by LTOM for the session.
•
TRACE=
indicates, when collecting session information, where the data should be captured
(in memory or file). Value of
F
indicates file and
M
indicates that trace data will be collected in
memory.
•
BUFFERS=
specifies the number of bytes dedicated to trace an individual session.
•
MAX_SESSIONS =
indicates the maximum number of sessions that will be traced.
•
Executing LTOM
LTOM can be executed in three different ways:
•
Interactively using the menu in Figure
6-20
, where LTOM will prompt for the database user id
and password
•
Interactively where LTOM will not prompt for user id and password
•
As a background process
Search WWH ::
Custom Search