mjf
Well Known Member
Hi List
I'm doing some research on moving our Oracle database from dictionary to locally managed tablespaces and would like to hear from anybody who has made this move. I am interested to hear of any performance issues with big tables like F0911 and the like. Our F0911 has approx 9 million records and our biggest table - a custom one has 16 million. I have heard of people running OneWorld with locally managed tablespaces but in all cases they have split their business data into 3 tablespaces of small, medium and large and had uniform extent sizing in each. I presume they are doing this by entering OCM override records for the tables they want to split into their medium and large tablespaces. This seems like a pain to manage. My interest is in setting the business data tablespace to autoallocate and let the database handle the extent sizings of all the tables in one tablespace. Your experiences would be greatly appreciated.
Regards
Marty
I'm doing some research on moving our Oracle database from dictionary to locally managed tablespaces and would like to hear from anybody who has made this move. I am interested to hear of any performance issues with big tables like F0911 and the like. Our F0911 has approx 9 million records and our biggest table - a custom one has 16 million. I have heard of people running OneWorld with locally managed tablespaces but in all cases they have split their business data into 3 tablespaces of small, medium and large and had uniform extent sizing in each. I presume they are doing this by entering OCM override records for the tables they want to split into their medium and large tablespaces. This seems like a pain to manage. My interest is in setting the business data tablespace to autoallocate and let the database handle the extent sizings of all the tables in one tablespace. Your experiences would be greatly appreciated.
Regards
Marty