Re: How to create pl/sql that run efficiently in background ?
Date: Tue, 3 Feb 2009 21:07:48 +0000 (UTC)
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
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.