Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 02 Oct 2012 @ 20:22:43 GMT

  <Prev Next>   <<First <Prev

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.



Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020