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@xxxxxxxxx> 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@xxxxxxxxx>
wrote:
I bet BT has more than a million to.
On Tue, Jan 21, 2020, 4:23 PM Andrew Kerber <andrew.kerber@xxxxxxxxx>
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@xxxxxxxxx>
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.'