 |
 |
Archives of the TeradataForum
Message Posted: Tue, 02 Oct 2012 @ 20:22:43 GMT
| Subj: | | Re: Sessions in PMON |
| |
| From: | | Dave Wellman |
Hi James,
The reason that your session didn't disappear straight away in PMON is because there is a time-lag (actually two) between 'reality' and what is
displayed on the PMON screen.
The raw data is built in the dbms and then used to populate a buffer. This is the first time-lag and is controlled by the "session collection
rate" that can be set in PMON or dbw etc.
Then you have a "refresh rate" which is set in PMON. How often does PMON go back to the dbms to get new data. This is the second "time-lag".
Whether you can abort other IDLE sessions really depends on whether or not they are still logged on (amongst other factors). As you saw with your
session, if those other IDLS sessions are for sessions that have actually logged off then there's probably no harm, but also no point - they'll
soon go from your PMON display.
Cheers,
Dave
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
| |
