I think BC
B:
Oracle Real Application Testing ... enables businesses to fully assess the outcome of a system changes in test or production.
Oracle Real Application Testing is comprised of the following features: Performance Analyzer (SPA), SPA ...
C:
SQL Performance Analyzer executes the SQL statements captured in the SQL Tuning Set and generates execution plans and execution statistics for each statement
For D , though group (summary) view is shown during analysis, i dont think that what they mean
by fine grained
B & C:
https://docs.oracle.com/en/database/oracle/oracle-database/19/ratug/introduction-to-sql-performance-analyzer.html#GUID-F07105CA-0DFA-4102-A8FE-1C11AD201528
Answer is B and C
B --> Helps users predict the impact of system changes on SQL workload response time
C--> SQL Performance Analyzer compares the performance of SQL statements before and after the change and produces a report identifying any changes in execution plans or performance of the SQL statements.
I will go with B D.
SPA offers fine grained analysis for each SQL. See the doc below
https://www.oracle.com/technetwork/database/manageability/spa-ow08-131564.pdf
*But not as a group
B:
SQL Performance Analyzer measures the impact of system changes both on the overall execution time of the SQL workload and on the response time of every individual SQL statement in the workload. By default, SQL Performance Analyzer uses elapsed time as a metric for comparison.
I vote for BC
B is correct.
i'm not pretty sure if D is correct, as i understand that fine-grained analsys is offered by individual SQL not as group.
Anyone?
https://www.oracle.com/a/otn/docs/enterprise-manager/ds-19c-oracle-real-application-testing.pdf
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
dacoben415lywenw
Highly Voted 3 years, 7 months agokaka321
Most Recent 6 months, 3 weeks agoScottL
9 months, 1 week ago_gio_
9 months, 2 weeks agovkra
11 months, 4 weeks agoDBA4All
1 year, 8 months agokameni
2 years, 5 months agoavanand
3 years, 5 months agomihanik
3 years, 4 months agocerebro2000x
3 years, 5 months agoveginha
3 years, 7 months ago