Archives of the TeradataForum
Message Posted: Tue, 02 Oct 2012 @ 20:22:43 GMT
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.
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|