Package com.oracle.bmc.opsi.requests

Class SummarizeSqlStatisticsRequest.Builder

    • Constructor Detail

      • Builder

        public Builder()

    • Method Detail

      • databaseId

        public SummarizeSqlStatisticsRequest.Builder databaseId​(String singularValue)
        Singular setter.

        Optional list of database OCIDs of the associated DBaaS entity.

        Parameters:
        singularValue - the singular value to set
        Returns:
        this builder instance

      • exadataInsightId

        public SummarizeSqlStatisticsRequest.Builder exadataInsightId​(String singularValue)
        Singular setter.

        Optional list of exadata insight resource OCIDs.

        Parameters:
        singularValue - the singular value to set
        Returns:
        this builder instance

      • cdbName

        public SummarizeSqlStatisticsRequest.Builder cdbName​(String singularValue)
        Singular setter.

        Filter by one or more cdb name.

        Parameters:
        singularValue - the singular value to set
        Returns:
        this builder instance

      • hostName

        public SummarizeSqlStatisticsRequest.Builder hostName​(String singularValue)
        Singular setter.

        Filter by one or more hostname.

        Parameters:
        singularValue - the singular value to set
        Returns:
        this builder instance

      • databaseTimePctGreaterThan

        public SummarizeSqlStatisticsRequest.Builder databaseTimePctGreaterThan​(Double databaseTimePctGreaterThan)
        Filter sqls by percentage of db time.
        Parameters:
        databaseTimePctGreaterThan - the value to set
        Returns:
        this builder instance

      • sqlIdentifier

        public SummarizeSqlStatisticsRequest.Builder sqlIdentifier​(List<String> sqlIdentifier)
        One or more unique SQL_IDs for a SQL Statement.

        Example: 6rgjh9bjmy2s7

        Parameters:
        sqlIdentifier - the value to set
        Returns:
        this builder instance

      • sqlIdentifier

        public SummarizeSqlStatisticsRequest.Builder sqlIdentifier​(String singularValue)
        Singular setter.

        One or more unique SQL_IDs for a SQL Statement. Example: 6rgjh9bjmy2s7

        Parameters:
        singularValue - the singular value to set
        Returns:
        this builder instance

      • analysisTimeInterval

        public SummarizeSqlStatisticsRequest.Builder analysisTimeInterval​(String analysisTimeInterval)
        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).

        Parameters:
        analysisTimeInterval - the value to set
        Returns:
        this builder instance

      • timeIntervalStart

        public SummarizeSqlStatisticsRequest.Builder timeIntervalStart​(Date timeIntervalStart)
        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.

        Parameters:
        timeIntervalStart - the value to set
        Returns:
        this builder instance

      • timeIntervalEnd

        public SummarizeSqlStatisticsRequest.Builder timeIntervalEnd​(Date timeIntervalEnd)
        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.

        Parameters:
        timeIntervalEnd - the value to set
        Returns:
        this builder instance

      • limit

        public SummarizeSqlStatisticsRequest.Builder limit​(Integer limit)
        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

        Parameters:
        limit - the value to set
        Returns:
        this builder instance

      • page

        public SummarizeSqlStatisticsRequest.Builder page​(String page)
        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.

        Parameters:
        page - the value to set
        Returns:
        this builder instance

      • opcRequestId

        public SummarizeSqlStatisticsRequest.Builder opcRequestId​(String opcRequestId)
        Unique Oracle-assigned identifier for the request.

        If you need to contact Oracle about a particular request, please provide the request ID.

        Parameters:
        opcRequestId - the value to set
        Returns:
        this builder instance

      • sortOrder

        public SummarizeSqlStatisticsRequest.Builder sortOrder​(SortOrder sortOrder)
        The sort order to use, either ascending (ASC) or descending (DESC).
        Parameters:
        sortOrder - the value to set
        Returns:
        this builder instance

      • definedTagEquals

        public SummarizeSqlStatisticsRequest.Builder definedTagEquals​(List<String> definedTagEquals)
        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”.

        Parameters:
        definedTagEquals - the value to set
        Returns:
        this builder instance

      • definedTagEquals

        public SummarizeSqlStatisticsRequest.Builder definedTagEquals​(String singularValue)
        Singular setter.

        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”.

        Parameters:
        singularValue - the singular value to set
        Returns:
        this builder instance

      • freeformTagEquals

        public SummarizeSqlStatisticsRequest.Builder freeformTagEquals​(List<String> freeformTagEquals)
        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”.

        Parameters:
        freeformTagEquals - the value to set
        Returns:
        this builder instance

      • freeformTagEquals

        public SummarizeSqlStatisticsRequest.Builder freeformTagEquals​(String singularValue)
        Singular setter.

        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”.

        Parameters:
        singularValue - the singular value to set
        Returns:
        this builder instance

      • definedTagExists

        public SummarizeSqlStatisticsRequest.Builder definedTagExists​(List<String> definedTagExists)
        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”.

        Parameters:
        definedTagExists - the value to set
        Returns:
        this builder instance

      • definedTagExists

        public SummarizeSqlStatisticsRequest.Builder definedTagExists​(String singularValue)
        Singular setter.

        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”.

        Parameters:
        singularValue - the singular value to set
        Returns:
        this builder instance

      • freeformTagExists

        public SummarizeSqlStatisticsRequest.Builder freeformTagExists​(List<String> freeformTagExists)
        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”.

        Parameters:
        freeformTagExists - the value to set
        Returns:
        this builder instance

      • freeformTagExists

        public SummarizeSqlStatisticsRequest.Builder freeformTagExists​(String singularValue)
        Singular setter.

        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”.

        Parameters:
        singularValue - the singular value to set
        Returns:
        this builder instance

      • compartmentIdInSubtree

        public SummarizeSqlStatisticsRequest.Builder compartmentIdInSubtree​(Boolean compartmentIdInSubtree)
        A flag to search all resources within a given compartment and all sub-compartments.
        Parameters:
        compartmentIdInSubtree - the value to set
        Returns:
        this builder instance

      • vmclusterName

        public SummarizeSqlStatisticsRequest.Builder vmclusterName​(String singularValue)
        Singular setter.

        Optional list of Exadata Insight VM cluster name.

        Parameters:
        singularValue - the singular value to set
        Returns:
        this builder instance

      • invocationCallback

        public SummarizeSqlStatisticsRequest.Builder invocationCallback​(com.oracle.bmc.http.client.RequestInterceptor invocationCallback)
        Set the invocation callback for the request to be built.
        Parameters:
        invocationCallback - the invocation callback to be set for the request
        Returns:
        this builder instance

      • retryConfiguration

        public SummarizeSqlStatisticsRequest.Builder retryConfiguration​(RetryConfiguration retryConfiguration)
        Set the retry configuration for the request to be built.
        Parameters:
        retryConfiguration - the retry configuration to be used for the request
        Returns:
        this builder instance