3 Months Free Update
3 Months Free Update
3 Months Free Update
Buffer cache access is too frequent when querying the SALES table. Examine this command which executes successfully:
ALTER TABLE SALES SHRINK SPACE;
For which access method does query performance on sales improve?
You use SQL Tuning Advisor to tune a given SQL statement.
The analysis eventually results in the implementation of a SQL Profile.
You then generate the new SQL Profile plan and enforce it using a SQL PlanBaselinebut forget to disable the SQLProfile and a few days later you find out that the SQL Profile is generating a new execution plan.
Which two statements are true?
For which two actions can SQL Performance Analyzer be used to assess the impact of changes to SQL
performance?
Database performance has degraded recently.
index range scan operations on index ix_sales_time_id are slower due to an increase in buffer gets on sales table blocks.
Examine these attributes displayed by querying DBA_TABLES:
Now, examine these attributes displayed by querying DBA_INDEXES:
Which action will reduce the excessive buffer gets?
Which procedure gathers statistics that are always used in the generation of any execution plan?
Users complain about slowness and session interruptions. Additional checks reveal the following error in the application log:
Which file has additional information about this error?
A Standard Edition production database has performance problems for two hours on the same day each week.
Which tool must you use to diagnose the problem?
SGA_TARGET and PGA_AGGREGATE_TARGET are configured to nonzero values.
MEMORY_target is then set to a nonzero value but memory_MAX_TARG£T is not set.
Which two statements are true?
A)
B)
C)
D)
E)
F)
G)
Examine this output of a query of VSPGA_TAPGET_ADVICE:
Which statements is true'
A database supporting a mixed workload is hosted on a server with 64 CPUs.
A large number of free buffer waits and buffer busy waits occur affecting performance.
The buffer cache size was then increased but after a few hours, the same wait events occur more often than before the change.
Examine these parameter settings:
Which two actions can help reduce the number of these waits7
Examine this statement and its corresponding execution plan:
Which phase introduces the CONCATENATION step?