What are the ways tablespaces can be managed and how do they differ?

What are the ways tablespaces can be managed and how do they
differ?

Question Posted / narmada kumari

2 Answers
6527 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the ways tablespaces can be managed and how do they differ?..

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

Is This Answer Correct ?

2 Yes

0 No

What are the ways tablespaces can be managed and how do they differ?..

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

Is This Answer Correct ?

1 Yes

3 No

Post New Answer

More DB Administration Interview Questions

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers

What is checkpoint?

3 Answers Accenture,

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers Patni,

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers

what r the types of backup?

5 Answers CSC,

What happens on checkpoint? : sql server DBA

0 Answers

What the different components in replication and what is their use? : sql server DBA

0 Answers

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers TCS, Wipro,

one datafile is lost in standy side how can you recover that??

2 Answers

For more DB Administration Interview Questions Click Here