Hi,
The following link has the procedure to convert temp files to qio files..
http://support.veritas.com/docs/233722
We have converted our temp files to qio files and I think from performance
point of they should be converted to qio.
Mohammed Ahsanuddin
Oracle DBA
-Original Message-
Hi Kathy,
Here is an excerpt from the Veritas Admin Guide.
Chapter 3, Using VERITAS Quick I/O P69
Handling Oracle Temporary Tablespaces and Quick I/O
You cannot convert temporary tablespaces using regular files to Quick I/O
files. By
default, qio_getdbfiles skips any tablespaces marked
Kathy,
We are using Veritas Quick IO on our Solaris Box 6500 with
Oracle Apps 11.5.6 on 8.1.7.2 database.
Right now we do not have the temp files converted to quick io
and wonder if we should. The guy who installed Quick IO
didn't seen to think we could but he was a pretty junior
Thanks but
The question was not HOW but SHOULD they be quick ioed.
I am asking for your opionions on whether Temp should be or not.
Kathy
Confidential
This e-mail and any files transmitted with it are the property
of Belkin Components and/or its affiliates, are confidential,
and are
we are using the quick I/O and as well as cached quik I/O also.
I had configured this a quite long time ago I have forgotten about temp
files issues which u people are talking about.
But We did have issues by just using quick I/O cause it acts like a cooked
raw file system and hence is write
1* Seems to have improved our read times. But I haven't really beachmarked it since
we did this
and a lot of tuning at the same time.
2* Yes
3* Yes we put in procedures so that you extend the file via qio
we aren't giving the file more space on the disk. We are just growing as we go.
Kathy,
The question was not HOW but SHOULD they be quick ioed.
I am asking for your opionions on whether Temp should be or not.
I believe the problem is with sparse files (that are created by CREATE
TEMPORARY TABLESPACE ...) since QIO cannot handle them. So, I would create
(and use) a
I just was wondering if you gain anything by putting TEMP on Quick IO or not. I
understand the issues. We are probably going to QIO them to see if it buys us
anything.
I will check out Metaclunk.
Thanks Arun for the tip about Cached QIO. We were going to tinker with that as well.
We
Ed,
I would be interested in getting a copy of your test scripts to try it out
on our setup. Solaris 8, veritas DBed 2.2 and Oracle 8.1.7.
Our performance has increased since switching to quick io, but that also
included a major application overhaul, and new disk layout and an upgrade
to