1. Home
  2. Flashcards
  3. Preview

OCP 3 SQL Performance Analyzer

  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
Author
Tralala
ID
213622
Card Set
OCP 3 SQL Performance Analyzer
Description
OCP 3 SQL Performance Analyzer
Updated

  1. Home
  2. Flashcards
  3. Preview