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 |
What are the steps you will take, if you are tasked with securing an SQL Server?
what is logical system in sap basis
How would you determine who has added a row to a table?
What authentication modes does sql server support? : sql server DBA
How would you determine the time zone under which a database was operating?
What is the difference between dropping a database and taking a database offline? : sql server DBA
How would you determine what sessions are connected and what resources they are waiting for?
Give two examples of how you might determine the structure of the table DEPT.
How do you add a data file to a tablespace?
which background process invoke at the time of upgradation tell me???
what is a user-defined lock?
What does coalescing a tablespace do?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)