Saved Bookmarks
| 1. |
What Is The Difference Between Dictionary Managed Tablespace And Locally Managed Tablespace? |
|
Answer» In dictionary managed tablespace, FREE block INFORMATION is maintained in data dictionary cache there by increases IO. In locally managed tablespace, the same information is maintained in datafile header itself there by reducing the IO. HENCE LMT is BETTER than DMT. In dictionary managed tablespace, free block information is maintained in data dictionary cache there by increases IO. In locally managed tablespace, the same information is maintained in datafile header itself there by reducing the IO. Hence LMT is better than DMT. |
|