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

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

0 Answers  

---

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

---

What is replication? : sql server DBA

0 Answers  

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

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

3 Answers   IBM,

---

Describe what redo logs are.

1 Answers  

---

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

How would you force a log switch?

4 Answers  

---

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?

0 Answers  

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

What is checkpoint?

3 Answers   Accenture,

---