var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Parsing queries after SGA flush
We test an oracle 8i database with LoadRunner tools, launching scenario with 50 users, executing the sames scripts.
Before testing a scenario, we flush the SGA.
We test loading database with 50 users executing the same scenario.
I hope some queries to be reused without parsing, but even for dynamical queries, number or execution and number of parse is the same.
Could someone explain me what's happened ?
If you could tell us how are you writting your dynamic sql statement. For one, constructing sql statements on the go shouldn't be considered dynamic sql.
Dynamic queries looks like
select fields1, fields2, fields3
I don't know how they are created. I don't develop this application.
My work is to test application performance, to explain bottlenecks and preconization.