Class SummarizeSqlStatisticsRequest

Inheritance

object

SummarizeSqlStatisticsRequest

Implements

IOciRequest

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.OpsiService.Requests

Assembly: OCI.DotNetSDK.Opsi.dll

Syntax

public class SummarizeSqlStatisticsRequest : IOciRequest

Examples

Click here to see an example of how to use SummarizeSqlStatistics request.

Properties

AnalysisTimeInterval

Declaration

[HttpConverter(TargetEnum.Query, "analysisTimeInterval")]
public string AnalysisTimeInterval { get; set; }

Property Value

Type	Description
string	Specify time period in ISO 8601 format with respect to current time. Default is last 30 days represented by P30D. If timeInterval is specified, then timeIntervalStart and timeIntervalEnd will be ignored. Examples P90D (last 90 days), P4W (last 4 weeks), P2M (last 2 months), P1Y (last 12 months), . Maximum value allowed is 25 months prior to current time (P25M).

Category

Declaration

[HttpConverter(TargetEnum.Query, "category", CollectionFormatType.Multi)]
public List<SummarizeSqlStatisticsRequest.CategoryEnum> Category { get; set; }

Property Value

Type	Description
List<SummarizeSqlStatisticsRequest.CategoryEnum>	Filter sqls by one or more performance categories.

CdbName

Declaration

[HttpConverter(TargetEnum.Query, "cdbName", CollectionFormatType.Multi)]
public List<string> CdbName { get; set; }

Property Value

Type	Description
List<string>	Filter by one or more cdb name.

CompartmentId

Declaration

[Required(ErrorMessage = "CompartmentId is required.")]
[HttpConverter(TargetEnum.Query, "compartmentId")]
public string CompartmentId { get; set; }

Property Value

Type	Description
string	The OCID of the compartment.

Remarks

Required

CompartmentIdInSubtree

Declaration

[HttpConverter(TargetEnum.Query, "compartmentIdInSubtree")]
public bool? CompartmentIdInSubtree { get; set; }

Property Value

Type	Description
bool?	A flag to search all resources within a given compartment and all sub-compartments.

DatabaseId

Declaration

[HttpConverter(TargetEnum.Query, "databaseId", CollectionFormatType.Multi)]
public List<string> DatabaseId { get; set; }

Property Value

Type	Description
List<string>	Optional list of database OCIDs of the associated DBaaS entity.

DatabaseTimePctGreaterThan

Declaration

[HttpConverter(TargetEnum.Query, "databaseTimePctGreaterThan")]
public double DatabaseTimePctGreaterThan { get; set; }

Property Value

Type	Description
double	Filter sqls by percentage of db time.

DatabaseType

Declaration

[HttpConverter(TargetEnum.Query, "databaseType", CollectionFormatType.Multi)]
public List<SummarizeSqlStatisticsRequest.DatabaseTypeEnum> DatabaseType { get; set; }

Property Value

Type	Description
List<SummarizeSqlStatisticsRequest.DatabaseTypeEnum>	Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.

DefinedTagEquals

Declaration

[HttpConverter(TargetEnum.Query, "definedTagEquals", CollectionFormatType.Multi)]
public List<string> DefinedTagEquals { get; set; }

Property Value

Type

Description

List<string>

A list of tag filters to apply. Only resources with a defined tag matching the value will be returned. Each item in the list has the format "{namespace}.{tagName}.{value}". All inputs are case-insensitive. Multiple values for the same key (i.e. same namespace and tag name) are interpreted as "OR". Values for different keys (i.e. different namespaces, different tag names, or both) are interpreted as "AND".

DefinedTagExists

Declaration

[HttpConverter(TargetEnum.Query, "definedTagExists", CollectionFormatType.Multi)]
public List<string> DefinedTagExists { get; set; }

Property Value

Type

Description

List<string>

A list of tag existence filters to apply. Only resources for which the specified defined tags exist will be returned. Each item in the list has the format "{namespace}.{tagName}.true" (for checking existence of a defined tag) or "{namespace}.true". All inputs are case-insensitive. Currently, only existence ("true" at the end) is supported. Absence ("false" at the end) is not supported. Multiple values for the same key (i.e. same namespace and tag name) are interpreted as "OR". Values for different keys (i.e. different namespaces, different tag names, or both) are interpreted as "AND".

ExadataInsightId

Declaration

[HttpConverter(TargetEnum.Query, "exadataInsightId", CollectionFormatType.Multi)]
public List<string> ExadataInsightId { get; set; }

Property Value

