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

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

---

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

---

how can you create a user-defined lock?

0 Answers   Oracle,

---

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers   TCS,

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---