Re: Need help with CONNECT_TIME & IDLE_TIME confusion...

To enable profiles you need to set the initialization parameter RESOURCE_something in the init.ora to TRUE, which defaults to FALSE. Please check the DBA manual.

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : ssubrama_at_nibucorp.ccdn.otc.com.au / avion_at_ozemail.com.au

Disclaimer : All opinions are truly and just mine.




>>2)What exactly are CONNECT_TIME and IDLE_TIME. I assume CONNECT_TIME is the

>>time you spend logged on the server and IDLE_TIME is the time

>>spent doing no work "INACTIVE". Heres the thing , I set CONNECT_TIME to 

>>30 and IDLE_TIME to 10 thinking one of the two would disconnect my 

>>connection. I then connected with a new user that has the profile I 

>>created assigned to it. I assume the time is in seconds or minutes so I

>>wait the full 30 minutes to be sure. But when I come back my user

>>connection is still up. Can someone explain what I am doing wrong and why

>>****************************************************************************

>>Eddie Hernandez                              North Broward Hospital District

>>Programmer/Oracle DBA                        1608 SE 3rd Avenue 

>>hernb0_at_nbhd.org                              Ft. Lauderdale, FL 33316

>>***************************************************************************

>

>

>

>Scott Moyer

>dmoyer_at_gpu.com