Home » RDBMS Server » Performance Tuning » IO Advice
IO Advice [message #65131] Fri, 14 May 2004 04:20 Go to next message
Tomasz
Messages: 13
Registered: May 2004
Junior Member
Hi there

I have this schema:

u01: table, index, system, temp

u02: table, index

u03: temp, table, index

u04: table, redo, table, index

u05: index, table

Would I move index, redo, temp to each volume and separate from tables?

Is it good strategy? When I look in statistics there are huge mobment on index.

My SGA statistics is:

shared pool free memory 1,71%
large pool free memory 8 %
java pool free memory 6,7%

 
Re: IO Advice [message #65133 is a reply to message #65131] Fri, 14 May 2004 08:34 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
one of the biggest myths is that indexes and tables should be separated into different tablespaces. The original recommendation was only aimed at spreading load between different disks. You could just as well have tables and indexes A-I in one TS, J-S in another and T-Z in another. Oracle has some good recommendations on placement of files. Best to search metalink.oracle.com
Previous Topic: Performance of Inline View
Next Topic: SQL-Performance Tuning
Goto Forum:
  


Current Time: Wed Sep 23 10:16:24 CDT 2020