-
need for creating new datafiles
hi friends, in our database, some of the tablespaces with
datafiles size exceeds
one giga byte. does it effetct peformance.?
shoud i create new tablespace space and datafile to
store the further objects and data?
thanks
-
1gb?
no, it doesnt affect performance - we arent in the 1970's anymore
-
Originally Posted by madhugp
hi friends, in our database, some of the tablespaces with
datafiles size exceeds
one giga byte. does it effetct peformance.?
thanks
If this size increases every - day, week you need to worry and analyze why?
Size does matter if you have less disk space, otherwise....
"What is past is PROLOGUE"
-
Prolly a more important thing to worry about is recovery. Bigger data files take longer to recover.
On the other hand, fewer files are somewhat easier to manage.
My suggestion: use ASM with OMF; set it .. and forget it!
Ken
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|