 |
 |
Archives of the TeradataForum
Message Posted: Fri, 26 Oct 2007 @ 15:14:25 GMT
| Subj: | | Re: Query on Sessions |
| |
| From: | | Geoffrey Rommel |
| | Every user who connects to Teradata system with SQL assistant or thru BTEQ will eat up one session? Or a single session can cater to
multiple users request? | |
A session can have only one user. On most systems, there are plenty of sessions available, but if you need more, you have at least these
options. (1) Ask your CE to define more PE vprocs. There's a good chance, however, that the number of PE's has already been optimized and you
don't want to burden the system with more. (2) Set up connection pooling. (3) Set up TDWM to kill inactive sessions after an hour or so. (4)
Analyze and modify your applications so that they don't use so many sessions! (For example, MultiLoad and FastLoad often need far fewer sessions
than they are given.) This is time-consuming but may be the best option in the long run.
| |
