Re: Create Tblspace kills DEC Alpha...

I believe that it is a common problem with Unix based Oracles. AIX does the same (or at least it used to.)

Its because Oracle explictly writes each data block in the tablespace (to prevent getting files with 'holes' in them), and uses performance enhancements in many unixes to queue big disk writes direct to the disks.

Best that I can suggest is to set up a cron job to do the tablespace creates in the silent hours, and reuse tablespaces wherever possible (ie don't drop the TS, just offline it, or keep the data files and use the 'reuse' option on create tablespace.)

-- 
Miles Thomas
Logica UK Ltd
thomasm "at" logica "dot" com
The above are personal opinions, and are
not necessarily the opinions of my employer.


Jerry Murr <jdm2_at_lsdn.ksc.nasa.gov> wrote in article
<3368D471.5182_at_lsdn.ksc.nasa.gov>...


> Here's one that has out local UNIX and Oracle folks stumped:

> 

> Oracle7 Server Release 7.3.2.2.0 running on Digital UNIX V4.0B.

> 

> When we execute a create tablespace command, the entire machine

> (DEC Alpha) slows down to the point we get calls from people 

> wondering what is wrong with the machine - Unix commands as

> well as Oracle commands run significantly slower.

> 

> Anyone out there tackled this one yet?  Oracle blames DEC; Dec 

> points the finger at Oracle.  I really need a solution.

> 

>                         Thanks in advance... Jerry

>                           Jerry.Murr-1_at_ksc.nasa.gov

>