-
Guys,
Is there anybody who knows what is the maximum number of users that we can create within an Oracle database?
Ed
-
I Guess... Users including roles=10K
Reddy,Sam
-
I'm sure this is realy just a guess, Sreddy.... AFAIK there is no such limit in Oracle, and I'm sure there are a lot Oracle databases out there having more than 10.000 users defined....
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
You might be Right Jmodic, But, I remembered I read in some documentation its the toal no of concurrent users is 10K.
I will confirm it with my Manager and post it back, he better knows as he deal with Oracle Licencing for products.
Reddy,Sam
-
Seek no more.... I've found in "Oracle Reference Manual":
Users and Roles maximum: 2,147,483,638
So we would need about 3 databases to define schema for each and every soul on this planet. Then we'll all be able to fool around in our own Oracle scemas, wouldn't that be nice? :)
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Thanks jmodic. Even I was wondering how can it be just 10K. Seems my memory gone mad, mentioning just 10K with no logical sense...
Reddy,Sam
-
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
|