PCTFREE and PCTUSED [message #393306] |
Sat, 21 March 2009 04:43 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
nandusb
Messages: 4 Registered: March 2009 Location: INDIA
|
Junior Member |
|
|
hi,
Currently I am working on 10g warehouse database,
I want to set PCTFREE and PCTUSED for a table
which will not have any insert and update operation
Only salact operation will be performed
but in future it is most likely that some delete operations might be performed.
So please sugest me value for PCTFREE and PCTUSED and also for INITRANS and INITMAX
Thanks,
|
|
|
|
|
|
|
Re: PCTFREE and PCTUSED [message #397122 is a reply to message #397118] |
Thu, 09 April 2009 02:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | when I looked the data block (used and pctfree) it shows me almost full. Like
|
Copy and paste what you did, don't explain it.
Quote: | so what should I do
|
Nothing. Why do you think there is something to do? What is your concern?
Regards
Michel
|
|
|