최신 1z1-064 무료덤프 - Oracle Database 12c: Performance Management and Tuning

A. to find the amount of Program Global Architecture (PGA) memory being currently consumed by a session

B. to find the exact number of executions of a specific query in a session in the last two minutes

C. to investigate intermittent performance problems in a session, only when the problem lasted less than five minutes in the last twelve hours

D. to identify a scheduler job that is not responding

E. to identify which module in an application was being executed in a session

A. Increase the size of the temporary tablespace or make it autoextensible.

B. Increase the size of the database buffer cache.

C. Enable Automatic Segment Space Management (ASSM) for the undo tablespace.

D. Increase the size of the undo tablespace and enable undo retention guarantee.

E. Enable temporary undo.

A. Create it in a locally managed tablespace with manual segment space management.

B. Create it in a locally managed tablespace with a bigger nonstandard block size and ASSM enabled.

C. Create it in a locally managed tablespace with ASSM enabled and assign a high value for the PCTFREE attribute.

D. Create it in locally managed tablespace with ASSM enabled and an additional freelist.

A. The ROWS column indicates the cardinality of each operation and is always calculated by dividing the total number of rows in the table by the number of distinct values in the column used in the WHERE clause predicate.

B. A HASH JOIN in the Operation column always implies that two tables are joined by using an equijoin.

C. An INDEX UNIQUE SCAN in the Operation column always implies that only one row will be returned.

D. A TABLE ACCESS FULL in the Operation column for a query with a WHERE clause occurs only if no index exists for the filter column.

E. The cost of the entire plan is indicated by the line with Id 0 and always includes both I/O and CPU resources.

A. to capture AWR data for a specified contiguous time period on an ongoing basis

B. to capture AWR data for a scheduled job that runs every day over a specified period of time

C. to capture AWR data during a system test that is scheduled for a weekend

D. to capture user activity information for a consumer group over a specified period of time

E. to capture statistics performance variation over a specified period of time

A. Create a temporary tablespace group and assign it to users.

B. Increase the value of the PGA_AGGREGATE_TARGET parameter.

C. Increase the size of the large pool.

D. Create another temporary tablespace and assign it to users.

E. Increase the value of the PGA_AGGREGATE_LIMIT parameter.

F. Enable temporary undo.

A. A better execution plan may be found for the SQL statements and can be evolved manually.

B. New SQL plan baselines might be generated automatically for the repeatable SQL statements.

C. New execution plans generated will always be added to the SQL plan baselines as fixed plans.

D. New execution plans cannot be evolved until execution plans from the previous version are dropped.

E. New execution plans generated will always be added to the SQL plan baselines as accepted plans.

A. Assign profiles to users running the batch operations and make sure that a priority is set for resource limits in profiles.

B. Create database services for the applications, assign individual sessions created by the applications to consumer groups, and then set a priority.

C. Create database services for the applications, create a job class associated with the service, batch the jobs, and then create jobs by using the job class.

D. Create database services for the applications and assign different profiles to the sessions to set a relative priority for resource usage.

A. Reducing DB time allows a database instance to support more user requests by using the same resources.

B. DB time includes the time spent on client processes and background processes.

C. DB time cannot exceed the maximum number of concurrent sessions multiplied by the actual elapsed time for each session.

D. DB time cannot exceed the total elapsed time (walk clock time) since the database instance started.

E. DB time is always greater than or equal to the DB CPU time.

A. to identify SQL statements whose performance may have regressed due to a hardware upgrade

B. to analyze the impact of network and interconnect changes on database workload

C. to identify SQL statements that require SQL profiles

D. to identify SQL statements in an application whose performance may have regressed due to migration from Oracle Database 11g to 12c

E. to analyze the impact of using bind variables for syntactically similar SQL statements

F. to analyze the impact of new indexes and materialized views on the SQL statements executed by an application