[PERFORM] Performance Problem between Ora 10g and Psql

[Thomas Radnetter]

Hello! We're facing a performance problem here in a Oracle 10g -> PostgreSQL environment. The Oracle DB accesses the PostgreSQL DB via UnixODBC + psqlODBC. There are some 100 records on the Oracle DB to be updated with data obtained from a view of the PostgreSQL DB. The fetched data accumulates to a few kB's and the update takes some 5 - 7 hours. During this time the PostgreSQL machine is running at approx. 100% CPU usage. If a select for the same data is issued from the Oracle DB the statement is executed in half a second. Is this the correct place to issue this problem? How can I trace down the cause for this performance problem? Thanx in advance! Regards, Thomas Radnetter p.s. Mr. Ludek Finstrle, can you help again? -- "Feel free" – 10 GB Mailbox, 100 FreeSMS/Monat ... Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail -- "Feel free" – 10 GB Mailbox, 100 FreeSMS/Monat ... Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail