Hi Anand,
Have you tried checking out if the SQL is the culprit. U say it runs faster
on SQL Anywhere but the same SQL would need minor modification and would run
just as good on Oracle. Mind you Oracle expects and goes about SQL's
differently from other databases.
Also try
------------------------------
Explain Plan
Set Statement_id = 'testing sql'
for <youSQL statements>
------------------------------
and try analyzing and tuning ur SQL for Oracle.
Hope this Helps,
Bye,
Karthik S.
-----Original Message-----
From: Funk, Sheldon (JUS) <[EMAIL PROTECTED]>
To: 'Anand' <[EMAIL PROTECTED]>; '[EMAIL PROTECTED]' <[EMAIL PROTECTED]>
Date: Wednesday, March 08, 2000 5:44 PM
Subject: RE: PFCSIG PowerBuilder Oracle performance issues
Anand,
Since the SQL Anywhere database is usually local to the app, have you
considered your network as the culprit?
Sheldon
> -----Original Message-----
> From: Anand [SMTP:[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]
> [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]
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
> [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]
