This content has been marked as final. Show 3 replies
For performance consideration you should user materialized views i think.1 person found this helpful
1 person found this helpful
Is there a limitation of joining "union" of 50 views?What can happen is if the connection to one of these servers is interrupted, the big "union" view will not work. As said by above poster MV, with lets say an hourly refresh, helps with this situation as you have the data that was gathered last time (and most likely it is still valid).
Have you also heard about integration utility called DBMS AQ message queuing service like SOA ? Does this works better in terms of performance and reliability?