OCP 3 SQL Performance Analyzer

Card Set Information

Author:
Tralala
ID:
213622
Filename:
OCP 3 SQL Performance Analyzer
Updated:
2014-05-12 07:31:58
Tags:
OCP SQL Performance Analyzer
Folders:

Description:
OCP 3 SQL Performance Analyzer
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user Tralala on FreezingBlue Flashcards. What would you like to do?


  1. When using SQL Performance Analyzer to test execute SQL in an STS, how many times is each SQL executed?
    Only once
  2. From which three sources can you load an STS to use as input to SQL Performance Analyzer?
    The AWR, cursor cache, or another STS
  3. When using SQL Performance Analyzer to test execute SQL in an STS, are the effects of DDL and DML taken into consideration?
    No
  4. When using SQL Performance Analyzer to test execute SQL in an STS, what is collected for each SQL?
    The execution plan and execution statistics
  5. When using SQL Performance Analyzer to test execute SQL in an STS, is the SQL executed concurrently or serially?
    Serially
  6. When capturing SQL workload to use with SQL Performance Analyzer, which three pieces of information are captured?
    The SQL statement text, the statement's execution context, and the frequency of the SQL statement's execution
  7. What are the steps in a workload capture?
    • Capture SQL workload
    • Execute SQL workload to capture baseline execution data
    • Move SQL workload to test environment
    • Implement proposed system changes
    • Execute SQL workload to capture execution data
    • Analyze differences in SQL Performance
    • Tune regressed SQL statments

What would you like to do?

Home > Flashcards > Print Preview