| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | STFUTRACEORA | Trace Switch for Oracle | 2 | INST_ID | | int | 10 | 0 | | |
TOPFunctions for U.S. Federal Government |
2 | FMRES_INST_HIST | Log of all installments created | 6 | INST_ID | Installment Identifier | nvarchar | 10 | 0 | | |
TOPOnline Correction Support Support Package and Add-On Tools |
3 | STACKCOMPS | Software Components in Software (SP) Stack | 2 | INST_ID | PPMS - General ID | nvarchar | 20 | 0 | | |
TOPOracle Database Monitors |
4 | GVD_CURR_BLKSRV | copy of gv$current_block_server | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
5 | GVD_INSTANCE | Copy of GV$INSTANCE | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
6 | GVD_MANGD_STANBY | copy of GV$MANAGED_STANDBY (currently not provided w. snaps) | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
7 | GVD_SPPARAMETER | Oracle Monitoring: Copy of GV$SPPARAMETER | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
TOPPerformance Monitors TCC |
8 | GVD_BGPROCESS | Oracle monitoring: Copy of GV$BGPROCESS | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
9 | GVD_BUFF_POOL_ST | Oracle Monitoring: Copy of gv$buffer_pool_statistics | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
10 | GVD_DATABASE | Copy of GV$DATABASE (currently not provided with snapshots) | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
11 | GVD_DATAFILE | Copy of GV$DATAFILE | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
12 | GVD_DATAGUARD_ST | Copy of GV$DATAGUARD_STATUS | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
13 | GVD_DB_CACHE_ADV | Copy of GV$DB_CACHE_ADVICE (currently not provided w. snaps) | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
14 | GVD_ENQUEUE_STAT | Copy of GV$ENQUEUE_STAT | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
15 | GVD_FILESTAT | Copy of GV$FILESTAT | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
16 | GVD_LATCH | Copy of GV$LATCH | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
17 | GVD_LATCHCHILDS | Copy of GV$LATCH_CHILDREN | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
18 | GVD_LATCHHOLDER | Copy of GV$LATCHHOLDER (currently not provided with snapsh) | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
19 | GVD_LATCHNAME | Copy of GV$LATCHNAME (currently not provided with snapshots) | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
20 | GVD_LATCH_MISSES | Copy of GV$LATCH_MISSES | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
21 | GVD_LATCH_PARENT | Copy of GV$LATCH_PARENT (currently not provided with snaps) | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
22 | GVD_LIBRARYCACHE | Oracle monitoring: Copy of GV$LIBRARYCACHE | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
23 | GVD_LOCK | Copy of GV$LOCK | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
24 | GVD_LOCKED_OBJEC | Copy of GV$LOCKED_OBJECT | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
25 | GVD_LOCK_ACTIVTY | Copy of GV$LOCK_ACTIVITY | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
26 | GVD_LOGFILE | Oracle monitoring: Copy of GV$LOGFILE | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
27 | GVD_OBJECT_DEPEN | Oracle monitoring: copy of GV$OBJECT_DEPENDENCY | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
28 | GVD_PARAMETER | Copy of GV$PARAMETER | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
29 | GVD_PARAMETER2 | Copy of GV$PARAMETER2 (currently not provided with snapshot | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
30 | GVD_PGASTAT | Copy of GV$PGASTAT | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
31 | GVD_PGA_TARGET_A | Copy of GV$PGA_TARGET_ADVICE | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
32 | GVD_PGA_TARGET_H | Copy of GV$PGA_TARGET_ADVICE_HISTOGRAM | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
33 | GVD_PROCESS | Copy of GV$PROCESS | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
34 | GVD_PX_SESSION | Oracle monitoring: Copy of GV$PX_SESSION | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
35 | GVD_ROWCACHE | Oracle monitoring: Copy of GV$ROWCACHE | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
36 | GVD_SEGMENT_STAT | Copy of GV$SEGMENT_STATISTICS (curr. not provided w. snaps) | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
37 | GVD_SEGSTAT | Oracle monitoring: Copy of GV$SEGSTAT | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
38 | GVD_SESSION | Oracle monitoring: Snapshot table for GV$SESSION | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
39 | GVD_SESSION_EVT | Oracle monitoring: copy of GV$SESSION_EVENT | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
40 | GVD_SESSION_WAIT | Oracle monitoring: Copy of GV$SESSION_WAIT | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
41 | GVD_SESSTAT | Snapshot table for GV$SESSTAT (curr. not provided w. snaps) | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
42 | GVD_SESS_IO | Copy of GV$SESS_IO (currently not provided with snapshots) | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
43 | GVD_SGA | Oracle monitoring: Snapshot table for GV$SGA | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
44 | GVD_SGACURRRESIZ | Oracle monitoring: Snapshot table for GV$SGA_CURRENT_RESIZE | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
45 | GVD_SGADYNCOMP | Oracle monitoring: Snapshot table for GV$SGA_DYNAMIC_COMPON | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
46 | GVD_SGADYNFREE | Oracle monitoring: Snapshot table for GV$SGA_DYNAMIC_FREE_M | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
47 | GVD_SGARESIZEOPS | Oracle Monitoring: Copy of GV$SGA_RESIZE_OPS | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
48 | GVD_SGASTAT | Oracle monitoring: Snapshot table for GV$SGASTAT | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
49 | GVD_SHAR_P_ADV | Oracle Monitoring: Copy of gv$shared_pool_advice | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
50 | GVD_SQL | Copy of GV$SQL (currently not provided with snapshots) | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
51 | GVD_SQLAREA | Copy of GV$SQLAREA (currently not provided with snapshots) | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
52 | GVD_SQLTEXT | Copy of GV$SQLTEXT (currently not provided with snapshots) | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
53 | GVD_SQL_WA_ACTIV | Oracle Monitoring: Copy of GV$SQL_WORKAREA_ACTIVE | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
54 | GVD_SQL_WA_HISTO | Oracle Monitoring: Copy of GV$SQL_WORKAREA_HISTOGRAM | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
55 | GVD_SQL_WORKAREA | Oracle Monitoring: Copy of GV$SQL_WORKAREA | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
56 | GVD_SYSSTAT | Copy of GV$SYSTAT | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
57 | GVD_SYSTEM_EVENT | Copy of GVSSYSTEM_EVENT | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
58 | GVD_TEMPFILE | Copy of GV$TEMPFILE | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
59 | GVD_UNDOSTAT | Oracle monitoring: copy of GV$UNDOSTAT | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
60 | GVD_WAITSTAT | Oracle Monitoring: Copy of GV$WAITSTAT | 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |
61 | ORA_SAPKCBFWAIT | Copy of SAP$KCBFWAIT | 3 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | | |