Get the endpoint that is being used to call (ex, https://www.example.com).
Sets the endpoint to call (ex, https://www.example.com).
The endpoint of the service.
Sets the region to call (ex, Region.US_PHOENIX_1). Note, this will call {@link #endpoint(String) endpoint} after resolving the endpoint.
The region of the service.
Sets the regionId to call (ex, 'us-phoenix-1').
Note, this will first try to map the region ID to a known Region and call {@link #region(Region) region}. If no known Region could be determined, it will create an endpoint assuming its in default Realm OC1 and then call {@link #endpoint(String) endpoint}.
The public region ID.
Determines whether realm specific endpoint should be used or not. Set realmSpecificEndpointTemplateEnabled to "true" if the user wants to enable use of realm specific endpoint template, otherwise set it to "false"
flag to enable the use of realm specific endpoint template
Adds data files or temp files to the tablespace.
This operation does not retry by default if the user has not defined a retry configuration.
AddDataFilesResponse
Adds a Managed Database to a specific Managed Database Group. After the database is added, it will be included in the management activities performed on the Managed Database Group.
This operation does not retry by default if the user has not defined a retry configuration.
AddManagedDatabaseToManagedDatabaseGroupResponse
Lists the metadata for each ADDM task who's end snapshot time falls within the provided start and end time. Details include the name of the ADDM task, description, user, status and creation date time.
This operation does not retry by default if the user has not defined a retry configuration.
AddmTasksResponse
Changes database parameter values. There are two kinds of database parameters:
- Dynamic parameters: They can be changed for the current Oracle Database instance. The changes take effect immediately. - Static parameters: They cannot be changed for the current instance. You must change these parameters and then restart the database before changes take effect.
*Note:** If the instance is started using a text initialization parameter file, the parameter changes are applicable only for the current instance. You must update them manually to be passed to a future instance.
This operation does not retry by default if the user has not defined a retry configuration.
ChangeDatabaseParametersResponse
Moves the Database Management private endpoint and its dependent resources to the specified compartment. This operation does not retry by default if the user has not defined a retry configuration.
ChangeDbManagementPrivateEndpointCompartmentResponse
Moves the external DB system and its related resources (excluding databases) to the specified compartment.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ChangeExternalDbSystemCompartmentResponse
Moves the Exadata infrastructure and its related resources (Exadata storage server, Exadata storage server connectors and Exadata storage server grid) to the specified compartment.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ChangeExternalExadataInfrastructureCompartmentResponse
Moves a job.
This operation does not retry by default if the user has not defined a retry configuration.
ChangeJobCompartmentResponse
Moves a Managed Database Group to a different compartment. The destination compartment must not have a Managed Database Group with the same name.
This operation does not retry by default if the user has not defined a retry configuration.
ChangeManagedDatabaseGroupCompartmentResponse
Moves a named credential to a different compartment. The destination compartment must not have a named credential with the same name.
This operation does not retry by default if the user has not defined a retry configuration.
ChangeNamedCredentialCompartmentResponse
Changes the retention period of unused plans. The period can range between 5 and 523 weeks.
The database purges plans that have not been used for longer than the plan retention period.
This operation does not retry by default if the user has not defined a retry configuration.
ChangePlanRetentionResponse
Changes the disk space limit for the SQL Management Base. The allowable range for this limit is between 1% and 50%.
This operation does not retry by default if the user has not defined a retry configuration.
ChangeSpaceBudgetResponse
Changes one or more attributes of a single plan or all plans associated with a SQL statement.
This operation does not retry by default if the user has not defined a retry configuration.
ChangeSqlPlanBaselinesAttributesResponse
Checks the status of the external DB system component connection specified in this connector. This operation will refresh the connectionStatus and timeConnectionStatusLastUpdated fields.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
CheckExternalDbSystemConnectorConnectionStatusResponse
Checks the status of the Exadata storage server connection specified by exadataStorageConnectorId.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
CheckExternalExadataStorageConnectorResponse
Close the client once it is no longer needed
Configures automatic capture filters to capture only those statements that match the filter criteria.
This operation does not retry by default if the user has not defined a retry configuration.
ConfigureAutomaticCaptureFiltersResponse
Configures the Automatic SPM Evolve Advisor task SYS_AUTO_SPM_EVOLVE_TASK
by specifying task parameters. As the task is owned by SYS
, only SYS
can
set task parameters.
This operation does not retry by default if the user has not defined a retry configuration.
ConfigureAutomaticSpmEvolveAdvisorTaskResponse
Creates a new Database Management private endpoint.
This operation does not retry by default if the user has not defined a retry configuration.
CreateDbManagementPrivateEndpointResponse
Creates an external DB system and its related resources.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
CreateExternalDbSystemResponse
Creates a new external connector. This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
CreateExternalDbSystemConnectorResponse
Creates an external DB system discovery resource and initiates the discovery process.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
CreateExternalDbSystemDiscoveryResponse
Creates an OCI resource for the Exadata infrastructure and enables the Monitoring service for the Exadata infrastructure. The following resource/subresources are created: Infrastructure Storage server connectors Storage servers Storage grids
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
CreateExternalExadataInfrastructureResponse
Creates the Exadata storage server connector after validating the connection information.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
CreateExternalExadataStorageConnectorResponse
Creates a job to be executed on a Managed Database or Managed Database Group. Only one of the parameters, managedDatabaseId or managedDatabaseGroupId should be provided as input in CreateJobDetails resource in request body.
This operation does not retry by default if the user has not defined a retry configuration.
CreateJobResponse
Creates a Managed Database Group. The group does not contain any Managed Databases when it is created, and they must be added later.
This operation does not retry by default if the user has not defined a retry configuration.
CreateManagedDatabaseGroupResponse
Creates a named credential.
This operation does not retry by default if the user has not defined a retry configuration.
CreateNamedCredentialResponse
Creates a tablespace within the Managed Database specified by managedDatabaseId.
This operation does not retry by default if the user has not defined a retry configuration.
CreateTablespaceResponse
Creates a new DbManagementWaiter for resources for this service.
The waiter configuration for termination and delay strategy
The service waiters.
Deletes a specific Database Management private endpoint. This operation does not retry by default if the user has not defined a retry configuration.
DeleteDbManagementPrivateEndpointResponse
Deletes the external DB system specified by externalDbSystemId
.
This operation does not retry by default if the user has not defined a retry configuration.
DeleteExternalDbSystemResponse
Deletes the external connector specified by externalDbSystemConnectorId
.
This operation does not retry by default if the user has not defined a retry configuration.
DeleteExternalDbSystemConnectorResponse
Deletes the external DB system discovery resource specified by externalDbSystemDiscoveryId
.
This operation does not retry by default if the user has not defined a retry configuration.
DeleteExternalDbSystemDiscoveryResponse
Deletes the Exadata infrastructure specified by externalExadataInfrastructureId.
This operation does not retry by default if the user has not defined a retry configuration.
DeleteExternalExadataInfrastructureResponse
Deletes the Exadata storage server connector specified by exadataStorageConnectorId.
This operation does not retry by default if the user has not defined a retry configuration.
DeleteExternalExadataStorageConnectorResponse
Deletes the job specified by jobId. This operation does not retry by default if the user has not defined a retry configuration.
DeleteJobResponse
Deletes the Managed Database Group specified by managedDatabaseGroupId. If the group contains Managed Databases, then it cannot be deleted.
This operation does not retry by default if the user has not defined a retry configuration.
DeleteManagedDatabaseGroupResponse
Deletes the named credential specified by namedCredentialId.
This operation does not retry by default if the user has not defined a retry configuration.
DeleteNamedCredentialResponse
Deletes the preferred credential based on the credentialName.
This operation does not retry by default if the user has not defined a retry configuration.
DeletePreferredCredentialResponse
Disables automatic initial plan capture.
This operation does not retry by default if the user has not defined a retry configuration.
DisableAutomaticInitialPlanCaptureResponse
Disables the Automatic SPM Evolve Advisor task.
One client controls both Automatic SQL Tuning Advisor and Automatic SPM Evolve Advisor. Thus, the same task enables or disables both.
This operation does not retry by default if the user has not defined a retry configuration.
DisableAutomaticSpmEvolveAdvisorTaskResponse
Disables a Database Management feature for the specified Autonomous Database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
DisableAutonomousDatabaseManagementFeatureResponse
Disables a Database Management feature for the specified Oracle cloud database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
DisableDatabaseManagementFeatureResponse
Disables a Database Management feature for the specified external container database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
DisableExternalContainerDatabaseManagementFeatureResponse
Disables Database Management service for all the components of the specified external DB system (except databases).
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
DisableExternalDbSystemDatabaseManagementResponse
Disables Stack Monitoring for all the components of the specified external DB system (except databases).
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
DisableExternalDbSystemStackMonitoringResponse
Disables Database Management for the Exadata infrastructure specified by externalExadataInfrastructureId. It covers the following components:
- Exadata infrastructure - Exadata storage grid - Exadata storage server
Note that Database Management will not be disabled for the DB systems within the Exadata infrastructure and should be disabled explicitly, if required.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
DisableExternalExadataInfrastructureManagementResponse
Disables a Database Management feature for the specified external non-container database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
DisableExternalNonContainerDatabaseManagementFeatureResponse
Disables a Database Management feature for the specified external pluggable database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
DisableExternalPluggableDatabaseManagementFeatureResponse
Disables the high-frequency Automatic SPM Evolve Advisor task.
It is available only on Oracle Exadata Database Machine, Oracle Database Exadata Cloud Service (ExaCS) and Oracle Database Exadata Cloud@Customer (ExaCC).
This operation does not retry by default if the user has not defined a retry configuration.
DisableHighFrequencyAutomaticSpmEvolveAdvisorTaskResponse
Disables a Database Management feature for the specified Oracle cloud pluggable database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
DisablePluggableDatabaseManagementFeatureResponse
Disables the use of SQL plan baselines stored in SQL Management Base.
When disabled, the optimizer does not use any SQL plan baselines.
This operation does not retry by default if the user has not defined a retry configuration.
DisableSqlPlanBaselinesUsageResponse
Completes the Exadata system prechecking on the following:
- Verifies if the DB systems are valid RAC DB systems or return 400 status code with NON_RAC_DATABASE_SYSTEM error code. - Verifies if the ASM connector defined for each DB system or return 400 status code with CONNECTOR_NOT_DEFINED error code. - Verifies if the agents associated with ASM are valid and could be used for the Exadata storage servers or return 400 status code with INVALID_AGENT error code. - Verifies if it is an Exadata system or return 400 status code with INVALID_EXADATA_SYSTEM error code.
Starts the discovery process for the Exadata system infrastructure. The following resources/components are discovered
- Exadata storage servers from each DB systems - Exadata storage grid for all Exadata storage servers - Exadata infrastructure
The same API covers both new discovery and rediscovery cases. For the new discovery case, new managed resources/sub-resources are created or the existing ones are overridden. For rediscovery case, the existing managed resources/sub-resources are checked to find out which ones should be added or which ones should be removed based on the unique key defined for each resource/sub-resource.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
DiscoverExternalExadataInfrastructureResponse
Drops a single plan or all plans associated with a SQL statement.
This operation does not retry by default if the user has not defined a retry configuration.
DropSqlPlanBaselinesResponse
Drops the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.
This operation does not retry by default if the user has not defined a retry configuration.
DropTablespaceResponse
Enables automatic initial plan capture. When enabled, the database checks whether executed SQL statements are eligible for automatic capture. It creates initial plan baselines for eligible statements.
By default, the database creates a SQL plan baseline for every eligible repeatable statement, including all recursive SQL and monitoring SQL. Thus, automatic capture may result in the creation of an extremely large number of plan baselines. To limit the statements that are eligible for plan baselines, configure filters.
This operation does not retry by default if the user has not defined a retry configuration.
EnableAutomaticInitialPlanCaptureResponse
Enables the Automatic SPM Evolve Advisor task. By default, the automatic task
SYS_AUTO_SPM_EVOLVE_TASK
runs every day in the scheduled maintenance window.
The SPM Evolve Advisor performs the following tasks:
- Checks AWR for top SQL - Looks for alternative plans in all available sources - Adds unaccepted plans to the plan history - Tests the execution of as many plans as possible during the maintenance window - Adds the alternative plan to the baseline if it performs better than the current plan
One client controls both Automatic SQL Tuning Advisor and Automatic SPM Evolve Advisor. Thus, the same task enables or disables both.
This operation does not retry by default if the user has not defined a retry configuration.
EnableAutomaticSpmEvolveAdvisorTaskResponse
Enables a Database Management feature for the specified Autonomous Database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
EnableAutonomousDatabaseManagementFeatureResponse
Enables a Database Management feature for the specified cloud database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
EnableDatabaseManagementFeatureResponse
Enables a Database Management feature for the specified external container database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
EnableExternalContainerDatabaseManagementFeatureResponse
Enables Database Management service for all the components of the specified external DB system (except databases).
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
EnableExternalDbSystemDatabaseManagementResponse
Enables Stack Monitoring for all the components of the specified external DB system (except databases).
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
EnableExternalDbSystemStackMonitoringResponse
Enables Database Management for the Exadata infrastructure specified by externalExadataInfrastructureId. It covers the following components:
- Exadata infrastructure - Exadata storage grid - Exadata storage server
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
EnableExternalExadataInfrastructureManagementResponse
Enables Database Management feature for the specified external non-container database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
EnableExternalNonContainerDatabaseManagementFeatureResponse
Enables a Database Management feature for the specified external pluggable database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
EnableExternalPluggableDatabaseManagementFeatureResponse
Enables the high-frequency Automatic SPM Evolve Advisor task. The high-frequency task runs every hour and runs for no longer than 30 minutes. These settings are not configurable.
The high-frequency task complements the standard Automatic SPM Evolve Advisor task. They are independent and are scheduled through two different frameworks.
It is available only on Oracle Exadata Database Machine, Oracle Database Exadata Cloud Service (ExaCS) and Oracle Database Exadata Cloud@Customer (ExaCC).
This operation does not retry by default if the user has not defined a retry configuration.
EnableHighFrequencyAutomaticSpmEvolveAdvisorTaskResponse
Enables a Database Management feature for the specified Oracle cloud pluggable database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
EnablePluggableDatabaseManagementFeatureResponse
Enables the use of SQL plan baselines stored in SQL Management Base.
When enabled, the optimizer uses SQL plan baselines to select plans to avoid potential performance regressions.
This operation does not retry by default if the user has not defined a retry configuration.
EnableSqlPlanBaselinesUsageResponse
Creates an AWR snapshot for the target database.
This operation does not retry by default if the user has not defined a retry configuration.
GenerateAwrSnapshotResponse
Gets the AWR report for the specific database.
This operation does not retry by default if the user has not defined a retry configuration.
GetAwrDbReportResponse
Gets the SQL health check report for one SQL of the specific database.
This operation does not retry by default if the user has not defined a retry configuration.
GetAwrDbSqlReportResponse
Gets the metrics related to cluster cache for the Oracle Real Application Clusters (Oracle RAC) database specified by managedDatabaseId.
This operation does not retry by default if the user has not defined a retry configuration.
GetClusterCacheMetricResponse
Gets the health metrics for a fleet of databases in a compartment or in a Managed Database Group. Either the CompartmentId or the ManagedDatabaseGroupId query parameters must be provided to retrieve the health metrics.
This operation does not retry by default if the user has not defined a retry configuration.
GetDatabaseFleetHealthMetricsResponse
Gets a summary of the activity and resource usage metrics like DB Time, CPU, User I/O, Wait, Storage, and Memory for a Managed Database. This operation does not retry by default if the user has not defined a retry configuration.
GetDatabaseHomeMetricsResponse
Gets a historical summary of the Database Guard performance metrics for Managed Databases. If the peerDatabaseCompartmentId is specified, then the metrics are only retrieved from the specified compartment. If the peerDatabaseCompartmentId is not specified, then the metrics are retrieved from the compartment of the Managed Database specified by the ManagedDatabaseId.
This operation does not retry by default if the user has not defined a retry configuration.
GetDataguardPerformanceMetricsResponse
Gets the details of a specific Database Management private endpoint. This operation does not retry by default if the user has not defined a retry configuration.
GetDbManagementPrivateEndpointResponse
Gets the details for the external ASM specified by externalAsmId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetExternalAsmResponse
Gets configuration details including disk groups for the external ASM specified by externalAsmId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetExternalAsmConfigurationResponse
Gets the details for the external ASM instance specified by externalAsmInstanceId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetExternalAsmInstanceResponse
Gets the details for the external cluster specified by externalClusterId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetExternalClusterResponse
Gets the details for the external cluster instance specified by externalClusterInstanceId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetExternalClusterInstanceResponse
Gets the details for the external DB home specified by externalDbHomeId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetExternalDbHomeResponse
Gets the details for the external DB node specified by externalDbNodeId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetExternalDbNodeResponse
Gets the details for the external DB system specified by externalDbSystemId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetExternalDbSystemResponse
Gets the details for the external connector specified by externalDbSystemConnectorId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetExternalDbSystemConnectorResponse
Gets the details for the external DB system discovery resource specified by externalDbSystemDiscoveryId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetExternalDbSystemDiscoveryResponse
Gets the details for the Exadata infrastructure specified by externalExadataInfrastructureId. It includes the DB systems and storage grid within the Exadata infrastructure.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetExternalExadataInfrastructureResponse
Gets the details for the Exadata storage server connector specified by exadataStorageConnectorId.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetExternalExadataStorageConnectorResponse
Gets the details for the Exadata storage server grid specified by exadataStorageGridId.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetExternalExadataStorageGridResponse
Gets the summary for the Exadata storage server specified by exadataStorageServerId.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetExternalExadataStorageServerResponse
Gets the details for the external listener specified by externalListenerId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetExternalListenerResponse
Get the IORM plan from the specific Exadata storage server.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetIormPlanResponse
Gets the details for the job specified by jobId.
This operation does not retry by default if the user has not defined a retry configuration.
GetJobResponse
Gets the details for the job execution specified by jobExecutionId.
This operation does not retry by default if the user has not defined a retry configuration.
GetJobExecutionResponse
Gets the details for the job run specified by jobRunId.
This operation does not retry by default if the user has not defined a retry configuration.
GetJobRunResponse
Gets the details for the Managed Database specified by managedDatabaseId.
This operation does not retry by default if the user has not defined a retry configuration.
GetManagedDatabaseResponse
Gets the details for the Managed Database Group specified by managedDatabaseGroupId.
This operation does not retry by default if the user has not defined a retry configuration.
GetManagedDatabaseGroupResponse
Gets the details for the named credential specified by namedCredentialId.
This operation does not retry by default if the user has not defined a retry configuration.
GetNamedCredentialResponse
Gets the open alerts from the specified Exadata storage server.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetOpenAlertHistoryResponse
Gets a comprehensive report of the Optimizer Statistics Advisor execution, which includes details of the Managed Database, findings, recommendations, rationale, and examples.
This operation does not retry by default if the user has not defined a retry configuration.
GetOptimizerStatisticsAdvisorExecutionResponse
Gets the Oracle system-generated script for the specified Optimizer Statistics Advisor execution. This operation does not retry by default if the user has not defined a retry configuration.
GetOptimizerStatisticsAdvisorExecutionScriptResponse
Gets a detailed report of the Optimizer Statistics Collection operation for the specified Managed Database. This operation does not retry by default if the user has not defined a retry configuration.
GetOptimizerStatisticsCollectionOperationResponse
Gets a summary of the resource usage metrics such as CPU, User I/O, and Storage for each PDB within a specific CDB. If comparmentId is specified, then the metrics for each PDB (within the CDB) in the specified compartment are retrieved. If compartmentId is not specified, then the metrics for all the PDBs within the CDB are retrieved.
This operation does not retry by default if the user has not defined a retry configuration.
GetPdbMetricsResponse
Gets a comparative summary of the baseline and target values of the Data Guard performance metrics for Managed Databases. If the peerDatabaseCompartmentId is specified, then the metrics are only retrieved from the specified compartment. If the peerDatabaseCompartmentId is not specified, then the metrics are retrieved from the compartment of the Managed Database specified by the ManagedDatabaseId.
This operation does not retry by default if the user has not defined a retry configuration.
GetPeerDatabaseMetricsResponse
Gets the preferred credential details for a Managed Database based on credentialName.
This operation does not retry by default if the user has not defined a retry configuration.
GetPreferredCredentialResponse
Gets the SQL plan baseline details for the specified planName.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetSqlPlanBaselineResponse
Gets the configuration details of SQL plan baselines for the specified Managed Database. The details include the settings for the capture and use of SQL plan baselines, SPM Evolve Advisor task, and SQL Management Base.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetSqlPlanBaselineConfigurationResponse
Gets the details of the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.
This operation does not retry by default if the user has not defined a retry configuration.
GetTablespaceResponse
Gets the SQL IDs with the top CPU activity from the Exadata storage server.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
GetTopSqlCpuActivityResponse
Gets the details of the user specified by managedDatabaseId and userName.
This operation does not retry by default if the user has not defined a retry configuration.
GetUserResponse
Gets the waiters available for resources for this service.
The service waiters.
Gets the status of the work request with the given Work Request ID This operation does not retry by default if the user has not defined a retry configuration.
GetWorkRequestResponse
Asynchronously implements the findings and recommendations of the Optimizer Statistics Advisor execution. This operation does not retry by default if the user has not defined a retry configuration.
ImplementOptimizerStatisticsAdvisorRecommendationsResponse
Gets the list of ASM properties for the specified managedDatabaseId. This operation does not retry by default if the user has not defined a retry configuration.
ListAsmPropertiesResponse
Gets the list of databases using a specific Database Management private endpoint. This operation does not retry by default if the user has not defined a retry configuration.
ListAssociatedDatabasesResponse
Lists AWR snapshots for the specified database in the AWR.
This operation does not retry by default if the user has not defined a retry configuration.
ListAwrDbSnapshotsResponse
Gets the list of databases and their snapshot summary details available in the AWR of the specified Managed Database.
This operation does not retry by default if the user has not defined a retry configuration.
ListAwrDbsResponse
Gets the list of consumer group privileges granted to a specific user. This operation does not retry by default if the user has not defined a retry configuration.
ListConsumerGroupPrivilegesResponse
Lists the SQL statements from shared SQL area, also called the cursor cache.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListCursorCacheStatementsResponse
Gets the list of containers for a specific user. This is only applicable if ALL_CONTAINERS !='Y'. This operation does not retry by default if the user has not defined a retry configuration.
ListDataAccessContainersResponse
Gets the list of database parameters for the specified Managed Database. The parameters are listed in alphabetical order, along with their current values.
This operation does not retry by default if the user has not defined a retry configuration.
ListDatabaseParametersResponse
Gets a list of Database Management private endpoints.
This operation does not retry by default if the user has not defined a retry configuration.
ListDbManagementPrivateEndpointsResponse
Lists ASM disk groups for the external ASM specified by externalAsmId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalAsmDiskGroupsResponse
Lists the ASM instances in the specified external ASM. This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalAsmInstancesResponse
Lists ASM users for the external ASM specified by externalAsmId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalAsmUsersResponse
Lists the ASMs in the specified external DB system. This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalAsmsResponse
Lists the cluster instances in the specified external cluster. This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalClusterInstancesResponse
Lists the clusters in the specified external DB system. This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalClustersResponse
Lists the external databases in the specified compartment or in the specified DB system. This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalDatabasesResponse
Lists the DB homes in the specified external DB system. This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalDbHomesResponse
Lists the external DB nodes in the specified external DB system. This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalDbNodesResponse
Lists the external connectors in the specified external DB system. This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalDbSystemConnectorsResponse
Lists the external DB system discovery resources in the specified compartment. This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalDbSystemDiscoveriesResponse
Lists the external DB systems in the specified compartment. This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalDbSystemsResponse
Lists the Exadata infrastructure resources in the specified compartment.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalExadataInfrastructuresResponse
Lists the Exadata storage server connectors for the specified Exadata infrastructure.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalExadataStorageConnectorsResponse
Lists the Exadata storage servers for the specified Exadata infrastructure.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalExadataStorageServersResponse
Lists the database services registered with the specified external listener for the specified Managed Database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalListenerServicesResponse
Lists the listeners in the specified external DB system. This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListExternalListenersResponse
Gets the job execution for a specific ID or the list of job executions for a job, job run, Managed Database or Managed Database Group in a specific compartment. Only one of the parameters, ID, jobId, jobRunId, managedDatabaseId or managedDatabaseGroupId should be provided. If none of these parameters is provided, all the job executions in the compartment are listed. Job executions can also be filtered based on the name and status parameters.
This operation does not retry by default if the user has not defined a retry configuration.
ListJobExecutionsResponse
Gets the job run for a specific ID or the list of job runs for a job, Managed Database or Managed Database Group in a specific compartment. Only one of the parameters, ID, jobId, managedDatabaseId, or managedDatabaseGroupId should be provided. If none of these parameters is provided, all the job runs in the compartment are listed. Job runs can also be filtered based on name and runStatus parameters.
This operation does not retry by default if the user has not defined a retry configuration.
ListJobRunsResponse
Gets the job for a specific ID or the list of jobs for a Managed Database or Managed Database Group in a specific compartment. Only one of the parameters, ID, managedDatabaseId or managedDatabaseGroupId, should be provided. If none of these parameters is provided, all the jobs in the compartment are listed. Jobs can also be filtered based on the name and lifecycleState parameters.
This operation does not retry by default if the user has not defined a retry configuration.
ListJobsResponse
Gets the Managed Database Group for a specific ID or the list of Managed Database Groups in a specific compartment. Managed Database Groups can also be filtered based on the name parameter. Only one of the parameters, ID or name should be provided. If none of these parameters is provided, all the Managed Database Groups in the compartment are listed.
This operation does not retry by default if the user has not defined a retry configuration.
ListManagedDatabaseGroupsResponse
Gets the Managed Database for a specific ID or the list of Managed Databases in a specific compartment.
Managed Databases can be filtered based on the name parameter. Only one of the parameters, ID or name
should be provided. If neither of these parameters is provided, all the Managed Databases in the compartment
are listed. Managed Databases can also be filtered based on the deployment type and management option.
If the deployment type is not specified or if it is ONPREMISE
, then the management option is not
considered and Managed Databases with ADVANCED
management option are listed.
This operation does not retry by default if the user has not defined a retry configuration.
ListManagedDatabasesResponse
Gets a single named credential specified by the name or all the named credentials in a specific compartment.
This operation does not retry by default if the user has not defined a retry configuration.
ListNamedCredentialsResponse
Gets the list of object privileges granted to a specific user. This operation does not retry by default if the user has not defined a retry configuration.
ListObjectPrivilegesResponse
Lists the details of the Optimizer Statistics Advisor task executions, such as their duration, and the number of findings, if any. Optionally, you can specify a date-time range (of seven days) to obtain the list of executions that fall within the specified time range. If the date-time range is not specified, then the executions in the last seven days are listed.
This operation does not retry by default if the user has not defined a retry configuration.
ListOptimizerStatisticsAdvisorExecutionsResponse
Gets a list of the optimizer statistics collection operations per hour, grouped by task or object status for the specified Managed Database. You must specify a value for GroupByQueryParam to determine whether the data should be grouped by task status or task object status. Optionally, you can specify a date-time range (of seven days) to obtain collection aggregations within the specified time range. If the date-time range is not specified, then the operations in the last seven days are listed. You can further filter the results by providing the optional type of TaskTypeQueryParam. If the task type not provided, then both Auto and Manual tasks are considered for aggregation.
This operation does not retry by default if the user has not defined a retry configuration.
ListOptimizerStatisticsCollectionAggregationsResponse
Lists the Optimizer Statistics Collection (Auto and Manual) task operation summary for the specified Managed Database. The summary includes the details of each operation and the number of tasks grouped by status: Completed, In Progress, Failed, and so on. Optionally, you can specify a date-time range (of seven days) to obtain the list of operations that fall within the specified time range. If the date-time range is not specified, then the operations in the last seven days are listed. This API also enables the pagination of results and the opc-next-page response header indicates whether there is a next page. If you use the same header value in a consecutive request, the next page records are returned. To obtain the required results, you can apply the different types of filters supported by this API.
This operation does not retry by default if the user has not defined a retry configuration.
ListOptimizerStatisticsCollectionOperationsResponse
Gets the list of preferred credentials for a given Managed Database.
This operation does not retry by default if the user has not defined a retry configuration.
ListPreferredCredentialsResponse
Gets the list of users on whose behalf the current user acts as proxy. This operation does not retry by default if the user has not defined a retry configuration.
ListProxiedForUsersResponse
Gets the list of proxy users for the current user. This operation does not retry by default if the user has not defined a retry configuration.
ListProxyUsersResponse
Gets the list of roles granted to a specific user. This operation does not retry by default if the user has not defined a retry configuration.
ListRolesResponse
Lists the database jobs used for loading SQL plan baselines in the specified Managed Database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListSqlPlanBaselineJobsResponse
Lists the SQL plan baselines for the specified Managed Database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ListSqlPlanBaselinesResponse
Gets the list of system privileges granted to a specific user. This operation does not retry by default if the user has not defined a retry configuration.
ListSystemPrivilegesResponse
Lists the database table statistics grouped by different statuses such as Not Stale Stats, Stale Stats, and No Stats. This also includes the percentage of each status.
This operation does not retry by default if the user has not defined a retry configuration.
ListTableStatisticsResponse
Gets the list of tablespaces for the specified managedDatabaseId. This operation does not retry by default if the user has not defined a retry configuration.
ListTablespacesResponse
Gets the list of users for the specified managedDatabaseId. This operation does not retry by default if the user has not defined a retry configuration.
ListUsersResponse
Returns a paginated list of errors for a given work request.
This operation does not retry by default if the user has not defined a retry configuration.
ListWorkRequestErrorsResponse
Returns a paginated list of logs for a given work request.
This operation does not retry by default if the user has not defined a retry configuration.
ListWorkRequestLogsResponse
The list of work requests in a specific compartment was retrieved successfully.
This operation does not retry by default if the user has not defined a retry configuration.
ListWorkRequestsResponse
Loads plans from Automatic Workload Repository (AWR) snapshots. You must specify the beginning and ending of the snapshot range. Optionally, you can apply a filter to load only plans that meet specified criteria. By default, the optimizer uses the loaded plans the next time that the database executes the SQL statements.
This operation does not retry by default if the user has not defined a retry configuration.
LoadSqlPlanBaselinesFromAwrResponse
Loads plans for statements directly from the shared SQL area, also called the cursor cache. By applying a filter on the module name, the schema, or the SQL ID you identify the SQL statement or set of SQL statements to load.
This operation does not retry by default if the user has not defined a retry configuration.
LoadSqlPlanBaselinesFromCursorCacheResponse
Modifies the Database Management feature for the specified Autonomous Database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ModifyAutonomousDatabaseManagementFeatureResponse
Modifies a Database Management feature for the specified Oracle cloud database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ModifyDatabaseManagementFeatureResponse
Modifies the Database Management feature for the specified Oracle cloud pluggable database.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
ModifyPluggableDatabaseManagementFeatureResponse
Patches the external DB system discovery specified by externalDbSystemDiscoveryId
.
This operation does not retry by default if the user has not defined a retry configuration.
PatchExternalDbSystemDiscoveryResponse
Removes a data file or temp file from the tablespace.
This operation does not retry by default if the user has not defined a retry configuration.
RemoveDataFileResponse
Removes a Managed Database from a Managed Database Group. Any management activities that are currently running on this database will continue to run to completion. However, any activities scheduled to run in the future will not be performed on this database.
This operation does not retry by default if the user has not defined a retry configuration.
RemoveManagedDatabaseFromManagedDatabaseGroupResponse
Resets database parameter values to their default or startup values.
This operation does not retry by default if the user has not defined a retry configuration.
ResetDatabaseParametersResponse
Resizes a data file or temp file within the tablespace.
This operation does not retry by default if the user has not defined a retry configuration.
ResizeDataFileResponse
Creates and executes a historic ADDM task using the specified AWR snapshot IDs. If an existing ADDM task uses the provided awr snapshot IDs, the existing task will be returned.
This operation does not retry by default if the user has not defined a retry configuration.
RunHistoricAddmResponse
Shutdown the circuit breaker used by the client when it is no longer needed
Summarizes the AWR CPU resource limits and metrics for the specified database in AWR.
This operation does not retry by default if the user has not defined a retry configuration.
SummarizeAwrDbCpuUsagesResponse
Summarizes the metric samples for the specified database in the AWR. The metric samples are summarized based on the Time dimension for each metric.
This operation does not retry by default if the user has not defined a retry configuration.
SummarizeAwrDbMetricsResponse
Summarizes the database parameter change history for one database parameter of the specified database in AWR. One change history record contains the previous value, the changed value, and the corresponding time range. If the database parameter value was changed multiple times within the time range, then multiple change history records are created for the same parameter. Note that this API only returns information on change history details for one database parameter. To get a list of all the database parameters whose values were changed during a specified time range, use the following API endpoint: /managedDatabases/{managedDatabaseId}/awrDbs/{awrDbId}/awrDbParameters
This operation does not retry by default if the user has not defined a retry configuration.
SummarizeAwrDbParameterChangesResponse
Summarizes the database parameter history for the specified database in AWR. This includes the list of database parameters, with information on whether the parameter values were modified within the query time range. Note that each database parameter is only listed once. Depending on the optional query parameters, the returned summary gets all the database parameters, which include:
- Each parameter whose value was changed during the time range: (valueChanged =\"Y\") - Each parameter whose value was unchanged during the time range: (valueChanged =\"N\") - Each parameter whose value was changed at the system level during the time range: (valueChanged =\"Y\" and valueModified = \"SYSTEM_MOD\") - Each parameter whose value was unchanged during the time range, however, the value is not the default value: (valueChanged =\"N\" and valueDefault = \"FALSE\")
Note that this API does not return information on the number of times each database parameter has been changed within the time range. To get the database parameter value change history for a specific parameter, use the following API endpoint: /managedDatabases/{managedDatabaseId}/awrDbs/{awrDbId}/awrDbParameterChanges
This operation does not retry by default if the user has not defined a retry configuration.
SummarizeAwrDbParametersResponse
Summarizes the AWR snapshot ranges that contain continuous snapshots, for the specified Managed Database.
This operation does not retry by default if the user has not defined a retry configuration.
SummarizeAwrDbSnapshotRangesResponse
Summarizes the AWR SYSSTAT sample data for the specified database in AWR. The statistical data is summarized based on the Time dimension for each statistic.
This operation does not retry by default if the user has not defined a retry configuration.
SummarizeAwrDbSysstatsResponse
Summarizes the AWR top wait events.
This operation does not retry by default if the user has not defined a retry configuration.
SummarizeAwrDbTopWaitEventsResponse
Summarizes AWR wait event data into value buckets and frequency, for the specified database in the AWR.
This operation does not retry by default if the user has not defined a retry configuration.
SummarizeAwrDbWaitEventBucketsResponse
Summarizes the AWR wait event sample data for the specified database in the AWR. The event data is summarized based on the Time dimension for each event.
This operation does not retry by default if the user has not defined a retry configuration.
SummarizeAwrDbWaitEventsResponse
Gets metrics for the external ASM specified by externalAsmId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
SummarizeExternalAsmMetricsResponse
Gets metrics for the external cluster specified by externalClusterId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
SummarizeExternalClusterMetricsResponse
Gets metrics for the external DB node specified by externalDbNodeId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
SummarizeExternalDbNodeMetricsResponse
Gets availability metrics for the components present in the external DB system specified by externalDbSystemId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
SummarizeExternalDbSystemAvailabilityMetricsResponse
Gets metrics for the external listener specified by externalListenerId
.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
SummarizeExternalListenerMetricsResponse
Gets the number of job executions grouped by status for a job, Managed Database, or Database Group in a specific compartment. Only one of the parameters, jobId, managedDatabaseId, or managedDatabaseGroupId should be provided. This operation does not retry by default if the user has not defined a retry configuration.
SummarizeJobExecutionsStatusesResponse
Gets the availability metrics related to managed database for the Oracle database specified by managedDatabaseId.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
SummarizeManagedDatabaseAvailabilityMetricsResponse
Gets the number of SQL plan baselines aggregated by their attributes.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
SummarizeSqlPlanBaselinesResponse
Gets the number of SQL plan baselines aggregated by the age of their last execution in weeks.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
SummarizeSqlPlanBaselinesByLastExecutionResponse
Tests the named credential.
This operation does not retry by default if the user has not defined a retry configuration.
TestNamedCredentialResponse
Tests the preferred credential.
This operation does not retry by default if the user has not defined a retry configuration.
TestPreferredCredentialResponse
Updates one or more attributes of a specific Database Management private endpoint. This operation does not retry by default if the user has not defined a retry configuration.
UpdateDbManagementPrivateEndpointResponse
Updates the external ASM specified by externalAsmId
.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateExternalAsmResponse
Updates the external ASM instance specified by externalAsmInstanceId
.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateExternalAsmInstanceResponse
Updates the external cluster specified by externalClusterId
.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateExternalClusterResponse
Updates the external cluster instance specified by externalClusterInstanceId
.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateExternalClusterInstanceResponse
Updates the external DB home specified by externalDbHomeId
.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateExternalDbHomeResponse
Updates the external DB node specified by externalDbNodeId
.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateExternalDbNodeResponse
Updates the external DB system specified by externalDbSystemId
.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateExternalDbSystemResponse
Updates the external connector specified by externalDbSystemConnectorId
.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateExternalDbSystemConnectorResponse
Updates the external DB system discovery specified by externalDbSystemDiscoveryId
.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateExternalDbSystemDiscoveryResponse
Updates the details for the Exadata infrastructure specified by externalExadataInfrastructureId.
This operation uses {@link common.OciSdkDefaultRetryConfiguration} by default if no retry configuration is defined by the user.
UpdateExternalExadataInfrastructureResponse
Updates the Exadata storage server connector specified by exadataStorageConnectorId.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateExternalExadataStorageConnectorResponse
Updates the Exadata storage server grid specified by exadataStorageGridId.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateExternalExadataStorageGridResponse
Updates the Exadata storage server specified by exadataStorageServerId.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateExternalExadataStorageServerResponse
Updates the external listener specified by externalListenerId
.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateExternalListenerResponse
Updates the details for the recurring scheduled job specified by jobId. Note that non-recurring (one time) jobs cannot be updated.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateJobResponse
Updates the Managed Database specified by managedDatabaseId.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateManagedDatabaseResponse
Updates the Managed Database Group specified by managedDatabaseGroupId.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateManagedDatabaseGroupResponse
Updates the named credential specified by namedCredentialId.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateNamedCredentialResponse
Updates the preferred credential based on the credentialName.
This operation does not retry by default if the user has not defined a retry configuration.
UpdatePreferredCredentialResponse
Updates the attributes of the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.
This operation does not retry by default if the user has not defined a retry configuration.
UpdateTablespaceResponse
This service client uses {@link common.CircuitBreaker.DefaultConfiguration} for all the operations by default if no circuit breaker configuration is defined by the user.