Data, Process, Insights & things I write about
Perhaps some of you know the SAP note #825653 Oracle: Common errors in which Martin Frauendorfer collected many “myths” and all-time misconceptions about Oracle databases. Here’s another one: " For all tables in an… Read More » Oracle – Popular Misconceptions: Tables without Segments
A customer was facing a problem when generating SQL scripts by using SQL. As this is a common habit in the Oracle world he tried to apply it to his MaxDB. Read More » Questions to SAP Support: “How to generate a SQL Script via SQL on MaxDB?”
So after a loooong wait time, it’s finally available to be downloaded by the SAP customers. What a relieve! Over is the time where tens of patches needed to be installed to run the database on a supported patch level and… Read More » Oracle Patchset 10.2.0.4 is released – finally.
With release 11g Oracle made many feature enhancements to the database and some of them are now down-ported into the soon-to-be-released patchset 10.2.0.4. One new feature that I just found by ‘accident’ is the easy… Read More » Oracle Patchset 10.2.0.4 – neat DBMS_STATS enhancement
In my mini-series " Mind the gap" I will try to shed some light on where the little or big differences between MaxDB and Oracle databases are and what to keep in mind when working with them. Read More » ‘Mind the gap…’ (#3 – Backup/Restore – Part 1)
Today a customer asked about how to monitor recovery activity on MaxDB. The typical questions here are: " Is it still running?" and " How long will it take?" While the last question cannot be answered easily (and most… Read More » Questions to SAP Support: “Is my MaxDB recovery still running?”
Today I got a support message to work on that I believe is of rather broad interest. Therefore, I decided to “forward” it to the SDN so that all community members can benefit from it. Read More » Questions to SAP Support: Is ODBC access to the database a good idea?
Every day I’m faced with colleagues, customers, partners or SDN members asking questions about MaxDB. How can we set up an external backup tool? Why is my index not taken by the optimizer? Can I use MaxDB as a productive… Read More » What you don’t know about MaxDB…
When faced with error messages like ORA-1578 Oracle database users just got the task to handle a database block corruption. I’ve already written about this topic before and today I’d like to share some tips and tricks to… Read More » Some hints to make handling of oracle datablock corruptions more efficient
While editing content for MaxDB Wiki here in SDN I wondered how I might return to an older version of the page. Unlike e.g. MediaWiki http://www.mediawiki.org/ the WIKI engine behind Wikipedia (http://www.wikipedia.org)… Read More » SDN Wiki Features – what features?