Home » Infrastructure » Unix » Slow tablespace creation on HP-UX (10.1.0.4.0, HP-UX B.11.23 U ia64)
Slow tablespace creation on HP-UX [message #317269] Wed, 30 April 2008 05:42
vladandr
Messages: 1
Registered: April 2008
Location: Uzbekistan
Junior Member
RDBMS: 10.1.0.4.0 - 64bit

OS : HP-UX B.11.23 U ia64
all kernel parameters set according with oracle
documentation

Mount Options
for /disk4 : oerror=mwdisable,
delaylog,nodatainlog,
noatime,logiosize=4096,
dev=1f014000

Problem : tablespace creation is too long!

For Example, (create tablespace TEST04 datafile '/disk4/test04.dbf' size 1G;) running 120s.

iostat show following:

c1t0d0 24 3.0 1.0
c1t1d0 16 1.0 1.0
c1t2d0 16 1.0 1.0
c1t3d0 16 1.0 1.0
c1t4d0 8780 304.0 1.0
c1t5d0 0 0.0 1.0

Bun when we just copy any file between disks it more fast(50 Mb/s).

Have you any idea why it is so?
And how tune I/O operations for oracle?
Previous Topic: return code
Next Topic: Oracle 8.1.7.4 on Solaris 10?
Goto Forum:
  


Current Time: Sat Dec 10 03:22:18 CST 2016

Total time taken to generate the page: 0.08635 seconds