Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.what is LRU algorithm least[…]
Read moreLatest Posts
The Database Buffer Cache contains what?,”found in the SGA.Holds copies of data blocks that are read from data filesContains keep pool, recycle pool
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review. The Database Buffer Cache[…]
Read moredescribe the Reserved Pool
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.describe the Reserved Pool found[…]
Read moredescribe the Sever Results Cache,”found in the shared pool in SGA.contains the SQL query result cache and PL/SQL function result cache, which share the same infrastructure. The server result cache contains result sets
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.describe the Sever Results Cache,”found[…]
Read moredescribe the Shared SQL area
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.describe the Shared SQL area[…]
Read moredescribe the data dictionary,”the data dictionary is found in the Shared pool in the SGA. It is both in the data dictionary cache (row cache: holds data as rows instead of buffers) and in the library cache.It is a collection of database tables and views containing reference info about the database, its structures
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.describe the data dictionary,”the data[…]
Read moreShared pool contains what?,”the shared pool contains the library cache and Shared SQL area, the data dictionary cache
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Shared pool contains what?,”the shared[…]
Read moredescribe the PGA,”Program Global Area (PGA) is a memory region that contains data and control information for each server process. An Oracle server process services a client’s requests. Each server process has its own private PGA that is allocated when the server process is started. Access to the PGA is exclusive to that server process
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.describe the PGA,”Program Global Area[…]
Read moreThe SGA contains what data structures,”shared pool, database buffer cache, redo log buffer, large pool, java pool, streams pool
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.The SGA contains what data[…]
Read moretwo basic memory structures associated with an instance
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.two basic memory structures associated[…]
Read more