oracle 什么是使用oracle数据库空间？（“ORA-12953: ... 超出了允许的最大数据库大小”）
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/10827911/
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
What is using Oracle database space? ("ORA-12953: ... exceeds the maximum allowed database size")
提问by kinkajou
I just have materialized view (small no of rows) in my oracle database and nothing but my database is compalining :
我只是在我的 oracle 数据库中有物化视图（很少的行），除了我的数据库之外什么都没有：
Error report:
SQL Error: ORA-12953: The request exceeds the maximum allowed database size of 11 GB
select sum(size_in_mb) from
(
SELECT owner,
segment_name,
segment_type,
sum(bytes)/1024/1024 size_in_mb
FROM dba_segments
WHERE owner NOT IN ('SYS','SYSTEM')
GROUP BY owner,
segment_name,
segment_type
ORDER BY SUM(bytes)/1024/1024
);
How do I find how much space which is using in oracle?
我如何找到oracle中使用了多少空间？
回答by Justin Cave
I assume from the error that you are using the express edition of the database.
我从错误中假设您使用的是数据库的快速版本。
SELECT owner,
segment_name,
segment_type,
sum(bytes)/1024/1024 size_in_mb
FROM dba_segments
WHERE owner NOT IN ('SYS','SYSTEM')
GROUP BY owner,
segment_name,
segment_type
ORDER BY SUM(bytes)/1024/1024
will show you the size of the objects owned by users other than SYSand SYSTEMordered by their size in MB.
会告诉你用比其他用户拥有的对象的大小SYS，并SYSTEM通过它们在MB大小排序。
回答by paulsm4
There are several DBA views, which look at several different aspects of "space":
有几个 DBA 视图，它们查看“空间”的几个不同方面：
* dba_free_space
* dba_data_files
* dba_tablespaces
Here are several simple - and useful - scripts:
以下是几个简单且有用的脚本：
I would definitely look at these scripts:
我肯定会看看这些脚本：
