OraFAQ Forum: Server Administration » create various datafiles or a big file

Home » RDBMS Server » Server Administration » create various datafiles or a big file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create various datafiles or a big file [message #189787]

Sun, 27 August 2006 08:59

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

Report message to a moderator

Re: create various datafiles or a big file [message #189788 is a reply to message #189787]

Sun, 27 August 2006 09:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

more physical devices, more better.
On a single disk, it does not matter.

Report message to a moderator

Re: create various datafiles or a big file [message #189795 is a reply to message #189788]

Sun, 27 August 2006 16:53

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

Report message to a moderator

Re: create various datafiles or a big file [message #189797 is a reply to message #189787]

Sun, 27 August 2006 19:54

BlackSwan
Messages: 26766
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

Report message to a moderator

Previous Topic:	SMTP transient error
Next Topic:	Migrate Oracle Database 10.1 to 10.2 on Solaris 64 bit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 21 12:58:34 CST 2025