Archive for the ‘Performance’ Category
Friday, October 26th, 2007
From time to time I get a little writer's block and sometime search for topics to blog about. I thought, what better way to get ideas for blog posts than to ask the readers of this blog. Here is your chance to influence the topic of upcoming ...
Posted in Oracle, Performance, Troubleshooting | 2 Comments »
Monday, October 1st, 2007
Andrew Holdsworth, the Senior Director of the Real-World Performance Group, will be having two presentation sessions at Oracle OpenWorld 2007, in addition to the Real-World Performance Group Roundtable session. The first presentation is Current Trends in Database Performance and the second one is When to Use the Appropriate Database ...
Posted in Oracle, Performance, Troubleshooting | No Comments »
Monday, September 17th, 2007
Many of you are aware of the Oracle 11g Database New Features and while some may be generally interested in new features, one area that I focus on is new features that yield gains in performance. Some of these features can be found in the General Server Performance section ...
Posted in 10gR2, 11gR1, Data Warehousing, Optimizer, Oracle, Performance, Statistics | 15 Comments »
Monday, August 27th, 2007
For those of you who will be attending Oracle OpenWorld 2007 and have interests in the database performance area, I would recommend to you to try and attend the Real-World Performance Group Roundtable session. The session starts with a brief "Hot List" of performance issues that have been predominant ...
Posted in Data Warehousing, Optimizer, Oracle, Performance | No Comments »
Friday, August 24th, 2007
Recently, I've been quite busy with performance projects and haven't had the spare time I would like to keep up on my blog. Now that those projects are behind me, I wanted to blog about the use of one feature that made a significant difference in performance on a ...
Posted in Data Warehousing, Execution Plans, Optimizer, Oracle, Performance, SQL Tuning | 1 Comment »
Monday, April 30th, 2007
Personally I believe the array interface is one of the most overlooked methods to increase database application scalability. Any time an application is selecting or inserting more than a single row, performance benefits are generally observed by using the array interface. The Oracle array interface exists for Oracle ...
Posted in Performance | 12 Comments »
Monday, April 23rd, 2007
In my previous post, Bind Variables, I discussed why using bind variables is one of the most important fundamentals in engineering scalable database applications. I briefly touch on the point that cursor management is also very important. In this post I will go into why this is important, ...
Posted in Performance, Troubleshooting | No Comments »
Monday, March 26th, 2007
Recently I've had several encounters with issues that I would consider to be part of basic scalable application design. These aren't design issues that are new. Most of them have been addressed many times over the past years, however, they are issues that continually seem to appear. ...
Posted in Performance | 1 Comment »