Powerhouse 8.43D and Oracle performance

[Viet Nguyen]

Adrian,

I would get the new version - run it in test mode first to confirm that
the problem is solved.

Viet.

 

-----Original Message-----
From: powerh-l-bounces+vnguyen=wsboces.org at lists.sowder.com
[mailto:powerh-l-bounces+vnguyen=wsboces.org at lists.sowder.com] On Behalf
Of Adrian.Hudson at eu.averydennison.com
Sent: Friday, January 04, 2008 7:24 AM
To: powerh-l at lists.sowder.com
Cc: Nienke.Gijsen at eu.averydennison.com
Subject: Powerhouse 8.43D and Oracle performance

 


Hi All, 

We are running 8.43D1 on an AIX server with Oracle 10g and have noticed
performance degradation caused by some inefficient 'behind the scenes'
SQL code generated by Powerhouse. The code in question relates to
Powerhouse figuring out which procedures a user has rights to by
querying the user_arguments object. 

Without going into the technical specifics, we logged a call with Cognos
(11-30343281) and they have suggested upgrading Powerhouse from 8.43D1
to 8.43E to improve overall Oracle performance, even though this
particular piece of SQL code is unchanged between the two releases. 

For us to upgrade is a considerably large task, so I was wondering in
advance of us considering it whether people have found the D1 to E
upgrade worthwhile (in particular from a performance perspective) 

Any general comments would be greatly appreciated. 

Kind Regards, 


Adrian Hudson 
- -----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this in error, please contact the sender and delete the
material from any computer.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20080104/abdfbf1a/attachment-0001.htm