Re: New application and AWR report advice
From: Daniel Fink <daniel.fink_at_optimaldba.com>
Date: Mon, 22 Sep 2008 07:48:49 -0600
Message-ID: <48D7A241.20508@optimaldba.com>
Date: Mon, 22 Sep 2008 07:48:49 -0600
Message-ID: <48D7A241.20508@optimaldba.com>
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:Received on Mon Sep 22 2008 - 08:48:49 CDT
> 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