All,

When you create a tablespace, What are general rules to determine the size and number of datafiles? How will this affect a database performance? Is there any advantage or disadvantage to using more small or a few large size datafiles. What is the smallest datafile you can create on AIX. Thanks!