rmiozzo20
Member
Hi all,
We went live 23 months ago and have been facing some performance problems for the last 6 months.
We are not allowed to purge tables because of country localization and business requirement.
Some of our huge database tables:
Table / Records
-------/ ----------
F3111T / 44,302,962
F3102 / 43,244,711
F4111 / 43,184,898
F39120W/ 41,759,244
F3111 / 29,071,557
F30026 / 19,215,399
F0911 / 17,430,645
We are planning to install Oracle Partitioning Table in order to improve performance. Any suggestions? Comments?
TIA
Regina
Enterprise One XE, Update 7, SP 19.1
HP-UX 11.0/Intel Win2K
Oracle 8i - 8.1.7
We went live 23 months ago and have been facing some performance problems for the last 6 months.
We are not allowed to purge tables because of country localization and business requirement.
Some of our huge database tables:
Table / Records
-------/ ----------
F3111T / 44,302,962
F3102 / 43,244,711
F4111 / 43,184,898
F39120W/ 41,759,244
F3111 / 29,071,557
F30026 / 19,215,399
F0911 / 17,430,645
We are planning to install Oracle Partitioning Table in order to improve performance. Any suggestions? Comments?
TIA
Regina
Enterprise One XE, Update 7, SP 19.1
HP-UX 11.0/Intel Win2K
Oracle 8i - 8.1.7