You should look at:

1) Ways to optimize the select statement
-use of indexes
-use of special oracle Hints /*FIRST_ROWS(TABLENAME)*/
-use of bind variables for repeated SQL
-fetch only the data you need and minimize number of rows and columns you fetch.

2) Ways to optimize amount of i/o needed for query...
-Cache table in memory if it is small
-Create table with special PCTFREE values ect...
-Store all rows in contiguous disk extents.
-Store table data on faster disks
-Minimize contention for data using distribution or raid..

3) server settings
-Increase server shared memory size
-optimize DB_BLOCK settings to match OS block size
-increase DB_BUFFERS for larger SQL area...

4)Network
-increase connections speed to server
-optimize sqlnet settings

First thing that comes to mind is indexes, and bind variables!

What is the exact SQL you are using, how often and how many records, columns are fetched...What is the table structure, indexes.

What ODBC driver do you use?
Are you using TCP/IP.

What RAID type do you use on the disk where the data is stored...

Perhaps I can give more specific reccomendations if you send back more info ...

Note: packet size has no effect when you do it on the ODBC driver but you can change it in your SQLNET Settings....

HTH





>Over our WAN, when I do an ODBC connection using Oracle - it is about 100 times slower to transfer data than when I connect to SQL Server and do the same transfer. I have tried to change my packet size but that has no effect. What should I look at to get Oracle faster on my Foxpro Side and on the Oracle Side.