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

TABLE: APPLSYS.FND_RAND_STATES

Object Details
Object Name: FND_RAND_STATES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_RAND_STATES
Subobject Name:
Status: VALID

This table stores the state information used by the secure pseudo random number generator

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LOCK_ID NUMBER
Yes PRNG id
LAST_SEQUENCE NUMBER
Yes Value of the sequence the last time the key was updated
RESEED_COUNTER NUMBER
Yes How many reseed operations have been done to the key
EVENT_COUNT NUMBER
Yes Number of entropy events that have been added to the pool since the last reseed operation
RANDOM_KEY RAW (24) Yes A random key that is part of the internal state of the random number generator
POOL0 RAW (16)
entropy pool0
POOL1 RAW (16)
entropy pool1
POOL2 RAW (16)
entropy pool2
POOL3 RAW (16)
entropy pool3
POOL4 RAW (16)
entropy pool4
POOL5 RAW (16)
entropy pool5
POOL6 RAW (16)
entropy pool6
POOL7 RAW (16)
entropy pool7
POOL8 RAW (16)
entropy pool8
POOL9 RAW (16)
entropy pool9
POOL10 RAW (16)
entropy pool10
POOL11 RAW (16)
entropy pool11
POOL12 RAW (16)
entropy pool12
POOL13 RAW (16)
entropy pool13
POOL14 RAW (16)
entropy pool14
POOL15 RAW (16)
entropy pool15
POOL16 RAW (16)
entropy pool16
POOL17 RAW (16)
entropy pool17
POOL18 RAW (16)
entropy pool18
POOL19 RAW (16)
entropy pool19
POOL20 RAW (16)
entropy pool20
POOL21 RAW (16)
entropy pool21
POOL22 RAW (16)
entropy pool22
POOL23 RAW (16)
entropy pool23
POOL24 RAW (16)
entropy pool24
POOL25 RAW (16)
entropy pool25
POOL26 RAW (16)
entropy pool26
POOL27 RAW (16)
entropy pool27
POOL28 RAW (16)
entropy pool28
POOL29 RAW (16)
entropy pool29
POOL30 RAW (16)
entropy pool30
POOL31 RAW (16)
entropy pool31
Query Text

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


SELECT LOCK_ID
,      LAST_SEQUENCE
,      RESEED_COUNTER
,      EVENT_COUNT
,      RANDOM_KEY
,      POOL0
,      POOL1
,      POOL2
,      POOL3
,      POOL4
,      POOL5
,      POOL6
,      POOL7
,      POOL8
,      POOL9
,      POOL10
,      POOL11
,      POOL12
,      POOL13
,      POOL14
,      POOL15
,      POOL16
,      POOL17
,      POOL18
,      POOL19
,      POOL20
,      POOL21
,      POOL22
,      POOL23
,      POOL24
,      POOL25
,      POOL26
,      POOL27
,      POOL28
,      POOL29
,      POOL30
,      POOL31
FROM APPLSYS.FND_RAND_STATES;

Dependencies

[top of page]

APPLSYS.FND_RAND_STATES does not reference any database object

APPLSYS.FND_RAND_STATES is referenced by following:

SchemaAPPS
SynonymFND_RAND_STATES