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

SCHEMANAME

TABLENAME

<SYSDBA>

ALLOCATORSTATISTIC

<SYSDBA>

DBTIMES

<SYSDBA>

ESTIMATED_PAGES

<SYSDBA>

INDEXSTATISTICS

<SYSDBA>

OMS_LOCKOBJ_INFO

<SYSDBA>

ROOTS

<SYSDBA>

SPINLOCKS

<SYSDBA>

TABLESTATISTICS

<SYSDBA>

USERSTATISTICS

DOMAIN

CONNECTEDUSERS

DOMAIN

SYSMON_BACKUPIOACCESS

DOMAIN

SYSMON_CONNECTION

DOMAIN

SYSMON_IOACCESS

DOMAIN

SYSMON_IOTHREAD

DOMAIN

SYSMON_REGION

DOMAIN

SYSMON_SPECIAL_THREAD

DOMAIN

SYSMON_UKTHREAD

back to top

New System Tables

List of tables only.  For column details follow

SCHEMANAME

TABLENAME

<SYSDBA>

COMMANDMONITOR

<SYSDBA>

COMMANDMONITORCONSTRAINTS

<SYSDBA>

COMMANDMONITORPARAMETERS

DOMAIN

DATAHANDLEROPTIONDEFINITIONS

DOMAIN

DATAHANDLERS

DOMAIN

DATASOURCECAPABILITIES

DOMAIN

DATASOURCEOPTIONS

DOMAIN

DATASOURCES

DOMAIN

EXTERNALTABLES

SYSINFO

DATASOURCEALERTS

SYSINFO

DATASOURCECONNECTIONS

SYSINFO

DATASOURCEMONITOR

SYSINFO

DATASOURCERUNNINGCOMMANDS

SYSINFO

DATASOURCESYSTEMATTRIBUTES

SYSINFO

DISTRIBUTEDTRANSACTIONS

SYSINFO

LOGQUEUEINFORMATION

SYSINFO

UDEPROCESSES

back to top

Altered Columns

SCHEMANAME

TABLENAME

COLUMNNAME

DATATYPE

NEWLEN

NEWDEC

OLDLEN

OLDDEC

<SYSDBA>

CONFIGURATION

DESCRIPTION

CHAR

8

 

40

 

<SYSDBA>

CONFIGURATION

CHAR_VALUE

CHAR

6

 

256

 

<SYSDBA>

LOCKLISTSTATISTICS

DESCRIPTION

CHAR

9

 

40

 

<SYSDBA>

LOCKLISTSTATISTICS

VALUE

CHAR

256

 

12

 

<SYSDBA>

LOCKSTATISTICS

LOCKMODE

CHAR

26

 

14

 

<SYSDBA>

LOCKSTATISTICS

REQMODE

CHAR

26

 

14

 

<SYSDBA>

TRANSACTIONS

LOCKMODE

CHAR

26

 

14

 

<SYSDBA>

TRANSACTIONS

REQMODE

CHAR

26

 

14

 

DOMAIN

LOCKS

LOCKMODE

CHAR

26

 

14

 

DOMAIN

LOCK_HOLDER

LOCKMODE

CHAR

26

 

14

 

DOMAIN

LOCK_REQUESTOR

REQMODE

CHAR

26

 

14

 

DOMAIN

LOCK_WAITS

H_LOCKMODE

CHAR

26

 

14

 

DOMAIN

LOCK_WAITS

R_REQMODE

CHAR

26

 

14

 

back to top

Added Columns

SCHEMANAME

TABLENAME

COLUMNNAME

LEN

DEC

DATATYPE

DOMAIN

TABLES

DATASOURCEID

8

 

CHAR

SYSINFO

CONSISTENTVIEWS

COMMANDID

8

 

CHAR

SYSINFO

IOTHREADSTATISTICS

QUEUEID

10

0

FIXED

SYSINFO

IOTHREADSTATISTICS

VOLUMETYPE

1

 

CHAR

SYSINFO

IOTHREADSTATISTICSRESET

QUEUEID

10

0

FIXED

SYSINFO

IOTHREADSTATISTICSRESET

VOLUMETYPE

1

 

CHAR

SYSINFO

MULTIVERSIONREADSTATISTICSRESET

PERCENTAGEPAGESCOPIEDFORWRITE

3

0

FIXED

SYSINFO

TABLESTORAGEDETAILS

SEPARATORCOUNT

10

0

FIXED

SYSINFO

TABLESTORAGEDETAILS

AVGUNPACKEDROWLENGTH

5

0

FIXED

SYSINFO

TASKGROUPSTATISTICS

THREADID

10

0

FIXED

SYSINFO

TASKGROUPSTATISTICS

COMMANDCOUNT

20

0

FIXED

SYSINFO

TASKGROUPSTATISTICS

THREADSTATE

20

 

CHAR

SYSINFO

TASKGROUPSTATISTICS

DISPATCHCOUNT

20

0

FIXED

SYSINFO

TASKGROUPSTATISTICS

TASKSWITCHCOUNT

20

0

FIXED

SYSINFO

TASKGROUPSTATISTICSRESET

COMMANDCOUNT

20

0

FIXED

SYSINFO

TASKGROUPSTATISTICSRESET

DISPATCHCOUNT

20

0

FIXED

SYSINFO

TASKGROUPSTATISTICSRESET

TASKSWITCHCOUNT

20

0

FIXED

back to top

Dropped/Renamed Columns

SCHEMANAME

TABLENAME

COLUMNNAME

LEN

DEC

DATATYPE

<SYSDBA>

CONFIGURATION

NUMERIC_VALUE

10

0

FIXED

<SYSDBA>

INDEXPAGES

OWNER

32

 

CHAR

<SYSDBA>

INDEXPAGES

CHAR_VALUE

12

 

CHAR

<SYSDBA>

INDEXPAGES

DESCRIPTION

40

 

CHAR

SYSINFO

MULTIVERSIONREADSTATISTICSRESET

PAGESCOPIEDFORWRITECOUNT

20

0

FIXED

 

back to top

DBAnalyzer Tables 780010

Tables utilized by DBAnalyzer. For column details follow:

back to top