range of time to create a 100G bigfile Tablespace decent server HW
702132Jun 8 2009 — edited Jun 9 2009Creating a 100G bigfile data space with autoextend 2G max of 200G. I run the script with smaller sizes 300mb initial 20mb autoextend 2g max size to ensure it worked as intended. All went well. So when I put in the larger file sizes it is taking a lot longer. I am aware that there is a large increase in the time needed to create 100GB tablespaces as oppposed to 300MB. I was wondering if you guys have created similar sized tablespaces and maybe how long it took you. I have let this run for over 12 hours and nothing to show for it.
Any contributions would be appreciated.
Bruce