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: 25578
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: 25578
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: Move objects between tablespaces
Next Topic: Database Userid Getting locked
Goto Forum:
  


Current Time: Tue Aug 22 02:25:54 CDT 2017

Total time taken to generate the page: 0.29192 seconds