RE: Sequences and RAC -- Inputs Required

From: <oracle-l-bounce_at_freelists.org>
Date: Tue, 1 Jun 2004 07:04:18 -0400
Message-ID: <A186CBDC8B1D61438BC50F1A77E91F7309B60F56@xchgbrsm1.corp.espn.pvt>

Close ... Except in my experience I'd put 4 = signs on the list line, instead of two. See, You have to multiply everything in RAC, resources, power and most importantly 'waits' ... Or as Cary would like to call it "timed Events".

Raj

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of k.sriramkumar_at_iflexsolutions.com
Sent: Tuesday, June 01, 2004 7:03 AM
To: oracle-l_at_freelists.org
Subject: RE: Sequences and RAC -- Inputs Required

SGkgSm9uYXRoYW4sDQoNCglUaGFua3MgYSBUT04gZm9yIHlvdXIgaW5wdXRzLiBZb3VyIGlu c2ln
aHQgaXMgdmVyeSBtdWNoIGFwcHJlY2lhdGVkLg0KDQpSZWdhcmRpbmcgdGhlIHRocm91Z2hw dXQg
Zm9yIGEgT0xUUCBhcHBsaWNhdGlvbiBkZXBsb3llZCBpbiBSQUMsIGlmIGEgc2luZ2xlIG5v ZGUg
c3lzdGVtIGRlbGl2ZXJzIDF4IFRQUyB0aGVuIGNhbiB3ZSBleHBlY3QgYSB0d28gd2F5IFJB QyB0
byBwcm92aWRlIDF4KyBUUFMgaWYgbm90IDJ4IFRQUz8gSSBuZWVkIHRvIGhpZ2hsaWdodCB0 aGlz
IHRvIHRoZSBtYW5hZ2VtZW50IGFzIG1hbmFnZW1lbnQgZXhwZWN0cyAyeCBUUFMgZnJvbSBS QUMu
IA0KDQpCZXN0IFJlZ2FyZHMNCg0KU3JpcmFtIEt1bWFyDQogDQoNCi0tLS0tT3JpZ2luYWwg TWVz
c2FnZS0tLS0tDQpGcm9tOiBvcmFjbGUtbC1ib3VuY2VAZnJlZWxpc3RzLm9yZyBbbWFpbHRv Om9y
YWNsZS1sLWJvdW5jZUBmcmVlbGlzdHMub3JnXSBPbiBCZWhhbGYgT2YgSm9uYXRoYW4gTGV3 aXMN
ClNlbnQ6IFR1ZXNkYXksIEp1bmUgMDEsIDIwMDQgMzozNyBQTQ0KVG86IG9yYWNsZS1sQGZy ZWVs
aXN0cy5vcmcNClN1YmplY3Q6IFJlOiBTZXF1ZW5jZXMgYW5kIFJBQyAtLSBJbnB1dHMgUmVx dWly
ZWQNCg0KDQpZb3UgbWF5IGJlIHJpZ2h0LiBTZXF1ZW5jZXMgKGFuZCBhbnkgc2VxdWVudGlh bGx5
DQpnZW5lcmF0ZWQgZGF0YSkgY2FuIGNhdXNlIHNpZ25pZmljYW50IHByb2JsZW1zIHdpdGgN ClJB
Qy4gSWYgeW91IGhhdmUgY3JlYXRlZCB0aGUgc2VxdWVuY2VzIHdpdGggZGVmYXVsdA0KY2Fj aGUg
c2l6ZXMgKHdoaWNoIGlzIDIwKSwgdGhlbiB5b3UgYXJlIGxpa2VseSB0byBzZWUNCmxvdHMg b2Yg
U1EgZW5xdWV1ZSB3YWl0cywgYW5kIGxvdHMgb2YgYWN0aXZpdHkgYXMgYmxvY2tzDQppbiB0 aGUg
c2VxJCB0YWJsZSBhcmUgYm91bmNlZCBiYWNrIGFuZCBmb3J0aCBhY3Jvc3MgdGhlDQppbnRl cmNv
bm5lY3QuDQoNClNldHRpbmcgYSBsYXJnZSBjYWNoZSBzaXplIG9uIHRoZSBzZXF1ZW5jZSBp cyB0
aGUgZmlyc3QNCnN0ZXAuICBhbHRlciBzZXF1ZW5jZSAuLi4uLiBjYWNoZSAxMDAwMC4NCg0K RGVw
ZW5kaW5nIG9uIHRoZSB0YWJsZSBhbmQgdGFibGVzcGFjZSBkZWZpbml0aW9ucw0KZm9yIHlv dXIg
aG90IHRhYmxlcywgeW91IG1heSBhbHNvIGhhdmUgdG8gbW9kaWZ5DQp0aGUgZnJlZWxpc3Qg c2V0
dGluZ3Mgb24gdGhlIHRhYmxlcywgb3IgcmVidWlsZCB0aGUgdGFibGVzDQp3aXRoIG11bHRp cGxl
IGZyZWVsaXN0IGdyb3Vwcy4gIElmIHlvdSBoYXBwZW4gdG8gaGF2ZQ0KdXNlZCB0YWJsZXNw YWNl
cyB3aXRoIEF1dG9tYXRpYyBTZWdtZW50IFNwYWNlDQpNYW5hZ2VtZW50IChBU1NNKSBlbmFi bGVk
LCB0aGVuIHRoZSBmcmVlbGlzdHMNCmFuZCBmcmVlbGlzdCBncm91cHMgYXJlIGlycmVsZXZh bnQu
ICBIb3dldmVyLCBtdWx0aXBsZQ0KZnJlZWxpc3RzLCBhbmQgQVNTTSB1c3VhbGx5IHdyZWNr IHRo
ZSBjbHVzdGVyaW5nX2ZhY3Rvcg0Kb24gc2VxdWVudGlhbCBpbmRleGVzLCBzbyBpZiB0aGlz IGlz
IGFuIHVwZ3JhZGUsIGRvbid0DQpiZSBzdXJwcmlzZWQgaWYgT3JhY2xlIHN0YXJ0cyB0byBp Z25v
cmUgc29tZSBvZiB5b3UNCmluZGV4ZXMuDQoNCg0KDQoNClJlZ2FyZHMNCg0KSm9uYXRoYW4g TGV3
aXMNCg0KaHR0cDovL3d3dy5qbGNvbXAuZGVtb24uY28udWsNCg0KaHR0cDovL3d3dy5qbGNv bXAu
ZGVtb24uY28udWsvZmFxL2luZF9mYXEuaHRtbA0KVGhlIENvLW9wZXJhdGl2ZSBPcmFjbGUg VXNl
cnMnIEZBUQ0KDQpodHRwOi8vd3d3LmpsY29tcC5kZW1vbi5jby51ay9zZW1pbmFyLmh0bWwN Ck9w
dGltaXNpbmcgT3JhY2xlIFNlbWluYXIgLSBzY2hlZHVsZSB1cGRhdGVkIE1heSAxc3QNCg0K DQot
LS0tLSBPcmlnaW5hbCBNZXNzYWdlIC0tLS0tIA0KRnJvbTogPGsuc3JpcmFta3VtYXJAaWZs ZXhz
b2x1dGlvbnMuY29tPg0KVG86IDxvcmFjbGUtbEBmcmVlbGlzdHMub3JnPg0KU2VudDogVHVl c2Rh
eSwgSnVuZSAwMSwgMjAwNCAxMDozNCBBTQ0KU3ViamVjdDogU2VxdWVuY2VzIGFuZCBSQUMg LS0g
SW5wdXRzIFJlcXVpcmVkDQoNCg0KOiBIaSBHdXJ1cywNCjoNCjogICAgIFdlIGFyZSB0ZXN0 aW5n
IG91ciBhcHBsaWNhdGlvbihPTFRQKSBpbiAyIG5vZGUgUkFDIHNldHVwKEhQIFVYIDExLjEx KQ0K
aW4gOWlSMig5LjIuMC40KS4gV2UgYXJlIHNlZWluZyBhIG5lZ2F0aXZlIHNjYWxhYmlsaXR5 IHdo
ZW4gd2UgbW92ZSB0byBSQUMuDQpTYXkgaWYgd2UgaGFkIHggVFBTIGluIGEgNCBDUFUgYm94 LCB3
ZSBhcmUgc2VlaW5nIG9ubHkgYSAuNngtLjd4IHdoZW4gd2UNCm1vdmUgdG8gYSAyIHdheSA0 IENQ
VSBib3guDQo6DQo6IEkgaGF2ZSBjaGVja2VkIHRoZSBiYXNpYyBSQUMgc2V0dXAgYW5kIHRo ZSBz
ZXR1cCBsb29rcyBvay4NCjoNCjogT3VyIGFwcGxpY2F0aW9uIHJlbGllcyBoZWF2aWx5IG9u IHNl
cXVlbmNlcyBhbmQgSSBmZWVsIHRoYXQgdGhlIHNlcXVlbmNlcw0KY291bGQgYmUgdGhlIG9u ZSB0
aGF0IGlzIGNhdXNpbmcgdGhlIHByb2JsZW0uIEkgYW0gcGxhbm5pbmcgdG8gY2FjaGUgdGhl DQpz
ZXF1ZW5jZXMgKCB3aXRoIG5vIG9yZGVyKQ0KOg0KOiBIYXZlIGFueSBvbmUgb2YgeW91IHNl ZW4g
YmV0dGVyIFRQUyB3aGVuIG1vdmVkIHRvIFJBQz8/IGFueSBwb2ludGVycyBmb3INCmFjaGll dmlu
ZyBiZXR0ZXIgVFBTIGluIFJBQz8NCjoNCjogQmVzdCBSZWdhcmRzDQo6DQo6IFNyaXJhbSBL dW1h
cg0KOg0KOg0KOg0KDQoNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NClBsZWFzZSBzZWUgdGhlIG9mZmljaWFsIE9SQUNM RS1M
IEZBUTogaHR0cDovL3d3dy5vcmFmYXEuY29tDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpUbyB1bnN1YnNjcmliZSBz ZW5k
IGVtYWlsIHRvOiAgb3JhY2xlLWwtcmVxdWVzdEBmcmVlbGlzdHMub3JnDQpwdXQgJ3Vuc3Vi c2Ny
aWJlJyBpbiB0aGUgc3ViamVjdCBsaW5lLg0KLS0NCkFyY2hpdmVzIGFyZSBhdCBodHRwOi8v d3d3
LmZyZWVsaXN0cy5vcmcvYXJjaGl2ZXMvb3JhY2xlLWwvDQpGQVEgaXMgYXQgaHR0cDovL3d3 dy5m
cmVlbGlzdHMub3JnL2hlbHAvZm9tLXNlcnZlL2NhY2hlLzEuaHRtbA0KLS0tLS0tLS0tLS0t LS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCg==

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Tue Jun 01 2004 - 06:01:05 CDT