| |
 |
|
Oracle Tips by Burleson |
Managing
Session State
In HTML DB, a session is defined for each user
that logs into the system. The session information is tracked and
stored before and after each page is submitted. The information
stored is the session number, when the session was created, the
workspace for the session, who is the user, and most importantly the
value of all the variables used in that session. The information is
referred to as the Session State. Figure 15.13 displays an example of
a session state.
The session state can be used to track down
problems or possible security violations. Session state is normally
purged from the system every 24 hours. The Administrator also has the
option of deleting these sessions manually through this interface.
Automatic deletion of the session states also can be adjusted from 10
seconds all the way up to one year.
The Administrator can also gather statistics
concerning the sessions, the entries for all the session states, and
the average number of entries per session.
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
