Skip to content

Instantly share code, notes, and snippets.

@mariuz

mariuz/MON$ATTACHMENTS.sql

Created March 2, 2014 16:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mariuz/9309091 to your computer and use it in GitHub Desktop.
Save mariuz/9309091 to your computer and use it in GitHub Desktop.
Download ZIP
MON$ATTACHMENTS query example
Raw
MON$ATTACHMENTS.sql
SELECT r.RDB$DB_KEY, r.MON$ATTACHMENT_ID, r.MON$SERVER_PID, r.MON$STATE,
r.MON$ATTACHMENT_NAME, r.MON$USER, r.MON$ROLE, r.MON$REMOTE_PROTOCOL,
r.MON$REMOTE_ADDRESS, r.MON$REMOTE_PID, r.MON$CHARACTER_SET_ID,
r.MON$TIMESTAMP, r.MON$GARBAGE_COLLECTION, r.MON$REMOTE_PROCESS,
r.MON$STAT_ID
FROM MON$ATTACHMENTS r
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment