Tag: Oracle
-
Oracle Workload Management, No. 2
Another one in the series of Oracle Workload Management posts: Workload Management – Based on Execution Times, about a dynamic switching system based on the optimizer’s estimate of the execution time.
-
Create Your Own Oracle TPC-H Playground on Linux
Husnu Sensoy lists in great detail how to Create Your Own Oracle TPC-H Playground on Linux. He doesn’t cover load generators or benchmark tools, just dbgen to generate test data. If you need more, look e.g. for Quest Benchmark Factory, which can create and benchmark all the relevant TPC-x benchmarks, also on DBs other than Oracle.… Continued
-
Using MySQL as NoSQL
Using MySQL as a NoSQL – A story for exceeding 750,000 qps on a commodity server – how to almost achieve double the Memcached performance using a MySQL UDF that bypasses the SQL layer, talks directly to the InnoDB layer. Wonder if the SQL overhead is similar in Oracle or MS SQL Server, and how you’d work around that there.… Continued
-
Oracle Critical Patch Update October 2010
The Oracle Critical Patch Update October 2010 is out, see the Oracle Security Blog for commentary. Of the 9 Database related vulnerabilities, 7 do not apply if you are on the latest patchset on 10gR2 or 11gR2, a much higher than usual number, and hopefully a good sign for what’s to come.… Continued
-
Oracle Workload Management
Jean-Pierre Dijcks is writing a good little series of posts on Oracle Workload Management:
After spending some time on discussing some of the new parallel features (like AutoDOP and Statement Queuing) it is about time to put these features in a larger context.… Continued
-
SQL Server Redundancy
Andrew Fryer wrote a reference post about SQL Server Redundancy earlier this month about the pros and cons of clustering and mirroring, so it’s about time I mention it here! His motivation was an internal request at Microsoft:
If there are internal Microsoft staff who don’t know when to use what, then I imagine there must still be confusion in the real world about these two approaches.… Continued
-
When do you need ACID?
The recent JPMorgan Chase outage caused by an Oracle RAC block corruption places an old question back on the agenda that gets ignored way too often: How to tell whether you need ACID-compliant transaction integrity. The cost of ACID in large database systems is so high that you should consider moving those parts to simpler, cheaper or better scalable (or all three) systems that may not provide ACID compliance, but still store your data.… Continued
-
Oracle Enterprise Manager 11g
Oracle Enterprise Manager 11g has been out for some time now, and articles were piling up that I wanted to write about… so here you go:
- What’s new in Oracle Enterprise Manager 11g for Oracle Database 11g Release 2 and Exadata V2
- Differences between EM10g and EM11g, this article is more on the sysadmin / OEM admin side
- OEM 11g pictures demo in full, some screenshots and explanations of using OEM 11g for DB tuning
Be warned – that’s just for the die-hard Oracle guys!
-
IBM Netezza Update
Analyst reactions to yesterday’s announcement of IBM acquiring Netezza are now coming in. Here’s Forrester’s Yuhanna on IBM Buying Netezza, Sending Clear Shot Across Oracle’s Bow, and there’s Curt Monash with Some thoughts on the announcement that IBM is buying Netezza.… Continued