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
6676 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 replication? : sql server DBA

0 Answers

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers

What is dbcc? : sql server DBA

0 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

Explain about your sql server dba experience? : sql server DBA

0 Answers

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers

Why would you call update statistics? : sql server DBA

0 Answers

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

4 Answers Wipro,

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers IBM,

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers HSBC,

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

0 Answers

For more DB Administration Interview Questions Click Here