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.DBMSHP_FUNCTION_INFO

Object Details

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

Information about each function in a run

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: SYS_C00255294

RUNID
SYMBOLID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00255294	NORMAL	UNIQUE	SYSTEM	RUNID SYMBOLID

Foreign Keys

Table	Foreign Table	Foreign Key Column
DBMSHP_FUNCTION_INFO	DBMSHP_RUNS	DBMSHP_FUNCTION_INFO RUNID
DBMSHP_PARENT_CHILD_INFO	DBMSHP_FUNCTION_INFO	DBMSHP_PARENT_CHILD_INFO RUNID DBMSHP_PARENT_CHILD_INFO PARENTSYMID
DBMSHP_PARENT_CHILD_INFO	DBMSHP_FUNCTION_INFO	DBMSHP_PARENT_CHILD_INFO RUNID DBMSHP_PARENT_CHILD_INFO CHILDSYMID

Columns

Name	Datatype	Length	Mandatory
RUNID	NUMBER		Yes
SYMBOLID	NUMBER		Yes
OWNER	VARCHAR2	(32)
MODULE	VARCHAR2	(32)
TYPE	VARCHAR2	(32)
FUNCTION	VARCHAR2	(4000)
LINE#	NUMBER
HASH	RAW	(32)
NAMESPACE	VARCHAR2	(32)
SUBTREE_ELAPSED_TIME	NUMBER
FUNCTION_ELAPSED_TIME	NUMBER
CALLS	NUMBER

Query Text

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


SELECT RUNID
,      SYMBOLID
,      OWNER
,      MODULE
,      TYPE
,      FUNCTION
,      LINE#
,      HASH
,      NAMESPACE
,      SUBTREE_ELAPSED_TIME
,      FUNCTION_ELAPSED_TIME
,      CALLS
FROM SYS.DBMSHP_FUNCTION_INFO;

Dependencies

[top of page]

SYS.DBMSHP_FUNCTION_INFO does not reference any database object

SYS.DBMSHP_FUNCTION_INFO is not referenced by any database object