Profile default values

20 pts.
Tags:
Oracle
I understand how and why profiles are used. My question is; what are the default values for each resource. For example when a profile has the 'Connect Time' as 'Default' what is the value of the 'Connect Time'? I would like to know all the 'default' values for all the resources to properly set the profiles.
ASKED: November 16, 2005  12:23 PM
UPDATED: November 16, 2005  1:21 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Look in sys.dba_profiles. That should show you what you need.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Redwine
    I will try to add some clarity to the question. When I query the column 'LIMIT' from the table DBA_PROFILES a value of 'DEFAULT' is returned. What does this equate to? Two hours, two minutes, twenty-four hours? When the RESOURCE IDLE TIME is set to 'DEFAULT', how many minutes is that? I have no problem understanding the value 'UNLIMITED' for the column 'LIMIT' from the table DBA_PROFILES or any numeric value. It the value 'DEFAULT'!
    20 pointsBadges:
    report
  • Charliep
    When you get a resource value of DEFAULT then look at the profile named DEFAULT for that resource and then look at the value. For example we have a profile named TEST that has a value of DEFAULT for the resource CONNECT_TIME. Looking at the profile named DEFAULT for the resource CONNECT_TIME shows a value of UNLIMITED. So the value for CONNECT_TIME for profile TEST is UNLIMITED. I hope this clears it up.
    0 pointsBadges:
    report
  • Redwine
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/profile-default-values/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following