What is set to IDLE TIME by default?

[Woo]

There was a question that asked what value for IDLE TIME in a profile is set by default. I looked through the study guide but I couldn't find. Can you help me answer this ?


Thank you in advance.

[jason]

Hi Woo,

By default, idle_time is default.

select Resource_Name, Limit
from DBA_PROFILES
where resource_name = 'IDLE_TIME'

RESOURCE_NAME LIMIT
----------------------------------------
IDLE_TIME UNLIMITED



Thanks
Jason

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Oracle DB Resources ( http://oracle.dbresources.com) - Online community for Oracle DBAs and Developer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[jason]

By default it is UNLIMITED.

Thanks
Jason

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Oracle DB Resources ( http://oracle.dbresources.com) - Online community for Oracle DBAs and Developer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[julian]

Originally posted by jason
By default it is UNLIMITED.

Thanks
Jason

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Oracle DB Resources ( http://oracle.dbresources.com) - Online community for Oracle DBAs and Developer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

So are all parameters of the DEFAULT profile.