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
6622 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

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers

Give two examples of referential integrity constraints.

2 Answers

How can you enable a trace for a session?

1 Answers

How many memory layers are in the shared pool?

3 Answers

what is the use of recording information about current session?

0 Answers Oracle,

How can you gather statistics on a table?

3 Answers

Query processing is slow(eg select query)how will u solve that

3 Answers TCS,

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

1 Answers

what is the purpose of catlaog in oracle rman?

2 Answers Value Labs,

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers

now one user in online.now i want drop him..how do u drop him?

4 Answers Wipro,

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers Infosys,

For more DB Administration Interview Questions Click Here