Some problems is not very good,
First is about table space data file,
Before in use Oracle has encountered a problem, a single data file space is 32 gb,
You will need to add more than 32 G data file, we are now in ERP system data about 500 G, the subsequent will continue to increase,
Migrated to the Oracle is about 10 multiple data files,
Internet use bigfile see said in tablespace large file table space, need not have been added the data file
Want to ask next actual business with bigfile in tablespace large file table space?
Large file tablespaces, and what are the strengths and weaknesses of the traditional comparison table space?
Large file table space in the backup, restore do you have any questions, will be slow?
Oracle RAC later if you want to do with the Data gruad words using bigfile in tablespace will there be?
Hope that friends can share, under the guidance of the
CodePudding user response:
With the large I/o performance is not very good, the migration is more troublesome, it is best not to use,CodePudding user response:
1, with not a lot of reality;2, the management is not convenient to maintenance, performance may be affected,
CodePudding user response:
Multiple data file backup reduction will be no problem, when I see online say large file table space with incremental backup mode