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: 65144
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: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also.

Regards
Michel
Previous Topic: why ESTD_PHYSICAL_READS and ESTD_PHYSICAL_READ_TIME are not change in proportional in v$db_cache_a
Next Topic: Performance impact on Oracle
Goto Forum:
  


Current Time: Sat Aug 19 19:30:53 CDT 2017

Total time taken to generate the page: 0.23344 seconds