What does coalescing a tablespace do?
- 2 Answers
- 18413 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / prashe
Coalescing is only valid for dictionary-managed tablespaces
and de-fragments space by combining neighboring free extents
into large single extents.
| Is This Answer Correct ? | 5 Yes | 5 No |
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
Why more redos are generated when the oracle database is in begin backup mode?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
what is the link between suppliers and banks in ap module in oracle apps? And also query?
Name two files used for network connection to a database.
hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent
You have just compiled a PL/SQL package but got errors, how would you view the errors?
Is there any link between pr form(purchse requisition)and po form(purchase order)
What is mrc and what is its use? : oracle accounts receivable
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
What is database schema?
Oracle General 
