你见过多少个序列

Question

本帖最后由 jdsnhan 于 2011-01-13 23:06:53 编辑

Answer 1

这个很强大，考验oracle极限~
动态创建的？？

Answer 2

147668 SEQUENCE
这么多SEQ，不是华为就是移动，而华为又是移动的手下，那肯定是移动了触发器也很多。汗，够维护的了还有PROCEDURE+FUN少于包的数量，蛮有意思的，不知道包里装了什么东西，不装P和F，还能装什么，呵呵

Answer 3

--太疯狂了....
--我们产品的数据库
select count(*),object_type from dba_objects
where owner='COST' group by object_type COUNT(*) OBJECT_TYPE
--------- ----------------
        2 DATABASE LINK
        3 FUNCTION
      240 INDEX
       25 LOB
        4 PACKAGE
       62 PROCEDURE
        9 SEQUENCE
       12 SYNONYM
      204 TABLE
       16 TRIGGER
       13 VIEW

Answer 4

SEQUENCE这么多，估计是动态创建的。

Answer 5

sys@SZTYORA> select object_type, count(*) as cnt
  2   from dba_objects
  3  where owner='MUSIC'
  4  group by object_type
  5  order by object_type;OBJECT_TYPE                                   CNT
-------------------------------------- ----------
DATABASE LINK                                   1
FUNCTION                                        4
INDEX                                         105
INDEX PARTITION                                25
PROCEDURE                                      14
SEQUENCE                                       30
TABLE                                          71
TABLE PARTITION                                51
TRIGGER                                        28
TYPE                                            2
VIEW                                           17已选择11行。

Answer 6

呵呵，不是real DBA，肯定没见过，我都我一个玩自己的数据库。嘎嘎

Answer 7

他仍在增长。SQL> select count(*),object_type from dba_objects
  2   where owner='XXXXXXXX' group by object_type;  COUNT(*) OBJECT_TYPE
---------- -------------------
      3379 INDEX
        27 PROCEDURE
       754 TRIGGER
      4809 TABLE
       286 VIEW
        26 FUNCTION
        67 PACKAGE BODY
    148318 SEQUENCE
        67 PACKAGE
       171 LOB

Answer 8

估计是bug,只管动态创建,未考虑删除

Answer 9

11 CLUSTER
12 DATABASE LINK
151 FUNCTION
1890 INDEX
11 LIBRARY
16 LOB
10 MATERIALIZED VIEW
12 PACKAGE
12 PACKAGE BODY
143 PROCEDURE
785 SEQUENCE
185 SYNONYM
1429 TABLE
79 TRIGGER
4 TYPE
550 VIEW我们的小系统 ，erp

Answer 10

608 INDEX PARTITION
460 TABLE PARTITION
166 SEQUENCE
24 PROCEDURE
20 LOB
1 PACKAGE
1 TRIGGER
2183 INDEX
2574 TABLE
386 VIEW
1607 FUNCTION
5 TYPE

Answer 11

--的确很疯狂，看看我的系统，也很强大吧～
select count(*),object_type from dba_objects
    where owner='YYQ' group by object_type;
-----------------------------------------------
count(*) object_type
28 SEQUENCE
2246 PROCEDURE
16 LOB
118 PACKAGE
115 PACKAGE BODY
6 TRIGGER
4200 TABLE
2223 INDEX
578 VIEW
1013 FUNCTION
2 TYPE

Answer 12

各位高手给评估一下，这样的结构会对库造成什么后果。开发商说了，这是bug，但是对系统没啥影响。

Answer 13

跟上面比起来，偶们的库一点不算什么，唯一的亮点就是分区的数量了TABLE SUBPARTITION 2892
INDEX 33
PROCEDURE 70
TABLE PARTITION 14961
TABLE 148
VIEW 11
FUNCTION 4
DATABASE LINK 2
SYNONYM 43
PACKAGE BODY 3
SEQUENCE 4
PACKAGE 3
LOB 1

Answer 14

晒下偶們滴小系統。。COUNT(*) OBJECT_TYPE
86 SEQUENCE
15 PROCEDURE
14 LOB
106 PACKAGE
106 PACKAGE BODY
53 TRIGGER
597 INDEX
712 TABLE
3 FUNCTION
259 VIEW