Interested to Buy Any Domain ? << Click Here >> for more details...
What are the ways tablespaces can be managed and how do they
differ?
- 2 Answers
- 6523 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
What types of replication are supported in sql server? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What is a correlated sub-query? : sql server DBA
what is the role of dip user in our database?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
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?
how can you enable flashback feature?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What the different components in replication and what is their use? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
what is ora 24313?what is the procedure to exclude that error?
Why would you call update statistics? : sql server DBA
what is asm?
What are the steps you will take to improve performance of a poor performing query?
what is a user-defined lock?
