최신 1z1-064 무료덤프 - Oracle Database 12c: Performance Management and Tuning
In your database, the locally managed tablespace, USERS, has the default space usage alert set to 85% for the warning level and 97% for the critical level.
Which two statements are true? (Choose two.)
Which two statements are true? (Choose two.)
정답: B,C
In your database, supporting an OLTP workload, the SALES table is range-partitioned on the SALES_DATE column. A new partition is created every quarter and is frequently used for updates and queries. You recently noticed degraded performance of queries on a new partition due to stale statistics. A local partitioned index exists on the SALES_DATE column.
What would you recommend to improve performance?
What would you recommend to improve performance?
정답: D
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.)
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
Your database supports multiple applications. The applications run on the middle tier and use connection pooling for connecting to the database.
You notice that the sessions created by the applications are competing for resources. You want to statistically measure the workload and set priorities.
What action must you perform to achieve this? (Choose the best answer.)
You notice that the sessions created by the applications are competing for resources. You want to statistically measure the workload and set priorities.
What action must you perform to achieve this? (Choose the best answer.)
정답: D
Which three statements are true about the TEST EXECUTE method of the SQL Performance Analyzer?
정답: B,D,E
You are administrating a database that supports a DSS workload. Syntactically similar queries using joins and aggregate functions are frequently executed by users to fetch data from remote databases by using database links.
Which three tasks should you perform to improve the performance of these queries?
Which three tasks should you perform to improve the performance of these queries?
정답: E,F,G
Examine the parameters set for a database instance:
An application performs a large number of identical queries on small lookup tables very frequently. Users complain about the slow response time of queries on these tables. On investigation, you notice that buffers are getting aged out of the buffer cache. To mitigate the issue, you increase the value of the SGA_MAX_SIZE and SGA_TARGET parameters, but after some time, you notice the same issue again.
Which two would you recommend as long-term solutions for this issue? (Choose two.)
An application performs a large number of identical queries on small lookup tables very frequently. Users complain about the slow response time of queries on these tables. On investigation, you notice that buffers are getting aged out of the buffer cache. To mitigate the issue, you increase the value of the SGA_MAX_SIZE and SGA_TARGET parameters, but after some time, you notice the same issue again.
Which two would you recommend as long-term solutions for this issue? (Choose two.)
정답: B,E
You plan to upgrade your production database from Oracle Database 11g to 12c and also to introduce new objects to the database. You also want to upgrade the hardware. You have already created a test system with the upgrades to be made to the production database. As part of the testing, you want to:
analyze and compare the overall database workload with concurrency and transaction characteristics find SQL statements that might get regressed because of the upgrade analyze execution plans for SQL statements for which performance might get regressed analyze the impact of new schema objects on database performance Which two tools would you recommend to achieve the objective? (Choose two.)
analyze and compare the overall database workload with concurrency and transaction characteristics find SQL statements that might get regressed because of the upgrade analyze execution plans for SQL statements for which performance might get regressed analyze the impact of new schema objects on database performance Which two tools would you recommend to achieve the objective? (Choose two.)
정답: A,F
Examine the query and its output:
Which two inferences can be definitely derived from this output? (Choose two.)
Which two inferences can be definitely derived from this output? (Choose two.)
정답: A,C
You recently joined a new team administering a database.
You notice that full table scans are performing poorly compared with full table scans on the databases you administered in a previous job.
You decide that performance problems are caused by a misconfiguration of factors affecting full table scans.
Which three factors should you investigate to determine the cause of the poorly performing Full Table Scans (FTS)? (Choose three.)
You notice that full table scans are performing poorly compared with full table scans on the databases you administered in a previous job.
You decide that performance problems are caused by a misconfiguration of factors affecting full table scans.
Which three factors should you investigate to determine the cause of the poorly performing Full Table Scans (FTS)? (Choose three.)
정답: B,C,D