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

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

---

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

---

Name three advisory statistics you can collect.

1 Answers  

---

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

---

What is dcl? : sql server DBA

0 Answers  

---

How can we see the database version in os level

6 Answers   Oracle,

---

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

---

why we use cursors

1 Answers  

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

How to make a replica of existing oracle server to another server?

3 Answers  

---

how can you create a user-defined lock?

0 Answers   Oracle,

---

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---