-
Hi,
I've just got to administer this Oracle 7.3.4 database. I found that the Max extent for most of the tables is huge, it's 2,147,483,645
The question here is, would that affect the performance or would it have any affect on the database in anyway ?
Thanx
DB_Lover
-
Basically, that number signifies that the segment has maxextents set to unlimited. In general, this is not a bad thing. See various threads on this forum detailing Fragmentation for more information...
Jeff Hunter
-
but is it a good practise to set it at 2,147,483,645?
-
No, don't set it to the number. Set MAXEXTENTS UNLIMITED. In general, yes, it is good practice.
Jeff Hunter
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
|