Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.3 major structures in Oracle[…]
Read moreAuthor: mfadmin
how many databases associated with an instance?
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.how many databases associated with[…]
Read moredefine connection
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.define connection Connection: Communication between[…]
Read moredefine Session
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.define Session Session: Specific connection[…]
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 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 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 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 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 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 more