Thursday, August 12, 2010

Performance, Indexing, Sun Ray, GoldenGate


Performance


Cary Millsap, who may be one of the better pretenders to the title of 'Mister Trace' himself, has come out with a program to use with Oracle SQL Developer called 'MR Trace'.
Have a look here. And Tom Kyte seems to think it looks interesting as well.


Indexing

In this posting on Partially Index a Table Christian Antognini over at the Striving for Optimal Performance blog has found a workaround for an indexing feature we actually don't have in Oracle, at least not yet:
Partially Index a Table

Sun Ray Desktop Virtualization

Sun Ray developer Craig Bender takes us on a demo tour of the Sun Ray 3+ and explains the elegance and efficiency of Virtual Desktop Infrastructure in this MP3 format interview.

Optimizer

At the Inside the Oracle Optimizer blog we have a posting on adaptive cursor sharing. This is a feature that has caused more than its share of confusion over the years. See what the experts have to say here: Explain adaptive cursor sharing behavior with cursor_sharing = similar and force.

GoldenGate

Over at the Oracle DBA – Tips and Techniques is a handy article on commands for GoldenGate: Useful GoldenGate commands - SHELL, OBEY, HELP, HISTORY,VERSIONS. What, no SIT?



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.