MACH_SNAPSHOT_SVC |
Logical Entity Name | MACH_SNAPSHOT_SVC |
Default Table Name | MACH_SNAPSHOT_SVC |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | EPICS |
Definition | Machine Snapshot Service: Indicates which PV Logger service the snapshot is for. Snapshots such as those for ESH require special retention and as such are logged by their own service. By default most snapshots are for "Physics". |
Note | |
PreSQL | |
DDL Code | CREATE TABLE EPICS.MACH_SNAPSHOT_SVC(      SVC_ID     VARCHAR2(10)     NOT NULL,      SVC_NM     VARCHAR2(50),      CONSTRAINT PK_MACH_SNAPSHOT_SVC PRIMARY KEY (SVC_ID)      USING INDEX          PCTFREE 10          INITRANS 2          MAXTRANS 255          TABLESPACE EPICS_INDEX_TS          LOGGING          STORAGE(INITIAL 64K                  NEXT 64K                  MINEXTENTS 1                  MAXEXTENTS UNLIMITED                  PCTINCREASE 0                  FREELISTS 1                  FREELIST GROUPS 1                  BUFFER_POOL DEFAULT                  ) ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE EPICS_TS LOGGING NOPARALLEL STORAGE(INITIAL 64K          NEXT 64K          MINEXTENTS 1          MAXEXTENTS UNLIMITED          PCTINCREASE 0          FREELISTS 1          FREELIST GROUPS 1          BUFFER_POOL DEFAULT          ) NOCACHE NOCOMPRESS ; |
PostSQL |
MACH_SNAPSHOT_SVC Columns |
ColumnName | Domain | Datatype | NULL | Definition |
SVC_ID | VARCHAR2(10) | NO | Service Identifier: Abbreviated identifer for the PV Logger service. |
|
SVC_NM | VARCHAR2(50) | YES | Service Name: Fully qualified name of the PV Logger service. |
MACH_SNAPSHOT_SVC Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_MACH_SNAPSHOT_SVC | PrimaryKey | SVC_ID |
MACH_SNAPSHOT_SVC Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
MACH_SNAPSHOT_TYPE | Non-Identifying | One To Zero or More | FK_MACH_SNAP_TYPE_SVC | NO | NO | NO |
MACH_SNAPSHOT_SVC Check Constraints |
Check Constraint Name | CheckConstraint |
MACH_SNAPSHOT_SVC Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | 10 |
PCTUSED | 40 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 1 |
MaxTrans | 255 |
Organization | Heap |
Cache | NO |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Table Compression | NO |
Row Movement | Disabled |
MACH_SNAPSHOT_SVC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACH_SNAPSHOT_SVC Growth Metrics |
TABLE METRIC | TABLE METRIC VALUE |
Current Row Count | 3 |
Growth | Static |
Growth Type | N/A |
Growth Period | N/A |
Maximum Rows | 0 |
Average Row Size | 0 |
MACH_SNAPSHOT_SVC Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
MACH_SNAPSHOT_SVC Security Types |
Name | Current Value |
MACH_SNAPSHOT_SVC Bound Attachments |
Name | Current Value |
MACH_SNAPSHOT_SVC Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical PVLOG.Machine Snapshot Service |
NO | |||
ALARM_MYSQL (MySQL) Does Not Exist |
NO | |||
ALARM_ORACLE (Oracle) Does Not Exist |
NO | |||
BICS (Oracle) Does Not Exist |
NO | |||
BLM (Oracle) Does Not Exist |
NO | |||
BYPASS_REQ (Oracle) Does Not Exist |
NO | |||
CHAN_ARCH (Oracle) Does Not Exist |
NO | |||
CNMS_PRPSL (Oracle) Does Not Exist |
NO | |||
DIAG (Oracle) Does Not Exist |
NO | |||
DIAG_MPS (Oracle) Does Not Exist |
NO | |||
ENGA (Oracle) Does Not Exist |
NO | |||
EPICS (Oracle) EPICS.MACH_SNAPSHOT_SVC |
NO | |||
EQUIP (Oracle) Does Not Exist |
NO | |||
EXPRESS (Oracle) Does Not Exist |
NO | |||
ICS_SFTW_APPL (Oracle) Does Not Exist |
NO | |||
INSTR (Oracle) Does Not Exist |
NO | |||
Instrument Logbook (Oracle) Does Not Exist |
NO | |||
INVT (Oracle) Does Not Exist |
NO | |||
IONSRC (Oracle) Does Not Exist |
NO | |||
IONSRC1 (Oracle) Does Not Exist |
NO | |||
IPTSv5 (Oracle) Does Not Exist |
NO | |||
IRMISBase (Oracle) Does Not Exist |
NO | |||
Logbook (Oracle) Does Not Exist |
NO | |||
Magnet (Oracle) Does Not Exist |
NO | |||
MPS (Oracle) Does Not Exist |
NO | |||
NS_OPER (Oracle) Does Not Exist |
NO | |||
OPER (Oracle) Does Not Exist |
NO | |||
PART (Oracle) Does Not Exist |
NO | |||
PRINT (Oracle) Does Not Exist |
NO | |||
PROC (Oracle) Does Not Exist |
NO | |||
PRPSL (Oracle) Does Not Exist |
NO | |||
PUBL (Oracle) Does Not Exist |
NO | |||
PUBL_V1 (Oracle) Does Not Exist |
NO | |||
PV_LOGGER (Oracle) EPICS.MACH_SNAPSHOT_SVC |
NO | |||
SCORE (Oracle) Does Not Exist |
NO | |||
SICAT (Oracle) Does Not Exist |
NO | |||
SMPL (Oracle) Does Not Exist |
NO | |||
SMPLACT (Oracle) Does Not Exist |
NO | |||
SURVEY (Oracle) Does Not Exist |
NO | |||
Watchman (Oracle) Does Not Exist |
NO | |||
XAL_OPTICS (Oracle) Does Not Exist |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
MACH_SNAPSHOT_SVC Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | PV Logger |
EPICS (Oracle) | Main Model |
PV_LOGGER (Oracle) | Main Model |
MACH_SNAPSHOT_SVC Data Movement Rules |
Name | Type | Rule Text/Value |