Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Functions of the DBMS,”creates databases,[…]
Read moreTag: db
Automatic 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 morePhysical Structures,”Data Files
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Physical Structures,”Data Files OS blocks”
Read moreAre logical and physical structure of oracle completely separate
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Are logical and physical structure[…]
Read moreTablespaces,”Tablespaces are the first level of logical organization of your physical storage. Each tablespace is responsible for organizing one or more data files. Typically, each tablespace might start attached to one data file, but as the database grows and your files become large
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Tablespaces,”Tablespaces are the first level[…]
Read moreSGA,”is a group of shared memory structures that contain data and control information for a single oracle database instance. It is shared by all server and background processes, eg
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.SGA,”is a group of shared[…]
Read moreSegments,”Segments are the next logical storage structure next to tablespaces. Segments are objects in the database that require physical storage and include the following:TablesIndexesMaterialized viewsPartitionsWhenever you create a segment
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Segments,”Segments are the next logical[…]
Read more