Re: How to create pl/sql that run efficiently in background ?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 3 Feb 2009 21:07:48 +0000 (UTC)
Message-ID: <gmabn4$lov$4_at_solani.org>
On Mon, 02 Feb 2009 22:12:05 -0600, Michael Austin wrote:
Date: Tue, 3 Feb 2009 21:07:48 +0000 (UTC)
Message-ID: <gmabn4$lov$4_at_solani.org>
On Mon, 02 Feb 2009 22:12:05 -0600, Michael Austin wrote:
> Are you using RAC? if no, then:
>
> CREATE SEQUENCE supplier_seq
> MINVALUE 1
> START WITH 1
> INCREMENT BY 1
> NOCACHE;
If RAC is used, then "ORDER" will give the desired effect, but
at a great performance cost. I've seen RAC DB choke because of
far too liberal use of the "ordered" sequences. The symptom is
a lot of "global cache busy" events pointing to the tablespace
SYSTEM.
-- http://mgogala.freehostia.comReceived on Tue Feb 03 2009 - 15:07:48 CST