Re: Oracle vs MySql Performance

On Aug 21, 7:58 am, Johne_uk <edg...@xxxxxxxxxxxxx> wrote:
Hi,

I'm looking for a few opinions on an issue we are experiencing.

My company currently uses a 3rd party application. Up until a few
weeks ago this application consisted of Java code and a database layer
that used MySql.

Performance on MySql was adequate but as our primary DB platform is
Oracle we influenced the 3rd part to introduce an Oracle version (NB:
most of the sql code is stored in a java db layer - schema just
consists of tables, views and indexes).

To facilitate this process the vendor has used almost pure ANSI Sql so
that the same sql can be used for both oracle / mysql with minimum
conversion required.

When the system was released we were surprised to find that the sql
(and hence application) ran slower on oracle than MySql (the Oracle db
server is also considerably more powerful).

At a high level does this surprise anybody on this forum. Does Oracle
struggle to execute ANSI sql compared to MySql.

The orginal code was also written for MySql and converted so that
might explain why is is running slower.

Any thoughts would be appreciated.

Tanks in advance
John

Capture a 10046 trace at level 12 of the session that is used by the
application. Look at the wait events in the raw trace file for clues
as to what may need to be adjusted. Look at the row source operations
in the trace file to make certain that indexes are used when
appropriate. It could be that the instance is not properly tuned for
the application. Cary Millsap's book will help with the
interpretation of the 10046 trace file.

Also, make certain that statistics were gathered for tables AND
indexes. In SQLPlus, that can be accomplished with a command that
looks like this:
EXEC DBMS_STATS.GATHER_SCHEMA_STATS(OWNNAME=> 'SCHEMA_OWNER_HERE',
CASCADE=> TRUE);

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.

.

Relevant Pages

  • Oracle 8 - revealing clear text passwords from the SGA
    ... Oracle 8 - revealing clear text passwords from the SGA ... needs to have been set to the same directory as the trace file location ... SQL> select name,value ...
    (Pen-Test)
  • Oracle vs MySql Performance
    ... Performance on MySql was adequate but as our primary DB platform is ... Oracle we influenced the 3rd part to introduce an Oracle version (NB: ... To facilitate this process the vendor has used almost pure ANSI Sql so ... might explain why is is running slower. ...
    (comp.databases.oracle.server)
  • Re: Oracle vs MySql Performance
    ... Performance on MySql was adequate but as our primary DB platform is ... Oracle we influenced the 3rd part to introduce an Oracle version (NB: ... To facilitate this process the vendor has used almost pure ANSI Sql so ... Set up a database agnostic app and you will notice you don't use the ...
    (comp.databases.oracle.server)
  • Re: Oracle vs MySql Performance
    ... weeks ago this application consisted of Java code and a database layer ... that used MySql. ... Oracle we influenced the 3rd part to introduce an Oracle version (NB: ... Look at the wait events in the raw trace file for clues ...
    (comp.databases.oracle.server)
  • Re: Frage: Auflistung der SQL Syntax von verschiedener Datenbanken
    ... SQL Syntax tabellarisch aufgelistet werden. ... MySQL Servern eine "DROP INDEX" Anweisung ... Gerade bei Oracle gibt es viele Unterschiede ... DBS. ...
    (microsoft.public.de.vb.datenbank)