Oracle tablespace metricset

edit

Oracle tablespace metricset

edit

This functionality is in beta and is subject to change. The design and code is less mature than official GA features and is being provided as-is with no warranties. Beta features are not subject to the support SLA of official GA features.

tablespace Metricset includes information about data files and temp files, grouped by Tablespace with free space available, used space, status of the data files, status of the Tablespace, etc.

Required database access

edit

To ensure that the module has access to the appropriate metrics, the module requires that you configure a user with access to the following tables:

  • SYS.DBA_TEMP_FILES
  • DBA_TEMP_FREE_SPACE
  • dba_data_files
  • dba_free_space

Description of fields

edit
  • data_file.id: Tablespace data file unique identifier number. Each data file of a Tablespace has a unique name (and each Tablespace may have more than one data file) but this is not the Tablespace ID.
  • data_file.name: Filename of the data file (with the full path)
  • data_file.online_status: Last known online status of the data file. One of SYSOFF, SYSTEM, OFFLINE, ONLINE or RECOVER.
  • data_file.size.bytes: Size of the file in bytes.
  • data_file.size.free.bytes: The size of the file available for user data. The actual size of the file minus this value is used to store file related metadata.
  • data_file.size.max.bytes: Maximum file size in bytes
  • data_file.status: File status: AVAILABLE or INVALID (INVALID means that the file number is not in use, for example, a file in a tablespace that was dropped)
  • name: Tablespace name
  • space.free.bytes: Tablespace total free space available, in bytes.
  • space.total.bytes: Tablespace total size, in bytes. Calculated by adding the file sizes for each Tablespace.
  • space.used.bytes: Tablespace used space, in bytes.

Fields

edit

For a description of each field in the metricset, see the exported fields section.

Here is an example document generated by this metricset:

{
    "@timestamp": "2017-10-12T08:05:34.853Z",
    "event": {
        "dataset": "oracle.tablespace",
        "duration": 115000,
        "module": "oracle"
    },
    "metricset": {
        "name": "tablespace"
    },
    "oracle": {
        "tablespace": {
            "data_file": {
                "id": 18,
                "name": "/u02/app/oracle/oradata/ORCLCDB/orclpdb1/sysaux01.dbf",
                "online_status": "ONLINE",
                "size": {
                    "bytes": 618659840,
                    "free": {
                        "bytes": 617611264
                    },
                    "max": {
                        "bytes": 34359721984
                    }
                },
                "status": "AVAILABLE"
            },
            "name": "SYSAUX",
            "space": {
                "free": {
                    "bytes": 34799616
                },
                "used": {
                    "bytes": 618659840
                }
            }
        }
    },
    "service": {
        "address": "oracle://sys:Oradoc_db1@localhost:1521/ORCLPDB1.localdomain?connectionClass=\u0026poolIncrement=0\u0026poolMaxSessions=0\u0026poolMinSessions=0\u0026sysdba=1\u0026sysoper=0\u0026sysasm=0\u0026standaloneConnection=0\u0026enableEvents=0\u0026heterogeneousPool=0\u0026prelim=0",
        "type": "oracle"
    }
}