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 the different topologies in which replication can be configured? : sql server DBA
what is the difference between hot backup n rman backup?
What is replication? : sql server DBA
Explain the use of setting GLOBAL_NAMES equal to TRUE.
hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table
Describe what redo logs are.
How would you determine what sessions are connected and what resources they are waiting for?
what is the difference between catalog & nocatalog?
How would you force a log switch?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
How to determine the service pack currently installed on SQL Server?
What is checkpoint?
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)