Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Removed/Renamed System Tables

SCHEMA

TABLENAME

<SYSDBA>

MONITOR_LONG

<SYSDBA>

MEMORY_HOLDERS

back to top

New System Tables

List of tables only.  For column details follow

SCHEMA

TABLENAME

<SYSDBA>

MONITOR_LOB

<SYSDBA>

SYSDDLHISTORY

DOMAIN

OMSDISCLOSEDCLASSES

DOMAIN

OMSDISCLOSEDCLASSMEMBERS

SYSINFO

IOJOBS

SYSINFO

PAGELOCKS

SYSINFO

FILESYSTEMS

SYSINFO

OMSVERSIONS

SYSINFO

CONVERTERMAPPING

SYSINFO

SHARELOCKSTATISTICS

SYSINFO

LOCKSTATISTICSRESET

SYSINFO

SHARELOCKINFORMATION

SYSINFO

SHARELOCKWAITINGTASKS

SYSINFO

MEMORYALLOCATORDETAILS

SYSINFO

OMSPROCEDURESTATISTICS

SYSINFO

LOGPARTITIONSTATISTICS

SYSINFO

FREEBLOCKMANAGERSECTIONS

SYSINFO

SHARELOCKSTATISTICSRESET

SYSINFO

HISTORYCLEANUPSTATISTICS

SYSINFO

FREEBLOCKMANAGERSTATISTICS

SYSINFO

FREEBLOCKMANAGERBLOCKSTATES

SYSINFO

HISTORYCLEANUPSTATISTICSRESET

SYSINFO

FREEBLOCKMANAGERSTATISTICSRESET

SYSINFO

CONSISTENTVIEWOPENTRANSACTIONS

SYSINFO

MULTIVERSIONREADSTATISTICSRESET

back to top

Altered Columns

SCHEMA

TABLENAME

COLUMNNAME

NEWLEN

NEWDEC

OLDLEN

OLDDEC

<SYSDBA>

CONSISTENTVIEWS

CREATORTRANSCOUNT

16

?

20

?

<SYSDBA>

CONSISTENTVIEWS

OPENDATE

8

?

10

?

<SYSDBA>

GARBAGECOLLECTOR_STATISTICS

RELHIST_SENSITIVE

38

0

20

0

<SYSDBA>

GARBAGECOLLECTOR_STATISTICS

RELHIST_TRUNCATE

38

0

20

0

<SYSDBA>

GARBAGECOLLECTOR_STATISTICS

DROP_FILE

1

0

20

0

<SYSDBA>

MONITOR_OMS

CallCnt

20

0

10

0

<SYSDBA>

MONITOR_OMS

SumRuntime

20

0

10

0

<SYSDBA>

MONITOR_OMS

SumStreamCommunicationTime

20

0

10

0

<SYSDBA>

MONITOR_OMS

MaxSubtransLevel

5

0

20

0

<SYSDBA>

MONITOR_OMS

AvgVarObjectSize

5

0

20

0

<SYSDBA>

MONITOR_OMS

MallocCnt

10

0

20

0

<SYSDBA>

MONITOR_OMS

MallocMin

10

0

20

0

<SYSDBA>

MONITOR_OMS

MallocMax

10

0

20

0

<SYSDBA>

MONITOR_OMS

MallocAvg

10

0

20

0

<SYSDBA>

MONITOR_OMS

FreeCnt

10

0

20

0

<SYSDBA>

MONITOR_OMS

FreeMin

10

0

20

0

<SYSDBA>

MONITOR_OMS

FreeMax

10

0

20

0

<SYSDBA>

MONITOR_OMS

FreeAvg

10

0

20

0

<SYSDBA>

MONITOR_OMS

OmsAvgChainLenSearched

5

2

10

2

<SYSDBA>

MONITOR_OMS

OmsRehash

5

0

20

0

DOMAIN

OMS_VERSIONS

CREATE_DATE

8

?

10

?

DOMAIN

OMS_VERSIONS

UNLOADED

2

?

3

?

DOMAIN

OMS_VERSIONS

VERSION_DESC

256

