@Generated(value="OracleSDKGenerator", comments="API Version: 20201101") public interface DbManagementAsync extends AutoCloseable
Use the Database Management API to monitor and manage resources such as Oracle Databases, MySQL Databases, and External Database Systems. For more information, see Database Management.
close
void refreshClient()
Rebuilds the client from scratch. Useful to refresh certificates.
void setEndpoint(String endpoint)
Sets the endpoint to call (ex, https://www.example.com).
endpoint
- The endpoint of the serice.String getEndpoint()
Gets the set endpoint for REST call (ex, https://www.example.com)
void setRegion(Region region)
Sets the region to call (ex, Region.US_PHOENIX_1).
Note, this will call setEndpoint
after resolving the
endpoint. If the service is not available in this region, however, an
IllegalArgumentException will be raised.
region
- The region of the service.void setRegion(String regionId)
Sets the region to call (ex, ‘us-phoenix-1’).
Note, this will first try to map the region ID to a known Region and call setRegion
.
If no known Region could be determined, it will create an endpoint based on the default
endpoint format (Region.formatDefaultRegionEndpoint(Service, String)
and then call setEndpoint
.
regionId
- The public region ID.void useRealmSpecificEndpointTemplate(boolean realmSpecificEndpointTemplateEnabled)
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”
realmSpecificEndpointTemplateEnabled
- flag to enable the use of realm specific endpoint
templateFuture<AddDataFilesResponse> addDataFiles(AddDataFilesRequest request, AsyncHandler<AddDataFilesRequest,AddDataFilesResponse> handler)
Adds data files or temp files to the tablespace.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<AddManagedDatabaseToManagedDatabaseGroupResponse> addManagedDatabaseToManagedDatabaseGroup(AddManagedDatabaseToManagedDatabaseGroupRequest request, AsyncHandler<AddManagedDatabaseToManagedDatabaseGroupRequest,AddManagedDatabaseToManagedDatabaseGroupResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<AddmTasksResponse> addmTasks(AddmTasksRequest request, AsyncHandler<AddmTasksRequest,AddmTasksResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ChangeDatabaseParametersResponse> changeDatabaseParameters(ChangeDatabaseParametersRequest request, AsyncHandler<ChangeDatabaseParametersRequest,ChangeDatabaseParametersResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ChangeDbManagementPrivateEndpointCompartmentResponse> changeDbManagementPrivateEndpointCompartment(ChangeDbManagementPrivateEndpointCompartmentRequest request, AsyncHandler<ChangeDbManagementPrivateEndpointCompartmentRequest,ChangeDbManagementPrivateEndpointCompartmentResponse> handler)
Moves the Database Management private endpoint and its dependent resources to the specified compartment.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ChangeExternalDbSystemCompartmentResponse> changeExternalDbSystemCompartment(ChangeExternalDbSystemCompartmentRequest request, AsyncHandler<ChangeExternalDbSystemCompartmentRequest,ChangeExternalDbSystemCompartmentResponse> handler)
Moves the external DB system and its related resources (excluding databases) to the specified compartment.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ChangeExternalExadataInfrastructureCompartmentResponse> changeExternalExadataInfrastructureCompartment(ChangeExternalExadataInfrastructureCompartmentRequest request, AsyncHandler<ChangeExternalExadataInfrastructureCompartmentRequest,ChangeExternalExadataInfrastructureCompartmentResponse> handler)
Moves the Exadata infrastructure and its related resources (Exadata storage server, Exadata storage server connectors and Exadata storage server grid) to the specified compartment.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ChangeJobCompartmentResponse> changeJobCompartment(ChangeJobCompartmentRequest request, AsyncHandler<ChangeJobCompartmentRequest,ChangeJobCompartmentResponse> handler)
Moves a job.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ChangeManagedDatabaseGroupCompartmentResponse> changeManagedDatabaseGroupCompartment(ChangeManagedDatabaseGroupCompartmentRequest request, AsyncHandler<ChangeManagedDatabaseGroupCompartmentRequest,ChangeManagedDatabaseGroupCompartmentResponse> handler)
Moves a Managed Database Group to a different compartment. The destination compartment must not have a Managed Database Group with the same name.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ChangeNamedCredentialCompartmentResponse> changeNamedCredentialCompartment(ChangeNamedCredentialCompartmentRequest request, AsyncHandler<ChangeNamedCredentialCompartmentRequest,ChangeNamedCredentialCompartmentResponse> handler)
Moves a named credential to a different compartment. The destination compartment must not have a named credential with the same name.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ChangePlanRetentionResponse> changePlanRetention(ChangePlanRetentionRequest request, AsyncHandler<ChangePlanRetentionRequest,ChangePlanRetentionResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ChangeSpaceBudgetResponse> changeSpaceBudget(ChangeSpaceBudgetRequest request, AsyncHandler<ChangeSpaceBudgetRequest,ChangeSpaceBudgetResponse> handler)
Changes the disk space limit for the SQL Management Base. The allowable range for this limit is between 1% and 50%.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ChangeSqlPlanBaselinesAttributesResponse> changeSqlPlanBaselinesAttributes(ChangeSqlPlanBaselinesAttributesRequest request, AsyncHandler<ChangeSqlPlanBaselinesAttributesRequest,ChangeSqlPlanBaselinesAttributesResponse> handler)
Changes one or more attributes of a single plan or all plans associated with a SQL statement.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<CheckExternalDbSystemConnectorConnectionStatusResponse> checkExternalDbSystemConnectorConnectionStatus(CheckExternalDbSystemConnectorConnectionStatusRequest request, AsyncHandler<CheckExternalDbSystemConnectorConnectionStatusRequest,CheckExternalDbSystemConnectorConnectionStatusResponse> handler)
Checks the status of the external DB system component connection specified in this connector. This operation will refresh the connectionStatus and timeConnectionStatusLastUpdated fields.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<CheckExternalExadataStorageConnectorResponse> checkExternalExadataStorageConnector(CheckExternalExadataStorageConnectorRequest request, AsyncHandler<CheckExternalExadataStorageConnectorRequest,CheckExternalExadataStorageConnectorResponse> handler)
Checks the status of the Exadata storage server connection specified by exadataStorageConnectorId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ConfigureAutomaticCaptureFiltersResponse> configureAutomaticCaptureFilters(ConfigureAutomaticCaptureFiltersRequest request, AsyncHandler<ConfigureAutomaticCaptureFiltersRequest,ConfigureAutomaticCaptureFiltersResponse> handler)
Configures automatic capture filters to capture only those statements that match the filter criteria.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ConfigureAutomaticSpmEvolveAdvisorTaskResponse> configureAutomaticSpmEvolveAdvisorTask(ConfigureAutomaticSpmEvolveAdvisorTaskRequest request, AsyncHandler<ConfigureAutomaticSpmEvolveAdvisorTaskRequest,ConfigureAutomaticSpmEvolveAdvisorTaskResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<CreateDbManagementPrivateEndpointResponse> createDbManagementPrivateEndpoint(CreateDbManagementPrivateEndpointRequest request, AsyncHandler<CreateDbManagementPrivateEndpointRequest,CreateDbManagementPrivateEndpointResponse> handler)
Creates a new Database Management private endpoint.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<CreateExternalDbSystemResponse> createExternalDbSystem(CreateExternalDbSystemRequest request, AsyncHandler<CreateExternalDbSystemRequest,CreateExternalDbSystemResponse> handler)
Creates an external DB system and its related resources.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<CreateExternalDbSystemConnectorResponse> createExternalDbSystemConnector(CreateExternalDbSystemConnectorRequest request, AsyncHandler<CreateExternalDbSystemConnectorRequest,CreateExternalDbSystemConnectorResponse> handler)
Creates a new external connector.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<CreateExternalDbSystemDiscoveryResponse> createExternalDbSystemDiscovery(CreateExternalDbSystemDiscoveryRequest request, AsyncHandler<CreateExternalDbSystemDiscoveryRequest,CreateExternalDbSystemDiscoveryResponse> handler)
Creates an external DB system discovery resource and initiates the discovery process.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<CreateExternalExadataInfrastructureResponse> createExternalExadataInfrastructure(CreateExternalExadataInfrastructureRequest request, AsyncHandler<CreateExternalExadataInfrastructureRequest,CreateExternalExadataInfrastructureResponse> handler)
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
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<CreateExternalExadataStorageConnectorResponse> createExternalExadataStorageConnector(CreateExternalExadataStorageConnectorRequest request, AsyncHandler<CreateExternalExadataStorageConnectorRequest,CreateExternalExadataStorageConnectorResponse> handler)
Creates the Exadata storage server connector after validating the connection information.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<CreateJobResponse> createJob(CreateJobRequest request, AsyncHandler<CreateJobRequest,CreateJobResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<CreateManagedDatabaseGroupResponse> createManagedDatabaseGroup(CreateManagedDatabaseGroupRequest request, AsyncHandler<CreateManagedDatabaseGroupRequest,CreateManagedDatabaseGroupResponse> handler)
Creates a Managed Database Group. The group does not contain any Managed Databases when it is created, and they must be added later.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<CreateNamedCredentialResponse> createNamedCredential(CreateNamedCredentialRequest request, AsyncHandler<CreateNamedCredentialRequest,CreateNamedCredentialResponse> handler)
Creates a named credential.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<CreateTablespaceResponse> createTablespace(CreateTablespaceRequest request, AsyncHandler<CreateTablespaceRequest,CreateTablespaceResponse> handler)
Creates a tablespace within the Managed Database specified by managedDatabaseId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DeleteDbManagementPrivateEndpointResponse> deleteDbManagementPrivateEndpoint(DeleteDbManagementPrivateEndpointRequest request, AsyncHandler<DeleteDbManagementPrivateEndpointRequest,DeleteDbManagementPrivateEndpointResponse> handler)
Deletes a specific Database Management private endpoint.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DeleteExternalDbSystemResponse> deleteExternalDbSystem(DeleteExternalDbSystemRequest request, AsyncHandler<DeleteExternalDbSystemRequest,DeleteExternalDbSystemResponse> handler)
Deletes the external DB system specified by externalDbSystemId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DeleteExternalDbSystemConnectorResponse> deleteExternalDbSystemConnector(DeleteExternalDbSystemConnectorRequest request, AsyncHandler<DeleteExternalDbSystemConnectorRequest,DeleteExternalDbSystemConnectorResponse> handler)
Deletes the external connector specified by externalDbSystemConnectorId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DeleteExternalDbSystemDiscoveryResponse> deleteExternalDbSystemDiscovery(DeleteExternalDbSystemDiscoveryRequest request, AsyncHandler<DeleteExternalDbSystemDiscoveryRequest,DeleteExternalDbSystemDiscoveryResponse> handler)
Deletes the external DB system discovery resource specified by externalDbSystemDiscoveryId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DeleteExternalExadataInfrastructureResponse> deleteExternalExadataInfrastructure(DeleteExternalExadataInfrastructureRequest request, AsyncHandler<DeleteExternalExadataInfrastructureRequest,DeleteExternalExadataInfrastructureResponse> handler)
Deletes the Exadata infrastructure specified by externalExadataInfrastructureId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DeleteExternalExadataStorageConnectorResponse> deleteExternalExadataStorageConnector(DeleteExternalExadataStorageConnectorRequest request, AsyncHandler<DeleteExternalExadataStorageConnectorRequest,DeleteExternalExadataStorageConnectorResponse> handler)
Deletes the Exadata storage server connector specified by exadataStorageConnectorId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DeleteJobResponse> deleteJob(DeleteJobRequest request, AsyncHandler<DeleteJobRequest,DeleteJobResponse> handler)
Deletes the job specified by jobId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DeleteManagedDatabaseGroupResponse> deleteManagedDatabaseGroup(DeleteManagedDatabaseGroupRequest request, AsyncHandler<DeleteManagedDatabaseGroupRequest,DeleteManagedDatabaseGroupResponse> handler)
Deletes the Managed Database Group specified by managedDatabaseGroupId. If the group contains Managed Databases, then it cannot be deleted.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DeleteNamedCredentialResponse> deleteNamedCredential(DeleteNamedCredentialRequest request, AsyncHandler<DeleteNamedCredentialRequest,DeleteNamedCredentialResponse> handler)
Deletes the named credential specified by namedCredentialId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DeletePreferredCredentialResponse> deletePreferredCredential(DeletePreferredCredentialRequest request, AsyncHandler<DeletePreferredCredentialRequest,DeletePreferredCredentialResponse> handler)
Deletes the preferred credential based on the credentialName.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DisableAutomaticInitialPlanCaptureResponse> disableAutomaticInitialPlanCapture(DisableAutomaticInitialPlanCaptureRequest request, AsyncHandler<DisableAutomaticInitialPlanCaptureRequest,DisableAutomaticInitialPlanCaptureResponse> handler)
Disables automatic initial plan capture.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DisableAutomaticSpmEvolveAdvisorTaskResponse> disableAutomaticSpmEvolveAdvisorTask(DisableAutomaticSpmEvolveAdvisorTaskRequest request, AsyncHandler<DisableAutomaticSpmEvolveAdvisorTaskRequest,DisableAutomaticSpmEvolveAdvisorTaskResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DisableAutonomousDatabaseManagementFeatureResponse> disableAutonomousDatabaseManagementFeature(DisableAutonomousDatabaseManagementFeatureRequest request, AsyncHandler<DisableAutonomousDatabaseManagementFeatureRequest,DisableAutonomousDatabaseManagementFeatureResponse> handler)
Disables a Database Management feature for the specified Autonomous Database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DisableDatabaseManagementFeatureResponse> disableDatabaseManagementFeature(DisableDatabaseManagementFeatureRequest request, AsyncHandler<DisableDatabaseManagementFeatureRequest,DisableDatabaseManagementFeatureResponse> handler)
Disables a Database Management feature for the specified Oracle cloud database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DisableExternalContainerDatabaseManagementFeatureResponse> disableExternalContainerDatabaseManagementFeature(DisableExternalContainerDatabaseManagementFeatureRequest request, AsyncHandler<DisableExternalContainerDatabaseManagementFeatureRequest,DisableExternalContainerDatabaseManagementFeatureResponse> handler)
Disables a Database Management feature for the specified external container database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DisableExternalDbSystemDatabaseManagementResponse> disableExternalDbSystemDatabaseManagement(DisableExternalDbSystemDatabaseManagementRequest request, AsyncHandler<DisableExternalDbSystemDatabaseManagementRequest,DisableExternalDbSystemDatabaseManagementResponse> handler)
Disables Database Management service for all the components of the specified external DB system (except databases).
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DisableExternalDbSystemStackMonitoringResponse> disableExternalDbSystemStackMonitoring(DisableExternalDbSystemStackMonitoringRequest request, AsyncHandler<DisableExternalDbSystemStackMonitoringRequest,DisableExternalDbSystemStackMonitoringResponse> handler)
Disables Stack Monitoring for all the components of the specified external DB system (except databases).
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DisableExternalExadataInfrastructureManagementResponse> disableExternalExadataInfrastructureManagement(DisableExternalExadataInfrastructureManagementRequest request, AsyncHandler<DisableExternalExadataInfrastructureManagementRequest,DisableExternalExadataInfrastructureManagementResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DisableExternalNonContainerDatabaseManagementFeatureResponse> disableExternalNonContainerDatabaseManagementFeature(DisableExternalNonContainerDatabaseManagementFeatureRequest request, AsyncHandler<DisableExternalNonContainerDatabaseManagementFeatureRequest,DisableExternalNonContainerDatabaseManagementFeatureResponse> handler)
Disables a Database Management feature for the specified external non-container database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DisableExternalPluggableDatabaseManagementFeatureResponse> disableExternalPluggableDatabaseManagementFeature(DisableExternalPluggableDatabaseManagementFeatureRequest request, AsyncHandler<DisableExternalPluggableDatabaseManagementFeatureRequest,DisableExternalPluggableDatabaseManagementFeatureResponse> handler)
Disables a Database Management feature for the specified external pluggable database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DisableHighFrequencyAutomaticSpmEvolveAdvisorTaskResponse> disableHighFrequencyAutomaticSpmEvolveAdvisorTask(DisableHighFrequencyAutomaticSpmEvolveAdvisorTaskRequest request, AsyncHandler<DisableHighFrequencyAutomaticSpmEvolveAdvisorTaskRequest,DisableHighFrequencyAutomaticSpmEvolveAdvisorTaskResponse> handler)
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).
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DisablePluggableDatabaseManagementFeatureResponse> disablePluggableDatabaseManagementFeature(DisablePluggableDatabaseManagementFeatureRequest request, AsyncHandler<DisablePluggableDatabaseManagementFeatureRequest,DisablePluggableDatabaseManagementFeatureResponse> handler)
Disables a Database Management feature for the specified Oracle cloud pluggable database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DisableSqlPlanBaselinesUsageResponse> disableSqlPlanBaselinesUsage(DisableSqlPlanBaselinesUsageRequest request, AsyncHandler<DisableSqlPlanBaselinesUsageRequest,DisableSqlPlanBaselinesUsageResponse> handler)
Disables the use of SQL plan baselines stored in SQL Management Base.
When disabled, the optimizer does not use any SQL plan baselines.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DiscoverExternalExadataInfrastructureResponse> discoverExternalExadataInfrastructure(DiscoverExternalExadataInfrastructureRequest request, AsyncHandler<DiscoverExternalExadataInfrastructureRequest,DiscoverExternalExadataInfrastructureResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DropSqlPlanBaselinesResponse> dropSqlPlanBaselines(DropSqlPlanBaselinesRequest request, AsyncHandler<DropSqlPlanBaselinesRequest,DropSqlPlanBaselinesResponse> handler)
Drops a single plan or all plans associated with a SQL statement.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<DropTablespaceResponse> dropTablespace(DropTablespaceRequest request, AsyncHandler<DropTablespaceRequest,DropTablespaceResponse> handler)
Drops the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<EnableAutomaticInitialPlanCaptureResponse> enableAutomaticInitialPlanCapture(EnableAutomaticInitialPlanCaptureRequest request, AsyncHandler<EnableAutomaticInitialPlanCaptureRequest,EnableAutomaticInitialPlanCaptureResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<EnableAutomaticSpmEvolveAdvisorTaskResponse> enableAutomaticSpmEvolveAdvisorTask(EnableAutomaticSpmEvolveAdvisorTaskRequest request, AsyncHandler<EnableAutomaticSpmEvolveAdvisorTaskRequest,EnableAutomaticSpmEvolveAdvisorTaskResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<EnableAutonomousDatabaseManagementFeatureResponse> enableAutonomousDatabaseManagementFeature(EnableAutonomousDatabaseManagementFeatureRequest request, AsyncHandler<EnableAutonomousDatabaseManagementFeatureRequest,EnableAutonomousDatabaseManagementFeatureResponse> handler)
Enables a Database Management feature for the specified Autonomous Database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<EnableDatabaseManagementFeatureResponse> enableDatabaseManagementFeature(EnableDatabaseManagementFeatureRequest request, AsyncHandler<EnableDatabaseManagementFeatureRequest,EnableDatabaseManagementFeatureResponse> handler)
Enables a Database Management feature for the specified cloud database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<EnableExternalContainerDatabaseManagementFeatureResponse> enableExternalContainerDatabaseManagementFeature(EnableExternalContainerDatabaseManagementFeatureRequest request, AsyncHandler<EnableExternalContainerDatabaseManagementFeatureRequest,EnableExternalContainerDatabaseManagementFeatureResponse> handler)
Enables a Database Management feature for the specified external container database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<EnableExternalDbSystemDatabaseManagementResponse> enableExternalDbSystemDatabaseManagement(EnableExternalDbSystemDatabaseManagementRequest request, AsyncHandler<EnableExternalDbSystemDatabaseManagementRequest,EnableExternalDbSystemDatabaseManagementResponse> handler)
Enables Database Management service for all the components of the specified external DB system (except databases).
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<EnableExternalDbSystemStackMonitoringResponse> enableExternalDbSystemStackMonitoring(EnableExternalDbSystemStackMonitoringRequest request, AsyncHandler<EnableExternalDbSystemStackMonitoringRequest,EnableExternalDbSystemStackMonitoringResponse> handler)
Enables Stack Monitoring for all the components of the specified external DB system (except databases).
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<EnableExternalExadataInfrastructureManagementResponse> enableExternalExadataInfrastructureManagement(EnableExternalExadataInfrastructureManagementRequest request, AsyncHandler<EnableExternalExadataInfrastructureManagementRequest,EnableExternalExadataInfrastructureManagementResponse> handler)
Enables Database Management for the Exadata infrastructure specified by externalExadataInfrastructureId. It covers the following components:
- Exadata infrastructure - Exadata storage grid - Exadata storage server
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<EnableExternalNonContainerDatabaseManagementFeatureResponse> enableExternalNonContainerDatabaseManagementFeature(EnableExternalNonContainerDatabaseManagementFeatureRequest request, AsyncHandler<EnableExternalNonContainerDatabaseManagementFeatureRequest,EnableExternalNonContainerDatabaseManagementFeatureResponse> handler)
Enables Database Management feature for the specified external non-container database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<EnableExternalPluggableDatabaseManagementFeatureResponse> enableExternalPluggableDatabaseManagementFeature(EnableExternalPluggableDatabaseManagementFeatureRequest request, AsyncHandler<EnableExternalPluggableDatabaseManagementFeatureRequest,EnableExternalPluggableDatabaseManagementFeatureResponse> handler)
Enables a Database Management feature for the specified external pluggable database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<EnableHighFrequencyAutomaticSpmEvolveAdvisorTaskResponse> enableHighFrequencyAutomaticSpmEvolveAdvisorTask(EnableHighFrequencyAutomaticSpmEvolveAdvisorTaskRequest request, AsyncHandler<EnableHighFrequencyAutomaticSpmEvolveAdvisorTaskRequest,EnableHighFrequencyAutomaticSpmEvolveAdvisorTaskResponse> handler)
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).
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<EnablePluggableDatabaseManagementFeatureResponse> enablePluggableDatabaseManagementFeature(EnablePluggableDatabaseManagementFeatureRequest request, AsyncHandler<EnablePluggableDatabaseManagementFeatureRequest,EnablePluggableDatabaseManagementFeatureResponse> handler)
Enables a Database Management feature for the specified Oracle cloud pluggable database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<EnableSqlPlanBaselinesUsageResponse> enableSqlPlanBaselinesUsage(EnableSqlPlanBaselinesUsageRequest request, AsyncHandler<EnableSqlPlanBaselinesUsageRequest,EnableSqlPlanBaselinesUsageResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GenerateAwrSnapshotResponse> generateAwrSnapshot(GenerateAwrSnapshotRequest request, AsyncHandler<GenerateAwrSnapshotRequest,GenerateAwrSnapshotResponse> handler)
Creates an AWR snapshot for the target database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetAwrDbReportResponse> getAwrDbReport(GetAwrDbReportRequest request, AsyncHandler<GetAwrDbReportRequest,GetAwrDbReportResponse> handler)
Gets the AWR report for the specific database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetAwrDbSqlReportResponse> getAwrDbSqlReport(GetAwrDbSqlReportRequest request, AsyncHandler<GetAwrDbSqlReportRequest,GetAwrDbSqlReportResponse> handler)
Gets the SQL health check report for one SQL of the specific database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetClusterCacheMetricResponse> getClusterCacheMetric(GetClusterCacheMetricRequest request, AsyncHandler<GetClusterCacheMetricRequest,GetClusterCacheMetricResponse> handler)
Gets the metrics related to cluster cache for the Oracle Real Application Clusters (Oracle RAC) database specified by managedDatabaseId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetDatabaseFleetHealthMetricsResponse> getDatabaseFleetHealthMetrics(GetDatabaseFleetHealthMetricsRequest request, AsyncHandler<GetDatabaseFleetHealthMetricsRequest,GetDatabaseFleetHealthMetricsResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetDatabaseHomeMetricsResponse> getDatabaseHomeMetrics(GetDatabaseHomeMetricsRequest request, AsyncHandler<GetDatabaseHomeMetricsRequest,GetDatabaseHomeMetricsResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetDataguardPerformanceMetricsResponse> getDataguardPerformanceMetrics(GetDataguardPerformanceMetricsRequest request, AsyncHandler<GetDataguardPerformanceMetricsRequest,GetDataguardPerformanceMetricsResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetDbManagementPrivateEndpointResponse> getDbManagementPrivateEndpoint(GetDbManagementPrivateEndpointRequest request, AsyncHandler<GetDbManagementPrivateEndpointRequest,GetDbManagementPrivateEndpointResponse> handler)
Gets the details of a specific Database Management private endpoint.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetExternalAsmResponse> getExternalAsm(GetExternalAsmRequest request, AsyncHandler<GetExternalAsmRequest,GetExternalAsmResponse> handler)
Gets the details for the external ASM specified by externalAsmId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetExternalAsmConfigurationResponse> getExternalAsmConfiguration(GetExternalAsmConfigurationRequest request, AsyncHandler<GetExternalAsmConfigurationRequest,GetExternalAsmConfigurationResponse> handler)
Gets configuration details including disk groups for the external ASM specified by
externalAsmId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetExternalAsmInstanceResponse> getExternalAsmInstance(GetExternalAsmInstanceRequest request, AsyncHandler<GetExternalAsmInstanceRequest,GetExternalAsmInstanceResponse> handler)
Gets the details for the external ASM instance specified by externalAsmInstanceId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetExternalClusterResponse> getExternalCluster(GetExternalClusterRequest request, AsyncHandler<GetExternalClusterRequest,GetExternalClusterResponse> handler)
Gets the details for the external cluster specified by externalClusterId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetExternalClusterInstanceResponse> getExternalClusterInstance(GetExternalClusterInstanceRequest request, AsyncHandler<GetExternalClusterInstanceRequest,GetExternalClusterInstanceResponse> handler)
Gets the details for the external cluster instance specified by externalClusterInstanceId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetExternalDbHomeResponse> getExternalDbHome(GetExternalDbHomeRequest request, AsyncHandler<GetExternalDbHomeRequest,GetExternalDbHomeResponse> handler)
Gets the details for the external DB home specified by externalDbHomeId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetExternalDbNodeResponse> getExternalDbNode(GetExternalDbNodeRequest request, AsyncHandler<GetExternalDbNodeRequest,GetExternalDbNodeResponse> handler)
Gets the details for the external DB node specified by externalDbNodeId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetExternalDbSystemResponse> getExternalDbSystem(GetExternalDbSystemRequest request, AsyncHandler<GetExternalDbSystemRequest,GetExternalDbSystemResponse> handler)
Gets the details for the external DB system specified by externalDbSystemId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetExternalDbSystemConnectorResponse> getExternalDbSystemConnector(GetExternalDbSystemConnectorRequest request, AsyncHandler<GetExternalDbSystemConnectorRequest,GetExternalDbSystemConnectorResponse> handler)
Gets the details for the external connector specified by externalDbSystemConnectorId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetExternalDbSystemDiscoveryResponse> getExternalDbSystemDiscovery(GetExternalDbSystemDiscoveryRequest request, AsyncHandler<GetExternalDbSystemDiscoveryRequest,GetExternalDbSystemDiscoveryResponse> handler)
Gets the details for the external DB system discovery resource specified by
externalDbSystemDiscoveryId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetExternalExadataInfrastructureResponse> getExternalExadataInfrastructure(GetExternalExadataInfrastructureRequest request, AsyncHandler<GetExternalExadataInfrastructureRequest,GetExternalExadataInfrastructureResponse> handler)
Gets the details for the Exadata infrastructure specified by externalExadataInfrastructureId. It includes the DB systems and storage grid within the Exadata infrastructure.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetExternalExadataStorageConnectorResponse> getExternalExadataStorageConnector(GetExternalExadataStorageConnectorRequest request, AsyncHandler<GetExternalExadataStorageConnectorRequest,GetExternalExadataStorageConnectorResponse> handler)
Gets the details for the Exadata storage server connector specified by exadataStorageConnectorId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetExternalExadataStorageGridResponse> getExternalExadataStorageGrid(GetExternalExadataStorageGridRequest request, AsyncHandler<GetExternalExadataStorageGridRequest,GetExternalExadataStorageGridResponse> handler)
Gets the details for the Exadata storage server grid specified by exadataStorageGridId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetExternalExadataStorageServerResponse> getExternalExadataStorageServer(GetExternalExadataStorageServerRequest request, AsyncHandler<GetExternalExadataStorageServerRequest,GetExternalExadataStorageServerResponse> handler)
Gets the summary for the Exadata storage server specified by exadataStorageServerId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetExternalListenerResponse> getExternalListener(GetExternalListenerRequest request, AsyncHandler<GetExternalListenerRequest,GetExternalListenerResponse> handler)
Gets the details for the external listener specified by externalListenerId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetIormPlanResponse> getIormPlan(GetIormPlanRequest request, AsyncHandler<GetIormPlanRequest,GetIormPlanResponse> handler)
Get the IORM plan from the specific Exadata storage server.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetJobResponse> getJob(GetJobRequest request, AsyncHandler<GetJobRequest,GetJobResponse> handler)
Gets the details for the job specified by jobId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetJobExecutionResponse> getJobExecution(GetJobExecutionRequest request, AsyncHandler<GetJobExecutionRequest,GetJobExecutionResponse> handler)
Gets the details for the job execution specified by jobExecutionId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetJobRunResponse> getJobRun(GetJobRunRequest request, AsyncHandler<GetJobRunRequest,GetJobRunResponse> handler)
Gets the details for the job run specified by jobRunId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetManagedDatabaseResponse> getManagedDatabase(GetManagedDatabaseRequest request, AsyncHandler<GetManagedDatabaseRequest,GetManagedDatabaseResponse> handler)
Gets the details for the Managed Database specified by managedDatabaseId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetManagedDatabaseGroupResponse> getManagedDatabaseGroup(GetManagedDatabaseGroupRequest request, AsyncHandler<GetManagedDatabaseGroupRequest,GetManagedDatabaseGroupResponse> handler)
Gets the details for the Managed Database Group specified by managedDatabaseGroupId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetNamedCredentialResponse> getNamedCredential(GetNamedCredentialRequest request, AsyncHandler<GetNamedCredentialRequest,GetNamedCredentialResponse> handler)
Gets the details for the named credential specified by namedCredentialId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetOpenAlertHistoryResponse> getOpenAlertHistory(GetOpenAlertHistoryRequest request, AsyncHandler<GetOpenAlertHistoryRequest,GetOpenAlertHistoryResponse> handler)
Gets the open alerts from the specified Exadata storage server.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetOptimizerStatisticsAdvisorExecutionResponse> getOptimizerStatisticsAdvisorExecution(GetOptimizerStatisticsAdvisorExecutionRequest request, AsyncHandler<GetOptimizerStatisticsAdvisorExecutionRequest,GetOptimizerStatisticsAdvisorExecutionResponse> handler)
Gets a comprehensive report of the Optimizer Statistics Advisor execution, which includes details of the Managed Database, findings, recommendations, rationale, and examples.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetOptimizerStatisticsAdvisorExecutionScriptResponse> getOptimizerStatisticsAdvisorExecutionScript(GetOptimizerStatisticsAdvisorExecutionScriptRequest request, AsyncHandler<GetOptimizerStatisticsAdvisorExecutionScriptRequest,GetOptimizerStatisticsAdvisorExecutionScriptResponse> handler)
Gets the Oracle system-generated script for the specified Optimizer Statistics Advisor execution.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetOptimizerStatisticsCollectionOperationResponse> getOptimizerStatisticsCollectionOperation(GetOptimizerStatisticsCollectionOperationRequest request, AsyncHandler<GetOptimizerStatisticsCollectionOperationRequest,GetOptimizerStatisticsCollectionOperationResponse> handler)
Gets a detailed report of the Optimizer Statistics Collection operation for the specified Managed Database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetPdbMetricsResponse> getPdbMetrics(GetPdbMetricsRequest request, AsyncHandler<GetPdbMetricsRequest,GetPdbMetricsResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetPeerDatabaseMetricsResponse> getPeerDatabaseMetrics(GetPeerDatabaseMetricsRequest request, AsyncHandler<GetPeerDatabaseMetricsRequest,GetPeerDatabaseMetricsResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetPreferredCredentialResponse> getPreferredCredential(GetPreferredCredentialRequest request, AsyncHandler<GetPreferredCredentialRequest,GetPreferredCredentialResponse> handler)
Gets the preferred credential details for a Managed Database based on credentialName.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetSqlPlanBaselineResponse> getSqlPlanBaseline(GetSqlPlanBaselineRequest request, AsyncHandler<GetSqlPlanBaselineRequest,GetSqlPlanBaselineResponse> handler)
Gets the SQL plan baseline details for the specified planName.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetSqlPlanBaselineConfigurationResponse> getSqlPlanBaselineConfiguration(GetSqlPlanBaselineConfigurationRequest request, AsyncHandler<GetSqlPlanBaselineConfigurationRequest,GetSqlPlanBaselineConfigurationResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetTablespaceResponse> getTablespace(GetTablespaceRequest request, AsyncHandler<GetTablespaceRequest,GetTablespaceResponse> handler)
Gets the details of the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetTopSqlCpuActivityResponse> getTopSqlCpuActivity(GetTopSqlCpuActivityRequest request, AsyncHandler<GetTopSqlCpuActivityRequest,GetTopSqlCpuActivityResponse> handler)
Gets the SQL IDs with the top CPU activity from the Exadata storage server.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetUserResponse> getUser(GetUserRequest request, AsyncHandler<GetUserRequest,GetUserResponse> handler)
Gets the details of the user specified by managedDatabaseId and userName.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<GetWorkRequestResponse> getWorkRequest(GetWorkRequestRequest request, AsyncHandler<GetWorkRequestRequest,GetWorkRequestResponse> handler)
Gets the status of the work request with the given Work Request ID
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ImplementOptimizerStatisticsAdvisorRecommendationsResponse> implementOptimizerStatisticsAdvisorRecommendations(ImplementOptimizerStatisticsAdvisorRecommendationsRequest request, AsyncHandler<ImplementOptimizerStatisticsAdvisorRecommendationsRequest,ImplementOptimizerStatisticsAdvisorRecommendationsResponse> handler)
Asynchronously implements the findings and recommendations of the Optimizer Statistics Advisor execution.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListAsmPropertiesResponse> listAsmProperties(ListAsmPropertiesRequest request, AsyncHandler<ListAsmPropertiesRequest,ListAsmPropertiesResponse> handler)
Gets the list of ASM properties for the specified managedDatabaseId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListAssociatedDatabasesResponse> listAssociatedDatabases(ListAssociatedDatabasesRequest request, AsyncHandler<ListAssociatedDatabasesRequest,ListAssociatedDatabasesResponse> handler)
Gets the list of databases using a specific Database Management private endpoint.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListAwrDbSnapshotsResponse> listAwrDbSnapshots(ListAwrDbSnapshotsRequest request, AsyncHandler<ListAwrDbSnapshotsRequest,ListAwrDbSnapshotsResponse> handler)
Lists AWR snapshots for the specified database in the AWR.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListAwrDbsResponse> listAwrDbs(ListAwrDbsRequest request, AsyncHandler<ListAwrDbsRequest,ListAwrDbsResponse> handler)
Gets the list of databases and their snapshot summary details available in the AWR of the specified Managed Database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListConsumerGroupPrivilegesResponse> listConsumerGroupPrivileges(ListConsumerGroupPrivilegesRequest request, AsyncHandler<ListConsumerGroupPrivilegesRequest,ListConsumerGroupPrivilegesResponse> handler)
Gets the list of consumer group privileges granted to a specific user.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListCursorCacheStatementsResponse> listCursorCacheStatements(ListCursorCacheStatementsRequest request, AsyncHandler<ListCursorCacheStatementsRequest,ListCursorCacheStatementsResponse> handler)
Lists the SQL statements from shared SQL area, also called the cursor cache.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListDataAccessContainersResponse> listDataAccessContainers(ListDataAccessContainersRequest request, AsyncHandler<ListDataAccessContainersRequest,ListDataAccessContainersResponse> handler)
Gets the list of containers for a specific user. This is only applicable if ALL_CONTAINERS !=‘Y’.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListDatabaseParametersResponse> listDatabaseParameters(ListDatabaseParametersRequest request, AsyncHandler<ListDatabaseParametersRequest,ListDatabaseParametersResponse> handler)
Gets the list of database parameters for the specified Managed Database. The parameters are listed in alphabetical order, along with their current values.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListDbManagementPrivateEndpointsResponse> listDbManagementPrivateEndpoints(ListDbManagementPrivateEndpointsRequest request, AsyncHandler<ListDbManagementPrivateEndpointsRequest,ListDbManagementPrivateEndpointsResponse> handler)
Gets a list of Database Management private endpoints.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalAsmDiskGroupsResponse> listExternalAsmDiskGroups(ListExternalAsmDiskGroupsRequest request, AsyncHandler<ListExternalAsmDiskGroupsRequest,ListExternalAsmDiskGroupsResponse> handler)
Lists ASM disk groups for the external ASM specified by externalAsmId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalAsmInstancesResponse> listExternalAsmInstances(ListExternalAsmInstancesRequest request, AsyncHandler<ListExternalAsmInstancesRequest,ListExternalAsmInstancesResponse> handler)
Lists the ASM instances in the specified external ASM.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalAsmUsersResponse> listExternalAsmUsers(ListExternalAsmUsersRequest request, AsyncHandler<ListExternalAsmUsersRequest,ListExternalAsmUsersResponse> handler)
Lists ASM users for the external ASM specified by externalAsmId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalAsmsResponse> listExternalAsms(ListExternalAsmsRequest request, AsyncHandler<ListExternalAsmsRequest,ListExternalAsmsResponse> handler)
Lists the ASMs in the specified external DB system.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalClusterInstancesResponse> listExternalClusterInstances(ListExternalClusterInstancesRequest request, AsyncHandler<ListExternalClusterInstancesRequest,ListExternalClusterInstancesResponse> handler)
Lists the cluster instances in the specified external cluster.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalClustersResponse> listExternalClusters(ListExternalClustersRequest request, AsyncHandler<ListExternalClustersRequest,ListExternalClustersResponse> handler)
Lists the clusters in the specified external DB system.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalDatabasesResponse> listExternalDatabases(ListExternalDatabasesRequest request, AsyncHandler<ListExternalDatabasesRequest,ListExternalDatabasesResponse> handler)
Lists the external databases in the specified compartment or in the specified DB system.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalDbHomesResponse> listExternalDbHomes(ListExternalDbHomesRequest request, AsyncHandler<ListExternalDbHomesRequest,ListExternalDbHomesResponse> handler)
Lists the DB homes in the specified external DB system.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalDbNodesResponse> listExternalDbNodes(ListExternalDbNodesRequest request, AsyncHandler<ListExternalDbNodesRequest,ListExternalDbNodesResponse> handler)
Lists the external DB nodes in the specified external DB system.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalDbSystemConnectorsResponse> listExternalDbSystemConnectors(ListExternalDbSystemConnectorsRequest request, AsyncHandler<ListExternalDbSystemConnectorsRequest,ListExternalDbSystemConnectorsResponse> handler)
Lists the external connectors in the specified external DB system.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalDbSystemDiscoveriesResponse> listExternalDbSystemDiscoveries(ListExternalDbSystemDiscoveriesRequest request, AsyncHandler<ListExternalDbSystemDiscoveriesRequest,ListExternalDbSystemDiscoveriesResponse> handler)
Lists the external DB system discovery resources in the specified compartment.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalDbSystemsResponse> listExternalDbSystems(ListExternalDbSystemsRequest request, AsyncHandler<ListExternalDbSystemsRequest,ListExternalDbSystemsResponse> handler)
Lists the external DB systems in the specified compartment.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalExadataInfrastructuresResponse> listExternalExadataInfrastructures(ListExternalExadataInfrastructuresRequest request, AsyncHandler<ListExternalExadataInfrastructuresRequest,ListExternalExadataInfrastructuresResponse> handler)
Lists the Exadata infrastructure resources in the specified compartment.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalExadataStorageConnectorsResponse> listExternalExadataStorageConnectors(ListExternalExadataStorageConnectorsRequest request, AsyncHandler<ListExternalExadataStorageConnectorsRequest,ListExternalExadataStorageConnectorsResponse> handler)
Lists the Exadata storage server connectors for the specified Exadata infrastructure.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalExadataStorageServersResponse> listExternalExadataStorageServers(ListExternalExadataStorageServersRequest request, AsyncHandler<ListExternalExadataStorageServersRequest,ListExternalExadataStorageServersResponse> handler)
Lists the Exadata storage servers for the specified Exadata infrastructure.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalListenerServicesResponse> listExternalListenerServices(ListExternalListenerServicesRequest request, AsyncHandler<ListExternalListenerServicesRequest,ListExternalListenerServicesResponse> handler)
Lists the database services registered with the specified external listener for the specified Managed Database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListExternalListenersResponse> listExternalListeners(ListExternalListenersRequest request, AsyncHandler<ListExternalListenersRequest,ListExternalListenersResponse> handler)
Lists the listeners in the specified external DB system.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListJobExecutionsResponse> listJobExecutions(ListJobExecutionsRequest request, AsyncHandler<ListJobExecutionsRequest,ListJobExecutionsResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListJobRunsResponse> listJobRuns(ListJobRunsRequest request, AsyncHandler<ListJobRunsRequest,ListJobRunsResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListJobsResponse> listJobs(ListJobsRequest request, AsyncHandler<ListJobsRequest,ListJobsResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListManagedDatabaseGroupsResponse> listManagedDatabaseGroups(ListManagedDatabaseGroupsRequest request, AsyncHandler<ListManagedDatabaseGroupsRequest,ListManagedDatabaseGroupsResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListManagedDatabasesResponse> listManagedDatabases(ListManagedDatabasesRequest request, AsyncHandler<ListManagedDatabasesRequest,ListManagedDatabasesResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListNamedCredentialsResponse> listNamedCredentials(ListNamedCredentialsRequest request, AsyncHandler<ListNamedCredentialsRequest,ListNamedCredentialsResponse> handler)
Gets a single named credential specified by the name or all the named credentials in a specific compartment.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListObjectPrivilegesResponse> listObjectPrivileges(ListObjectPrivilegesRequest request, AsyncHandler<ListObjectPrivilegesRequest,ListObjectPrivilegesResponse> handler)
Gets the list of object privileges granted to a specific user.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListOptimizerStatisticsAdvisorExecutionsResponse> listOptimizerStatisticsAdvisorExecutions(ListOptimizerStatisticsAdvisorExecutionsRequest request, AsyncHandler<ListOptimizerStatisticsAdvisorExecutionsRequest,ListOptimizerStatisticsAdvisorExecutionsResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListOptimizerStatisticsCollectionAggregationsResponse> listOptimizerStatisticsCollectionAggregations(ListOptimizerStatisticsCollectionAggregationsRequest request, AsyncHandler<ListOptimizerStatisticsCollectionAggregationsRequest,ListOptimizerStatisticsCollectionAggregationsResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListOptimizerStatisticsCollectionOperationsResponse> listOptimizerStatisticsCollectionOperations(ListOptimizerStatisticsCollectionOperationsRequest request, AsyncHandler<ListOptimizerStatisticsCollectionOperationsRequest,ListOptimizerStatisticsCollectionOperationsResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListPreferredCredentialsResponse> listPreferredCredentials(ListPreferredCredentialsRequest request, AsyncHandler<ListPreferredCredentialsRequest,ListPreferredCredentialsResponse> handler)
Gets the list of preferred credentials for a given Managed Database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListProxiedForUsersResponse> listProxiedForUsers(ListProxiedForUsersRequest request, AsyncHandler<ListProxiedForUsersRequest,ListProxiedForUsersResponse> handler)
Gets the list of users on whose behalf the current user acts as proxy.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListProxyUsersResponse> listProxyUsers(ListProxyUsersRequest request, AsyncHandler<ListProxyUsersRequest,ListProxyUsersResponse> handler)
Gets the list of proxy users for the current user.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListRolesResponse> listRoles(ListRolesRequest request, AsyncHandler<ListRolesRequest,ListRolesResponse> handler)
Gets the list of roles granted to a specific user.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListSqlPlanBaselineJobsResponse> listSqlPlanBaselineJobs(ListSqlPlanBaselineJobsRequest request, AsyncHandler<ListSqlPlanBaselineJobsRequest,ListSqlPlanBaselineJobsResponse> handler)
Lists the database jobs used for loading SQL plan baselines in the specified Managed Database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListSqlPlanBaselinesResponse> listSqlPlanBaselines(ListSqlPlanBaselinesRequest request, AsyncHandler<ListSqlPlanBaselinesRequest,ListSqlPlanBaselinesResponse> handler)
Lists the SQL plan baselines for the specified Managed Database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListSystemPrivilegesResponse> listSystemPrivileges(ListSystemPrivilegesRequest request, AsyncHandler<ListSystemPrivilegesRequest,ListSystemPrivilegesResponse> handler)
Gets the list of system privileges granted to a specific user.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListTableStatisticsResponse> listTableStatistics(ListTableStatisticsRequest request, AsyncHandler<ListTableStatisticsRequest,ListTableStatisticsResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListTablespacesResponse> listTablespaces(ListTablespacesRequest request, AsyncHandler<ListTablespacesRequest,ListTablespacesResponse> handler)
Gets the list of tablespaces for the specified managedDatabaseId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListUsersResponse> listUsers(ListUsersRequest request, AsyncHandler<ListUsersRequest,ListUsersResponse> handler)
Gets the list of users for the specified managedDatabaseId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListWorkRequestErrorsResponse> listWorkRequestErrors(ListWorkRequestErrorsRequest request, AsyncHandler<ListWorkRequestErrorsRequest,ListWorkRequestErrorsResponse> handler)
Returns a paginated list of errors for a given work request.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListWorkRequestLogsResponse> listWorkRequestLogs(ListWorkRequestLogsRequest request, AsyncHandler<ListWorkRequestLogsRequest,ListWorkRequestLogsResponse> handler)
Returns a paginated list of logs for a given work request.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ListWorkRequestsResponse> listWorkRequests(ListWorkRequestsRequest request, AsyncHandler<ListWorkRequestsRequest,ListWorkRequestsResponse> handler)
The list of work requests in a specific compartment was retrieved successfully.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<LoadSqlPlanBaselinesFromAwrResponse> loadSqlPlanBaselinesFromAwr(LoadSqlPlanBaselinesFromAwrRequest request, AsyncHandler<LoadSqlPlanBaselinesFromAwrRequest,LoadSqlPlanBaselinesFromAwrResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<LoadSqlPlanBaselinesFromCursorCacheResponse> loadSqlPlanBaselinesFromCursorCache(LoadSqlPlanBaselinesFromCursorCacheRequest request, AsyncHandler<LoadSqlPlanBaselinesFromCursorCacheRequest,LoadSqlPlanBaselinesFromCursorCacheResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ModifyAutonomousDatabaseManagementFeatureResponse> modifyAutonomousDatabaseManagementFeature(ModifyAutonomousDatabaseManagementFeatureRequest request, AsyncHandler<ModifyAutonomousDatabaseManagementFeatureRequest,ModifyAutonomousDatabaseManagementFeatureResponse> handler)
Modifies the Database Management feature for the specified Autonomous Database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ModifyDatabaseManagementFeatureResponse> modifyDatabaseManagementFeature(ModifyDatabaseManagementFeatureRequest request, AsyncHandler<ModifyDatabaseManagementFeatureRequest,ModifyDatabaseManagementFeatureResponse> handler)
Modifies a Database Management feature for the specified Oracle cloud database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ModifyPluggableDatabaseManagementFeatureResponse> modifyPluggableDatabaseManagementFeature(ModifyPluggableDatabaseManagementFeatureRequest request, AsyncHandler<ModifyPluggableDatabaseManagementFeatureRequest,ModifyPluggableDatabaseManagementFeatureResponse> handler)
Modifies the Database Management feature for the specified Oracle cloud pluggable database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<PatchExternalDbSystemDiscoveryResponse> patchExternalDbSystemDiscovery(PatchExternalDbSystemDiscoveryRequest request, AsyncHandler<PatchExternalDbSystemDiscoveryRequest,PatchExternalDbSystemDiscoveryResponse> handler)
Patches the external DB system discovery specified by externalDbSystemDiscoveryId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<RemoveDataFileResponse> removeDataFile(RemoveDataFileRequest request, AsyncHandler<RemoveDataFileRequest,RemoveDataFileResponse> handler)
Removes a data file or temp file from the tablespace.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<RemoveManagedDatabaseFromManagedDatabaseGroupResponse> removeManagedDatabaseFromManagedDatabaseGroup(RemoveManagedDatabaseFromManagedDatabaseGroupRequest request, AsyncHandler<RemoveManagedDatabaseFromManagedDatabaseGroupRequest,RemoveManagedDatabaseFromManagedDatabaseGroupResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ResetDatabaseParametersResponse> resetDatabaseParameters(ResetDatabaseParametersRequest request, AsyncHandler<ResetDatabaseParametersRequest,ResetDatabaseParametersResponse> handler)
Resets database parameter values to their default or startup values.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<ResizeDataFileResponse> resizeDataFile(ResizeDataFileRequest request, AsyncHandler<ResizeDataFileRequest,ResizeDataFileResponse> handler)
Resizes a data file or temp file within the tablespace.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<RunHistoricAddmResponse> runHistoricAddm(RunHistoricAddmRequest request, AsyncHandler<RunHistoricAddmRequest,RunHistoricAddmResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeAwrDbCpuUsagesResponse> summarizeAwrDbCpuUsages(SummarizeAwrDbCpuUsagesRequest request, AsyncHandler<SummarizeAwrDbCpuUsagesRequest,SummarizeAwrDbCpuUsagesResponse> handler)
Summarizes the AWR CPU resource limits and metrics for the specified database in AWR.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeAwrDbMetricsResponse> summarizeAwrDbMetrics(SummarizeAwrDbMetricsRequest request, AsyncHandler<SummarizeAwrDbMetricsRequest,SummarizeAwrDbMetricsResponse> handler)
Summarizes the metric samples for the specified database in the AWR. The metric samples are summarized based on the Time dimension for each metric.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeAwrDbParameterChangesResponse> summarizeAwrDbParameterChanges(SummarizeAwrDbParameterChangesRequest request, AsyncHandler<SummarizeAwrDbParameterChangesRequest,SummarizeAwrDbParameterChangesResponse> handler)
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
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeAwrDbParametersResponse> summarizeAwrDbParameters(SummarizeAwrDbParametersRequest request, AsyncHandler<SummarizeAwrDbParametersRequest,SummarizeAwrDbParametersResponse> handler)
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
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeAwrDbSnapshotRangesResponse> summarizeAwrDbSnapshotRanges(SummarizeAwrDbSnapshotRangesRequest request, AsyncHandler<SummarizeAwrDbSnapshotRangesRequest,SummarizeAwrDbSnapshotRangesResponse> handler)
Summarizes the AWR snapshot ranges that contain continuous snapshots, for the specified Managed Database.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeAwrDbSysstatsResponse> summarizeAwrDbSysstats(SummarizeAwrDbSysstatsRequest request, AsyncHandler<SummarizeAwrDbSysstatsRequest,SummarizeAwrDbSysstatsResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeAwrDbTopWaitEventsResponse> summarizeAwrDbTopWaitEvents(SummarizeAwrDbTopWaitEventsRequest request, AsyncHandler<SummarizeAwrDbTopWaitEventsRequest,SummarizeAwrDbTopWaitEventsResponse> handler)
Summarizes the AWR top wait events.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeAwrDbWaitEventBucketsResponse> summarizeAwrDbWaitEventBuckets(SummarizeAwrDbWaitEventBucketsRequest request, AsyncHandler<SummarizeAwrDbWaitEventBucketsRequest,SummarizeAwrDbWaitEventBucketsResponse> handler)
Summarizes AWR wait event data into value buckets and frequency, for the specified database in the AWR.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeAwrDbWaitEventsResponse> summarizeAwrDbWaitEvents(SummarizeAwrDbWaitEventsRequest request, AsyncHandler<SummarizeAwrDbWaitEventsRequest,SummarizeAwrDbWaitEventsResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeExternalAsmMetricsResponse> summarizeExternalAsmMetrics(SummarizeExternalAsmMetricsRequest request, AsyncHandler<SummarizeExternalAsmMetricsRequest,SummarizeExternalAsmMetricsResponse> handler)
Gets metrics for the external ASM specified by externalAsmId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeExternalClusterMetricsResponse> summarizeExternalClusterMetrics(SummarizeExternalClusterMetricsRequest request, AsyncHandler<SummarizeExternalClusterMetricsRequest,SummarizeExternalClusterMetricsResponse> handler)
Gets metrics for the external cluster specified by externalClusterId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeExternalDbNodeMetricsResponse> summarizeExternalDbNodeMetrics(SummarizeExternalDbNodeMetricsRequest request, AsyncHandler<SummarizeExternalDbNodeMetricsRequest,SummarizeExternalDbNodeMetricsResponse> handler)
Gets metrics for the external DB node specified by externalDbNodeId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeExternalDbSystemAvailabilityMetricsResponse> summarizeExternalDbSystemAvailabilityMetrics(SummarizeExternalDbSystemAvailabilityMetricsRequest request, AsyncHandler<SummarizeExternalDbSystemAvailabilityMetricsRequest,SummarizeExternalDbSystemAvailabilityMetricsResponse> handler)
Gets availability metrics for the components present in the external DB system specified by
externalDbSystemId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeExternalListenerMetricsResponse> summarizeExternalListenerMetrics(SummarizeExternalListenerMetricsRequest request, AsyncHandler<SummarizeExternalListenerMetricsRequest,SummarizeExternalListenerMetricsResponse> handler)
Gets metrics for the external listener specified by externalListenerId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeJobExecutionsStatusesResponse> summarizeJobExecutionsStatuses(SummarizeJobExecutionsStatusesRequest request, AsyncHandler<SummarizeJobExecutionsStatusesRequest,SummarizeJobExecutionsStatusesResponse> handler)
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.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeManagedDatabaseAvailabilityMetricsResponse> summarizeManagedDatabaseAvailabilityMetrics(SummarizeManagedDatabaseAvailabilityMetricsRequest request, AsyncHandler<SummarizeManagedDatabaseAvailabilityMetricsRequest,SummarizeManagedDatabaseAvailabilityMetricsResponse> handler)
Gets the availability metrics related to managed database for the Oracle database specified by managedDatabaseId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeSqlPlanBaselinesResponse> summarizeSqlPlanBaselines(SummarizeSqlPlanBaselinesRequest request, AsyncHandler<SummarizeSqlPlanBaselinesRequest,SummarizeSqlPlanBaselinesResponse> handler)
Gets the number of SQL plan baselines aggregated by their attributes.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<SummarizeSqlPlanBaselinesByLastExecutionResponse> summarizeSqlPlanBaselinesByLastExecution(SummarizeSqlPlanBaselinesByLastExecutionRequest request, AsyncHandler<SummarizeSqlPlanBaselinesByLastExecutionRequest,SummarizeSqlPlanBaselinesByLastExecutionResponse> handler)
Gets the number of SQL plan baselines aggregated by the age of their last execution in weeks.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<TestNamedCredentialResponse> testNamedCredential(TestNamedCredentialRequest request, AsyncHandler<TestNamedCredentialRequest,TestNamedCredentialResponse> handler)
Tests the named credential.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<TestPreferredCredentialResponse> testPreferredCredential(TestPreferredCredentialRequest request, AsyncHandler<TestPreferredCredentialRequest,TestPreferredCredentialResponse> handler)
Tests the preferred credential.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateDbManagementPrivateEndpointResponse> updateDbManagementPrivateEndpoint(UpdateDbManagementPrivateEndpointRequest request, AsyncHandler<UpdateDbManagementPrivateEndpointRequest,UpdateDbManagementPrivateEndpointResponse> handler)
Updates one or more attributes of a specific Database Management private endpoint.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateExternalAsmResponse> updateExternalAsm(UpdateExternalAsmRequest request, AsyncHandler<UpdateExternalAsmRequest,UpdateExternalAsmResponse> handler)
Updates the external ASM specified by externalAsmId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateExternalAsmInstanceResponse> updateExternalAsmInstance(UpdateExternalAsmInstanceRequest request, AsyncHandler<UpdateExternalAsmInstanceRequest,UpdateExternalAsmInstanceResponse> handler)
Updates the external ASM instance specified by externalAsmInstanceId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateExternalClusterResponse> updateExternalCluster(UpdateExternalClusterRequest request, AsyncHandler<UpdateExternalClusterRequest,UpdateExternalClusterResponse> handler)
Updates the external cluster specified by externalClusterId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateExternalClusterInstanceResponse> updateExternalClusterInstance(UpdateExternalClusterInstanceRequest request, AsyncHandler<UpdateExternalClusterInstanceRequest,UpdateExternalClusterInstanceResponse> handler)
Updates the external cluster instance specified by externalClusterInstanceId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateExternalDbHomeResponse> updateExternalDbHome(UpdateExternalDbHomeRequest request, AsyncHandler<UpdateExternalDbHomeRequest,UpdateExternalDbHomeResponse> handler)
Updates the external DB home specified by externalDbHomeId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateExternalDbNodeResponse> updateExternalDbNode(UpdateExternalDbNodeRequest request, AsyncHandler<UpdateExternalDbNodeRequest,UpdateExternalDbNodeResponse> handler)
Updates the external DB node specified by externalDbNodeId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateExternalDbSystemResponse> updateExternalDbSystem(UpdateExternalDbSystemRequest request, AsyncHandler<UpdateExternalDbSystemRequest,UpdateExternalDbSystemResponse> handler)
Updates the external DB system specified by externalDbSystemId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateExternalDbSystemConnectorResponse> updateExternalDbSystemConnector(UpdateExternalDbSystemConnectorRequest request, AsyncHandler<UpdateExternalDbSystemConnectorRequest,UpdateExternalDbSystemConnectorResponse> handler)
Updates the external connector specified by externalDbSystemConnectorId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateExternalDbSystemDiscoveryResponse> updateExternalDbSystemDiscovery(UpdateExternalDbSystemDiscoveryRequest request, AsyncHandler<UpdateExternalDbSystemDiscoveryRequest,UpdateExternalDbSystemDiscoveryResponse> handler)
Updates the external DB system discovery specified by externalDbSystemDiscoveryId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateExternalExadataInfrastructureResponse> updateExternalExadataInfrastructure(UpdateExternalExadataInfrastructureRequest request, AsyncHandler<UpdateExternalExadataInfrastructureRequest,UpdateExternalExadataInfrastructureResponse> handler)
Updates the details for the Exadata infrastructure specified by externalExadataInfrastructureId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateExternalExadataStorageConnectorResponse> updateExternalExadataStorageConnector(UpdateExternalExadataStorageConnectorRequest request, AsyncHandler<UpdateExternalExadataStorageConnectorRequest,UpdateExternalExadataStorageConnectorResponse> handler)
Updates the Exadata storage server connector specified by exadataStorageConnectorId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateExternalExadataStorageGridResponse> updateExternalExadataStorageGrid(UpdateExternalExadataStorageGridRequest request, AsyncHandler<UpdateExternalExadataStorageGridRequest,UpdateExternalExadataStorageGridResponse> handler)
Updates the Exadata storage server grid specified by exadataStorageGridId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateExternalExadataStorageServerResponse> updateExternalExadataStorageServer(UpdateExternalExadataStorageServerRequest request, AsyncHandler<UpdateExternalExadataStorageServerRequest,UpdateExternalExadataStorageServerResponse> handler)
Updates the Exadata storage server specified by exadataStorageServerId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateExternalListenerResponse> updateExternalListener(UpdateExternalListenerRequest request, AsyncHandler<UpdateExternalListenerRequest,UpdateExternalListenerResponse> handler)
Updates the external listener specified by externalListenerId
.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateJobResponse> updateJob(UpdateJobRequest request, AsyncHandler<UpdateJobRequest,UpdateJobResponse> handler)
Updates the details for the recurring scheduled job specified by jobId. Note that non-recurring (one time) jobs cannot be updated.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateManagedDatabaseResponse> updateManagedDatabase(UpdateManagedDatabaseRequest request, AsyncHandler<UpdateManagedDatabaseRequest,UpdateManagedDatabaseResponse> handler)
Updates the Managed Database specified by managedDatabaseId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateManagedDatabaseGroupResponse> updateManagedDatabaseGroup(UpdateManagedDatabaseGroupRequest request, AsyncHandler<UpdateManagedDatabaseGroupRequest,UpdateManagedDatabaseGroupResponse> handler)
Updates the Managed Database Group specified by managedDatabaseGroupId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateNamedCredentialResponse> updateNamedCredential(UpdateNamedCredentialRequest request, AsyncHandler<UpdateNamedCredentialRequest,UpdateNamedCredentialResponse> handler)
Updates the named credential specified by namedCredentialId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdatePreferredCredentialResponse> updatePreferredCredential(UpdatePreferredCredentialRequest request, AsyncHandler<UpdatePreferredCredentialRequest,UpdatePreferredCredentialResponse> handler)
Updates the preferred credential based on the credentialName.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Future<UpdateTablespaceResponse> updateTablespace(UpdateTablespaceRequest request, AsyncHandler<UpdateTablespaceRequest,UpdateTablespaceResponse> handler)
Updates the attributes of the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.
request
- The request object containing the details to sendhandler
- The request handler to invoke upon completion, may be null.Copyright © 2016–2024. All rights reserved.