EBS R12,11i不同类型对象在系统中的数量
EBS R12,11i，不同类型对象在系统中的数量OBJECT_TYPE
COUNT(11i)
COUNT(R12)
Count(R12)-Count(11i)
SYNONYM
185840
79410
-106430
INDEX
49591
60247
10656
PACKAGE
50027
55218
5191
PACKAGE BODY
48947
53999
5052
VIEW
35638
39594
3956
TABLE
30661
36529
5868
JAVA CLASS
17736
23432
5696
SEQUENCE
10789
12975
2186
TYPE
2823
7135
4312
TRIGGER
5360
6866
1506
这里的Java Class只是说load到DB里边Java对象的数量，还有大量OAF Java对象是没有算入统计的
另附上查询语句
SELECT object_type, Count(*) count
FROM dba_objects
GROUP BY object_type
ORDER BY Count desc;
另外据说Fusion将大量减少PL/SQL（Package,Function）的使用，将把大量的业务代码放到Java（ADF）中去
-- Oracle EBS 12.1.3 --
SELECT COUNT(*)
FROM DBA_OBJECTS
WHERE OBJECT_TYPE = 'PACKAGE BODY'
and owner not in ('SYS','SYSTEM');
COUNT(*)
----------------------
47929
-- Oracle Fusion 11.1.1.5.1 --
SELECT COUNT(*)
FROM DBA_OBJECTS
WHERE OBJECT_TYPE = 'PACKAGE BODY'
AND OWNER NOT IN ('SYS','SYSTEM');
COUNT(*)
----------------------
3677
转载请注明出处：http://blog.csdn.net/pan_tian/article/details/7644153
页:
[1]