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

Your database supports a DSS workload. In an application, a few complex queries that contain multiple functions and expressions are using materialized views. You notice that some queries are performing poorly because they are not benefiting from query rewrites.
Which three actions would you take to improve the performance of queries? (Choose three.)

• A.Use the DBMS_ADVISOR.TUNE_MVIEW procedure to get recommendations about rewriting materialized views.
• B.Use the DBMS_MVIEW.EXPLAIN_REWRITE procedure to analyze why a query failed to rewrite.
• C.Create a SQL Tuning Set (STS) and submit as input to the SQL Access Advisor to generate recommendations about query rewrite and fast refresh for materialized views.
• D.Create an STS and submit as input to the SQL Performance Analyzer to get recommendations about improving the performance of queries.
• E.Use the DBMS_ADVISOR.QUICK_TUNE procedure to analyze queries based on the usage of query rewrite with materialized views.

Examine the parameters set for your database instance:

You notice that for one particular SQL statement, the optimizer generates a new better plan than the plans in the SQL Plan Management Base.
Which action is taken by the optimizer? (Choose the best answer.)

• A.It adds the newly generated plan as an accepted but non-fixed plan.
• B.It adds the newly generated plan as enabled and accepted.
• C.It adds the newly generated plan as enabled but not accepted.
• D.It adds the newly generated plan as a fixed plan, which will be used each time the SQL statement is executed.

Examine the partial TOP 10 Foreground Events by Total Wait Time section of an AWR report:

What should you examine to diagnose the cause of the top three wait events? (Choose the best answer.)

• A.the V$ACTIVE_SESSION_HISTORY view
• B.the Segment Statistics section of the AWR report
• C.the Time Model Statistics section of the AWR report
• D.the SQL statements based on elapsed time from the AWR report
• E.the Latch Activity section

Examine the Load Profile section of an AWR report:

Which two inferences can you derive from the details in this section? (Choose two.)

• A.The values for DB Time and DB CPU imply that the database had a high proportion of idle time during the specified snapshot interval.
• B.The values for Logical reads and Physical reads imply that the number of disk reads per second was less than the total number of DB block reads and consistent gets per second.
• C.The values for SQL Work Area and User calls imply that only sort-based operations were performed.
• D.The values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred quite often.
• E.The values for Redo size and Block changes imply that only updates were performed by transactions.

You are administrating a database on a symmetric multiprocessing (SMP) machines. The database supports a mixed workload. You notice a large number of free buffer waits and buffer busy waits that are affecting the performance of the database. To mitigate the issue, you increase the buffer cache size, but after some time, you notice the same wait events with a high number.
Examine the parameters set for the instance:

Which two actions would you recommend to resolve the issue?

• A.configuring the KEEP buffer pool
• B.decreasing the idle time resource limit in the profile assigned to users
• C.enabling asynchronous I/O for the file system
• D.increasing the value of the DB_FILE_MULTIBLOCK_READ_COUNT parameter
• E.increasing the number of DBWn processes