Re: How may idle user sessions be killed prior to a shutdown?

Blv n Drms (blvndrms_at_aol.com) wrote:
: Might I suggest another way we are using at our sites doing cold backups:
 

: Set the RESOURCE_LIMIT = TRUE in your init.ora then alter your users/roles
: to have a resource timeout of 2 hours. What that means is if their
: session is idle for 2 hours they are disconnected from oracle. It does
: not solve the problem of processes that are actually modifying data at
: backup time but handles the user who just forgets to log off at the end of
: the day.
 

: I would caution against using shutdown abort...it can cause you to have to
: do media recovery a lot more often than you may like.
: Jack Richter

I would agree with setting the RESOURCE_LIMIT in the init.ora file. But rather than changing the users/ roles I would create a profile (maybe called IDLE) with a limit of idle_time 5 (the number is in minutes).   This can be found in chapter 11 of the Oracle7 Server Admin Guide. I have tested this and it does not mean that if a session is idle for 5 minutes it will be disconnected. It will only disconnect after abnormal termination.

Hope this helps.

Pete

~ Pete Maggio                     ~ The views expressed here are my own  ~
~ Control Data Systems, Inc.      ~ and do not necessarily reflect those ~
~ 1803 Research Blvd, Suite 500   ~ of Control Data Systems, Inc.        ~
~ Rockville, MD 20850-2059        ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ Internet: <maggio_at_cdc.com>      ~ The Internet is, by far, the great-  ~
~ Voice:    202.761.1387          ~ est and most significant achievement ~
~ FAX:      202.761.0292          ~ in the history of mankind.  -H. Hahn ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~