create tablespace, very slow

Hi,

We have Oracle8.0.5 on hpux10.20, hpux11.0(32bit), and hpux11.0(64bit).

When I add tablespaces to existing database in hpux11.0, it takes about 5 to
10 minutes to create a 1G datafile, that's fine. But in hpux10.20, it takes
1 hour for the same size.

I've tried to set db_file_direct_io_count to various values but got no improvement.

Any comments appreciated

Thanks & Regards
bjin Received on Tue Jul 27 1999 - 03:59:48 CDT