DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: MAX. NO OF SCHEMA

  1. #1
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    151
    Guys,

    Is there anybody who knows what is the maximum number of users that we can create within an Oracle database?

    Ed

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I Guess... Users including roles=10K
    Reddy,Sam

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  6. #6
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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

  7. #7
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    151
    Thanks a lot guys!!!

    Ed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width