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

how will you see when the database was started using sql prompt?

2 Answers IBM,

Explain the concept of the DUAL table.

3 Answers

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

2 Answers IBM,

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers IBM,

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers

What purpose does the model database server? : sql server DBA

0 Answers

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers STC,

what do you understand by fine-grained auditing?

0 Answers Oracle,

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers

If we issue alter database begin backup. What happens to database?

2 Answers

For more DB Administration Interview Questions Click Here