eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: SYS.SMON_SCN_TIME

Object Details

Object Name:	SMON_SCN_TIME
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSAUX
PCT Free:	0
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SMON_SCN_TIME_SCN_IDX	NORMAL	UNIQUE	SYSAUX	SCN
SMON_SCN_TIME_TIM_IDX	NORMAL	UNIQUE	SYSAUX	TIME_MP

Columns

Name	Datatype	Length
THREAD	NUMBER
TIME_MP	NUMBER
TIME_DP	DATE
SCN_WRP	NUMBER
SCN_BAS	NUMBER
NUM_MAPPINGS	NUMBER
TIM_SCN_MAP	RAW	(1200)
SCN	NUMBER
ORIG_THREAD	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT THREAD
,      TIME_MP
,      TIME_DP
,      SCN_WRP
,      SCN_BAS
,      NUM_MAPPINGS
,      TIM_SCN_MAP
,      SCN
,      ORIG_THREAD
FROM SYS.SMON_SCN_TIME;

Dependencies

[top of page]

SYS.SMON_SCN_TIME does not reference any database object

SYS.SMON_SCN_TIME is referenced by following:

SYS: DBA_MVIEWS