EBS R12,11i不同类型对象在系统中的数量

EBS R12,11i,不同类型对象在系统中的数量

OBJECT_TYPECOUNT(11i)COUNT(R12)Count(R12)-Count(11i)
SYNONYM18584079410-106430
INDEX495916024710656
PACKAGE50027552185191
PACKAGE BODY48947539995052
VIEW35638395943956
TABLE30661365295868
JAVA CLASS17736234325696
SEQUENCE10789129752186
TYPE282371354312
TRIGGER536068661506

这里的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

请使用浏览器的分享功能分享到微信等