--太疯狂了.... --我们产品的数据库 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
SEQUENCE这么多,估计是动态创建的。
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行。
呵呵,不是real DBA,肯定没见过,我都我一个玩自己的数据库。嘎嘎
他仍在增长。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
估计是bug,只管动态创建,未考虑删除
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
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
--的确很疯狂,看看我的系统,也很强大吧~ 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
各位高手给评估一下,这样的结构会对库造成什么后果。开发商说了,这是bug,但是对系统没啥影响。
跟上面比起来,偶们的库一点不算什么,唯一的亮点就是分区的数量了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
晒下偶們滴小系統。。COUNT(*) OBJECT_TYPE 86 SEQUENCE 15 PROCEDURE 14 LOB 106 PACKAGE 106 PACKAGE BODY 53 TRIGGER 597 INDEX 712 TABLE 3 FUNCTION 259 VIEW
动态创建的??
这么多SEQ,不是华为就是移动,而华为又是移动的手下,那肯定是移动了触发器也很多。汗,够维护的了还有PROCEDURE+FUN少于包的数量,蛮有意思的,不知道包里装了什么东西,不装P和F,还能装什么,呵呵
--太疯狂了....
--我们产品的数据库
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
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行。
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
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
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
--的确很疯狂,看看我的系统,也很强大吧~
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
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
86 SEQUENCE
15 PROCEDURE
14 LOB
106 PACKAGE
106 PACKAGE BODY
53 TRIGGER
597 INDEX
712 TABLE
3 FUNCTION
259 VIEW