SIEBEL AND SQL performance Analyzer
We are upgrading our Siebel database to 11.2.0.3 following the below Siebel on Exadata white paper. 99% of the SPA results are good but where Siebel uses the front end to restrict the number of rows SPA will return all the rows from the tables. We can easily identify these queries and test them in isolation but does anyone know of a way you can simulate what the front end is doing within the SPA test?
http://www.oracle.com/technetwork/database/features/availability/maa-wp-siebel-exadata-177506.pdf
Thanks