Benchmarking I/O with Oracle ORION is an important part of planning, baselining, and performance-tuning Oracle environments. I've previously provided ORION results for the hi1.4xlarge SSD-backed instance class, and based on some recent work, I wanted to provide an update for the newer hs1.8xlarge instance class. Below you'll find hs1.8xlarge Oracle ORION benchmark results with the following
If you're like me, you love ipython notebook but often write R. RStudio's integrated RMarkdown is nice, but for some contexts like quick demos or basic training, a browser-based interface is unbeatable. What if we could get the best of both worlds - an ipython notebook for R? The answer is rNotebook, and if you
Throughput, throughput, throughput - for many databases, this is the performance measure of importance. When you are working with a fixed number of IOPS but see mixed workload types, system health can be assessed through the average read and write operation size. In an ASM environment, we can query this information by ASM disk
How long does your Oracle RMAN backup take to complete? How does this vary over time? Are there patterns by week, week of month, or day of week? The gist below can help you evaluate questions like these. If you're interested in using R with Oracle more generally, check out this previous post
Back in 2011, I covered the relative performance difference of the most popular libraries for text processing in R and Python. In case you can't guess the answer, Python and NLTK won by a significant margin over R and tm. Text processing with R seemed simple on paper, but performance and flexibility limitations have
Back in March, I posted the slides to my talk at the Silicon Valley Reinvent Law event - Law's Future from Finance's Past. Last week, we posted the video online; you can watch below. Michael Bommarito - Law’s Future from Finance’s Past from ReInvent Law Channel on Vimeo.
As a consultant and advisor to many firms running on or investigating AWS, I find SSH host and key management to be a constant struggle. From IAM credentials to default OS logins, it's easy to lose time with constant lookups. What we'd really like is to get a custom SSH config file for AWS.
Live from ReInvent Law Silicon Valley, where I gave an Ignite-style talk drawing analogy to law's future from finance's past. Slides embedded below and video forthcoming:
I'll be giving a talk tonight on automated Oracle database deployment at the SouthEast Michigan Oracle Professionals (SEMOP) Meetup Group. While I'll be following up on this post later, I wanted to share the slides and Github repository for participants to follow along: Automating Oracle Database deployment with Amazon Web Services, fabric, and boto from mjbommar Github
In many circumstances, you might want to connect R directly to a database to store and retrieve data. If the source database is an Oracle database, you have a number of options: ROracle RODBC RJDBC Using ROracle should theoretically provide you with the best performing client, as this library is a wrapper around the
