RE: Find the table's name that using sequences

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Wed, 16 Jul 2003 15:47:11 -0400
Message-Id: <25937.338122@fatcity.com>

In order for sequence not to become a "bottle neck", use "cache" option.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----
From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] Sent: Wednesday, July 16, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Find the table's name that using sequences

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 hammering the database?? And
what happens if you have to reset the sequence, then you have to check the
primary key values on many tables. One sequence to one table sounds good to
me, but I would love to hear pros/cons about this...

-----Original Message-----
Sent: Wednesday, July 16, 2003 3:35 PM
To: Multiple recipients of list ORACLE-L

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 <mitchell.lee_at_rogers.com> wrote:
> 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
>

Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com <http://sbc.yahoo.com>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net>  
-- 
Author: Rachel Carmichael 
  INET: wisernet100_at_yahoo.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>  
San Diego, California        -- Mailing list and web hosting services 
--------------------------------------------------------------------- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing).

Received on Wed Jul 16 2003 - 14:47:11 CDT