Re: New application and AWR report advice

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 sanity 
check 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 VARIABLE
65,099 0 2.60 3bh0n0n7f92t6 

Module: dllhost.exe
SELECT OWNER_ID,ENTITY_ID, VAR_ID, VERSION, VAR_TYPE,
VAR_VALUE, DISPLAY_NAME, D

YNAMIC FROM VARIABLE
47,361 0 1.89 ag56wuczvmppx 

Module: dllhost.exe
SELECT OWNER_ID, VAR_ID, VERSION, VAR_TYPE , VAR_VALUE,
DISPLAY_NAME, DYNAMIC F

ROM FINISHED_JOB_VARIABLE
28,582 0 1.14 6aswwzmuc7tcj 
Module: dllhost.exe

SELECT OWNER_ID, ENTITY_ID, VAR_ID, VERSION, VAR_TYPE,
VAR_VALUE, DISPLAY_NAME,
DYNAMIC FROM VARIABLE
Thanks Fred. 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: