RE: Find the table's name that using sequences

From: Chris Grabowy <chris.grabowy_at_lmco.com>
Date: Wed, 16 Jul 2003 15:26:00 -0400
Message-Id: <25937.338116@fatcity.com>

This is a multi-part message in MIME format.

--Boundary_(ID_HBW+VPJxkKtHhfTTBmP3zg)
Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT

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-----
From: Rachel Carmichael [mailto:wisernet100_at_yahoo.com] Sent: Wednesday, July 16, 2003 3:35 PM
To: Multiple recipients of list ORACLE-L Subject: Re: Find the table's name that using sequences

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). 


--Boundary_(ID_HBW+VPJxkKtHhfTTBmP3zg)
Content-type: application/ms-tnef; name=winmail.dat
Content-transfer-encoding: BASE64
Content-disposition: attachment; filename=winmail.dat

eJ8+IgETAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAA
AElQTS5NaWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAA
ANMHBwAQAA8AGQAAAAMAHAEBA5AGANATAAAsAAAACwACAAEAAAALACMAAAAAAAMA
JgAAAAAACwApAAAAAAADAC4AAAAAAAMANgAAAAAAHgBwAAEAAAArAAAARmluZCB0
aGUgdGFibGUncyBuYW1lIHRoYXQgdXNpbmcgc2VxdWVuY2VzAAACAXEAAQAAABYA
AAABw0vQFfwHA8ElaKZHd4W+Bcv+g9bBAAACAR0MAQAAABwAAABTTVRQOkNIUklT
LkdSQUJPV1lATE1DTy5DT00ACwABDgAAAABAAAYOAM7H8s9LwwECAQoOAQAAABgA
AAAAAAAAas/KG9mMx0iL1Ha5MJBBqsKAAAADABQOAQAAAAsAHw4BAAAAAgEJEAEA
AABjDgAAXw4AAH82AABMWkZ1KsknUAMACgByY3BnMTI1gjIDQ2h0bWwxAzA/AQMB
9wqAAqQD4wIAY2jBCsBzZXQwIAcTAoD/EAMAUARWCFUHshHVDlEDAd0Q1zIGAAbD
EdUzBEYQ2VkS72Y0EG8RezUDxlR8YWgDcQKAEeMI7wn3O3scHw4wNR0/HkMR4Qxg
Y2cAUAsJAWQzNhFgC6U0siAQAipcDrIBkGciEAAzIDwhRE9DVABZUEUgSFRNTAAg
UFVCTElDIIAiLS8vVzNDJNBIRFREI+Q0LhFgVHJyAHJ0aQIgB0Ak0EX4TiI+EeMi
hyMwCqMnPHwxOSNAI/InLiIgKZBFREFEJy0xNzcjQFRwSVRMRSctIhAO8FIQZTog
RguAZCB0jGhlLpABoGxlJwQgVyagB4AukWEFQHUAkG6UZyAZIHEKUG5jB5DpKI04
NSNALyyfKTIoLwszTyj2Ng7wPE1FVBxBIAWgAjAJ8HQ9IgMF4CPzNS41MC40ADgw
Ny4yMzAwEiIvUz1HJvBFUkH4VE9SJy0t4TIQKx8i8Q803yLhN9AjQEJPRFlHJy0h
kTw/Zzk2I0BE3ElWJyAikwAhIAAAQLVzEWAiaTY0QJ9BoiJLOOEq4VNQQU42oAtg
BBBiPSxQNzQyKWApYC3nNhA4IAHQMDNAj0O/DhADOAAjQEZPTlQgZp8A0DjgBxM2
oRuxPSM4cKc4cAEgMFBpejjgMkbr+xgwAzBjE/ADsgHQAzBBV+BXZWxsLCI8TIE+
86cuoRwgNqF1bC6AYi7AXmIwAgeQBCAbsGcN4CA/HCBFgAIgBCBFgC6QbyDgd2h5
IHkIYFJQUBM9GPB2LsACIC7AMGYgcK8TMU5fT2Mu8i4onDVAId4vSWJG6Ub3Q+05
FPAyEP9FElfPQZ4BwEb3CqJYeAqA/SicMCrhJTBAa1h/Pl8/b/9Af1uPQp9gr0S/
Rc9G32a//0j/Sg9LEQqjS09MX2rPVt8fX89Y/1oPc19nWiZuYoxzcAKAahdcJ2EB
QP9kb1xvXX9ej1+fdo9hv2LP/2o/ZO+Bv3bfaB9pL4Pfa0+fbF9KX27Pb9+CZUFs
UbCjTj9/1EkgZAIgJwVA2GtubwfgBpAgkJBS5LZlU2AFwGdSQSZgaFOM3wIQBcAD
gVKALuNzjyBRsKZ1LnBRAWlrLsBhjz+/f+MG4AJALxAvUAWQa1Ii/weAVkx3v3jO
EXAucRrgB+CvUuSS75P5kVBtCrBjBUB/la9/8gTwB0ABoAMQJmB53D8/mB+ZL5o7
TwXAU0HrMCIbsHQEIG+CADAABJB7BCAY8G0HgAUQMDEuomT3L9ABoIZwZaAvoT+a
Hy6A354vf/JSYC/RGPBwVGAGMf+RYVKiU0NSMRwgGSEukzBm/48gLqEDoKu6GOCX
cy6xqW/tf/JwBRAAwHJSgJVQUoD2dgdAClBzpj+nT3kKAiD/k+qYD7Lfol1TqlIx
U5Iu4/+Utq9vf/KSYARwl6SPIFCQ/wVAkZYbsKwULrAKwLWvtr/jeQqwsG9zLzax
sc+/P794+wGgCGCeD09GBAAuxnD/cV9yb34/dI/IL3mPep97r398v8sfft9/74Dz
JGAjgEuQUVVPVCPQZGmLkB8i0G6BoAAvEDchQVJHwElOLVJJRyPwLjD4MHB4JxHD
GAqxEALUofkKsVxxHADUoRjgcK/Rv98ia5rR0o+BI4ZFT7zAG7CYb2tNUOEi8GVI
UZDHBIHUVwdAaWdu1JABcX+H29ev2BBNSYLfiC/gsGn/IXKJP4pJGsTaJJrgjD8a
Av2N3y3qMqMw33ALgIsh3fX/6jMonDYQPXE5gcMYlTBQ0FcKgdi/hXdCh9tiTUlG
9QNhOsl/L+/q0KkH8ADQ6y6wAyBDCsBtDeAY8PSx78Tv2l+FwduhWwDAAxBSMB46
A/EEkRFAz2AwQHnJGtFvLgWgbV3r3+zv/+3/7w/wH+JEBmACMPHP8t9bmndN8GRQ
0aWQeY8gSh9QIFKANhCPIIeSIDM6njMx8PWf9q/3tFBN+f/f+w/8H/0v/j/iRFT4
cP//+wEPmoZNUCAmcCCwLsAcIP5jD9ATIDbQpAOVMNTgoyDlOUBDMmAtTAcfCC8J
P8cKTwtf/0V1YmqXcP/f/w3v89kuIQR/BY/3tC5fL2//MHYR3xLvE/8gPyFPIl/H
D/8ZP8vvzP/OD88fJ6/ZLdti/Dwh6jD00LSwkiE24B2QhmbxkR2gZXh0Lw/g//gw
tMCcsfggxMDqMD3fG9/320/jBRjwUNZ/5Cnjn+Svv+W959+NQU0ckSC5xSKkUexz
IpVxU9YumvNPpBEQ8zwyUYQgKJcAT7EesrTA7xrvMr8dBOtAbp/xJg8nH//zuiMP
JB8lLzjvOf87D+Jx+a7Dcym9s1NfVGJV/0PP/0TfQC9BP/elKb8qxTV/SH//KUQY
8TVBMa9S7zPPNN83f884j0nfSu//GFFMi0HekL2SgWzh4KRRrM2kUHWfkP8DYaxD
1LAQcE1RlYCxc1HP/1m/96Uv9B3ATv9QD1EfRk//R19W316/X8/pTbjarbPqwJ/4
scTA6sC5Yt8wdXClkc+Vb2Zf93iLUXVtcuJ0Uf9OlCX/aY8tOlRfVW9Wf1eP/1id
bDAY4WyMfS9Y31nvWv//XA9dH25fb29wf+nI6wCf8N/0kvV9wnJ1EML5PCg49RDl
i8QuHiBlQMEg62CkgKv5oow/Z41aPppZd8Eg/zBAF/x5D2pvdJ91rx0Ta2//bH9t
j4gPiR+KLxSvkR8O6fxIaakQjACTP5RPlV+Y7/+Z/56fnB+dL54/n0+gX6tP/8Jv
w3+WD5cfmC+iz6PfpP//pg+nH6gvqT+qT7kvrG+SGtpBxMBm3uARIUkdocSg/mev
oHdgc1EeUD8RZCO/wP0dg29isbEfsi8dBDxzHlD/TQFioh9/tB+1L7Dftz+4T7+5
X7pvu3/Lv72fke1i3ZD/xk/HX8hvyX/Kj88v5b3nb//OP9f/0F+R7cAg5qBiYAKg
h07srv+wD2RiYV9Nx/pkTYAnMUDqsE1RTQBNEPxtdUyAd2Ew8N+P4J+wPP5JHlDC
X8NvxHU+U0AAA3DyaWIgYT/Sj9Of1K/Vv//Wz9vfzK/ab9t/3I/dn/Sf/+Wv5r94
L+x/ta/ur++//K+/2O/Z//OP/+/1r5ILVD/x+0zAd2NkZSBOEfpv+3/tn//9j/6f
A6/x3wI/A08EXwVv/xpEi6YH7wj/Cg/oX+lvmI//C88M3w3vDv8QDxyfEi+SGv8U
fxWPel97b3x/H99+n3+v/4C/KF+C34PvhP+GD4cfHS/zHj8fTyBfNj83TiMPJB9/
Fp8aLxs/LJ8zLzQ/in1EL00QF18uP1P0ecBgIFnyYcIAbyHrbzlfOm87f588jz2f
Pq8/v2DPQkNEpY1BsFNh4IuATm93c7ACbmQRJDI5Ljk1vCBwj8BB70L/GWVt42D9
crAhRS9GP0dPSF9Jb0p/T0uPTJ8ff/ecPEEBlmgRZHBmPSL48HRwOoAvL3NiYy55
RMJNj/IiW3xksGxkUQJmA2GAcwF0e0hZUEXAUkxJTksgXy9gMzx9fVwhYYCP0FFw
XGPwZjFcdYwQXJhjH5ABr1VfJan8f1E2OSnCQSoe/1SvVb9Wz1ffWO9Z/wGfW6//
iugi/2xPaT9uf2+Pd59aL/tzL1xNUN9QwTDFkuPhFDBFT9Bmv8BjaWGMEE9AUkFD
TEUtT2BGuEFROl0vXj9mRHeDgJAub3Jh3yBxLnpA/nRgf2GPYp2DjWRvZX+HXv92
72iPes9qr3XPdt9t33jv/3n/ew9yH3y/dD91T5BfjU+/ko+Tn5uve6+XP1xNQdJg
JcIAcoDwUmEUIiBD/SxAbX/QBuAUQJlvmn+Rf/+cj52fnq+Vv5bPoW+p7/g/o/lP
3vBORVSA8HfA8MPqoIQxMTAwQF/npF//pW+meiXfJu8sPykPKh0t/38vDzAfMS8y
P5/frF9A+0ZaYeOQQxQA6wBOhEB37YPAa06A6qB2f9DGLa8P/7AexL/Fz8bfx+/I
/wZWmTFAODU4LTUzzbEw/DUxym+CH4pI3yAUEMNx/2A/hT+GT9C/iF+Jb9SvZ2//
jI/KD46vsz+0T6bfp++o/3+qD6sfwR9NnwegQbDSsGesbyyjob8wZoPAbn/w/8p/
y4/Jv+hf6W/qf+uP7J//7a/uv+/P8N/x7/L/9A/1Hz/2L/c/zF+ZPlG/GThNYXJp
4bFnIL8w04AHYG7SZLFwZWJewG/TgP8i/7GhxG/dn96v37/gz+Hf4u//4//lD5ia
Cy8MPw1PDl4BP/8CTwNf/L/9zxnPBR8GLwc/F8DPCc8XglRB0FJFTfBPVkUgRHHW
QNLAIiCcZnLRoH9RsZAgbf75/+dAfvD/webBgID+4hI/E0/7UvbEkHO6wBbxD48Q
nxGvPxU/Fk8XXxhvGX9A+3RvlYDwTP9xRxwQdUDRGSAgKG5vdH9ARVj3gFApEVCg
bP8THv8gD1MEyX+gICcrlicp/6Mm0P8h7yL/JA8lHyYvJz8oTylfBypuf3EhdSBC
T0RZQ+dANvBjbHVkf0Bh//9RNwAuLy8/FFXRkFOA/vAH59D/MIDwVU5TVUL/gCcy
DzMfNC81PzZPN184b5s5f61NKIPAf1NuYSFw/3+RHRc9jz6fUwT/YxvxsXDn/7DD
QCtQIGJ/QF7gU2DMdmX/0ByCKS75T/pf7bBbWU9xHSB5Qa9Cv0PPf0TfRe9G/0gP
SR+tTYAAcz8bYEyfTa8wVB4Df2JIRfhMUCDRkR0g/8HnoX+Q/39huzBZgOehHSAA
YEAQLNAVvzBrfwF1UlBjcmn+Yv8hUR1Vb1Z/Xm+7MbW/L7bPt9+479y+ML2BL0IA
TE9DS1FVT1T2RWY/a79nzaBuUjxB3L2EMjdlwUhUTUzcvQozXzV9dOAAHgBCEAEA
AAArAAAAPEYwMDEuMDA1QzUyQzYuMjAwMzA3MTYxMTM0MzFAZmF0Y2l0eS5jb20+
AAADAAJZAAAWAAMACVkCAAAACwAAgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAA
AAADAAKACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMAB4AIIAYAAAAAAMAA
AAAAAABGAAAAAFKFAAA/cQEAHgAJgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEA
AAAEAAAAOS4wAB4ADoAIIAYAAAAAAMAAAAAAAABGAAAAAIOFAAABAAAAEwAAADc3
NzQyMTkxOS0xNjA3MjAwMwAACwARgAggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAA
AAADABKACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAsAG4AIIAYAAAAAAMAA
AAAAAABGAAAAAA6FAAAAAAAAAwAcgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAA
AAADAB6ACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4AaYDzNKCJZh5IR5dT
3kky8v9fAAAAAAAAAAABAAAADgAAAENocmlzIEdyYWJvd3kAAAAeAGqA8zSgiWYe
SEeXU95JMvL/XwAAAAABAAAAAQAAAA0AAABVbnJlc3RyaWN0ZWQAAAAAHgBrgPM0
oIlmHkhHl1PeSTLy/18AAAAAAgAAAAEAAAAjAAAASW5mb3JtYXRpb24gdGhhdCBp
cyBub3Qgc2Vuc2l0aXZlLgAAHgBsgPM0oIlmHkhHl1PeSTLy/18AAAAABAAAAAEA
AAABAAAAAAAAAAMAbYDzNKCJZh5IR5dT3kky8v9fAAAAAAMAAAAAAAAAAgH4DwEA
AAAQAAAAas/KG9mMx0iL1Ha5MJBBqgIB+g8BAAAAEAAAAGrPyhvZjMdIi9R2uTCQ
QaoCAfsPAQAAAJYAAAAAAAAAOKG7EAXlEBqhuwgAKypWwgAAbXNwc3QuZGxsAAAA
AABOSVRB+b+4AQCqADfZbgAAAEM6XERvY3VtZW50cyBhbmQgU2V0dGluZ3NcY2dy
YWJvd3lcTG9jYWwgU2V0dGluZ3NcQXBwbGljYXRpb24gRGF0YVxNaWNyb3NvZnRc
T3V0bG9va1xtYWlsYm94LnBzdAAAAAMA/g8FAAAAAwANNP03AAACAX8AAQAAADEA
AAAwMDAwMDAwMDZBQ0ZDQTFCRDk4Q0M3NDg4QkQ0NzZCOTMwOTA0MUFBNDRBNjI0
MDAAAAAAAwAGEO/O27IDAAcQawYAAAMAEBAAAAAAAwAREAEAAAAeAAgQAQAAAGUA
AABXRUxMLFRIRVJFQ09VTERCRUJVU0lORVNTTE9HSUNSRUFTT05TQVNUT1dIWVlP

Received on Wed Jul 16 2003 - 14:26:00 CDT