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]

VIEW: SYS.DBA_SECUREFILE_LOG_INSTANCES

Object Details

Object Name:	DBA_SECUREFILE_LOG_INSTANCES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
GUID	VARCHAR2	(32)	Yes
USER_NAME	VARCHAR2	(128)	Yes
LOG_NAME	VARCHAR2	(128)	Yes
LOG_ID	NUMBER
INST	NUMBER		Yes
SPLIT	VARCHAR2	(8)
FIXED_SIZE	VARCHAR2	(12)
FLUSH	VARCHAR2	(16)
MEM_READ	VARCHAR2	(15)
MAX_BUCKET_NO	NUMBER
NUM_BUCKETS	NUMBER
INC_SCN	NUMBER
INC_TIME	DATE
CRT_SCN	NUMBER
CRT_TIME	DATE
INC#	NUMBER

Query Text

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


SELECT GUID
,      USER_NAME
,      LOG_NAME
,      LOG_ID
,      INST
,      SPLIT
,      FIXED_SIZE
,      FLUSH
,      MEM_READ
,      MAX_BUCKET_NO
,      NUM_BUCKETS
,      INC_SCN
,      INC_TIME
,      CRT_SCN
,      CRT_TIME
,      INC#
FROM SYS.DBA_SECUREFILE_LOG_INSTANCES;

Dependencies

[top of page]

SYS.DBA_SECUREFILE_LOG_INSTANCES references the following:

SYS: CLI_INST$; CLI_LOG$; USER$

SYS.DBA_SECUREFILE_LOG_INSTANCES is not referenced by any database object