RE: I/O bound on tablespace for one partition

2002-06-10 Thread VIVEK_SHARMA 
Title: Message



 
What 
OS Stripe Width would you Consider Ideal for respective Types (OLTP & Batch) 
of Applications ?
What 
is your nature of Application ?
Any 
Good Docs Links on the Same ?
 
Thanks
 -Original 
Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 07, 2002 
12:54 AMTo: Multiple recipients of list ORACLE-LSubject: 
RE: I/O bound on tablespace for one partition

  

  
  
  Okay 
  guys,
   
  We are using OS 
  striping.  However, for reasons of partition elimination, etc. I 
  broke up 80 years of data into separate years.  Now one of the 
  tablespaces is being hit 70% of the time.  Given OS striping and that 
  I can't really stripe manually (very ltd.) is it worth moving partitions 
  into multiple tablespaces? 

RE: I/O bound on tablespace for one partition

2002-06-06 Thread Paula_Stankus 
Title: Message




  


Okay 
guys,
 
We are using OS 
striping.  However, for reasons of partition elimination, etc. I broke 
up 80 years of data into separate years.  Now one of the tablespaces is 
being hit 70% of the time.  Given OS striping and that I can't really 
stripe manually (very ltd.) is it worth moving partitions into multiple 
tablespaces?