LOBSEGMENT 对象填满了我在 Oracle 中的表空间
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7839248/
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
LOBSEGMENT objects filling up my tablespace in Oracle
提问by filippo
I'm using a Oracle 10gR2 DB, and was taking a look in one of my tablespaces when I noticed something odd.
我正在使用 Oracle 10gR2 DB，并且当我注意到一些奇怪的事情时正在查看我的一个表空间。
Apart from my table objects, I found a bunch of "LOBSEGMENT" types if quite big sizes - one of then with 17gb.
除了我的表对象之外，我发现了一堆“LOBSEGMENT”类型，如果它们的尺寸很大——其中一个是 17gb。
I'm no expert in Oracle, and would not know in which situations these are generated. There are some tables with LOB objects in this TS, but how could I figure which belongs to what?
我不是 Oracle 专家，也不知道这些是在哪些情况下生成的。在这个 TS 中有一些带有 LOB 对象的表，但我怎么知道哪个属于什么？
This TS is supposed to keep our large tables, so it has configured EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64M. That could be another issue, apart from that large object there are dozens of other ones, each of then with at least64m.
这个 TS 应该保留我们的大表，所以它配置了EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64M. 这可能是另一个问题，除了那个大物体之外，还有几十个其他物体，每个物体至少有64m。
The objects I do not recognise are of two kinds: LOBSEGMENT(named like "SYS_LOB0000187667C00006$$"), and LOBINDEX(named ali "SYS_IL0000187607C00006$$").
我不认识的对象有两种：（LOBSEGMENT命名为“SYS_LOB0000187667C00006$$”）和LOBINDEX（命名为“SYS_IL0000187607C00006$$”）。
One source of this problem I could think of is the use of views. We use a bunch of views joining several massive tables from this TS with no special configuration. Could it be a problem?
我能想到的这个问题的一个来源是视图的使用。我们使用一堆视图连接来自这个 TS 的几个大表，没有特殊配置。会不会有问题？
thanks!
谢谢！
回答by Ludovic Kuty
The LOBSEGMENTstores the LOB data and the LOBINDEXallows the DB to find and assemble the pieces of the LOB which are at different places in the tablespace.
该LOBSEGMENT存储LOB数据和LOBINDEX允许DB找到并组装LOB的碎片，它们在表空间中的不同的地方。
Check the answer of a similar postto find the table and column that consumes space.
检查类似帖子的答案以查找占用空间的表和列。
Taken from the other post:
摘自另一个帖子：
SELECT owner, table_name, column_name
FROM dba_lobs
WHERE segment_name = 'SYS_LOB<<identifier>>$$'
