Oracle PL/SQL Performance Tuning Tips & Techniques

PL-SQL Performance Tuning Cover2

Dulcian’s Michael Rosenblum and Dr. Paul Dorsey have just completed another book for Oracle Press: Oracle PL/SQL Performance Tuning Tips & Techniques This book present a hands-on approach to enabling optimal results from PL/SQL. The book begins by describing the discovery

Tagged with: , , , , ,
Posted in BLOG, Code tips, Development, Dulcian News, News, Oracle, Our Books, PL/SQL, Publications, Resources, What's New

Thoughts on Performance Tuning

Michael Rosenblum and I are writing a book about PL/SQL performance tuning for Oracle Press. I started thinking about the “big picture” ideas that everyone should know.  The following is the list that I came up with. If you have

Tagged with: , ,
Posted in BLOG, PL/SQL, Publications

If you don’t ask, you will never find out why your system is performing poorly

We had a large operation that took up to a minute to run.  It was copying data to a staging area, running over a thousand data validation rules (~50,000 lines of code), and then formatting all of the validation errors

Tagged with: ,
Posted in BLOG, PL/SQL, SQL

Another Anecdote Supporting the Thick Database Approach

This post describes how our thick database approach helped us to easily identify performance issues within a new application. Dulcian’s BRIM-Objects includes  an object modeling tool  based on UML class diagrams. We built this tool over 10 years ago using

Tagged with: , ,
Posted in BLOG, Development

Performance Considerations for Web Applications – Paul Dorsey, Michael Rosenblum IOUG Collab 2009

Paul Dorsey and Michael Rosenblum published this article in the IOUG Web Architecture Best Practices Booklet (Collab’09 edition)  in 2009. The Introduction is below: Many of the performance tuning techniques applied to client/server applications that consisted of rewriting poorly written SQL code and tuning the database

Tagged with: ,
Posted in Articles, Code tips
Disclaimer
The information presented on this blog is presented to provide general technical information. If, while attempting to apply any of the ideas, procedures, or suggestions herein, you experience any kind of programming or system problems or failure, it will be as a result of your own actions. Dulcian, Inc. and all authors of text found anywhere on this site, and all internally-linked Web sites, Mail Lists, Blogs and/or e-mail group discussion, disclaim responsibility for any user's actions and any damage that may occur based on information found on this website and associated Mail Lists, Blogs and/or e-mail group discussion. Any technical advice or directions found on or through this site is provided AS IS and its provided without warranty or any guarantee of its accuracy. You perform any modifications to programs or software AT YOUR OWN RISK.