Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to
analyze impact on the performance of SQL statements.
A.
Change in the Oracle Database version
B.
Change in your network infrastructure
C.
Change in the hardware configuration of the database server
D.
Migration of database storage from non-ASM to ASM storage
E.
Database and operating system upgrade
Explanation:
Oracle 11g/12c makes further use of SQL tuning sets with the SQL Performance
Analyzer, which compares the performance of the statements in a tuning set before and after a
database change. The database change can be as major or minor as you like, such as:
* (E) Database, operating system, or hardware upgrades.
* (A,C) Database, operating system, or hardware configuration changes.
* Database initialization parameter changes.
* Schema changes, such as adding indexes or materialized views.* Refreshing optimizer statistics.
* Creating or changing SQL profiles.
A,C,E
A,C,E – TRUE
Examples of common system changes for which you can use the SQL Performance Analyzer include:
– Database upgrade, patches, initialization parameter changes
– Configuration changes to the operating system, hardware, or database
– Schema changes such as adding new indexes, partitioning or materialized views
– Gathering optimizer statistics.
– SQL tuning actions, for example, creating SQL profiles
– Database consolidation testing using Oracle Multitenant Databases or schema consolidation methods
http://www.google.pl/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&cad=rja&uact=8&ved=0CDwQFjAB&url=http%3A%2F%2Fwww.oracle.com%2Ftechnetwork%2Fdatabase%2Fmanageability%2Freal-application-testing-wp-12c-1896131.pdf%3FssSourceSiteId%3Docomen&ei=RpfkU6C-B6OL7AaJ2oGoAQ&usg=AFQjCNEfz-uBPkr1xrmDxup3r3j8q9CyCg&sig2=MQu-skppnW19D4rUse8e_w&bvm=bv.72676100,d.bGE
ACE
ACE – OK
Database upgrade
Configuration changes to the operating system, hardware, or database
Database initialization parameter changes
Schema changes, for example, adding new indexes or materialized views
Gathering optimizer statistics
Validating SQL tuning actions, for example, creating SQL profiles or implementing partitioning
http://docs.oracle.com/cd/B28359_01/server.111/e12159/spa.htm#RATAD101
ACE
SQL Performance Analyzer enables you to assess the performance impact of any system change resulting in changes to SQL execution plans and performance characteristics. Examples of common system changes for which you can use SQL Performance Analyzer include:
Database upgrade (A, E)
Configuration changes to the operating system, hardware, or database (C and E)
Database initialization parameter changes
Schema changes, for example, adding new indexes or materialized views
Gathering optimizer statistics
Validating SQL tuning actions, for example, creating SQL profiles or implementing partitioning.
A,C,E
I blog frequently and I really appreciate your information. The article has really peaked my interest. I’m going to take a note of your website and keep checking for new information about once a week. I subscribed to your Feed too.|
This article is really a pleasant one it helps new net users, who are wishing for blogging.|