DBA_UNDO_EXTENTS

最新推荐文章于 2024-09-06 09:56:08 发布

原创最新推荐文章于 2024-09-06 09:56:08 发布 · 2.7k 阅读

0 ·

CC 4.0 BY-SA版权

v$ package 专栏收录该内容

9 篇文章

订阅专栏

本文详细介绍了DBA_UNDO_EXTENTS命令如何报告undo所有段的信息，解释了不同实例间的undo表空间分布状态差异，并强调了查询活跃实例上的undo表空间空间分布的重要性。

DBA_UNDO_EXTENTS描述了undo的所有段信息

The status of the undo space distribution reported by DBA_UNDO_EXTENTS is correct for the undo tablespace that is active on the instance on which DBA_UNDO_EXTENTS is queried.However, due to the use of in-memory information that is different on each instance, there can be a discrepancy in the status of the undo spacedistribution of undo tablespaces active on other instances when queried fromone instance. This does not affect undo functionality and is only a reportingdiscrepancy for other instances' undo tablespace space distribution status. Asa best practice, query the space distribution for an undo tablespace from theinstance on which it is active.

Column              	Datatype        	NULL	       Description
OWNER               	CHAR(3)	                    	Owner of the undo tablespace
SEGMENT_NAME        	VARCHAR2(30)    	NOT NULL   	Name of the undo segment
TABLESPACE_NAME	     VARCHAR2(30)	    NOT NULL	   Name of the undo tablespace
EXTENT_ID	           NUMBER	 	                    ID of the extent
FILE_ID	             NUMBER	          NOT NULL	   File identifier number of the file containing the extent
BLOCK_ID            	NUMBER	 	                    Start block number of the extent
BYTES	               NUMBER	                     	Size of the extent (in bytes)
BLOCKS	              NUMBER	                     	Size of the extent (in blocks)
RELATIVE_FNO        	NUMBER	                     	Relative number of the file containing the segment header
COMMIT_JTIME        	NUMBER	                     	Commit time of the undo in the extent expressed as Julian time. This                                                   column is deprecated, but retained for backward compatibility reasons.
COMMIT_WTIME        	VARCHAR2(20)	               	Commit time of the undo in the extent expressed as Wallclock time.Thi                                                  s column is deprecated, but retained for backward compatibility reasons.
STATUS              	VARCHAR2(9)	                	Transaction Status of the undo in the extent:
                                                  ACTIVE
                                                  EXPIRED
                                                  UNEXPIRED