Interested to Buy Any Domain ? << Click Here >> for more details...
What does coalescing a tablespace do?
- 2 Answers
- 19581 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 |
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
0 Answers Punjab National Bank,
3. Steps in UAT?
pl help me, i want oracle HRMS training institute address,in chennai
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
When a user process fails, what background process cleans up after it?
What is difference b/w Credit memo and Adjustment in AR.
What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?
key flexfield structure
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
0 Answers Pathway Technologies,
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
how can we send a concurrent program output to the clients through mail or fax give me example.
write a query to find the third maximum salary of a employee.(table:employ col name:salary)
Oracle General 
