Zsolt, I think we'll need some additional information, Like what type of computer are you and the customer using, what OS, how much data at each site, how many users, a dump of V$SGA would help too as well as how the disks and files are laid out.
Dick Goulet ____________________Reply Separator____________________ Author: Zsolt Csillag <[EMAIL PROTECTED]> Date: 8/13/2002 6:03 AM Hi, My application is _very_ slow at the customer's side. The same application is fast on my both computer. The only difference: My databases are 9i, the customer's is 8i. My tablespace is locally managed, the customer's is dictionary one. Both database are cost based and with new statistics gathered. Every table and index files are the same. Do you have any idea? Thank you in advance, Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Zsolt Csillag INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).