As each year at end of November the biggest Oracle European conference takes place in Nürnberg, #DOAG2017. This year is a little bit special, because the DOAG celebrate the 30th edition of the conference. dbi services is for the 5th time present with a booth and 8 sessions at the DOAG. During the last 2 days I already followed many sessions, and I want to give you my impression and feedback’s about the market trends….
All posts by Hervé Schweitzer
As in recent years, dbi services was present at the DOAG 2016 conference with 9 presentations and a 1 day training. Our presentations have been well appreciated with many participants in large conference rooms, and mostly because they contain live demos. You can review our adventure on linkedin Below, a picture from our booth with the full team (Marketing,Sales and Referents)
This week I worked on a GoldenGate 188.8.131.52.10 POC setup and was facing an issue which for me is a serious drawback of the Oracle GoldenGate product.If you want to create additional columns on the target database online in a GoldenGate configuration you have to be aware of the below situation which can happen in your setup:The below demo was created on a Oracle GoldenGate Downstream server For the test, I have created the schema…
Once a replication environment is set up, it’s rarely forever. Adding tables to an Oracle GoldenGate replication group with minimal impact to the current replication is quite a difficult operation. This posting should help you with this task. In the example below, tables from schema G001 will be added to an existing replication setup from the database PROD1 to REP1. CFG_ADV_COND CFG_NARRATIVE_TEMPLATE CFG_REG_REPORT_RULES CMN_LOOKUP CMN_USER_LOGIN Stop the replication environment Connect to the source database PROD1 and…
Last week, Oracle Ace Director Jonathan Lewis held an Oracle Optimizer Workshop at dbi services BaselArea. I would like to share some of the key learnings of this really interesting exchange I experienced together with my colleagues.
Last week, I attended for the first time the Microsoft TechDays. The 2011 Swiss “edition” took place in Bern. For me it is new challenge, because I newer worked deeply with the Microsoft Database Platform “SQL Server”.
Last Week at my Customer, I used dbua to upgrade an oracle database 10h to 11g, the migration run successfully. But next day I had a monitoring message that the diag directory is groing very fast.
Last week, I was not able to complete a backup because of the ORA-19566 error: “exceeded limit of 0 corrupt blocks”. Here is what you can do to fix it. Starting Point: backup error Here is the starting point of this case. The following error is found in the RMAN Backup log file: allocated channel: ch1 channel ch1: sid=25 devtype=DISK Starting backup at 27-APR-11 channel ch1: starting incremental level 0 datafile backupset channel ch1: specifying…
Discussing with some tuning gourous we were made aware about this feature. It is not so far from the adaptive cursor sharing perfectly described in Chris’s blog : http://antognini.ch/papers/BindVariablePeeking_20090718.pdf
This feature, compares the real execution (number of returned/actual rows “A-rows”) with some expectations (number of expected rows “E-rows”) and chooses another plan for the next executions if the difference between the expectation and the actual result is too big. “Cardinality Feedback” is not well documented in the Oracle documentation.
Recently, I had an Oracle error with Data Pump at a Customer, which was not easy to localize. Here is the error I received during a DBIOWNER schema export with Data Pump:
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [TABLE_STATISTICS]
ORA-00942: table or view does not exist