Fred,This sounds like a case of an application/application server performing 'test' parses. Do these sql_ids show up in the awr/statspack reports prior to the application installation? Can you tie these statements back to the new application (program_id in v$sql is a good place to start)?
It sounds like you have a good case for at least opening a support ticket with the vendor. Regards, Daniel Fink -- Daniel Fink OptimalDBA.com - Oracle Performance, Diagnosis, Data Recovery and Training OptimalDBA http://www.optimaldba.com Oracle Blog http://optimaldba.blogspot.com Lost Data? http://www.ora600.be/ Fred Tilly wrote:
Hi All, We just added a new application onto our database server, which had been running smoothly until the new third party application was added. The AWR report which I have summarized below is over a 2 hr period, and the server has 8 x cpu each a quad core and 32GB of memory.Before I push back on the vendor I would link to sanitycheck what I have concluded, which is the application would appear to be parsing more statements than it is actually executing.Parse Calls Executions Parses SQL Id------------ ------------ --------- ------------- 79,285 0 3.17 cugfcrccvdb7w Module: dllhost.exe SELECT VAR_VALUE,CATEGORY_ID FROM VARIABLE65,099 0 2.60 3bh0n0n7f92t6Module: dllhost.exe SELECT OWNER_ID,ENTITY_ID, VAR_ID, VERSION, VAR_TYPE, VAR_VALUE, DISPLAY_NAME, D YNAMIC FROM VARIABLE47,361 0 1.89 ag56wuczvmppxModule: dllhost.exe SELECT OWNER_ID, VAR_ID, VERSION, VAR_TYPE , VAR_VALUE, DISPLAY_NAME, DYNAMIC F ROM FINISHED_JOB_VARIABLE28,582 0 1.14 6aswwzmuc7tcjModule: dllhost.exe SELECT OWNER_ID, ENTITY_ID, VAR_ID, VERSION, VAR_TYPE, VAR_VALUE, DISPLAY_NAME, DYNAMIC FROM VARIABLEThanks Fred.