Tuning an Oracle database is not a simple as "doing" it. The queries can be tuned specifically for Oracle as well. Has your DBA looked at the queries. Which way is the optimizer set? How many expected rows? Which hints are being used? Which indexes? ...
Are the rowcounts identical betwween the SQL Anywhere instance and the Oracle instance? Is network/wan lag an issue?
We have a reasonably large, replicated Oracle database. Some queries need to be tuned, some don't. Are you doing a DISTINCT, Order By, ...? I have several tables with 10s of millions of rows. Oracle's performance is fine, but we (DBA and Developers) worked together to get the performance we needed.
And I will climb off my soapbox now.
Thanks,
Jason
-----Original Message-----
From: Anand [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 08, 2000 2:09 PM
To: '[EMAIL PROTECTED]'
Subject: PFCSIG PowerBuilder Oracle performance issues
Hello All,
I have a general question pertaining to PB - Oracle performance.
We have a SQL intensive application, which pimarily contains SQL queries,
and very little graphical interface.
We have been running in against a Sybase SQL Anywhere database, as well as
an Oracle database.
We have discovered that the SQL processing takes considerably longer with an
Oracle database.
The Oracle database has been tuned by the DBA.
Does anyone have any suggestions about how the performance against an Oracle
database can be speeded up (Remember the same SQL statement seems to take
lesser time against SQL Anywhere database).
Any suggestions welcome.
Anand
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
