Powerhouse + Oracle-9i + AIX - Response issues

[Darren Reely]

Oracle has several indexing types. Perhaps adjusting that could help 
some of your performance issues.

We have a table with 1.7 million records that has a column that can 
contain 1 of 16 possible values. We indexed this one way and the 
performance sucked. Our DBA tried another indexing type and it worked 
wonders.

Sorry, I don't remember the details. But that is why you have an 
experienced Oracle DBA handy. Riiight?

In one of your e-mails you mentioned upgrading PH to the latest patch 
level. Have you done that and had any better success?

Darren


Goparaju, Vidyasagar wrote:
> We are in the process of migration from AS400 Powerhouse to Powerhouse 
> on AIX under Oracle environment.
> 
>  
> 
> We have successfully converted our application and almost ready for the 
> production move. But we have been experiencing response issues. 
> Powerhouse under Oracle environment is relatively very slow.
> 
>  
> 
> Any of you have gone thru similar issues when migrated to Oracle 
> environment? What steps have you taken to improve the response? We have 
> a huge Cobol routine that runs off of our quick screens using DO 
> EXTERNAL. That is also taking longer time and a big concern to our clients.
> 
>  
> 
>  Please let me know if you have any suggestions or information.
> 
>  
> 
> Thanks very much
> 
> Sagar Goparaju
> TradePoint Systems
> 
>  
> 
> STATEMENT OF CONFIDENTIALITY:
> The information contained in this electronic message is intended for the 
> exclusive use of the addressee(s) and may contain confidential 
> information.  If you are not the intended recipient of this email, be 
> advised you have received this message in error and that any use, 
> dissemination, forwarding, printing, or copying is strictly prohibited.  
> Please notify TradePoint Systems LLC immediately at (603) 889-3200 and 
> destroy all copies of this message and any attachments.
>