Slow deletion/adding a column in a database wit a lot of synonyms
Hi all,I have an interesting problem in a database 10.2.0.5 EE x64bit on RHEL 5.8
The database has a lot of db users ~ 7k, each user with about 3k synonyms (because of the application design), so total there are approx 21M synonyms in the database.
When I try to add a new column or delete existing one in a user table, it takes about 7 hours to complete.
If i delete some users it is much faster - for instance with 7M synonyms (2.3k users) the operations happens very fast.
I will be very happy if someone can advice what causes this and how it can be fixed.
The database has a lot of db users ~ 7k, each user with about 3k synonyms (because of the application design), so total there are approx 21M synonyms in the database.
When I try to add a new column or delete existing one in a user table, it takes about 7 hours to complete.
If i delete some users it is much faster - for instance with 7M synonyms (2.3k users) the operations happens very fast.
I will be very happy if someone can advice what causes this and how it can be fixed.
0