Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace Datafile

The details of a data file.

Enumerations

Properties

Functions

Properties

Optional allocatedSizeKB

allocatedSizeKB: undefined | number

The allocated file size in KB. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional freeSpaceKB

freeSpaceKB: undefined | number

The free space available in the data file in KB. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional incrementBy

incrementBy: undefined | number

The number of blocks used as auto-extension increment. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional instanceId

instanceId: undefined | number

Instance ID of the instance to which the temp file belongs. This column has a NULL value for temp files that belong to shared tablespaces. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional isAutoExtensible

isAutoExtensible: undefined | false | true

Indicates whether the data file is auto-extensible.

Optional lostWriteProtect

lostWriteProtect: LostWriteProtect

The lost write protection status of the file.

Optional maxSizeKB

maxSizeKB: undefined | number

The maximum file size in KB. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

name

name: string

The filename (including the path) of the data file or temp file.

Optional onlineStatus

onlineStatus: OnlineStatus

The online status of the file.

Optional shared

shared: Shared

Type of tablespace this file belongs to. If it's for a shared tablespace, for a local temporary tablespace for RIM (read-only) instances, or for local temporary tablespace for all instance types.

Optional status

status: Status

The status of the file. INVALID status is used when the file number is not in use, for example, a file in a tablespace that was removed.

Optional usedPercentAllocated

usedPercentAllocated: undefined | number

The percentage of used space out of the total allocated space in the file. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional usedPercentAvailable

usedPercentAvailable: undefined | number

The percentage of used space out of the maximum available space in the file. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional usedSpaceKB

usedSpaceKB: undefined | number

The total space used in the data file in KB. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional userSizeKB

userSizeKB: undefined | number

The size of the file available for user data in KB. The actual size of the file minus the USER_BYTES value is used to store file-related metadata. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Functions

getDeserializedJsonObj

  • getDeserializedJsonObj(obj: Datafile): object

getJsonObj