What are the ways tablespaces can be managed and how do they
differ?
- 2 Answers
- 5828 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
how can you initialize log miner?
what do you understand by fine-grained auditing?
What are the steps you will take to improve performance of a poor performing query?
Can you redefine a table online?
How would you go about verifying the network name that the local_listener is currently using?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
how can you create a user-defined lock?
what is asm?
What authentication modes does sql server support? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
How can you control the amount of free space in your index pages? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
