About MaMerker

MaMerker · 16-06-2020

Question: Is it possible to switch of "Optimizer Statistics Gathering" temporarily in a session?Background of Question:We finished a complete "continuous syncronisation" of our Oracle database with > 1000 tables based on autoamtically created trigger...

MaMerker · 24-05-2020

Hallo,hier nochmal ein Frage zu der ich nichts in der Doku gefunden habe.Ist es möglich über eine Connection (via OCI oder JDBC) in der verbundenen Datenbank ein "update" oder "delete" auszuführen. Bisher fand ich nur Infos zum Import und Export.Hint...

MaMerker · 22-05-2020

Probleme bei Nutzung Connection JDBC to Oracle: Verwendete Scripte (Auszug):-- For JDBC ConnectionCREATE OR REPLACE CONNECTION JDBC_ORACLE --Install JDBC driver first via EXAoperation--see https://www.exasol.com/support/browse/SOL-179TO 'jdbc:oracle:...

MaMerker · 18-06-2020

@exa-SebastianB I found this in your documentation:Autocommit-Modus Bitte beachten Sie, dass der Autocommit-Modus unter Windows am bestennur mittels SQLSetConnectAttr() ausgeschaltet werden sollte und nicht inden Einstellungen der Datenquelle. Der Wi...

MaMerker · 18-06-2020

@exa-SebastianB see request before, I forgot to link you with @.

MaMerker · 18-06-2020

Dear Sebastian,thanks for your hint. This might be a further option for optimzation.But currently I´m focusing on the ODBC autocommit and I tried to switch it of.but I didn´t succeed.As already mentioned, we are using Oracle Gateway for ODBC and Exas...

MaMerker · 17-06-2020

Result Profiler:Statement 1: insert into (1 Datensatz) with auto commitStatement 2: import into ... from ORA at OCI_ORACLE statement select ... with auto commit PART_IDPART_NAMEOBJECT_NAMEOBJECT_ROWSOUT_ROWSDURATIONCPUTEMP_DB_RAM_PEAKHDD_READHDD_WRIT...

MaMerker · 16-06-2020

Dear @kristof & @mwellbro ,thanks for your comments and hints, I will check profiler (have never used it before) and also check ODBC advices.Best regardsMartin

User Statistics

User Activity

Temporarily Switch off "Optimizer Statistics Gathering"

update table in foreign database

Performance bei Zugriff auf Oracle-Datenbank

Re: Temporarily Switch off "Optimizer Statistics Gathering"

Re: Temporarily Switch off "Optimizer Statistics Gathering"

Re: Temporarily Switch off "Optimizer Statistics Gathering"

Re: Temporarily Switch off "Optimizer Statistics Gathering"

Re: Temporarily Switch off "Optimizer Statistics Gathering"

New to the Exasol Community?