|
-
Yes.
If you put it Automatic allocation, you should check what tables/indexes are getting bigger, not because any problem, just to separate them to another tablespace (TBS1_BIG_DATA) or something, it's not necessary just more beauty :).
If you put it Uniform you should check if you don't overestimate some table, this you can know seeing blocks free after an analyze.
Again, you can create 3 tablespaces in uniform:
Extent:
128K=>Small tables
4M=>Medium tables
128M=>Big tables
Hope it helps.
You can find these in a doc called "How stop defragmenting...."
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
|