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.
Printable View
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.
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.Quote:
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~