| 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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
