What are the ways tablespaces can be managed and how do they
differ?
- 2 Answers
- 6839 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
what is the last version,the release date of that version and fix pack of ibm db2 udb?
