Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
A free extent in a dictionary-managed tablespace is made up
of a collection of contiguous free blocks.
When allocating new extents to a tablespace segment, the
database uses the free extent closest in size to the
required extent. In some cases, when segments are dropped,
their extents are deallocated and marked as free, but
adjacent free extents are not immediately recombined into
larger free extents. The result is fragmentation that makes
allocation of larger extents more difficult.
Oracle Database addresses fragmentation in several ways:
When attempting to allocate a new extent for a segment, the
database first tries to find a free extent large enough for
the new extent. Whenever the database cannot find a free
extent that is large enough for the new extent, it
coalesces adjacent free extents in the tablespace and looks
again.
The SMON background process periodically coalesces
neighboring free extents when the PCTINCREASE value for a
tablespace is not zero.
If you set PCTINCREASE=0, no coalescing of free extents
occurs. If you are concerned about the overhead of ongoing
coalesce operations of SMON, an alternative is to set
PCTINCREASE=0, and periodically coalesce free space
manually.
Manually Coalesce any adjacent free extens user this
command:
ALTER TABLESPACE <<TABLESPACENAME>> COALESCE
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
How would you determine who has added a row to a table?
Explain the payment term in ar. : oracle accounts receivable
what is semphore explian it?
Give two methods you could use to determine what DDL changes have been made.
as a technical developer in oracle applications which type errors feced in your experience sofar
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
Explain how to close periods in ar. : oracle accounts receivable
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
what are the tools used for oracle 10g in real time.
Is there any link between pr form(purchse requisition)and po form(purchase order)
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
how to replace not in with not exist?
Are These Dff's Flexible?
