Posts Categorized: Technical Blog

Oracle Database Machine on a Budget: Standard Edition (SE)?

One of the customers (actually a prospect) here in Australia asked me about minimal Oracle licensing on a quarter rack database machine. This prompted a thought of using Oracle Standard Edition instead of full blown Enterprise Edition with bunch of options. Before even going into possibility of using Oracle SE for the database machine, let’s see if we even want to.

Unveiling the OLTP Oracle Database Machine & Exadata v2

Let’s go into the nitty-gritty… ODBM (Oracle Database Machine) v2 is twice as fast as version 1 when it comes to data warehousing. Compare to version 1, ODBM v2 runs OLTP traffic — “something that Netezza and Teradata can’t do at all… but we can do both [i.e. data warehousing] and we do both very well” said Ellison. So what’s inside?

NoCoug SQL Challenge Entry

I love puzzles. So when I heard about the NoCoug SQL Challenge I felt tempted to give it a go. The Northern California Oracle Users Group (NoCoug) has challenged us to find a good way to calculate the probability of getting different sums for x throws of a n-sided die using only SQL. The probabilities for the faces of a single die are stored in a table and that’s all you need to start playing with the problem. The SQL Challenge rules can be found on the NoCoug website, along with some other relevant information.

Reporting Space-Wasting Objects in Oracle

I chose to talk about a technique I used at a client’s site to report the topmost space-wasting objects in an Oracle database. I was looking for a way to detect these objects without having to run some expensive analyze statements or dbms_stats jobs. I found out that I can use the dbms_space package to do this. It worked very well for me and I’m sure lots of DBAs could use this technique too.

Basic I/O Monitoring on Linux

Indeed, while the technique we discuss here is basic, it gives a good overview and is very easy to use. So let get focused… We will use iostat utility. There is much to say about IO monitoring and interpreting results. Perhaps this is only the first of a series of posts about IO statistics. At Pythian we often come across different environments with specific characteristics and various requirements that our clients have. So stay tune — more to come.

Page 56 of 56« First...102030...5253545556