Class ListManagedMySqlDatabaseSqlDataRequest

Inheritance
object
ListManagedMySqlDatabaseSqlDataRequest
Implements
Inherited Members
Namespace: Oci.DatabasemanagementService.Requests
Assembly: OCI.DotNetSDK.Databasemanagement.dll
Syntax
public class ListManagedMySqlDatabaseSqlDataRequest : IOciRequest
Examples

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

Properties

EndTime

Declaration
[Required(ErrorMessage = "EndTime is required.")]
[HttpConverter(TargetEnum.Query, "endTime")]
public string EndTime { get; set; }
Property Value
Type Description
string

The end time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".
Remarks

Required

FilterColumn

Declaration
[HttpConverter(TargetEnum.Query, "filterColumn")]
public string FilterColumn { get; set; }
Property Value
Type Description
string

The parameter to filter results by key criteria which include :

  • AVG_TIMER_WAIT
  • SUM_TIMER_WAIT
  • COUNT_STAR
  • SUM_ERRORS
  • SUM_ROWS_AFFECTED
  • SUM_ROWS_SENT
  • SUM_ROWS_EXAMINED
  • SUM_CREATED_TMP_TABLES
  • SUM_NO_INDEX_USED
  • SUM_NO_GOOD_INDEX_USED
  • FIRST_SEEN
  • LAST_SEEN
  • HEATWAVE_OFFLOADED
  • HEATWAVE_OUT_OF_MEMORY

Limit

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

The maximum number of records returned in the paginated response.

ManagedMySqlDatabaseId

Declaration
[Required(ErrorMessage = "ManagedMySqlDatabaseId is required.")]
[HttpConverter(TargetEnum.Path, "managedMySqlDatabaseId")]
public string ManagedMySqlDatabaseId { get; set; }
Property Value
Type Description
string

The OCID of the Managed MySQL Database.
Remarks

Required

OpcRequestId

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

The client request ID for tracing.

Page

Declaration
[HttpConverter(TargetEnum.Query, "page")]
public string Page { get; set; }
Property Value
Type Description
string

The page token representing the page from where the next set of paginated results are retrieved. This is usually retrieved from a previous list call.

SortBy

Declaration
[HttpConverter(TargetEnum.Query, "sortBy")]
public ListManagedMySqlDatabaseSqlDataRequest.SortByEnum? SortBy { get; set; }
Property Value
Type Description
ListManagedMySqlDatabaseSqlDataRequest.SortByEnum?

The field to sort information by. Only one sortOrder can be used. The default sort order for \u2018TIMECREATED\u2019 is descending and the default sort order for \u2018NAME\u2019 is ascending. The \u2018NAME\u2019 sort order is case-sensitive.

SortOrder

Declaration
[HttpConverter(TargetEnum.Query, "sortOrder")]
public SortOrders? SortOrder { get; set; }
Property Value
Type Description
SortOrders?

The option to sort information in ascending (\u2018ASC\u2019) or descending (\u2018DESC\u2019) order. Ascending order is the default order.

StartTime

Declaration
[Required(ErrorMessage = "StartTime is required.")]
[HttpConverter(TargetEnum.Query, "startTime")]
public string StartTime { get; set; }
Property Value
Type Description
string

The start time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".
Remarks

Required

Implements