Originally posted by irehman
Answer is no effect on performance.
I can't agree with this :
Why:
1) avg # of colums for each table 5-7 (then > 5000 rows in sys.col$ table)
2) when oracle have to work with dictionary tables it use not only
db cache, but dictionary and library cache too.
size of these areas not so big as db cache.
3) oracle have to check permitions to access for each objects in reingeneering process.
This is library/dictionary cache too.
as possible result --> oracle increase # of locks, and then we may have
degradation of perfomance with parse new "usual" sql statments.