Oracle DB 中的对象总数是多少？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21684972/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-09-19 02:13:45 来源:igfitidea点击:
what is total number of objects in Oracle DB?
提问by Programmer Khan
Can anyone tell me what is the total number of objects in Oracle database? From number I mean count of oracle objects.
谁能告诉我 Oracle 数据库中的对象总数是多少？从数字我的意思是oracle对象的数量。
Regards, Hamd
问候， 哈姆德
回答by Rafa Hernández
Number of objets group by owner.
按所有者分组的对象数。
select count(*),
owner
from dba_objects
group by owner;
Number of objects group by object type, filtered by owner
按对象类型分组的对象数，按所有者过滤
select count(*), owner, object_type
from dba_objects
where owner= '?????????'
group by owner, object_type;
回答by eddy.dbm
Version: Number of objects per user
版本：每个用户的对象数
SELECT a.username
,COUNT(b.object_name)
FROM sys.dba_users a
LEFT JOIN sys.dba_objects b ON a.username = b.owner
GROUP BY a.username
ORDER BY a.username;
