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
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
In a typical Oracle database implementation, you'll want to baseline or benchmark your storage. The storage team will hand over, and you'll run a battery of tests using software like bonnie++ or ORION. You'll make sure that the results are in-line with requirements and expectations. What if you are implementing said database on
Did you find this post useful? Does your organization need Oracle services? We can help. Much of this morning went into investigating strange ADDM reports on a two-node Oracle RAC database. For some reason, there were statistically improbable differences between impact percentages that have persisted over a month; in this case, instance 2 would
In our last post on cloud architectures, I covered a simple one-node Oracle Transportation Management instance on Amazon Web Services using EC2. This OTM cloud hosting configuration is well-suited to a development environment and is a very inexpensive option for teams that have on-staff database administration skills. For teams that do not have the
Did you find this post useful? Does your organization need Oracle services? We can help. Working with Oracle databases can be daunting to developers and analysts who lack a deep understanding of relational models and SQL. One excellent example of a mystifying pitfall is the dreaded ORA-02292: integrity constraint error. This error often
