Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Logical Storage data blocksextentssegmentstablespaces
Read moreCategory: Database
Functions of the database application inlcude,”creating and processing forms
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Functions of the database application[…]
Read moreAutomatic Memory Management
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Automatic Memory Management Oracle manages[…]
Read moreExtents,”-An extent is a specific number of logicallly contiguous data blocks
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Extents,”-An extent is a specific[…]
Read moreFunctions of the DBMS,”creates databases, tables, and supporting structures, manages database data
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Functions of the DBMS,”creates databases,[…]
Read moreAutomatic shared memory management,”Enables you to exercise more control over the size of the SGA and is the default when automatic memory management is disabled. Oracle will tune the the total SGA to a supplied target size and will also tune the sizes of SGA components. There are few components that take the memory from teh SGA_TARGET parameter, leaving the memory avilable for the auomatically tuned parameters. Following SGA components need to be manually sized. LOG_BUFFER, DB_KEEP_CACHE_SIZE
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Automatic shared memory management,”Enables you[…]
Read moreData blocks,”-At the finest level of granularity
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Data blocks,”-At the finest level[…]
Read moreManual Shared Memory Mangement
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Manual Shared Memory Mangement you[…]
Read moreSegments,”-A set of extents allocated for a user object eg, a table
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Segments,”-A set of extents allocated[…]
Read moreProcess Structure
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Process Structure Client processBackground processServer[…]
Read more