|
-
Originally posted by rohitsn
Hi,
Yes increasing the value of freelists will help .Give this parameter at the object level creation.
Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
[email protected]
Actually Rohit, it does not matter at what time you define the number of freelists. You can always increase the number of freelists:
Code:
alter table XXX storage(FREELISTS 6);
On the other hand FREELIST GROUPS can be defined only at creation time.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: [email protected]
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
|