Re: One Million User Accounts

I have 190K on one of my databases, it works but I really dislike it. I’ve not run into the ora600 previously mentioned but I do find that data dictionary queries are very often slow and need a helping hand.

You might want to look at Real Application Security and schemaless users as it means these users don’t appear in a lot of the data dictionary tables. We’re currently investigating it now and are pretty much sold.

Thanks,
Andrew

On Tue, 21 Jan 2020 at 16:41, Rich J <rich242j_at_gmail.com> wrote:

> I want to create ~1500 users, eliminating an application proxy login
> because troubleshooting session activity is next to impossible with the
> Java client's inability to provide a client process ID (i.e. all
> application users connect to the DB using the same username).
>
> It's not 1M+, but I could see a similar need on a larger scale.
>
> Rich
>
> On Tue, Jan 21, 2020 at 10:31 AM Howard Latham <howard.latham_at_gmail.com>
> wrote:
>
>> I bet BT has more than a million to.
>>
>> On Tue, Jan 21, 2020, 4:23 PM Andrew Kerber <andrew.kerber_at_gmail.com>
>> wrote:
>>
>>> I bet amazon has far more than a million user accounts....
>>>
>>> On Tue, Jan 21, 2020 at 10:15 AM Mladen Gogala <gogala.mladen_at_gmail.com>
>>> wrote:
>>>
>>>> Why would you need such number of accounts? This sounds like the
>>>> application design was done by Pinky & the Brain.
>>>> On 1/21/20 10:51 AM, Ethan Post wrote:
>>>>
>>>> Anyone tried to create 1000's-1,000,000 user accounts and seen if there
>>>> are any issues? I can't believe there would be but I recall a bug or
>>>> something going back in which I ran into issues with a high # of user
>>>> accounts.
>>>>
>>>> Thanks,
>>>> Ethan
>>>> e-t-h-a-n.com
>>>>
>>>>
>>>
>>> --
>>> Andrew W. Kerber
>>>
>>> 'If at first you dont succeed, dont take up skydiving.'
>>>
>>

--
http://www.freelists.org/webpage/oracle-l