Answer / ram

tablespaces can be managed in 2 ways 1) Dictionary Managed
2) Locally managed

in DMT data dictionary tables stores the information of free and used extents, for used extents information in dmt tablespace uses sys.uet$ view and free extents information in DMT tablespace stored in sys.fet$

in LMT tablespace, tablespace datafiles maintains own bitmaps @ datafile headers these store the used extents and free extents information.

LMT is preferable, because it won't generate any rollbacks,
dictionary contention is reduced, space wastage removed & fragmentation removed

Answer / kittu

tablespaces can be managed in 2 ways 1) Dictionary Managed
2) Locally managed

In dictionary managed tablespace oracle will take care of tablespace

In locally managed tablespace we need to take care of tablespace

Name three advisory statistics you can collect.

1 Answers  

---

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

what is asm?

0 Answers   Oracle,

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

---

How to start SQL Server in minimal configuration mode?

1 Answers  

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

---

What is dcl? : sql server DBA

0 Answers  

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---