Wednesday, June 16, 2010

APEX, RDBMS Memory, Performance, Linux


APEX


Dimitri Gielis has an excellent blog we've linked to before, Dimitri Gielis Blog (Oracle Application Express - APEX). He's running a series on the countdown to the public release of 4.0 that is well worth reading: CD APEX 4.0: Feedback feature and Team Development

Troubleshooting RDBMS Memory

Tanel Poder recommends an article by Randolf Geist on Oracle memory troubleshooting. I somehow missed it before: Oracle memory troubleshooting article.

Performance

James Morle blogs on Log File Sync and AWR – Not Good Bedfellows and starts a discussion you may want to join (and experiment with the results yourself) on AWR. There is an overarching issue that you can see from this article: Always have a set of tools and never depend totally on one tool for performance monitoring and measurement, not even if Oracle made the tool. There are always other factors and there are always going to be specialized tools that are best for a particular situations (i.e. don't try to pry out flat screws with a phillips screwdriver).

Linux

Writing some scripts involving copying data (very few exist without that function). Here's an interesting post on some of the under the hood activities and performance of Linux sendfile and splice over at the Superpatterns blog: Zero-Copy in Linux with sendfile() and splice()

No comments:

Official, Youbetcha Legalese

This blog is provided for information purposes only and the contents hereof are subject to change without notice. This blog contains links to articles, sites, blogs, that are created by entities other than Oracle. These links may contain advice, information, and opinion that is incorrect or untested. This blog, links, and other materials contained or referenced in this blog are not warranted to be error-free, nor are they subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this blog, links and other materials contained or referenced in this blog, and no contractual obligations are formed either directly or indirectly by this blog, link or other materials. This blog may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. The opinions and recommendations contained in this blog(including links) do not represent the position of Oracle Corporation.

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.