What does coalescing a tablespace do?



What does coalescing a tablespace do?..

Answer / guest

If we find that fragmentation of space in a tablespace is
high (contiguous space on our disk appears as
non-contiguous),we can coalesce any free space using the

ALTER TABLESPACE TABLESPACE_NAME COALESCE ; command

We must have the ALTER TABLESPACE system privilege to
coalesce tablespaces.

Regards
Abhinav Phadnis

Is This Answer Correct ?    17 Yes 1 No

Post New Answer

More DB Administration Interview Questions

How would you determine who has added a row to a table?

4 Answers  


How would you force a log switch?

4 Answers  


What the different topologies in which replication can be configured? : sql server DBA

0 Answers  


how can you record information about current session?

0 Answers   Oracle,


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  






any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,


Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  


Name three advisory statistics you can collect.

1 Answers  


What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  


What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  


What view would you use to look at the size of a data file?

3 Answers  


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  


Categories