Home » RDBMS Server » Server Administration » create various datafiles or a big file
create various datafiles or a big file [message #189787] Sun, 27 August 2006 08:59 Go to next message
mostafa71
Messages: 18
Registered: May 2005
Junior Member

hi,

I am migrating database to 10g and I want to organize the data.
So what is better, create various datafiles or a big file in a tablespace?

regareds
mostafa71
Re: create various datafiles or a big file [message #189788 is a reply to message #189787] Sun, 27 August 2006 09:36 Go to previous messageGo to next message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
more physical devices, more better.
On a single disk, it does not matter.
Re: create various datafiles or a big file [message #189795 is a reply to message #189788] Sun, 27 August 2006 16:53 Go to previous messageGo to next message
mostafa71
Messages: 18
Registered: May 2005
Junior Member

hi,
can I have more details I will use HP UX 64bit with EVA storage (7 Disks) stripe the data in all disks
thanks
Re: create various datafiles or a big file [message #189797 is a reply to message #189787] Sun, 27 August 2006 19:54 Go to previous message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
On a single logical volume, it does not matter.
All the I/O does down a single channel/path
Previous Topic: SMTP transient error
Next Topic: Migrate Oracle Database 10.1 to 10.2 on Solaris 64 bit
Goto Forum:
  


Current Time: Tue Dec 06 00:24:21 CST 2016

Total time taken to generate the page: 0.06602 seconds