| Defragmentation of tables in oracle [message #372108] |
Wed, 10 January 2001 08:40  |
Jagjeet Manocha
Messages: 1
Registered: January 2001
|
Junior Member |
|
|
I was searching on some info on defragmenting a table in oracle.
The information that I need is , say , we have a table with some 10000 rows and we delete some 2000 rows
from that table. Will oracle free up that space for storing the new rows or the programmers needs to execute
some command.
any information on the above asap will be appreciated.
|
|
|
|
| Re: Defragmentation of tables in oracle [message #372113 is a reply to message #372108] |
Wed, 10 January 2001 12:17  |
Andrew again...
Messages: 270
Registered: July 2000
|
Senior Member |
|
|
Oracle usually only marks the records as having been deleted, and the space is only made available for re-allocation once the % of remaining data in the block drops below a certain threshold (a block is usually 8kb). This level usually defaults to 40% and is called PCTUSED, implying that after rows have been inserted into a block, you need to delete around 1/2 of them before any new rows will be inserted into that block. PCTFREE is similar but is used to specify how much free space Oracle will allow in a block - after inserting data - to allow for subsequent updates.
The short answer is that Oracle will sort it out for you. See the documentation for more info...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