?

512

?

DOMAIN

DBPROCEDURES

EXECUTION_KIND

10

?

6

?

DOMAIN

PACKAGES

EXECUTION_KIND

10

?

6

?

DOMAIN

ROLES

CREATEDATE

8

?

10

?

DOMAIN

SCHEMAS

CREATEDATE

8

?

10

?

DOMAIN

USERS

CREATEDATE

8

?

10

?

DOMAIN

USERS

ALTERDATE

8

?

10

?

DOMAIN

USERS

PWCREADATE

8

?

10

?

DOMAIN

VIEWCOLUMNS

CREATEDATE

8

?

10

?

back to top

Added Columns

SCHEMANAME

TABLENAME

COLUMNNAME

DATATYPE

LEN

DEC

<SYSDBA>

GARBAGECOLLECTOR_STATISTICS

DELETE_ROW

FIXED

20

0

<SYSDBA>

GARBAGECOLLECTOR_STATISTICS

DELETE_INDEX

FIXED

20

0

<SYSDBA>

SYSMONITOR

SYSCOMMAND_ANALYZE_CMDID

CHAR

8

<SYSDBA>

SYSMONITOR

COMMANDSTATISTICS_COMMANDID

CHAR

8

DOMAIN

CLASSCONTAINERS

KEYSIZE

FIXED

5

0

DOMAIN

CLASSCONTAINERS

OMS_CLASSID

FIXED

10

0

DOMAIN

CLASSCONTAINERS

KEYFILECOUNT

FIXED

2

0

DOMAIN

CLASSCONTAINERS

KEYPREFIXSIZE

FIXED

5

0

DOMAIN

CLASSCONTAINERS

CREATEDATE

TIMESTAMP

26

DOMAIN

CONSTRAINTS

CONSTRAINTTYPE

CHAR

12

DOMAIN

DBPROCEDURES

DBPROCID

CHAR

8

DOMAIN

FUNCTIONS

FUNCTIONID

CHAR

8

DOMAIN

FUNCTIONS

EXECUTION_KIND

CHAR

10

DOMAIN

SCHEMAS

COMMENT

LONG

DOMAIN

SYSMON_TASK_DETAIL

CMDEXECLATCNT

FIXED

20

0

DOMAIN

SYSMON_TASK_DETAIL

CLIENTCMDEXECCNT

FIXED

20

0

DOMAIN

SYSMON_TASK_DETAIL

TOTCMDEXECABSLAT

FIXED

20

0

DOMAIN

SYSMON_TASK_DETAIL

TOTCLCMDEXECTIME

FIXED

20

0

DOMAIN

SYSMON_TASK_DETAIL

TOTCMDEXECRELLAT

FIXED

20

0

DOMAIN

SYSMON_TASK_DETAIL

CLIENTSEMWAITCNT

FIXED

20

0

DOMAIN

SYSMON_TASK_DETAIL

TOTCLSEMWAITTIME

FIXED

20

0

DOMAIN

SYSMON_TASK_DETAIL

CLIENTSEMPOSTCNT

FIXED

20

0

DOMAIN

SYSMON_TASK_DETAIL

KERNELSEMPOSTCNT

FIXED

20

0

DOMAIN

SYSMON_TASK_DETAIL

TOTCLSEMPOSTTIME

FIXED

20

0

DOMAIN

SYSMON_TASK_DETAIL

TOTKNLSEMPOSTTIME

FIXED

20

0

DOMAIN

SYSMON_TASK_DETAIL

AVGCMDEXECABSLAT

FIXED

20

4

DOMAIN

SYSMON_TASK_DETAIL

AVGCLCMDEXECTIME

FIXED

20

4

DOMAIN

SYSMON_TASK_DETAIL

AVGCMDEXECRELLAT

FIXED

20

4

DOMAIN

SYSMON_TASK_DETAIL

AVGCLSEMWAITTIME

FIXED

20

4

DOMAIN

SYSMON_TASK_DETAIL

AVGCLSEMPOSTTIME

FIXED

20

4

DOMAIN

SYSMON_TASK_DETAIL

