-
Hi,
I have created a profile in which i have set SESSIONS_PER_USER 1 , but it is able to connect more session with the same username to which i have assigned this profile.I have also checked DBA_PROFILES and its giving the parameter value as 1.
Take Care,
Nishant.
-
To enable the resources either
1) ALTER SYSTEM SET RESOURCE LIMIT=TRUE;
or
2)Change in the INIT.ORA PARAMETER -> RESOURCE LIMIT=TRUE and restart the DB.
Take Care,
Tanaka.
-
Originally posted by tanaka
To enable the resources either
1) ALTER SYSTEM SET RESOURCE LIMIT=TRUE;
It is
Code:
ALTER SYSTEM SET RESOURCE_LIMIT=TRUE;
. You have omitted the underscore.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Sorry , I missed the underscore.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|