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 |
How would you determine who has added a row to a table?
How would you force a log switch?
What the different topologies in which replication can be configured? : sql server DBA
how can you record information about current session?
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
any body know about orawaves do they really provide placements in their unique placement program
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Name three advisory statistics you can collect.
What is the difference between the SQL Loader and IMPORT utilities?
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
What view would you use to look at the size of a data file?
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