千家信息网

Oracle commonly uesd tables/vi

发表于:2025-11-07 作者:千家信息网编辑
千家信息网最后更新 2025年11月07日,一、oracle commonly table1、dba_extents #describes the extents comprising the segments in all tablespac
千家信息网最后更新 2025年11月07日Oracle commonly uesd tables/vi

一、oracle commonly table
1、dba_extents #describes the extents comprising the segments in all tablespaces in the database.

commonly column
owner
segment_name
partition_name
tablespace_name
blocks
bytes

2、dba_segments#describes the storage allocated for all segments in the database.

owner
segment_name
partition_name
segment_type *
segment_subtype # subtype of lob segment :sourcefile assm mssm and null
tablespace_name
bytes

NOTE:The next Blog describe the principles of  Oracle 12C RAC .
0