| IO Advice [message #65131] |
Fri, 14 May 2004 04:20  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