AVGKNLSEMPOSTTIME

FIXED

20

4

SYSINFO

ACTIVECONFIGURATION

DEPRECATED

CHAR

3

SYSINFO

CATALOGCACHESTATISTICS

DDLINVALIDATECOUNT

FIXED

10

0

SYSINFO

CATALOGCACHESTATISTICS

TIMEOUTINVALIDATECOUNT

FIXED

10

0

SYSINFO

CONSISTENTVIEWS

UNUSEDTIME

FIXED

10

0

SYSINFO

CONSISTENTVIEWS

TRANSACTIONID

FIXED

15

0

SYSINFO

CONSISTENTVIEWS

CONSISTENTVIEWID

FIXED

15

0

SYSINFO

CONSISTENTVIEWS

CREATEDATE

TIMESTAMP

26

SYSINFO

DATACACHE

USEDPINAREASIZE

FIXED

20

0

SYSINFO

DATASTATISTICS

USEDSHADOWSIZE

FIXED

10

0

SYSINFO

DATASTATISTICS

USEDSNAPSHOTSIZE

FIXED

10

0

SYSINFO

DATASTATISTICS

USEDPERMANENTCONVERTERSIZE

FIXED

10

0

SYSINFO

DATASTATISTICS

USEDTEMPORARYCONVERTERSIZE

FIXED

10

0

SYSINFO

DATAVOLUMES

WRITABLE

CHAR

3

SYSINFO

DATAVOLUMES

FILESYSTEMID

FIXED

5

0

SYSINFO

FILES

CACHE

CHAR

3

SYSINFO

FILES

NOCACHE

CHAR

3

SYSINFO

IOTHREADSTATISTICS

LOADAVG

FIXED

16

2

SYSINFO

IOTHREADSTATISTICS

QUEUEPRIORITY

CHAR

6

SYSINFO

MULTIVERSIONREADSTATISTICS

HISTORYACCESSCOUNT

FIXED

20

0

SYSINFO

MULTIVERSIONREADSTATISTICS

HISTORYANCHORTOPAGECOUNT

FIXED

20

0

SYSINFO

MULTIVERSIONREADSTATISTICS

HISTORYANCHORTOFILECOUNT

FIXED

20

0

SYSINFO

MULTIVERSIONREADSTATISTICS

HISTORYANCHORFROMPAGECOUNT

FIXED

20

0

SYSINFO

MULTIVERSIONREADSTATISTICS

HISTORYANCHORFROMFILECOUNT

FIXED

20

0

SYSINFO

MULTIVERSIONREADSTATISTICS

PERCENTAGEPAGESCOPIEDFORWRITE

FIXED

3

0

SYSINFO

SESSIONS

CURRENTSCHEMANAME

CHAR

32

SYSINFO

SESSIONS

IDENTIFICATIONTYPE

CHAR

8

SYSINFO

SESSIONS

AUTHENTICATEDIDENTITY

CHAR

32

SYSINFO

SESSIONS

AUTHENTICATIONMETHOD

CHAR

8

SYSINFO

SESSIONS

AUTHENTICATIONMECHANISM

CHAR

32

SYSINFO

SNAPSHOTS

COMMENT

CHAR

60

SYSINFO

SNAPSHOTS

MAXNEEDEDSIZE

FIXED

20

0

SYSINFO

SNAPSHOTS

TRANSACTIONCONSISTENT

CHAR

3

SYSINFO

TABLESTORAGEDETAILS

RECORDEXTENSIONPAGECOUNT

FIXED

10

0

back to top

Dropped/Renamed Columns

SCHEMANAME

TABLENAME

COLUMNNAME

LEN

DEC

DATATYPE

SYSINFO

CATALOGCACHESTATISTICS

INVALIDATECOUNT

10

0

FIXED

SYSINFO

FILEDIRECTORIES

TASKID

10

0

FIXED

SYSINFO

IOTHREADSTATISTICSRESET

PATH

256

 

CHAR

back to top

DBAnalyzer Tables 770506

Tables utilized by DBAnalyzer. For column details follow:

back to top

 |