RE: Find the table's name that using sequences

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 get the developers to use sequences.

they use a development package that is object-oriented. And which therefore stores a row in a single table for every table for which they are generating a sequence number. so if they have 100 tables, I have 100 rows in a single Oracle table.

It's only slightly better than having one row in a table as the "sequence".

I'd take the performance of a single Oracle sequence over the performance of the table with multiple rows any day.

• Chris Grabowy <chris.grabowy_at_lmco.com> wrote:
  > 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).
  >
  >
  

> ATTACHMENT part 2 application/ms-tnef name=winmail.dat