Title: Message
Hi All
At first I thought it is easy to find those tables to use
sequences but I failed. dba_sequence don't give too
much info. Is there any idea?
Thanks in advance
Mitchell
no table "uses" a sequence. And there is no reason (other than sanity
checks) to have one sequence per table.
SQL code will use the sequence, usually to retrieve a value from the
sequence to then insert into or update a column in a table.
--- Mitchell <[EMAIL PROTECTED]> wrote:
> Hi All
>
> A
x27;s name
that using sequences
Hi All
At first I thought it is easy to find those tables to
use sequences but I failed. dba_sequence don't give too much info.
Is there any idea?
Thanks in advance
Mitchell
Michell,
A sequence is created and select privileges granted to users or roles.
The users or roles use the sequence in the applications to insert/update
the data in the tables. Check the privileges granted to the users/roles
and then get the info from the developers as to which tables use the
sequ
Well, there could be business logic reasons as to why you would have one
sequence per table.
Also, I don't know if I would ever go with one sequence for many tables,
sounds like a bottle neck to me. And how would one sequence for many tables
impact scalability?? Or having lots of users hammerin
If you are using the sequence to generate the primary key for a table, then the
sequence should only be used for that table. I can't think of a pro to have one
sequence shared for the primary keys on many different tables.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PRO
I didn't say you should have only one sequence in the database. I said
there was no reason you had to have multiple ones.
and there isn't. There is no restriction in Oracle that you have to do
so. As it happens, for many of the reasons you stated, we have multiple
sequences. That is, where I can g
Title: RE: Find the table's name that using sequences
I'd check dependencies of the sequence, you'll know what procedures,functions,packages,triggers that sue the sequence.
Raj
Rajendra d
In order for sequence not to become a "bottle neck", use "cache" option.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, July 16, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L
Well, there could be business logic reasons as to why you would have one
se
A mad rampage through DBA_SOURCE might reveal something useful.
Something like:
select name,text from dba_source where upper(text) like '%SEQUENCE_NAME%';
And do the same with TRIGGER_BODY from DBA_TRIGGERS.
-Original Message-
-
this doesn't take into account external code that uses the sequence
there is no way to know for certain which sequence is being used to
generate values for which table. Even if you have multiple sequences,
you can't force a programmer to use the sequence you have designated as
"the one" for th
In addition to what Jacques has mentioned, here is my 0.02.
Why only one sequence per table? Does it stem from the concern that a single
sequence becomes "overloaded" with request to be inserted into multiple
tables?
The overloading does not come from number of tables, but number of
concurrent re
L PROTECTED]>
cc:
Subject: RE: Find the table's name that using sequences
A mad rampage through DBA_SOURCE might reveal something useful.
Something like:
select name,text from dba_source where upper(text) like '%SEQUENCE_NAME%';
And do the same with TRIGGER_BODY
co.com> cc:
Sent by: Subject: RE: Find the table's name
that using sequences
[EMAIL PROTECTED]
>
>
> Stephen Lee <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 07/16/2003 02:14 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:RE: Find the tab
Title: RE: [PMX:#] RE: Find the table's name that using sequences
Very True ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can
16 matches
Mail list logo