Interested to Buy Any Domain ? << Click Here >> for more details...
What does coalescing a tablespace do?
- 2 Answers
- 19507 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 |
What is an Oracle database Full Backup?
A scenario for amount correction & how to use amount correction functionality in AP invoices
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
What is the Symbol use for Inner Join
Difference between negative and positive adjustments : oracle accounts receivable
How many segment are present in Oracle Manufacturing
A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?
Explain the difference between a hot backup and a cold backup and the benefits associated with each
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views
Oracle General 
