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
|
