3,491
社区成员
发帖
与我相关
我的任务
分享
SQL> select count(*),object_type from dba_objects
2 where owner='XXXXXX' group by object_type;
COUNT(*) OBJECT_TYPE
---------- -------------------
3011 INDEX
27 PROCEDURE
4252 TABLE
383 TRIGGER
286 VIEW
26 FUNCTION
67 PACKAGE BODY
147668 SEQUENCE
67 PACKAGE
171 LOB
已选择10行。
COUNT(*) OBJECT_TYPE
86 SEQUENCE
15 PROCEDURE
14 LOB
106 PACKAGE
106 PACKAGE BODY
53 TRIGGER
597 INDEX
712 TABLE
3 FUNCTION
259 VIEW
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
148318 SEQUENCE
--的确很疯狂,看看我的系统,也很强大吧~
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
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