Title: To create a new datafile or to increase a existing datafile.
In
this case anything would do. Better would be to expand the already mentioned
dfiles as the Sixth datafile would be placed on to some H.Disk and then I/O
contention to that disk would increase. Better is to redistribute the load among
the various datafiles.
If you
have one hard disk then it would not matter at all between the two different
scenarios.
Vikas
Khanna
-Original Message-From: Denham Eva
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 16, 2002 1:53
PMTo: Multiple recipients of list ORACLE-LSubject: To
create a new datafile or to increase a existing datafile.
Hello Gurus
Which is the better policy: Say you have five datafiles of 1GB in size each, now the
total freespace is less than 10%. Would it
be wise to increase the datafiles to 2GB or would it be better for the system
to add a sixth datafile?
Would appreciate any views on this point.
Rgds Denham
Eva Oracle DBA
In UNIX Land
On a quiet Night, you can hear
the Windows machines reboot.
DISCLAIMER
This message is for the named person's use only. It
may contain confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If you
receive this message in error, please immediately delete it and all copies of
it from your system, destroy any hard copies of it and notify the sender. You
must not, directly or indirectly, use, disclose, distribute, print, or copy
any part of this message if you are not the intended recipient. TFMC, its
holding company, and any of its subsidiaries each reserve the right to monitor
and manage all e-mail communications through its networks.
Any views expressed in this message are those of
the individual sender, except where the message states otherwise and the
sender is authorized to state them to be views of any such entity.
This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information
please visit www.marshalsoftware.com