Search

Top 60 Oracle Blogs

Recent comments

Oakies Blog Aggregator

A gotcha with parallel index builds, parallel degree and query plans

Reading the following article about PARALLEL hint by Jonathan Lewis made me remember a somewhat related gotcha with parallelism.
Often when creating (or rebuilding) an index on a large table, doing it with PARALLEL x option makes it go faster – usually in case when your IO subsystem is not the bottleneck and you have enough spare CPU capacity to throw in.
A small example below:
Tanel@Sol01> create table t1 as select * from all_objects; Table created.

My version of SQL string to table tokenizer

This one’s a short post on a fairly random topic as unfortunately I don’t have time today to come up with anything deeper :)
I needed to come up with a delimited string to table tokenizer for an Oracle development project. There are quite a few examples out there how to do that, including Adrian Billington’s www.oracle-developer.net and the http://technology.amis.nl/blog/?p=1631.
So far the simplest solution I had seen was using a bunch of INSTR’s, SUBSTR’s and DECODE’s in a CONNECT BY loop.

Advanced Oracle Troubleshooting Guide: When the wait interface is not enough [part 1]

Welcome to read my first real post on this blog!
If I ever manage to post any more entries, the type and style of content will be pretty much as this one: Oracle problem diagnosis and troubleshooting techniques with some OS and hardware touch in it. And internals! ;-)
Nevertheless, I am also a fan of systematic approaches and methods, so I plan to propose some less known OS and Oracle techniques for reducing guesswork in advanced Oracle troubleshooting even further.

User-defined aggregate functions in oracle 9i

We can create our own aggregate functions in 9i and use them like built-ins. September 2003

The merge statement in oracle 9i

Update or insert data from a single DML statement in 9i. September 2002

Associative arrays in oracle 9i release 2

Oracle extends its PL/SQL array processing capabilities. May 2002

Merge enhancements in 10g

Enhancements to the MERGE statement in 10g provide much greater flexibility. June 2004

Enhancements to dbms_output in 10g release 2

Oracle finally "fixes" DBMS_OUTPUT. August 2005

Flashback restore points in oracle 10g release 2

Restore points enable us to capture a point in time for flashback operations. August 2005

Flashback table in 10g

Oracle extends flashback technology to restore dropped tables. June 2004