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
Difference between transaction type and transaction sources. : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
Explain how to close periods in ar. : oracle accounts receivable
What is the importance of batch source set up in ar? : oracle accounts receivable
How would you go about increasing the buffer cache hit ratio?
Can we modify approve purchase order?if yes what is navigation?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
where the dff data will be stored
can we use lexical perameter in oracle plsql if yes how
What is the sql query to find the employee who has Nth maximum salary?
What is auto invoicing? : oracle accounts receivable
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
as a technical developer in oracle applications which type errors feced in your experience sofar
How do you create a credit note against an invoice? : oracle accounts receivable
can u pls share responsibilities for production how to environment in odi?and how to generate report ?