1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / narmada kumari

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 a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

1 Answers  

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  

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

1 Answers  

How would you go about increasing the buffer cache hit ratio?

2 Answers  

Where would you look for errors from the database engine?

1 Answers   IBM,

What is replication? : sql server DBA

1 Answers  

What is dbcc? : sql server DBA

1 Answers  

What are the different ways you can create databases in sql server? : sql server DBA

1 Answers  

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

what functionality does oracle provide to secure sensitive information?

1 Answers   Oracle,

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories