Home » RDBMS Server » Performance Tuning » How to place many datafile on large tablespace? (9.2i, OS AIX)
How to place many datafile on large tablespace? [message #276872] Fri, 26 October 2007 10:08 Go to next message
sailor_man
Messages: 4
Registered: October 2007
Location: POLAND
Junior Member
Hi,
I've Oracle database with storage on fast matrix. There I have three filesystems. On first filesystem I've all datafiels four large tablespaces.

I want to add next datafiles on tablespace AA. What is the best solution to do it:
1) Add some datafile to first filesystem, add next some datafile to second filesystem (datafiles tablespace AA will be on two filesystems)
2) Move exist datafile to second filesystem, add next some datafile to second filesystem (datafiles tablespace AA will be on one filesystems)

Please help me, which solution is better for performance?

Thanks a lot
Krzysztof
Re: How to place many datafile on large tablespace? [message #276882 is a reply to message #276872] Fri, 26 October 2007 10:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In the latest versions, files are used in a round robin way.

Regards
Michel
Re: How to place many datafile on large tablespace? [message #277176 is a reply to message #276872] Mon, 29 October 2007 02:50 Go to previous messageGo to next message
sailor_man
Messages: 4
Registered: October 2007
Location: POLAND
Junior Member
I use ORACLE 9.2i.
Re: How to place many datafile on large tablespace? [message #277185 is a reply to message #277176] Mon, 29 October 2007 03:21 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also.

Regards
Michel
Previous Topic: hint: first_rows
Next Topic: difference between locking and disabling statistics
Goto Forum:
  


Current Time: Fri Dec 02 21:07:20 CST 2016

Total time taken to generate the page: 0.05902 seconds