Posts Categorized: Technical Blog
What is Exalytics? It’s a BI appliance machine — it’s like an application middle tier for complete Business Intellegence data warehousing solutions. You put it in front of Exadata and users get all the tools to work with that data – analyze, predict, run reports and etc.
Common Cause for ORA-4031 in 10gR2, Excess “KGH: NO ACCESS” Memory Allocation [Video] [ID 801787.1] Don’t be misled by the title of the note. I think any Oracle DBA who switch on ASMM should read though this carefully. The note is full of significant technical details. I will leave it to you to read it carefully. In this blog post I would like to share with you the most important takeaway, from my point of view.
Many analysts are suggesting that a big data appliance will be announced at this OOW. Based on published Oracle OpenWorld focus sessions on oracle.com (PDF documents), the following technologies will most likely be the key — Hadoop, NoSQL, Hadoop data loader for Oracle, R Language. Want more details — you have to wait for them.
As OOW approaches. I want to re-share some of my trivia/coincidental facts about Oracle with you; some have heard this before.
It seems to be assumed that fixed-point values, DECIMAL and NUMERIC, in MySQL are not susceptible to rounding errors because they are exact numeric data types. It must be kept it mind, that there are limits in precision, and the maximum number of digits for DECIMAL is 65. What I am discussing here is rounding error.
Sometimes clients ask us to implement scripts that change objects in their schemes. In order to prevent the situation when these scripts hung just because some, or several, objects are pinned. Here are two simple procedures that can help to check what we will get during our maintenance.
I’m an experienced Oracle DBA, I have lots of Linux experience and scores of RAC installations under my belt. I also work for one of the best and more experienced RAC teams in the world. So when a customer asked how long it will take to install 2-node RAC, we answered “2 hours”. It took over 30 hours…
Oracle Database Appliance (ODA) is in many ways similar to an Exadata quarter rack: they both use two similar compute servers in an engineered system configuration, with shared storage and flash storage. But in other ways, especially networking and storage, they differ significantly.
I’ve started putting together some information about the Oracle Database Appliance in question-and-answer form. If you have an unanswered question, ask away in the comment section in this post.
When I first heard about Oracle Database Appliance and what it does, I got really excited — I saw great potential in this product. When we got our hands dirty and started testing the appliance, I become confident that this product will be a hit. This article is targeted at system architects and managers to explain what they get, and don’t get, with Oracle Database Appliances.