Re: create tablespace, very slow

On one of my HP-UX 10.20 systems, some of the logical drives are similarly slow to format datafiles, while others (on the same system) are much faster. Therefore, I think it probably has more to do with the UNIX filesystem setup than with Oracle. However, I am not the UNIX administrator, so I don't know what the difference is.

Tim

In article <379E670F.1F8BEBC3_at_hpsgns1.sgp.hp.com>,   Jin Bo <jinbo_at_hpsgns1.sgp.hp.com> wrote:
> Kenneth C Stahl wrote:
>
> > Jin Bo wrote:
> >
> > > 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.
> >
> > This may be a dumb question, but is it possible that the file
system slice
> > where you are creating the tablespace with hpux is mounted via NFS?
If so,
> > then you are lucky it is only taking an hour to create the
tablespace. If
> > this isn't true, then what type of disk storage are you using?
RAID? IDE?
> > SCSI? All these things can have a factor in how long it takes to
create a
>
> File system: hfs. Hard disks: SCSI.
>
> >
> > tablespace. Rember, the process doesn't just allocate the storage,
the
> > datafile is also "formatted" and segment information is stored in
the
> > system tables.
>
> You are right. We observed that on hpux11.0 datafile creation process
is
> slightly slower under Oracle8 than that under Oracle7. Only on
hpux10.20
> it becomes so slow that it will take 1 hour to create a 1G datafile.
>
> >
> >
> > Ken
>
> Thanks for your response.
>
> bjin
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 28 1999 - 08:28:26 CDT