Impact of Oracle Attachements on Data Base
I am part of a Oracle Genral Ledger Functional Support team and planning to use Oracle attachment Feature at a global level. Need your assistance and advise on some of the queries we have...
1) Is there a size limitation on the Oracle Database to Store attachements? If yes, what is this limit?
2) If we use this feature at a mass level ( User base of 800+ accross Globe), will it pose performance issues? Like, slow Journal Queries, Delay in concurrent Request or Customized Requests etc?
3) Is there a Maximun size per attachment and if a bigger attachement will slow down Oracle workflow ?