Class Tablespace

The details of a tablespace.

Inheritance

object

Tablespace

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.DatabasemanagementService.Models

Assembly: OCI.DotNetSDK.Databasemanagement.dll

Syntax

public class Tablespace

Properties

AllocatedSizeKB

Declaration

[JsonProperty(PropertyName = "allocatedSizeKB")]
public decimal? AllocatedSizeKB { get; set; }

Property Value

Type	Description
decimal?	The allocated tablespace size in KB.

AllocationType

Declaration

[JsonProperty(PropertyName = "allocationType")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.AllocationTypeEnum? AllocationType { get; set; }

Property Value

Type	Description
Tablespace.AllocationTypeEnum?	The type of extent allocation in effect for the tablespace.

BlockSizeBytes

Declaration

[JsonProperty(PropertyName = "blockSizeBytes")]
public decimal? BlockSizeBytes { get; set; }

Property Value

Type	Description
decimal?	The tablespace block size.

CompressFor

Declaration

[JsonProperty(PropertyName = "compressFor")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.CompressForEnum? CompressFor { get; set; }

Property Value

Type	Description
Tablespace.CompressForEnum?	The operation type for which default compression is enabled.

Datafiles

Declaration

[JsonProperty(PropertyName = "datafiles")]
public List<Datafile> Datafiles { get; set; }

Property Value

Type	Description
List<Datafile>	A list of the data files associated with the tablespace.

DefaultCellMemory

Declaration

[JsonProperty(PropertyName = "defaultCellMemory")]
public string DefaultCellMemory { get; set; }

Property Value

Type	Description
string	This specifies the default value for the CELLMEMORY attribute that tables created in the tablespace will inherit unless the behavior is overridden explicitly. This column is intended for use with Oracle Exadata.

DefaultInMemory

Declaration

[JsonProperty(PropertyName = "defaultInMemory")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.DefaultInMemoryEnum? DefaultInMemory { get; set; }

Property Value

Type	Description
Tablespace.DefaultInMemoryEnum?	Indicates whether the In-Memory Column Store (IM column store) is by default enabled or disabled for tables in the tablespace.

DefaultInMemoryCompression

Declaration

[JsonProperty(PropertyName = "defaultInMemoryCompression")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.DefaultInMemoryCompressionEnum? DefaultInMemoryCompression { get; set; }

Property Value

Type	Description
Tablespace.DefaultInMemoryCompressionEnum?	Indicates the default compression level for the IM column store for the tablespace.

DefaultInMemoryDistribute

Declaration

[JsonProperty(PropertyName = "defaultInMemoryDistribute")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.DefaultInMemoryDistributeEnum? DefaultInMemoryDistribute { get; set; }

Property Value

Type	Description
Tablespace.DefaultInMemoryDistributeEnum?	Indicates how the IM column store is distributed by default for the tablespace in an Oracle Real Application Clusters (Oracle RAC) environment.

DefaultInMemoryDuplicate

Declaration

[JsonProperty(PropertyName = "defaultInMemoryDuplicate")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.DefaultInMemoryDuplicateEnum? DefaultInMemoryDuplicate { get; set; }

Property Value

Type	Description
Tablespace.DefaultInMemoryDuplicateEnum?	Indicates the duplicate setting for the IM column store in an Oracle RAC environment.

DefaultInMemoryPriority

Declaration

[JsonProperty(PropertyName = "defaultInMemoryPriority")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.DefaultInMemoryPriorityEnum? DefaultInMemoryPriority { get; set; }

Property Value

Type	Description
Tablespace.DefaultInMemoryPriorityEnum?	Indicates the default priority for In-Memory Column Store (IM column store) population for the tablespace.

DefaultInMemoryService

Declaration

[JsonProperty(PropertyName = "defaultInMemoryService")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.DefaultInMemoryServiceEnum? DefaultInMemoryService { get; set; }

Property Value

Type	Description
Tablespace.DefaultInMemoryServiceEnum?	Indicates how the IM column store is populated on various instances by default for the tablespace.

DefaultInMemoryServiceName

Declaration

[JsonProperty(PropertyName = "defaultInMemoryServiceName")]
public string DefaultInMemoryServiceName { get; set; }

Property Value

Type	Description
string	Indicates the service name for the service on which the IM column store should be populated by default for the tablespace. This column has a value only when the corresponding DEF_INMEMORY_SERVICE is USER_DEFINED. In all other cases, this column is null.

DefaultIndexCompression

Declaration

[JsonProperty(PropertyName = "defaultIndexCompression")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.DefaultIndexCompressionEnum? DefaultIndexCompression { get; set; }

Property Value

Type	Description
Tablespace.DefaultIndexCompressionEnum?	Indicates whether default index compression is enabled or disabled.

DefaultTableCompression

Declaration

[JsonProperty(PropertyName = "defaultTableCompression")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.DefaultTableCompressionEnum? DefaultTableCompression { get; set; }

Property Value

Type	Description
Tablespace.DefaultTableCompressionEnum?	Indicates whether default table compression is enabled or disabled.

ExtentManagement

Declaration

[JsonProperty(PropertyName = "extentManagement")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.ExtentManagementEnum? ExtentManagement { get; set; }

Property Value

Type	Description
Tablespace.ExtentManagementEnum?	Indicates whether the extents in the tablespace are Locally managed or Dictionary managed.

FreeSpaceKB

Declaration

[JsonProperty(PropertyName = "freeSpaceKB")]
public decimal? FreeSpaceKB { get; set; }

Property Value

Type	Description
decimal?	The free space available in the tablespace in KB.

IndexCompressFor

Declaration

[JsonProperty(PropertyName = "indexCompressFor")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.IndexCompressForEnum? IndexCompressFor { get; set; }

Property Value

Type	Description
Tablespace.IndexCompressForEnum?	The operation type for which default index compression is enabled.

IsBigfile

Declaration

[JsonProperty(PropertyName = "isBigfile")]
public bool? IsBigfile { get; set; }

Property Value

Type	Description
bool?	Indicates whether the tablespace is a Bigfile tablespace or a Smallfile tablespace.

IsChunkTablespace

Declaration

[JsonProperty(PropertyName = "isChunkTablespace")]
public bool? IsChunkTablespace { get; set; }

Property Value

Type	Description
bool?	Indicates whether this is a chunk tablespace.

IsDefault

Declaration

[JsonProperty(PropertyName = "isDefault")]
public bool? IsDefault { get; set; }

Property Value

Type	Description
bool?	Indicates whether this is the default tablespace.

IsEncrypted

Declaration

[JsonProperty(PropertyName = "isEncrypted")]
public bool? IsEncrypted { get; set; }

Property Value

Type	Description
bool?	Indicates whether the tablespace is encrypted.

IsForceLogging

Declaration

[JsonProperty(PropertyName = "isForceLogging")]
public bool? IsForceLogging { get; set; }

Property Value

Type	Description
bool?	Indicates whether the tablespace is under Force Logging mode.

IsPluggedIn

Declaration

[JsonProperty(PropertyName = "isPluggedIn")]
public bool? IsPluggedIn { get; set; }

Property Value

Type	Description
bool?	Indicates whether the tablespace is plugged in.

Logging

Declaration

[JsonProperty(PropertyName = "logging")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.LoggingEnum? Logging { get; set; }

Property Value

Type	Description
Tablespace.LoggingEnum?	The default logging attribute.

LostWriteProtect

Declaration

[JsonProperty(PropertyName = "lostWriteProtect")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.LostWriteProtectEnum? LostWriteProtect { get; set; }

Property Value

Type	Description
Tablespace.LostWriteProtectEnum?	The lost write protection setting for the tablespace.

MaxSizeKB

Declaration

[JsonProperty(PropertyName = "maxSizeKB")]
public decimal? MaxSizeKB { get; set; }

Property Value

Type

Description

decimal?

The maximum tablespace size in KB. If the tablespace contains any data files with Autoextend enabled, then this column displays the amount of underlying free storage space for the tablespace. For example, if the current tablespace size is 1 GB, the combined maximum size of all its data files is 32 GB, and its underlying storage (for example, ASM or file system storage) has 20 GB of free space, then this column will have a value of approximately 20 GB. If the tablespace contains only data files with autoextend disabled, then this column displays the allocated space for the entire tablespace, that is, the combined size of all data files in the tablespace.

Name

Declaration

[Required(ErrorMessage = "Name is required.")]
[JsonProperty(PropertyName = "name")]
public string Name { get; set; }

Property Value

Type	Description
string	The name of the tablespace.

Remarks

Required

PredicateEvaluation

Declaration

[JsonProperty(PropertyName = "predicateEvaluation")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.PredicateEvaluationEnum? PredicateEvaluation { get; set; }

Property Value

Type	Description
Tablespace.PredicateEvaluationEnum?	Indicates whether predicates are evaluated by Host or by Storage.

Retention

Declaration

[JsonProperty(PropertyName = "retention")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.RetentionEnum? Retention { get; set; }

Property Value

Type	Description
Tablespace.RetentionEnum?	Indicates whether undo retention guarantee is enabled for the tablespace.

SegmentSpaceManagement

Declaration

[JsonProperty(PropertyName = "segmentSpaceManagement")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.SegmentSpaceManagementEnum? SegmentSpaceManagement { get; set; }

Property Value

Type	Description
Tablespace.SegmentSpaceManagementEnum?	Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO).

Shared

Declaration

[JsonProperty(PropertyName = "shared")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.SharedEnum? Shared { get; set; }

Property Value

Type	Description
Tablespace.SharedEnum?	Indicates whether the tablespace is for shared tablespace, or for local temporary tablespace for leaf (read-only) instances, or for local temporary tablespace for all instance types.

Status

Declaration

[JsonProperty(PropertyName = "status")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.StatusEnum? Status { get; set; }

Property Value

Type	Description
Tablespace.StatusEnum?	The status of the tablespace.

TempGroup

Declaration

[JsonProperty(PropertyName = "tempGroup")]
public string TempGroup { get; set; }

Property Value

Type	Description
string	The temporary tablespace group.

Type

Declaration

[Required(ErrorMessage = "Type is required.")]
[JsonProperty(PropertyName = "type")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Tablespace.TypeEnum? Type { get; set; }

Property Value

Type	Description
Tablespace.TypeEnum?	The type of tablespace.

Remarks

Required

UsedPercentAllocated

Declaration

[JsonProperty(PropertyName = "usedPercentAllocated")]
public double UsedPercentAllocated { get; set; }

Property Value

Type	Description
double	The percentage of used space out of the total allocated space in the tablespace.

UsedPercentAvailable

Declaration

[JsonProperty(PropertyName = "usedPercentAvailable")]
public double UsedPercentAvailable { get; set; }

Property Value

Type	Description
double	The percentage of used space out of the maximum available space in the tablespace.

UsedSpaceKB

Declaration

[JsonProperty(PropertyName = "usedSpaceKB")]
public decimal? UsedSpaceKB { get; set; }

Property Value

Type	Description
decimal?	The total space used by the tablespace in KB.

UserSizeKB

Declaration

[JsonProperty(PropertyName = "userSizeKB")]
public decimal? UserSizeKB { get; set; }

Property Value

Type	Description
decimal?	The size of the tablespace available for user data in KB. The difference between tablespace size and user data size is used for storing metadata.