1z1-084 무료 덤프문제 온라인 액세스

Examine this output of a query of VSPGA_TAPGET_ADVICE:

Which statements is true'

• A.PGAA_AGGREGATE should be set to at least 800 MB.
• B.With a target of 700 MB or more, all multipass executions work areas would be eliminated.
• C.GGREGATE_TARGET should be set to at least 700 MB.
• D.With a target of 800 MB or more, all one-pass execution work areas would be eliminated.

An Oracle 19c database uses default values for all optimizer initialization parameters.
After a table undergoes partition maintenance, a large number of wait events occur for:
cursor: pin S wait on X
Which command reduces the number of these wait events?

• A.ALTER SYSTEM SET CURSOR_SHARING = FORCE;
• B.ALTER SYSTEM SET CURSOR_SPACE_FOR_TIME - TRUE;
• C.ALTER SYSTEM SET SESSION CACHED CURSORS = 500;
• D.ALTER SYSTEM SET CURSOR_INVALIDATION = DEFERRED;

Multiple sessions are inserting data concurrently into a table that has an LOB column.
At some point in time, one of the sessions cannot find available space in the LOB segment and needs to allocate a new extent.
Which wait event will be raised in the other sessions that need space in the LOB column?

• A.enq: HW - contention
• B.enq: TM - contention
• C.enq: SQ - contention
• D.enq: TX - allocate ITL entry

Which two statements are true about the use and monitoring of Buffer Cache Hit ratios and their value in tuning Database I/O performance?

• A.A 60% cache hit ratio can be observed for database instances which have very good I/O performance.
• B.The performance of workloads that primarily generate full table scans and fast full index scans are always affected by the cache hit ratio.
• C.Both the RECYCLE and KEEP buffer caches should always have a very high cache hit ratio.
• D.The buffer cache advisory view v$db_cache_advice provides advice on cache hit ratios appropriate for the instance workload.
• E.A 99% cache hit ratio can be observed for database instances which have very poor I/O performance.

Which procedure gathers statistics that are always used in the generation of any execution plan?

• A.DBMS_STATS.GATHER_DATABASE_STATS
• B.DBMS_STATS.GATHER_FIXED_ OBJECTS_STATS
• C.DBMS_STATS.GATHER_DICTIONARY_STATS
• D.DBMS_STATS.GATHER_SYSTEM_STATS