Latest Answer : Locally Managed Tablespaces Include the following Benefits:1.Free extents are managed in the Tablespace.2.Bitmap is used to record free extents.3.Each bit corresponds to a block or a group of block.4.Bit value indicates free or used. ...
Latest Answer : Advantages in using Locally Managed Tablespaces:Because locally managed tablespaces do not record free space in data dictionary, it reduces contention on these tables. Local management of extents automatically tracks adjacent free space, eliminating the ...
What are the advantages of data definition language (DDL) statements against a partitioned table with the UPDATE GLOBAL INDEXES clause?
What is the command issued by the DBA to protect the primary database against data loss and data divergence?
What is the reason for having poor database performance if low value is set for the parameter FAST_START_MTTR_TARGET?
What are the sequences of steps performed to process a request for a server process in the Oracle Shared Server architecture?
Where does the script written using RMAN command gets stored and how to display the commands used in the script?
How can one check whether the RMAN repository information is synchronized with the actual files that exist on disk?
What is the type of recover used to recover an archived log that is lost or corrupted in the process of performing media recovery?