Type	Description
List<string>	Optional list of exadata insight resource OCIDs.

FreeformTagEquals

Declaration

[HttpConverter(TargetEnum.Query, "freeformTagEquals", CollectionFormatType.Multi)]
public List<string> FreeformTagEquals { get; set; }

Property Value

Type	Description
List<string>	A list of tag filters to apply. Only resources with a freeform tag matching the value will be returned. The key for each tag is "{tagName}.{value}". All inputs are case-insensitive. Multiple values for the same tag name are interpreted as "OR". Values for different tag names are interpreted as "AND".

FreeformTagExists

Declaration

[HttpConverter(TargetEnum.Query, "freeformTagExists", CollectionFormatType.Multi)]
public List<string> FreeformTagExists { get; set; }

Property Value

Type	Description
List<string>	A list of tag existence filters to apply. Only resources for which the specified freeform tags exist the value will be returned. The key for each tag is "{tagName}.true". All inputs are case-insensitive. Currently, only existence ("true" at the end) is supported. Absence ("false" at the end) is not supported. Multiple values for different tag names are interpreted as "AND".

HostName

Declaration

[HttpConverter(TargetEnum.Query, "hostName", CollectionFormatType.Multi)]
public List<string> HostName { get; set; }

Property Value

Type	Description
List<string>	Filter by one or more hostname.

Id

Declaration

[HttpConverter(TargetEnum.Query, "id", CollectionFormatType.Multi)]
public List<string> Id { get; set; }

Property Value

Type	Description
List<string>	Optional list of database insight resource OCIDs.

Limit

Declaration

[HttpConverter(TargetEnum.Query, "limit")]
public int? Limit { get; set; }

Property Value

Type	Description
int?	For list pagination. The maximum number of results per page, or items to return in a paginated "List" call. For important details about how pagination works, see List Pagination. Example: 50

OpcRequestId

Declaration

[HttpConverter(TargetEnum.Header, "opc-request-id")]
public string OpcRequestId { get; set; }

Property Value

Type	Description
string	Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.

Page

Declaration

[HttpConverter(TargetEnum.Query, "page")]
public string Page { get; set; }

Property Value

Type	Description
string	For list pagination. The value of the opc-next-page response header from the previous "List" call. For important details about how pagination works, see List Pagination.

SortBy

Declaration

[HttpConverter(TargetEnum.Query, "sortBy")]
public SummarizeSqlStatisticsRequest.SortByEnum? SortBy { get; set; }

Property Value

Type	Description
SummarizeSqlStatisticsRequest.SortByEnum?	The field to use when sorting SQL statistics. Example: databaseTimeInSec

SortOrder

Declaration

[HttpConverter(TargetEnum.Query, "sortOrder")]
public SortOrder? SortOrder { get; set; }

Property Value

Type	Description
SortOrder?	The sort order to use, either ascending (ASC) or descending (DESC).

SqlIdentifier

Declaration

[HttpConverter(TargetEnum.Query, "sqlIdentifier", CollectionFormatType.Multi)]
public List<string> SqlIdentifier { get; set; }

Property Value

Type	Description
List<string>	One or more unique SQL_IDs for a SQL Statement. Example: 6rgjh9bjmy2s7

TimeIntervalEnd

Declaration

[HttpConverter(TargetEnum.Query, "timeIntervalEnd")]
public DateTime? TimeIntervalEnd { get; set; }

Property Value

Type	Description
DateTime?	Analysis end time in UTC in ISO 8601 format(exclusive). Example 2019-10-30T00:00:00Z (yyyy-MM-ddThh:mm:ssZ). timeIntervalStart and timeIntervalEnd are used together. If timeIntervalEnd is not specified, current time is used as timeIntervalEnd.

TimeIntervalStart

Declaration

[HttpConverter(TargetEnum.Query, "timeIntervalStart")]
public DateTime? TimeIntervalStart { get; set; }

Property Value

Type	Description
DateTime?	Analysis start time in UTC in ISO 8601 format(inclusive). Example 2019-10-30T00:00:00Z (yyyy-MM-ddThh:mm:ssZ). The minimum allowed value is 2 years prior to the current day. timeIntervalStart and timeIntervalEnd parameters are used together. If analysisTimeInterval is specified, this parameter is ignored.

VmclusterName

Declaration

[HttpConverter(TargetEnum.Query, "vmclusterName", CollectionFormatType.Multi)]
public List<string> VmclusterName { get; set; }

Property Value

Type	Description
List<string>	Optional list of Exadata Insight VM cluster name.

Implements

IOciRequest