Class DbManagementClient
- java.lang.Object
-
- com.oracle.bmc.http.internal.BaseSyncClient
-
- com.oracle.bmc.databasemanagement.DbManagementClient
-
- All Implemented Interfaces:
DbManagement
,AutoCloseable
@Generated(value="OracleSDKGenerator", comments="API Version: 20201101") public class DbManagementClient extends BaseSyncClient implements DbManagement
-
-
Nested Class Summary
Nested Classes Modifier and Type Class Description static class
DbManagementClient.Builder
Builder class for this client.
-
Field Summary
Fields Modifier and Type Field Description String
clientCommonLibraryVersion
Compatible SDK version, provided by the codegen.Optional<String>
minimumClientCommonLibraryVersionFromClient
Minimum compatible SDK version, maybe provided by the codegen.static Service
SERVICE
Service instance for DbManagement.
-
Constructor Summary
Constructors Constructor Description DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory)
Deprecated.Use thebuilder
instead.DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory, List<ClientConfigurator> additionalClientConfigurators)
Deprecated.Use thebuilder
instead.DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory, List<ClientConfigurator> additionalClientConfigurators, String endpoint)
Deprecated.Use thebuilder
instead.DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory, Map<SigningStrategy,RequestSignerFactory> signingStrategyRequestSignerFactories, List<ClientConfigurator> additionalClientConfigurators, String endpoint)
Deprecated.Use thebuilder
instead.DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory, Map<SigningStrategy,RequestSignerFactory> signingStrategyRequestSignerFactories, List<ClientConfigurator> additionalClientConfigurators, String endpoint, ExecutorService executorService)
Deprecated.Use thebuilder
instead.DbManagementClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider)
Deprecated.Use thebuilder
instead.DbManagementClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration)
Deprecated.Use thebuilder
instead.DbManagementClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator)
Deprecated.Use thebuilder
instead.
-
Method Summary
-
Methods inherited from class com.oracle.bmc.http.internal.BaseSyncClient
clientCall
-
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
-
Methods inherited from interface java.lang.AutoCloseable
close
-
Methods inherited from interface com.oracle.bmc.databasemanagement.DbManagement
getEndpoint, refreshClient, setEndpoint, useRealmSpecificEndpointTemplate
-
-
-
-
Constructor Detail
-
DbManagementClient
@Deprecated public DbManagementClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider)
Deprecated.Use thebuilder
instead.Create a new client instance.- Parameters:
authenticationDetailsProvider
- The authentication details (seeDbManagementClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider)
)
-
DbManagementClient
@Deprecated public DbManagementClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration)
Deprecated.Use thebuilder
instead.Create a new client instance.- Parameters:
authenticationDetailsProvider
- The authentication details (seeDbManagementClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider)
)configuration
-ClientBuilderBase.configuration
-
DbManagementClient
@Deprecated public DbManagementClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator)
Deprecated.Use thebuilder
instead.Create a new client instance.- Parameters:
authenticationDetailsProvider
- The authentication details (seeDbManagementClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider)
)configuration
-ClientBuilderBase.configuration
clientConfigurator
-ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
-
DbManagementClient
@Deprecated public DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory)
Deprecated.Use thebuilder
instead.Create a new client instance.- Parameters:
authenticationDetailsProvider
- The authentication details (seeDbManagementClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider)
)configuration
-ClientBuilderBase.configuration
clientConfigurator
-ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
defaultRequestSignerFactory
-ClientBuilderBase.requestSignerFactory
-
DbManagementClient
@Deprecated public DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory, List<ClientConfigurator> additionalClientConfigurators)
Deprecated.Use thebuilder
instead.Create a new client instance.- Parameters:
authenticationDetailsProvider
- The authentication details (seeDbManagementClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider)
)configuration
-ClientBuilderBase.configuration
clientConfigurator
-ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
defaultRequestSignerFactory
-ClientBuilderBase.requestSignerFactory
additionalClientConfigurators
-ClientBuilderBase.additionalClientConfigurators
-
DbManagementClient
@Deprecated public DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory, List<ClientConfigurator> additionalClientConfigurators, String endpoint)
Deprecated.Use thebuilder
instead.Create a new client instance.- Parameters:
authenticationDetailsProvider
- The authentication details (seeDbManagementClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider)
)configuration
-ClientBuilderBase.configuration
clientConfigurator
-ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
defaultRequestSignerFactory
-ClientBuilderBase.requestSignerFactory
additionalClientConfigurators
-ClientBuilderBase.additionalClientConfigurators
endpoint
-ClientBuilderBase.endpoint(java.lang.String)
-
DbManagementClient
@Deprecated public DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory, Map<SigningStrategy,RequestSignerFactory> signingStrategyRequestSignerFactories, List<ClientConfigurator> additionalClientConfigurators, String endpoint)
Deprecated.Use thebuilder
instead.Create a new client instance.- Parameters:
authenticationDetailsProvider
- The authentication details (seeDbManagementClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider)
)configuration
-ClientBuilderBase.configuration
clientConfigurator
-ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
defaultRequestSignerFactory
-ClientBuilderBase.requestSignerFactory
additionalClientConfigurators
-ClientBuilderBase.additionalClientConfigurators
endpoint
-ClientBuilderBase.endpoint(java.lang.String)
signingStrategyRequestSignerFactories
-ClientBuilderBase.signingStrategyRequestSignerFactories
-
DbManagementClient
@Deprecated public DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory, Map<SigningStrategy,RequestSignerFactory> signingStrategyRequestSignerFactories, List<ClientConfigurator> additionalClientConfigurators, String endpoint, ExecutorService executorService)
Deprecated.Use thebuilder
instead.Create a new client instance.- Parameters:
authenticationDetailsProvider
- The authentication details (seeDbManagementClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider)
)configuration
-ClientBuilderBase.configuration
clientConfigurator
-ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
defaultRequestSignerFactory
-ClientBuilderBase.requestSignerFactory
additionalClientConfigurators
-ClientBuilderBase.additionalClientConfigurators
endpoint
-ClientBuilderBase.endpoint(java.lang.String)
signingStrategyRequestSignerFactories
-ClientBuilderBase.signingStrategyRequestSignerFactories
executorService
-DbManagementClient.Builder.executorService
-
-
Method Detail
-
builder
public static DbManagementClient.Builder builder()
Create a builder for this client.- Returns:
- builder
-
setRegion
public void setRegion(Region region)
Description copied from interface:DbManagement
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.- Specified by:
setRegion
in interfaceDbManagement
- Parameters:
region
- The region of the service.
-
setRegion
public void setRegion(String regionId)
Description copied from interface:DbManagement
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 callsetEndpoint
.- Specified by:
setRegion
in interfaceDbManagement
- Parameters:
regionId
- The public region ID.
-
addDataFiles
public AddDataFilesResponse addDataFiles(AddDataFilesRequest request)
Description copied from interface:DbManagement
Adds data files or temp files to the tablespace.- Specified by:
addDataFiles
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
addManagedDatabaseToManagedDatabaseGroup
public AddManagedDatabaseToManagedDatabaseGroupResponse addManagedDatabaseToManagedDatabaseGroup(AddManagedDatabaseToManagedDatabaseGroupRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
addManagedDatabaseToManagedDatabaseGroup
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
addmTasks
public AddmTasksResponse addmTasks(AddmTasksRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
addmTasks
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
changeDatabaseParameters
public ChangeDatabaseParametersResponse changeDatabaseParameters(ChangeDatabaseParametersRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
changeDatabaseParameters
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
changeDbManagementPrivateEndpointCompartment
public ChangeDbManagementPrivateEndpointCompartmentResponse changeDbManagementPrivateEndpointCompartment(ChangeDbManagementPrivateEndpointCompartmentRequest request)
Description copied from interface:DbManagement
Moves the Database Management private endpoint and its dependent resources to the specified compartment.- Specified by:
changeDbManagementPrivateEndpointCompartment
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
changeExternalDbSystemCompartment
public ChangeExternalDbSystemCompartmentResponse changeExternalDbSystemCompartment(ChangeExternalDbSystemCompartmentRequest request)
Description copied from interface:DbManagement
Moves the external DB system and its related resources (excluding databases) to the specified compartment.- Specified by:
changeExternalDbSystemCompartment
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
changeExternalExadataInfrastructureCompartment
public ChangeExternalExadataInfrastructureCompartmentResponse changeExternalExadataInfrastructureCompartment(ChangeExternalExadataInfrastructureCompartmentRequest request)
Description copied from interface:DbManagement
Moves the Exadata infrastructure and its related resources (Exadata storage server, Exadata storage server connectors and Exadata storage server grid) to the specified compartment.- Specified by:
changeExternalExadataInfrastructureCompartment
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
changeJobCompartment
public ChangeJobCompartmentResponse changeJobCompartment(ChangeJobCompartmentRequest request)
Description copied from interface:DbManagement
Moves a job.- Specified by:
changeJobCompartment
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
changeManagedDatabaseGroupCompartment
public ChangeManagedDatabaseGroupCompartmentResponse changeManagedDatabaseGroupCompartment(ChangeManagedDatabaseGroupCompartmentRequest request)
Description copied from interface:DbManagement
Moves a Managed Database Group to a different compartment.The destination compartment must not have a Managed Database Group with the same name.
- Specified by:
changeManagedDatabaseGroupCompartment
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
changeNamedCredentialCompartment
public ChangeNamedCredentialCompartmentResponse changeNamedCredentialCompartment(ChangeNamedCredentialCompartmentRequest request)
Description copied from interface:DbManagement
Moves a named credential to a different compartment.The destination compartment must not have a named credential with the same name.
- Specified by:
changeNamedCredentialCompartment
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
changePlanRetention
public ChangePlanRetentionResponse changePlanRetention(ChangePlanRetentionRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
changePlanRetention
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
changeSpaceBudget
public ChangeSpaceBudgetResponse changeSpaceBudget(ChangeSpaceBudgetRequest request)
Description copied from interface:DbManagement
Changes the disk space limit for the SQL Management Base.The allowable range for this limit is between 1% and 50%.
- Specified by:
changeSpaceBudget
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
changeSqlPlanBaselinesAttributes
public ChangeSqlPlanBaselinesAttributesResponse changeSqlPlanBaselinesAttributes(ChangeSqlPlanBaselinesAttributesRequest request)
Description copied from interface:DbManagement
Changes one or more attributes of a single plan or all plans associated with a SQL statement.- Specified by:
changeSqlPlanBaselinesAttributes
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
checkExternalDbSystemConnectorConnectionStatus
public CheckExternalDbSystemConnectorConnectionStatusResponse checkExternalDbSystemConnectorConnectionStatus(CheckExternalDbSystemConnectorConnectionStatusRequest request)
Description copied from interface:DbManagement
Checks the status of the external DB system component connection specified in this connector.This operation will refresh the connectionStatus and timeConnectionStatusLastUpdated fields.
- Specified by:
checkExternalDbSystemConnectorConnectionStatus
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
checkExternalExadataStorageConnector
public CheckExternalExadataStorageConnectorResponse checkExternalExadataStorageConnector(CheckExternalExadataStorageConnectorRequest request)
Description copied from interface:DbManagement
Checks the status of the Exadata storage server connection specified by exadataStorageConnectorId.- Specified by:
checkExternalExadataStorageConnector
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
checkExternalMySqlDatabaseConnectorConnectionStatus
public CheckExternalMySqlDatabaseConnectorConnectionStatusResponse checkExternalMySqlDatabaseConnectorConnectionStatus(CheckExternalMySqlDatabaseConnectorConnectionStatusRequest request)
Description copied from interface:DbManagement
Check the status of the external database connection specified in this connector.This operation will refresh the connectionStatus and timeConnectionStatusLastUpdated fields.
- Specified by:
checkExternalMySqlDatabaseConnectorConnectionStatus
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
configureAutomaticCaptureFilters
public ConfigureAutomaticCaptureFiltersResponse configureAutomaticCaptureFilters(ConfigureAutomaticCaptureFiltersRequest request)
Description copied from interface:DbManagement
Configures automatic capture filters to capture only those statements that match the filter criteria.- Specified by:
configureAutomaticCaptureFilters
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
configureAutomaticSpmEvolveAdvisorTask
public ConfigureAutomaticSpmEvolveAdvisorTaskResponse configureAutomaticSpmEvolveAdvisorTask(ConfigureAutomaticSpmEvolveAdvisorTaskRequest request)
Description copied from interface:DbManagement
Configures the Automatic SPM Evolve Advisor taskSYS_AUTO_SPM_EVOLVE_TASK
by specifying task parameters.As the task is owned by
SYS
, onlySYS
can set task parameters.- Specified by:
configureAutomaticSpmEvolveAdvisorTask
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
createDbManagementPrivateEndpoint
public CreateDbManagementPrivateEndpointResponse createDbManagementPrivateEndpoint(CreateDbManagementPrivateEndpointRequest request)
Description copied from interface:DbManagement
Creates a new Database Management private endpoint.- Specified by:
createDbManagementPrivateEndpoint
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
createExternalDbSystem
public CreateExternalDbSystemResponse createExternalDbSystem(CreateExternalDbSystemRequest request)
Description copied from interface:DbManagement
Creates an external DB system and its related resources.- Specified by:
createExternalDbSystem
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
createExternalDbSystemConnector
public CreateExternalDbSystemConnectorResponse createExternalDbSystemConnector(CreateExternalDbSystemConnectorRequest request)
Description copied from interface:DbManagement
Creates a new external connector.- Specified by:
createExternalDbSystemConnector
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
createExternalDbSystemDiscovery
public CreateExternalDbSystemDiscoveryResponse createExternalDbSystemDiscovery(CreateExternalDbSystemDiscoveryRequest request)
Description copied from interface:DbManagement
Creates an external DB system discovery resource and initiates the discovery process.- Specified by:
createExternalDbSystemDiscovery
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
createExternalExadataInfrastructure
public CreateExternalExadataInfrastructureResponse createExternalExadataInfrastructure(CreateExternalExadataInfrastructureRequest request)
Description copied from interface:DbManagement
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
- Specified by:
createExternalExadataInfrastructure
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
createExternalExadataStorageConnector
public CreateExternalExadataStorageConnectorResponse createExternalExadataStorageConnector(CreateExternalExadataStorageConnectorRequest request)
Description copied from interface:DbManagement
Creates the Exadata storage server connector after validating the connection information.- Specified by:
createExternalExadataStorageConnector
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
createExternalMySqlDatabase
public CreateExternalMySqlDatabaseResponse createExternalMySqlDatabase(CreateExternalMySqlDatabaseRequest request)
Description copied from interface:DbManagement
Creates an external MySQL database.- Specified by:
createExternalMySqlDatabase
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
createExternalMySqlDatabaseConnector
public CreateExternalMySqlDatabaseConnectorResponse createExternalMySqlDatabaseConnector(CreateExternalMySqlDatabaseConnectorRequest request)
Description copied from interface:DbManagement
Creates an external MySQL connector resource.- Specified by:
createExternalMySqlDatabaseConnector
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
createJob
public CreateJobResponse createJob(CreateJobRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
createJob
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
createManagedDatabaseGroup
public CreateManagedDatabaseGroupResponse createManagedDatabaseGroup(CreateManagedDatabaseGroupRequest request)
Description copied from interface:DbManagement
Creates a Managed Database Group.The group does not contain any Managed Databases when it is created, and they must be added later.
- Specified by:
createManagedDatabaseGroup
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
createNamedCredential
public CreateNamedCredentialResponse createNamedCredential(CreateNamedCredentialRequest request)
Description copied from interface:DbManagement
Creates a named credential.- Specified by:
createNamedCredential
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
createTablespace
public CreateTablespaceResponse createTablespace(CreateTablespaceRequest request)
Description copied from interface:DbManagement
Creates a tablespace within the Managed Database specified by managedDatabaseId.- Specified by:
createTablespace
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
deleteDbManagementPrivateEndpoint
public DeleteDbManagementPrivateEndpointResponse deleteDbManagementPrivateEndpoint(DeleteDbManagementPrivateEndpointRequest request)
Description copied from interface:DbManagement
Deletes a specific Database Management private endpoint.- Specified by:
deleteDbManagementPrivateEndpoint
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
deleteExternalDbSystem
public DeleteExternalDbSystemResponse deleteExternalDbSystem(DeleteExternalDbSystemRequest request)
Description copied from interface:DbManagement
Deletes the external DB system specified byexternalDbSystemId
.- Specified by:
deleteExternalDbSystem
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
deleteExternalDbSystemConnector
public DeleteExternalDbSystemConnectorResponse deleteExternalDbSystemConnector(DeleteExternalDbSystemConnectorRequest request)
Description copied from interface:DbManagement
Deletes the external connector specified byexternalDbSystemConnectorId
.- Specified by:
deleteExternalDbSystemConnector
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
deleteExternalDbSystemDiscovery
public DeleteExternalDbSystemDiscoveryResponse deleteExternalDbSystemDiscovery(DeleteExternalDbSystemDiscoveryRequest request)
Description copied from interface:DbManagement
Deletes the external DB system discovery resource specified byexternalDbSystemDiscoveryId
.- Specified by:
deleteExternalDbSystemDiscovery
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
deleteExternalExadataInfrastructure
public DeleteExternalExadataInfrastructureResponse deleteExternalExadataInfrastructure(DeleteExternalExadataInfrastructureRequest request)
Description copied from interface:DbManagement
Deletes the Exadata infrastructure specified by externalExadataInfrastructureId.- Specified by:
deleteExternalExadataInfrastructure
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
deleteExternalExadataStorageConnector
public DeleteExternalExadataStorageConnectorResponse deleteExternalExadataStorageConnector(DeleteExternalExadataStorageConnectorRequest request)
Description copied from interface:DbManagement
Deletes the Exadata storage server connector specified by exadataStorageConnectorId.- Specified by:
deleteExternalExadataStorageConnector
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
deleteExternalMySqlDatabase
public DeleteExternalMySqlDatabaseResponse deleteExternalMySqlDatabase(DeleteExternalMySqlDatabaseRequest request)
Description copied from interface:DbManagement
Deletes the Oracle Cloud Infrastructure resource representing an external MySQL database.- Specified by:
deleteExternalMySqlDatabase
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
deleteExternalMySqlDatabaseConnector
public DeleteExternalMySqlDatabaseConnectorResponse deleteExternalMySqlDatabaseConnector(DeleteExternalMySqlDatabaseConnectorRequest request)
Description copied from interface:DbManagement
Deletes the Oracle Cloud Infrastructure resource representing an external MySQL database connector.- Specified by:
deleteExternalMySqlDatabaseConnector
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
deleteJob
public DeleteJobResponse deleteJob(DeleteJobRequest request)
Description copied from interface:DbManagement
Deletes the job specified by jobId.- Specified by:
deleteJob
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
deleteManagedDatabaseGroup
public DeleteManagedDatabaseGroupResponse deleteManagedDatabaseGroup(DeleteManagedDatabaseGroupRequest request)
Description copied from interface:DbManagement
Deletes the Managed Database Group specified by managedDatabaseGroupId.If the group contains Managed Databases, then it cannot be deleted.
- Specified by:
deleteManagedDatabaseGroup
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
deleteNamedCredential
public DeleteNamedCredentialResponse deleteNamedCredential(DeleteNamedCredentialRequest request)
Description copied from interface:DbManagement
Deletes the named credential specified by namedCredentialId.- Specified by:
deleteNamedCredential
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
deletePreferredCredential
public DeletePreferredCredentialResponse deletePreferredCredential(DeletePreferredCredentialRequest request)
Description copied from interface:DbManagement
Deletes the preferred credential based on the credentialName.- Specified by:
deletePreferredCredential
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
disableAutomaticInitialPlanCapture
public DisableAutomaticInitialPlanCaptureResponse disableAutomaticInitialPlanCapture(DisableAutomaticInitialPlanCaptureRequest request)
Description copied from interface:DbManagement
Disables automatic initial plan capture.- Specified by:
disableAutomaticInitialPlanCapture
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
disableAutomaticSpmEvolveAdvisorTask
public DisableAutomaticSpmEvolveAdvisorTaskResponse disableAutomaticSpmEvolveAdvisorTask(DisableAutomaticSpmEvolveAdvisorTaskRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
disableAutomaticSpmEvolveAdvisorTask
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
disableAutonomousDatabaseManagementFeature
public DisableAutonomousDatabaseManagementFeatureResponse disableAutonomousDatabaseManagementFeature(DisableAutonomousDatabaseManagementFeatureRequest request)
Description copied from interface:DbManagement
Disables a Database Management feature for the specified Autonomous Database.- Specified by:
disableAutonomousDatabaseManagementFeature
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
disableDatabaseManagementFeature
public DisableDatabaseManagementFeatureResponse disableDatabaseManagementFeature(DisableDatabaseManagementFeatureRequest request)
Description copied from interface:DbManagement
Disables a Database Management feature for the specified Oracle cloud database.- Specified by:
disableDatabaseManagementFeature
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
disableExternalContainerDatabaseManagementFeature
public DisableExternalContainerDatabaseManagementFeatureResponse disableExternalContainerDatabaseManagementFeature(DisableExternalContainerDatabaseManagementFeatureRequest request)
Description copied from interface:DbManagement
Disables a Database Management feature for the specified external container database.- Specified by:
disableExternalContainerDatabaseManagementFeature
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
disableExternalDbSystemDatabaseManagement
public DisableExternalDbSystemDatabaseManagementResponse disableExternalDbSystemDatabaseManagement(DisableExternalDbSystemDatabaseManagementRequest request)
Description copied from interface:DbManagement
Disables Database Management service for all the components of the specified external DB system (except databases).- Specified by:
disableExternalDbSystemDatabaseManagement
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
disableExternalDbSystemStackMonitoring
public DisableExternalDbSystemStackMonitoringResponse disableExternalDbSystemStackMonitoring(DisableExternalDbSystemStackMonitoringRequest request)
Description copied from interface:DbManagement
Disables Stack Monitoring for all the components of the specified external DB system (except databases).- Specified by:
disableExternalDbSystemStackMonitoring
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
disableExternalExadataInfrastructureManagement
public DisableExternalExadataInfrastructureManagementResponse disableExternalExadataInfrastructureManagement(DisableExternalExadataInfrastructureManagementRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
disableExternalExadataInfrastructureManagement
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
disableExternalMySqlDatabaseManagement
public DisableExternalMySqlDatabaseManagementResponse disableExternalMySqlDatabaseManagement(DisableExternalMySqlDatabaseManagementRequest request)
Description copied from interface:DbManagement
Disables Database Management for an external MySQL Database.- Specified by:
disableExternalMySqlDatabaseManagement
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
disableExternalNonContainerDatabaseManagementFeature
public DisableExternalNonContainerDatabaseManagementFeatureResponse disableExternalNonContainerDatabaseManagementFeature(DisableExternalNonContainerDatabaseManagementFeatureRequest request)
Description copied from interface:DbManagement
Disables a Database Management feature for the specified external non-container database.- Specified by:
disableExternalNonContainerDatabaseManagementFeature
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
disableExternalPluggableDatabaseManagementFeature
public DisableExternalPluggableDatabaseManagementFeatureResponse disableExternalPluggableDatabaseManagementFeature(DisableExternalPluggableDatabaseManagementFeatureRequest request)
Description copied from interface:DbManagement
Disables a Database Management feature for the specified external pluggable database.- Specified by:
disableExternalPluggableDatabaseManagementFeature
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
disableHighFrequencyAutomaticSpmEvolveAdvisorTask
public DisableHighFrequencyAutomaticSpmEvolveAdvisorTaskResponse disableHighFrequencyAutomaticSpmEvolveAdvisorTask(DisableHighFrequencyAutomaticSpmEvolveAdvisorTaskRequest request)
Description copied from interface:DbManagement
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).
- Specified by:
disableHighFrequencyAutomaticSpmEvolveAdvisorTask
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
disablePluggableDatabaseManagementFeature
public DisablePluggableDatabaseManagementFeatureResponse disablePluggableDatabaseManagementFeature(DisablePluggableDatabaseManagementFeatureRequest request)
Description copied from interface:DbManagement
Disables a Database Management feature for the specified Oracle cloud pluggable database.- Specified by:
disablePluggableDatabaseManagementFeature
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
disableSqlPlanBaselinesUsage
public DisableSqlPlanBaselinesUsageResponse disableSqlPlanBaselinesUsage(DisableSqlPlanBaselinesUsageRequest request)
Description copied from interface:DbManagement
Disables the use of SQL plan baselines stored in SQL Management Base.When disabled, the optimizer does not use any SQL plan baselines.
- Specified by:
disableSqlPlanBaselinesUsage
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
discoverExternalExadataInfrastructure
public DiscoverExternalExadataInfrastructureResponse discoverExternalExadataInfrastructure(DiscoverExternalExadataInfrastructureRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
discoverExternalExadataInfrastructure
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
dropSqlPlanBaselines
public DropSqlPlanBaselinesResponse dropSqlPlanBaselines(DropSqlPlanBaselinesRequest request)
Description copied from interface:DbManagement
Drops a single plan or all plans associated with a SQL statement.- Specified by:
dropSqlPlanBaselines
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
dropTablespace
public DropTablespaceResponse dropTablespace(DropTablespaceRequest request)
Description copied from interface:DbManagement
Drops the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.- Specified by:
dropTablespace
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
enableAutomaticInitialPlanCapture
public EnableAutomaticInitialPlanCaptureResponse enableAutomaticInitialPlanCapture(EnableAutomaticInitialPlanCaptureRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
enableAutomaticInitialPlanCapture
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
enableAutomaticSpmEvolveAdvisorTask
public EnableAutomaticSpmEvolveAdvisorTaskResponse enableAutomaticSpmEvolveAdvisorTask(EnableAutomaticSpmEvolveAdvisorTaskRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
enableAutomaticSpmEvolveAdvisorTask
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
enableAutonomousDatabaseManagementFeature
public EnableAutonomousDatabaseManagementFeatureResponse enableAutonomousDatabaseManagementFeature(EnableAutonomousDatabaseManagementFeatureRequest request)
Description copied from interface:DbManagement
Enables a Database Management feature for the specified Autonomous Database.- Specified by:
enableAutonomousDatabaseManagementFeature
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
enableDatabaseManagementFeature
public EnableDatabaseManagementFeatureResponse enableDatabaseManagementFeature(EnableDatabaseManagementFeatureRequest request)
Description copied from interface:DbManagement
Enables a Database Management feature for the specified cloud database.- Specified by:
enableDatabaseManagementFeature
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
enableExternalContainerDatabaseManagementFeature
public EnableExternalContainerDatabaseManagementFeatureResponse enableExternalContainerDatabaseManagementFeature(EnableExternalContainerDatabaseManagementFeatureRequest request)
Description copied from interface:DbManagement
Enables a Database Management feature for the specified external container database.- Specified by:
enableExternalContainerDatabaseManagementFeature
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
enableExternalDbSystemDatabaseManagement
public EnableExternalDbSystemDatabaseManagementResponse enableExternalDbSystemDatabaseManagement(EnableExternalDbSystemDatabaseManagementRequest request)
Description copied from interface:DbManagement
Enables Database Management service for all the components of the specified external DB system (except databases).- Specified by:
enableExternalDbSystemDatabaseManagement
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
enableExternalDbSystemStackMonitoring
public EnableExternalDbSystemStackMonitoringResponse enableExternalDbSystemStackMonitoring(EnableExternalDbSystemStackMonitoringRequest request)
Description copied from interface:DbManagement
Enables Stack Monitoring for all the components of the specified external DB system (except databases).- Specified by:
enableExternalDbSystemStackMonitoring
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
enableExternalExadataInfrastructureManagement
public EnableExternalExadataInfrastructureManagementResponse enableExternalExadataInfrastructureManagement(EnableExternalExadataInfrastructureManagementRequest request)
Description copied from interface:DbManagement
Enables Database Management for the Exadata infrastructure specified by externalExadataInfrastructureId.It covers the following components:
- Exadata infrastructure - Exadata storage grid - Exadata storage server
- Specified by:
enableExternalExadataInfrastructureManagement
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
enableExternalMySqlDatabaseManagement
public EnableExternalMySqlDatabaseManagementResponse enableExternalMySqlDatabaseManagement(EnableExternalMySqlDatabaseManagementRequest request)
Description copied from interface:DbManagement
Enables Database Management for an external MySQL Database.- Specified by:
enableExternalMySqlDatabaseManagement
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
enableExternalNonContainerDatabaseManagementFeature
public EnableExternalNonContainerDatabaseManagementFeatureResponse enableExternalNonContainerDatabaseManagementFeature(EnableExternalNonContainerDatabaseManagementFeatureRequest request)
Description copied from interface:DbManagement
Enables Database Management feature for the specified external non-container database.- Specified by:
enableExternalNonContainerDatabaseManagementFeature
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
enableExternalPluggableDatabaseManagementFeature
public EnableExternalPluggableDatabaseManagementFeatureResponse enableExternalPluggableDatabaseManagementFeature(EnableExternalPluggableDatabaseManagementFeatureRequest request)
Description copied from interface:DbManagement
Enables a Database Management feature for the specified external pluggable database.- Specified by:
enableExternalPluggableDatabaseManagementFeature
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
enableHighFrequencyAutomaticSpmEvolveAdvisorTask
public EnableHighFrequencyAutomaticSpmEvolveAdvisorTaskResponse enableHighFrequencyAutomaticSpmEvolveAdvisorTask(EnableHighFrequencyAutomaticSpmEvolveAdvisorTaskRequest request)
Description copied from interface:DbManagement
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).
- Specified by:
enableHighFrequencyAutomaticSpmEvolveAdvisorTask
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
enablePluggableDatabaseManagementFeature
public EnablePluggableDatabaseManagementFeatureResponse enablePluggableDatabaseManagementFeature(EnablePluggableDatabaseManagementFeatureRequest request)
Description copied from interface:DbManagement
Enables a Database Management feature for the specified Oracle cloud pluggable database.- Specified by:
enablePluggableDatabaseManagementFeature
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
enableSqlPlanBaselinesUsage
public EnableSqlPlanBaselinesUsageResponse enableSqlPlanBaselinesUsage(EnableSqlPlanBaselinesUsageRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
enableSqlPlanBaselinesUsage
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
generateAwrSnapshot
public GenerateAwrSnapshotResponse generateAwrSnapshot(GenerateAwrSnapshotRequest request)
Description copied from interface:DbManagement
Creates an AWR snapshot for the target database.- Specified by:
generateAwrSnapshot
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getAwrDbReport
public GetAwrDbReportResponse getAwrDbReport(GetAwrDbReportRequest request)
Description copied from interface:DbManagement
Gets the AWR report for the specific database.- Specified by:
getAwrDbReport
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getAwrDbSqlReport
public GetAwrDbSqlReportResponse getAwrDbSqlReport(GetAwrDbSqlReportRequest request)
Description copied from interface:DbManagement
Gets the SQL health check report for one SQL of the specific database.- Specified by:
getAwrDbSqlReport
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getClusterCacheMetric
public GetClusterCacheMetricResponse getClusterCacheMetric(GetClusterCacheMetricRequest request)
Description copied from interface:DbManagement
Gets the metrics related to cluster cache for the Oracle Real Application Clusters (Oracle RAC) database specified by managedDatabaseId.- Specified by:
getClusterCacheMetric
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getDatabaseFleetBackupMetrics
public GetDatabaseFleetBackupMetricsResponse getDatabaseFleetBackupMetrics(GetDatabaseFleetBackupMetricsRequest request)
Description copied from interface:DbManagement
Gets the fleet of container databases (CDBs) and their backup details and metrics, in a compartment or Database Group.The databaseHostedIn query parameter must be provided to list either cloud or external databases. Either the CompartmentId or the ManagedDatabaseGroupId query parameters must be provided to retrieve the HA and backup metrics.
- Specified by:
getDatabaseFleetBackupMetrics
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getDatabaseFleetDataguardMetrics
public GetDatabaseFleetDataguardMetricsResponse getDatabaseFleetDataguardMetrics(GetDatabaseFleetDataguardMetricsRequest request)
Description copied from interface:DbManagement
Gets the fleet of Oracle Data Guard-enabled container databases (CDBs) along with Data Guard metrics and standby databases, in a compartment or Database Group.Either the CompartmentId or the ManagedDatabaseGroupId query parameters must be provided to retrieve the list of databases and Data Guard metrics.
- Specified by:
getDatabaseFleetDataguardMetrics
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getDatabaseFleetHaOverviewMetrics
public GetDatabaseFleetHaOverviewMetricsResponse getDatabaseFleetHaOverviewMetrics(GetDatabaseFleetHaOverviewMetricsRequest request)
Description copied from interface:DbManagement
Gets the fleet of container databases (CDBs) and their HA and backup metrics in a compartment or in a Database Group.Either the CompartmentId or the ManagedDatabaseGroupId query parameters must be provided to retrieve the HA and backup metrics.
- Specified by:
getDatabaseFleetHaOverviewMetrics
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getDatabaseFleetHealthMetrics
public GetDatabaseFleetHealthMetricsResponse getDatabaseFleetHealthMetrics(GetDatabaseFleetHealthMetricsRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
getDatabaseFleetHealthMetrics
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getDatabaseHaBackupDetails
public GetDatabaseHaBackupDetailsResponse getDatabaseHaBackupDetails(GetDatabaseHaBackupDetailsRequest request)
Description copied from interface:DbManagement
Gets HA and backup details with metrics and backup history for a single database.- Specified by:
getDatabaseHaBackupDetails
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getDatabaseHomeMetrics
public GetDatabaseHomeMetricsResponse getDatabaseHomeMetrics(GetDatabaseHomeMetricsRequest request)
Description copied from interface:DbManagement
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.- Specified by:
getDatabaseHomeMetrics
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getDataguardPerformanceMetrics
public GetDataguardPerformanceMetricsResponse getDataguardPerformanceMetrics(GetDataguardPerformanceMetricsRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
getDataguardPerformanceMetrics
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getDbManagementPrivateEndpoint
public GetDbManagementPrivateEndpointResponse getDbManagementPrivateEndpoint(GetDbManagementPrivateEndpointRequest request)
Description copied from interface:DbManagement
Gets the details of a specific Database Management private endpoint.- Specified by:
getDbManagementPrivateEndpoint
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalAsm
public GetExternalAsmResponse getExternalAsm(GetExternalAsmRequest request)
Description copied from interface:DbManagement
Gets the details for the external ASM specified byexternalAsmId
.- Specified by:
getExternalAsm
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalAsmConfiguration
public GetExternalAsmConfigurationResponse getExternalAsmConfiguration(GetExternalAsmConfigurationRequest request)
Description copied from interface:DbManagement
Gets configuration details including disk groups for the external ASM specified byexternalAsmId
.- Specified by:
getExternalAsmConfiguration
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalAsmInstance
public GetExternalAsmInstanceResponse getExternalAsmInstance(GetExternalAsmInstanceRequest request)
Description copied from interface:DbManagement
Gets the details for the external ASM instance specified byexternalAsmInstanceId
.- Specified by:
getExternalAsmInstance
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalCluster
public GetExternalClusterResponse getExternalCluster(GetExternalClusterRequest request)
Description copied from interface:DbManagement
Gets the details for the external cluster specified byexternalClusterId
.- Specified by:
getExternalCluster
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalClusterInstance
public GetExternalClusterInstanceResponse getExternalClusterInstance(GetExternalClusterInstanceRequest request)
Description copied from interface:DbManagement
Gets the details for the external cluster instance specified byexternalClusterInstanceId
.- Specified by:
getExternalClusterInstance
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalDbHome
public GetExternalDbHomeResponse getExternalDbHome(GetExternalDbHomeRequest request)
Description copied from interface:DbManagement
Gets the details for the external DB home specified byexternalDbHomeId
.- Specified by:
getExternalDbHome
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalDbNode
public GetExternalDbNodeResponse getExternalDbNode(GetExternalDbNodeRequest request)
Description copied from interface:DbManagement
Gets the details for the external DB node specified byexternalDbNodeId
.- Specified by:
getExternalDbNode
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalDbSystem
public GetExternalDbSystemResponse getExternalDbSystem(GetExternalDbSystemRequest request)
Description copied from interface:DbManagement
Gets the details for the external DB system specified byexternalDbSystemId
.- Specified by:
getExternalDbSystem
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalDbSystemConnector
public GetExternalDbSystemConnectorResponse getExternalDbSystemConnector(GetExternalDbSystemConnectorRequest request)
Description copied from interface:DbManagement
Gets the details for the external connector specified byexternalDbSystemConnectorId
.- Specified by:
getExternalDbSystemConnector
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalDbSystemDiscovery
public GetExternalDbSystemDiscoveryResponse getExternalDbSystemDiscovery(GetExternalDbSystemDiscoveryRequest request)
Description copied from interface:DbManagement
Gets the details for the external DB system discovery resource specified byexternalDbSystemDiscoveryId
.- Specified by:
getExternalDbSystemDiscovery
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalExadataInfrastructure
public GetExternalExadataInfrastructureResponse getExternalExadataInfrastructure(GetExternalExadataInfrastructureRequest request)
Description copied from interface:DbManagement
Gets the details for the Exadata infrastructure specified by externalExadataInfrastructureId.It includes the DB systems and storage grid within the Exadata infrastructure.
- Specified by:
getExternalExadataInfrastructure
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalExadataStorageConnector
public GetExternalExadataStorageConnectorResponse getExternalExadataStorageConnector(GetExternalExadataStorageConnectorRequest request)
Description copied from interface:DbManagement
Gets the details for the Exadata storage server connector specified by exadataStorageConnectorId.- Specified by:
getExternalExadataStorageConnector
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalExadataStorageGrid
public GetExternalExadataStorageGridResponse getExternalExadataStorageGrid(GetExternalExadataStorageGridRequest request)
Description copied from interface:DbManagement
Gets the details for the Exadata storage server grid specified by exadataStorageGridId.- Specified by:
getExternalExadataStorageGrid
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalExadataStorageServer
public GetExternalExadataStorageServerResponse getExternalExadataStorageServer(GetExternalExadataStorageServerRequest request)
Description copied from interface:DbManagement
Gets the summary for the Exadata storage server specified by exadataStorageServerId.- Specified by:
getExternalExadataStorageServer
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalListener
public GetExternalListenerResponse getExternalListener(GetExternalListenerRequest request)
Description copied from interface:DbManagement
Gets the details for the external listener specified byexternalListenerId
.- Specified by:
getExternalListener
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalMySqlDatabase
public GetExternalMySqlDatabaseResponse getExternalMySqlDatabase(GetExternalMySqlDatabaseRequest request)
Description copied from interface:DbManagement
Retrieves the external MySQL database information.- Specified by:
getExternalMySqlDatabase
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getExternalMySqlDatabaseConnector
public GetExternalMySqlDatabaseConnectorResponse getExternalMySqlDatabaseConnector(GetExternalMySqlDatabaseConnectorRequest request)
Description copied from interface:DbManagement
Retrieves the MySQL database connector.- Specified by:
getExternalMySqlDatabaseConnector
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getIormPlan
public GetIormPlanResponse getIormPlan(GetIormPlanRequest request)
Description copied from interface:DbManagement
Get the IORM plan from the specific Exadata storage server.- Specified by:
getIormPlan
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getJob
public GetJobResponse getJob(GetJobRequest request)
Description copied from interface:DbManagement
Gets the details for the job specified by jobId.- Specified by:
getJob
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getJobExecution
public GetJobExecutionResponse getJobExecution(GetJobExecutionRequest request)
Description copied from interface:DbManagement
Gets the details for the job execution specified by jobExecutionId.- Specified by:
getJobExecution
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getJobRun
public GetJobRunResponse getJobRun(GetJobRunRequest request)
Description copied from interface:DbManagement
Gets the details for the job run specified by jobRunId.- Specified by:
getJobRun
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getManagedDatabase
public GetManagedDatabaseResponse getManagedDatabase(GetManagedDatabaseRequest request)
Description copied from interface:DbManagement
Gets the details for the Managed Database specified by managedDatabaseId.- Specified by:
getManagedDatabase
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getManagedDatabaseGroup
public GetManagedDatabaseGroupResponse getManagedDatabaseGroup(GetManagedDatabaseGroupRequest request)
Description copied from interface:DbManagement
Gets the details for the Managed Database Group specified by managedDatabaseGroupId.- Specified by:
getManagedDatabaseGroup
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getNamedCredential
public GetNamedCredentialResponse getNamedCredential(GetNamedCredentialRequest request)
Description copied from interface:DbManagement
Gets the details for the named credential specified by namedCredentialId.- Specified by:
getNamedCredential
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getOpenAlertHistory
public GetOpenAlertHistoryResponse getOpenAlertHistory(GetOpenAlertHistoryRequest request)
Description copied from interface:DbManagement
Gets the open alerts from the specified Exadata storage server.- Specified by:
getOpenAlertHistory
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getOptimizerStatisticsAdvisorExecution
public GetOptimizerStatisticsAdvisorExecutionResponse getOptimizerStatisticsAdvisorExecution(GetOptimizerStatisticsAdvisorExecutionRequest request)
Description copied from interface:DbManagement
Gets a comprehensive report of the Optimizer Statistics Advisor execution, which includes details of the Managed Database, findings, recommendations, rationale, and examples.- Specified by:
getOptimizerStatisticsAdvisorExecution
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getOptimizerStatisticsAdvisorExecutionScript
public GetOptimizerStatisticsAdvisorExecutionScriptResponse getOptimizerStatisticsAdvisorExecutionScript(GetOptimizerStatisticsAdvisorExecutionScriptRequest request)
Description copied from interface:DbManagement
Gets the Oracle system-generated script for the specified Optimizer Statistics Advisor execution.- Specified by:
getOptimizerStatisticsAdvisorExecutionScript
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getOptimizerStatisticsCollectionOperation
public GetOptimizerStatisticsCollectionOperationResponse getOptimizerStatisticsCollectionOperation(GetOptimizerStatisticsCollectionOperationRequest request)
Description copied from interface:DbManagement
Gets a detailed report of the Optimizer Statistics Collection operation for the specified Managed Database.- Specified by:
getOptimizerStatisticsCollectionOperation
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getPdbMetrics
public GetPdbMetricsResponse getPdbMetrics(GetPdbMetricsRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
getPdbMetrics
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getPeerDatabaseMetrics
public GetPeerDatabaseMetricsResponse getPeerDatabaseMetrics(GetPeerDatabaseMetricsRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
getPeerDatabaseMetrics
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getPreferredCredential
public GetPreferredCredentialResponse getPreferredCredential(GetPreferredCredentialRequest request)
Description copied from interface:DbManagement
Gets the preferred credential details for a Managed Database based on credentialName.- Specified by:
getPreferredCredential
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getSqlPlanBaseline
public GetSqlPlanBaselineResponse getSqlPlanBaseline(GetSqlPlanBaselineRequest request)
Description copied from interface:DbManagement
Gets the SQL plan baseline details for the specified planName.- Specified by:
getSqlPlanBaseline
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getSqlPlanBaselineConfiguration
public GetSqlPlanBaselineConfigurationResponse getSqlPlanBaselineConfiguration(GetSqlPlanBaselineConfigurationRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
getSqlPlanBaselineConfiguration
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getTablespace
public GetTablespaceResponse getTablespace(GetTablespaceRequest request)
Description copied from interface:DbManagement
Gets the details of the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.- Specified by:
getTablespace
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getTopSqlCpuActivity
public GetTopSqlCpuActivityResponse getTopSqlCpuActivity(GetTopSqlCpuActivityRequest request)
Description copied from interface:DbManagement
Gets the SQL IDs with the top CPU activity from the Exadata storage server.- Specified by:
getTopSqlCpuActivity
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getUser
public GetUserResponse getUser(GetUserRequest request)
Description copied from interface:DbManagement
Gets the details of the user specified by managedDatabaseId and userName.- Specified by:
getUser
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getWorkRequest
public GetWorkRequestResponse getWorkRequest(GetWorkRequestRequest request)
Description copied from interface:DbManagement
Gets the status of the work request with the given Work Request ID- Specified by:
getWorkRequest
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
implementOptimizerStatisticsAdvisorRecommendations
public ImplementOptimizerStatisticsAdvisorRecommendationsResponse implementOptimizerStatisticsAdvisorRecommendations(ImplementOptimizerStatisticsAdvisorRecommendationsRequest request)
Description copied from interface:DbManagement
Asynchronously implements the findings and recommendations of the Optimizer Statistics Advisor execution.- Specified by:
implementOptimizerStatisticsAdvisorRecommendations
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listAsmProperties
public ListAsmPropertiesResponse listAsmProperties(ListAsmPropertiesRequest request)
Description copied from interface:DbManagement
Gets the list of ASM properties for the specified managedDatabaseId.- Specified by:
listAsmProperties
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listAssociatedDatabases
public ListAssociatedDatabasesResponse listAssociatedDatabases(ListAssociatedDatabasesRequest request)
Description copied from interface:DbManagement
Gets the list of databases using a specific Database Management private endpoint.- Specified by:
listAssociatedDatabases
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listAwrDbSnapshots
public ListAwrDbSnapshotsResponse listAwrDbSnapshots(ListAwrDbSnapshotsRequest request)
Description copied from interface:DbManagement
Lists AWR snapshots for the specified database in the AWR.- Specified by:
listAwrDbSnapshots
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listAwrDbs
public ListAwrDbsResponse listAwrDbs(ListAwrDbsRequest request)
Description copied from interface:DbManagement
Gets the list of databases and their snapshot summary details available in the AWR of the specified Managed Database.- Specified by:
listAwrDbs
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listConsumerGroupPrivileges
public ListConsumerGroupPrivilegesResponse listConsumerGroupPrivileges(ListConsumerGroupPrivilegesRequest request)
Description copied from interface:DbManagement
Gets the list of consumer group privileges granted to a specific user.- Specified by:
listConsumerGroupPrivileges
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listCursorCacheStatements
public ListCursorCacheStatementsResponse listCursorCacheStatements(ListCursorCacheStatementsRequest request)
Description copied from interface:DbManagement
Lists the SQL statements from shared SQL area, also called the cursor cache.- Specified by:
listCursorCacheStatements
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listDataAccessContainers
public ListDataAccessContainersResponse listDataAccessContainers(ListDataAccessContainersRequest request)
Description copied from interface:DbManagement
Gets the list of containers for a specific user.This is only applicable if ALL_CONTAINERS !=‘Y’.
- Specified by:
listDataAccessContainers
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listDatabaseParameters
public ListDatabaseParametersResponse listDatabaseParameters(ListDatabaseParametersRequest request)
Description copied from interface:DbManagement
Gets the list of database parameters for the specified Managed Database.The parameters are listed in alphabetical order, along with their current values.
- Specified by:
listDatabaseParameters
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listDbManagementPrivateEndpoints
public ListDbManagementPrivateEndpointsResponse listDbManagementPrivateEndpoints(ListDbManagementPrivateEndpointsRequest request)
Description copied from interface:DbManagement
Gets a list of Database Management private endpoints.- Specified by:
listDbManagementPrivateEndpoints
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalAsmDiskGroups
public ListExternalAsmDiskGroupsResponse listExternalAsmDiskGroups(ListExternalAsmDiskGroupsRequest request)
Description copied from interface:DbManagement
Lists ASM disk groups for the external ASM specified byexternalAsmId
.- Specified by:
listExternalAsmDiskGroups
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalAsmInstances
public ListExternalAsmInstancesResponse listExternalAsmInstances(ListExternalAsmInstancesRequest request)
Description copied from interface:DbManagement
Lists the ASM instances in the specified external ASM.- Specified by:
listExternalAsmInstances
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalAsmUsers
public ListExternalAsmUsersResponse listExternalAsmUsers(ListExternalAsmUsersRequest request)
Description copied from interface:DbManagement
Lists ASM users for the external ASM specified byexternalAsmId
.- Specified by:
listExternalAsmUsers
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalAsms
public ListExternalAsmsResponse listExternalAsms(ListExternalAsmsRequest request)
Description copied from interface:DbManagement
Lists the ASMs in the specified external DB system.- Specified by:
listExternalAsms
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalClusterInstances
public ListExternalClusterInstancesResponse listExternalClusterInstances(ListExternalClusterInstancesRequest request)
Description copied from interface:DbManagement
Lists the cluster instances in the specified external cluster.- Specified by:
listExternalClusterInstances
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalClusters
public ListExternalClustersResponse listExternalClusters(ListExternalClustersRequest request)
Description copied from interface:DbManagement
Lists the clusters in the specified external DB system.- Specified by:
listExternalClusters
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalDatabases
public ListExternalDatabasesResponse listExternalDatabases(ListExternalDatabasesRequest request)
Description copied from interface:DbManagement
Lists the external databases in the specified compartment or in the specified DB system.- Specified by:
listExternalDatabases
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalDbHomes
public ListExternalDbHomesResponse listExternalDbHomes(ListExternalDbHomesRequest request)
Description copied from interface:DbManagement
Lists the DB homes in the specified external DB system.- Specified by:
listExternalDbHomes
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalDbNodes
public ListExternalDbNodesResponse listExternalDbNodes(ListExternalDbNodesRequest request)
Description copied from interface:DbManagement
Lists the external DB nodes in the specified external DB system.- Specified by:
listExternalDbNodes
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalDbSystemConnectors
public ListExternalDbSystemConnectorsResponse listExternalDbSystemConnectors(ListExternalDbSystemConnectorsRequest request)
Description copied from interface:DbManagement
Lists the external connectors in the specified external DB system.- Specified by:
listExternalDbSystemConnectors
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalDbSystemDiscoveries
public ListExternalDbSystemDiscoveriesResponse listExternalDbSystemDiscoveries(ListExternalDbSystemDiscoveriesRequest request)
Description copied from interface:DbManagement
Lists the external DB system discovery resources in the specified compartment.- Specified by:
listExternalDbSystemDiscoveries
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalDbSystems
public ListExternalDbSystemsResponse listExternalDbSystems(ListExternalDbSystemsRequest request)
Description copied from interface:DbManagement
Lists the external DB systems in the specified compartment.- Specified by:
listExternalDbSystems
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalExadataInfrastructures
public ListExternalExadataInfrastructuresResponse listExternalExadataInfrastructures(ListExternalExadataInfrastructuresRequest request)
Description copied from interface:DbManagement
Lists the Exadata infrastructure resources in the specified compartment.- Specified by:
listExternalExadataInfrastructures
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalExadataStorageConnectors
public ListExternalExadataStorageConnectorsResponse listExternalExadataStorageConnectors(ListExternalExadataStorageConnectorsRequest request)
Description copied from interface:DbManagement
Lists the Exadata storage server connectors for the specified Exadata infrastructure.- Specified by:
listExternalExadataStorageConnectors
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalExadataStorageServers
public ListExternalExadataStorageServersResponse listExternalExadataStorageServers(ListExternalExadataStorageServersRequest request)
Description copied from interface:DbManagement
Lists the Exadata storage servers for the specified Exadata infrastructure.- Specified by:
listExternalExadataStorageServers
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalListenerServices
public ListExternalListenerServicesResponse listExternalListenerServices(ListExternalListenerServicesRequest request)
Description copied from interface:DbManagement
Lists the database services registered with the specified external listener for the specified Managed Database.- Specified by:
listExternalListenerServices
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalListeners
public ListExternalListenersResponse listExternalListeners(ListExternalListenersRequest request)
Description copied from interface:DbManagement
Lists the listeners in the specified external DB system.- Specified by:
listExternalListeners
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listExternalMySqlDatabases
public ListExternalMySqlDatabasesResponse listExternalMySqlDatabases(ListExternalMySqlDatabasesRequest request)
Description copied from interface:DbManagement
Gets the list of External MySQL Databases.- Specified by:
listExternalMySqlDatabases
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listJobExecutions
public ListJobExecutionsResponse listJobExecutions(ListJobExecutionsRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
listJobExecutions
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listJobRuns
public ListJobRunsResponse listJobRuns(ListJobRunsRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
listJobRuns
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listJobs
public ListJobsResponse listJobs(ListJobsRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
listJobs
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listManagedDatabaseGroups
public ListManagedDatabaseGroupsResponse listManagedDatabaseGroups(ListManagedDatabaseGroupsRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
listManagedDatabaseGroups
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listManagedDatabases
public ListManagedDatabasesResponse listManagedDatabases(ListManagedDatabasesRequest request)
Description copied from interface:DbManagement
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 withADVANCED
management option are listed.- Specified by:
listManagedDatabases
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listMySqlDatabaseConnectors
public ListMySqlDatabaseConnectorsResponse listMySqlDatabaseConnectors(ListMySqlDatabaseConnectorsRequest request)
Description copied from interface:DbManagement
Gets the list of External MySQL Database connectors.- Specified by:
listMySqlDatabaseConnectors
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listNamedCredentials
public ListNamedCredentialsResponse listNamedCredentials(ListNamedCredentialsRequest request)
Description copied from interface:DbManagement
Gets a single named credential specified by the name or all the named credentials in a specific compartment.- Specified by:
listNamedCredentials
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listObjectPrivileges
public ListObjectPrivilegesResponse listObjectPrivileges(ListObjectPrivilegesRequest request)
Description copied from interface:DbManagement
Gets the list of object privileges granted to a specific user.- Specified by:
listObjectPrivileges
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listOptimizerStatisticsAdvisorExecutions
public ListOptimizerStatisticsAdvisorExecutionsResponse listOptimizerStatisticsAdvisorExecutions(ListOptimizerStatisticsAdvisorExecutionsRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
listOptimizerStatisticsAdvisorExecutions
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listOptimizerStatisticsCollectionAggregations
public ListOptimizerStatisticsCollectionAggregationsResponse listOptimizerStatisticsCollectionAggregations(ListOptimizerStatisticsCollectionAggregationsRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
listOptimizerStatisticsCollectionAggregations
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listOptimizerStatisticsCollectionOperations
public ListOptimizerStatisticsCollectionOperationsResponse listOptimizerStatisticsCollectionOperations(ListOptimizerStatisticsCollectionOperationsRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
listOptimizerStatisticsCollectionOperations
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listPreferredCredentials
public ListPreferredCredentialsResponse listPreferredCredentials(ListPreferredCredentialsRequest request)
Description copied from interface:DbManagement
Gets the list of preferred credentials for a given Managed Database.- Specified by:
listPreferredCredentials
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listProxiedForUsers
public ListProxiedForUsersResponse listProxiedForUsers(ListProxiedForUsersRequest request)
Description copied from interface:DbManagement
Gets the list of users on whose behalf the current user acts as proxy.- Specified by:
listProxiedForUsers
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listProxyUsers
public ListProxyUsersResponse listProxyUsers(ListProxyUsersRequest request)
Description copied from interface:DbManagement
Gets the list of proxy users for the current user.- Specified by:
listProxyUsers
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listRoles
public ListRolesResponse listRoles(ListRolesRequest request)
Description copied from interface:DbManagement
Gets the list of roles granted to a specific user.- Specified by:
listRoles
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listSqlPlanBaselineJobs
public ListSqlPlanBaselineJobsResponse listSqlPlanBaselineJobs(ListSqlPlanBaselineJobsRequest request)
Description copied from interface:DbManagement
Lists the database jobs used for loading SQL plan baselines in the specified Managed Database.- Specified by:
listSqlPlanBaselineJobs
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listSqlPlanBaselines
public ListSqlPlanBaselinesResponse listSqlPlanBaselines(ListSqlPlanBaselinesRequest request)
Description copied from interface:DbManagement
Lists the SQL plan baselines for the specified Managed Database.- Specified by:
listSqlPlanBaselines
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listSystemPrivileges
public ListSystemPrivilegesResponse listSystemPrivileges(ListSystemPrivilegesRequest request)
Description copied from interface:DbManagement
Gets the list of system privileges granted to a specific user.- Specified by:
listSystemPrivileges
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listTableStatistics
public ListTableStatisticsResponse listTableStatistics(ListTableStatisticsRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
listTableStatistics
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listTablespaces
public ListTablespacesResponse listTablespaces(ListTablespacesRequest request)
Description copied from interface:DbManagement
Gets the list of tablespaces for the specified managedDatabaseId.- Specified by:
listTablespaces
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listUsers
public ListUsersResponse listUsers(ListUsersRequest request)
Description copied from interface:DbManagement
Gets the list of users for the specified managedDatabaseId.- Specified by:
listUsers
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listWorkRequestErrors
public ListWorkRequestErrorsResponse listWorkRequestErrors(ListWorkRequestErrorsRequest request)
Description copied from interface:DbManagement
Returns a paginated list of errors for a given work request.- Specified by:
listWorkRequestErrors
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listWorkRequestLogs
public ListWorkRequestLogsResponse listWorkRequestLogs(ListWorkRequestLogsRequest request)
Description copied from interface:DbManagement
Returns a paginated list of logs for a given work request.- Specified by:
listWorkRequestLogs
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
listWorkRequests
public ListWorkRequestsResponse listWorkRequests(ListWorkRequestsRequest request)
Description copied from interface:DbManagement
The list of work requests in a specific compartment was retrieved successfully.- Specified by:
listWorkRequests
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
loadSqlPlanBaselinesFromAwr
public LoadSqlPlanBaselinesFromAwrResponse loadSqlPlanBaselinesFromAwr(LoadSqlPlanBaselinesFromAwrRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
loadSqlPlanBaselinesFromAwr
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
loadSqlPlanBaselinesFromCursorCache
public LoadSqlPlanBaselinesFromCursorCacheResponse loadSqlPlanBaselinesFromCursorCache(LoadSqlPlanBaselinesFromCursorCacheRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
loadSqlPlanBaselinesFromCursorCache
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
modifyAutonomousDatabaseManagementFeature
public ModifyAutonomousDatabaseManagementFeatureResponse modifyAutonomousDatabaseManagementFeature(ModifyAutonomousDatabaseManagementFeatureRequest request)
Description copied from interface:DbManagement
Modifies the Database Management feature for the specified Autonomous Database.- Specified by:
modifyAutonomousDatabaseManagementFeature
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
modifyDatabaseManagementFeature
public ModifyDatabaseManagementFeatureResponse modifyDatabaseManagementFeature(ModifyDatabaseManagementFeatureRequest request)
Description copied from interface:DbManagement
Modifies a Database Management feature for the specified Oracle cloud database.- Specified by:
modifyDatabaseManagementFeature
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
modifyPluggableDatabaseManagementFeature
public ModifyPluggableDatabaseManagementFeatureResponse modifyPluggableDatabaseManagementFeature(ModifyPluggableDatabaseManagementFeatureRequest request)
Description copied from interface:DbManagement
Modifies the Database Management feature for the specified Oracle cloud pluggable database.- Specified by:
modifyPluggableDatabaseManagementFeature
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
patchExternalDbSystemDiscovery
public PatchExternalDbSystemDiscoveryResponse patchExternalDbSystemDiscovery(PatchExternalDbSystemDiscoveryRequest request)
Description copied from interface:DbManagement
Patches the external DB system discovery specified byexternalDbSystemDiscoveryId
.- Specified by:
patchExternalDbSystemDiscovery
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
removeDataFile
public RemoveDataFileResponse removeDataFile(RemoveDataFileRequest request)
Description copied from interface:DbManagement
Removes a data file or temp file from the tablespace.- Specified by:
removeDataFile
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
removeManagedDatabaseFromManagedDatabaseGroup
public RemoveManagedDatabaseFromManagedDatabaseGroupResponse removeManagedDatabaseFromManagedDatabaseGroup(RemoveManagedDatabaseFromManagedDatabaseGroupRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
removeManagedDatabaseFromManagedDatabaseGroup
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
resetDatabaseParameters
public ResetDatabaseParametersResponse resetDatabaseParameters(ResetDatabaseParametersRequest request)
Description copied from interface:DbManagement
Resets database parameter values to their default or startup values.- Specified by:
resetDatabaseParameters
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
resizeDataFile
public ResizeDataFileResponse resizeDataFile(ResizeDataFileRequest request)
Description copied from interface:DbManagement
Resizes a data file or temp file within the tablespace.- Specified by:
resizeDataFile
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
runHistoricAddm
public RunHistoricAddmResponse runHistoricAddm(RunHistoricAddmRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
runHistoricAddm
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeAwrDbCpuUsages
public SummarizeAwrDbCpuUsagesResponse summarizeAwrDbCpuUsages(SummarizeAwrDbCpuUsagesRequest request)
Description copied from interface:DbManagement
Summarizes the AWR CPU resource limits and metrics for the specified database in AWR.- Specified by:
summarizeAwrDbCpuUsages
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeAwrDbMetrics
public SummarizeAwrDbMetricsResponse summarizeAwrDbMetrics(SummarizeAwrDbMetricsRequest request)
Description copied from interface:DbManagement
Summarizes the metric samples for the specified database in the AWR.The metric samples are summarized based on the Time dimension for each metric.
- Specified by:
summarizeAwrDbMetrics
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeAwrDbParameterChanges
public SummarizeAwrDbParameterChangesResponse summarizeAwrDbParameterChanges(SummarizeAwrDbParameterChangesRequest request)
Description copied from interface:DbManagement
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
- Specified by:
summarizeAwrDbParameterChanges
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeAwrDbParameters
public SummarizeAwrDbParametersResponse summarizeAwrDbParameters(SummarizeAwrDbParametersRequest request)
Description copied from interface:DbManagement
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
- Specified by:
summarizeAwrDbParameters
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeAwrDbSnapshotRanges
public SummarizeAwrDbSnapshotRangesResponse summarizeAwrDbSnapshotRanges(SummarizeAwrDbSnapshotRangesRequest request)
Description copied from interface:DbManagement
Summarizes the AWR snapshot ranges that contain continuous snapshots, for the specified Managed Database.- Specified by:
summarizeAwrDbSnapshotRanges
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeAwrDbSysstats
public SummarizeAwrDbSysstatsResponse summarizeAwrDbSysstats(SummarizeAwrDbSysstatsRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
summarizeAwrDbSysstats
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeAwrDbTopWaitEvents
public SummarizeAwrDbTopWaitEventsResponse summarizeAwrDbTopWaitEvents(SummarizeAwrDbTopWaitEventsRequest request)
Description copied from interface:DbManagement
Summarizes the AWR top wait events.- Specified by:
summarizeAwrDbTopWaitEvents
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeAwrDbWaitEventBuckets
public SummarizeAwrDbWaitEventBucketsResponse summarizeAwrDbWaitEventBuckets(SummarizeAwrDbWaitEventBucketsRequest request)
Description copied from interface:DbManagement
Summarizes AWR wait event data into value buckets and frequency, for the specified database in the AWR.- Specified by:
summarizeAwrDbWaitEventBuckets
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeAwrDbWaitEvents
public SummarizeAwrDbWaitEventsResponse summarizeAwrDbWaitEvents(SummarizeAwrDbWaitEventsRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
summarizeAwrDbWaitEvents
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeExternalAsmMetrics
public SummarizeExternalAsmMetricsResponse summarizeExternalAsmMetrics(SummarizeExternalAsmMetricsRequest request)
Description copied from interface:DbManagement
Gets metrics for the external ASM specified byexternalAsmId
.- Specified by:
summarizeExternalAsmMetrics
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeExternalClusterMetrics
public SummarizeExternalClusterMetricsResponse summarizeExternalClusterMetrics(SummarizeExternalClusterMetricsRequest request)
Description copied from interface:DbManagement
Gets metrics for the external cluster specified byexternalClusterId
.- Specified by:
summarizeExternalClusterMetrics
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeExternalDbNodeMetrics
public SummarizeExternalDbNodeMetricsResponse summarizeExternalDbNodeMetrics(SummarizeExternalDbNodeMetricsRequest request)
Description copied from interface:DbManagement
Gets metrics for the external DB node specified byexternalDbNodeId
.- Specified by:
summarizeExternalDbNodeMetrics
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeExternalDbSystemAvailabilityMetrics
public SummarizeExternalDbSystemAvailabilityMetricsResponse summarizeExternalDbSystemAvailabilityMetrics(SummarizeExternalDbSystemAvailabilityMetricsRequest request)
Description copied from interface:DbManagement
Gets availability metrics for the components present in the external DB system specified byexternalDbSystemId
.- Specified by:
summarizeExternalDbSystemAvailabilityMetrics
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeExternalListenerMetrics
public SummarizeExternalListenerMetricsResponse summarizeExternalListenerMetrics(SummarizeExternalListenerMetricsRequest request)
Description copied from interface:DbManagement
Gets metrics for the external listener specified byexternalListenerId
.- Specified by:
summarizeExternalListenerMetrics
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeJobExecutionsStatuses
public SummarizeJobExecutionsStatusesResponse summarizeJobExecutionsStatuses(SummarizeJobExecutionsStatusesRequest request)
Description copied from interface:DbManagement
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.
- Specified by:
summarizeJobExecutionsStatuses
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeManagedDatabaseAvailabilityMetrics
public SummarizeManagedDatabaseAvailabilityMetricsResponse summarizeManagedDatabaseAvailabilityMetrics(SummarizeManagedDatabaseAvailabilityMetricsRequest request)
Description copied from interface:DbManagement
Gets the availability metrics related to managed database for the Oracle database specified by managedDatabaseId.- Specified by:
summarizeManagedDatabaseAvailabilityMetrics
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeSqlPlanBaselines
public SummarizeSqlPlanBaselinesResponse summarizeSqlPlanBaselines(SummarizeSqlPlanBaselinesRequest request)
Description copied from interface:DbManagement
Gets the number of SQL plan baselines aggregated by their attributes.- Specified by:
summarizeSqlPlanBaselines
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
summarizeSqlPlanBaselinesByLastExecution
public SummarizeSqlPlanBaselinesByLastExecutionResponse summarizeSqlPlanBaselinesByLastExecution(SummarizeSqlPlanBaselinesByLastExecutionRequest request)
Description copied from interface:DbManagement
Gets the number of SQL plan baselines aggregated by the age of their last execution in weeks.- Specified by:
summarizeSqlPlanBaselinesByLastExecution
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
testNamedCredential
public TestNamedCredentialResponse testNamedCredential(TestNamedCredentialRequest request)
Description copied from interface:DbManagement
Tests the named credential.- Specified by:
testNamedCredential
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
testPreferredCredential
public TestPreferredCredentialResponse testPreferredCredential(TestPreferredCredentialRequest request)
Description copied from interface:DbManagement
Tests the preferred credential.- Specified by:
testPreferredCredential
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateDbManagementPrivateEndpoint
public UpdateDbManagementPrivateEndpointResponse updateDbManagementPrivateEndpoint(UpdateDbManagementPrivateEndpointRequest request)
Description copied from interface:DbManagement
Updates one or more attributes of a specific Database Management private endpoint.- Specified by:
updateDbManagementPrivateEndpoint
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateExternalAsm
public UpdateExternalAsmResponse updateExternalAsm(UpdateExternalAsmRequest request)
Description copied from interface:DbManagement
Updates the external ASM specified byexternalAsmId
.- Specified by:
updateExternalAsm
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateExternalAsmInstance
public UpdateExternalAsmInstanceResponse updateExternalAsmInstance(UpdateExternalAsmInstanceRequest request)
Description copied from interface:DbManagement
Updates the external ASM instance specified byexternalAsmInstanceId
.- Specified by:
updateExternalAsmInstance
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateExternalCluster
public UpdateExternalClusterResponse updateExternalCluster(UpdateExternalClusterRequest request)
Description copied from interface:DbManagement
Updates the external cluster specified byexternalClusterId
.- Specified by:
updateExternalCluster
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateExternalClusterInstance
public UpdateExternalClusterInstanceResponse updateExternalClusterInstance(UpdateExternalClusterInstanceRequest request)
Description copied from interface:DbManagement
Updates the external cluster instance specified byexternalClusterInstanceId
.- Specified by:
updateExternalClusterInstance
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateExternalDbHome
public UpdateExternalDbHomeResponse updateExternalDbHome(UpdateExternalDbHomeRequest request)
Description copied from interface:DbManagement
Updates the external DB home specified byexternalDbHomeId
.- Specified by:
updateExternalDbHome
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateExternalDbNode
public UpdateExternalDbNodeResponse updateExternalDbNode(UpdateExternalDbNodeRequest request)
Description copied from interface:DbManagement
Updates the external DB node specified byexternalDbNodeId
.- Specified by:
updateExternalDbNode
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateExternalDbSystem
public UpdateExternalDbSystemResponse updateExternalDbSystem(UpdateExternalDbSystemRequest request)
Description copied from interface:DbManagement
Updates the external DB system specified byexternalDbSystemId
.- Specified by:
updateExternalDbSystem
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateExternalDbSystemConnector
public UpdateExternalDbSystemConnectorResponse updateExternalDbSystemConnector(UpdateExternalDbSystemConnectorRequest request)
Description copied from interface:DbManagement
Updates the external connector specified byexternalDbSystemConnectorId
.- Specified by:
updateExternalDbSystemConnector
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateExternalDbSystemDiscovery
public UpdateExternalDbSystemDiscoveryResponse updateExternalDbSystemDiscovery(UpdateExternalDbSystemDiscoveryRequest request)
Description copied from interface:DbManagement
Updates the external DB system discovery specified byexternalDbSystemDiscoveryId
.- Specified by:
updateExternalDbSystemDiscovery
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateExternalExadataInfrastructure
public UpdateExternalExadataInfrastructureResponse updateExternalExadataInfrastructure(UpdateExternalExadataInfrastructureRequest request)
Description copied from interface:DbManagement
Updates the details for the Exadata infrastructure specified by externalExadataInfrastructureId.- Specified by:
updateExternalExadataInfrastructure
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateExternalExadataStorageConnector
public UpdateExternalExadataStorageConnectorResponse updateExternalExadataStorageConnector(UpdateExternalExadataStorageConnectorRequest request)
Description copied from interface:DbManagement
Updates the Exadata storage server connector specified by exadataStorageConnectorId.- Specified by:
updateExternalExadataStorageConnector
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateExternalExadataStorageGrid
public UpdateExternalExadataStorageGridResponse updateExternalExadataStorageGrid(UpdateExternalExadataStorageGridRequest request)
Description copied from interface:DbManagement
Updates the Exadata storage server grid specified by exadataStorageGridId.- Specified by:
updateExternalExadataStorageGrid
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateExternalExadataStorageServer
public UpdateExternalExadataStorageServerResponse updateExternalExadataStorageServer(UpdateExternalExadataStorageServerRequest request)
Description copied from interface:DbManagement
Updates the Exadata storage server specified by exadataStorageServerId.- Specified by:
updateExternalExadataStorageServer
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateExternalListener
public UpdateExternalListenerResponse updateExternalListener(UpdateExternalListenerRequest request)
Description copied from interface:DbManagement
Updates the external listener specified byexternalListenerId
.- Specified by:
updateExternalListener
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateExternalMysqlDatabase
public UpdateExternalMysqlDatabaseResponse updateExternalMysqlDatabase(UpdateExternalMysqlDatabaseRequest request)
Description copied from interface:DbManagement
Updates the External Mysql Database.- Specified by:
updateExternalMysqlDatabase
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateExternalMysqlDatabaseConnector
public UpdateExternalMysqlDatabaseConnectorResponse updateExternalMysqlDatabaseConnector(UpdateExternalMysqlDatabaseConnectorRequest request)
Description copied from interface:DbManagement
Updates the External Mysql Database Connector.- Specified by:
updateExternalMysqlDatabaseConnector
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateJob
public UpdateJobResponse updateJob(UpdateJobRequest request)
Description copied from interface:DbManagement
Updates the details for the recurring scheduled job specified by jobId.Note that non-recurring (one time) jobs cannot be updated.
- Specified by:
updateJob
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateManagedDatabase
public UpdateManagedDatabaseResponse updateManagedDatabase(UpdateManagedDatabaseRequest request)
Description copied from interface:DbManagement
Updates the Managed Database specified by managedDatabaseId.- Specified by:
updateManagedDatabase
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateManagedDatabaseGroup
public UpdateManagedDatabaseGroupResponse updateManagedDatabaseGroup(UpdateManagedDatabaseGroupRequest request)
Description copied from interface:DbManagement
Updates the Managed Database Group specified by managedDatabaseGroupId.- Specified by:
updateManagedDatabaseGroup
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateNamedCredential
public UpdateNamedCredentialResponse updateNamedCredential(UpdateNamedCredentialRequest request)
Description copied from interface:DbManagement
Updates the named credential specified by namedCredentialId.- Specified by:
updateNamedCredential
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updatePreferredCredential
public UpdatePreferredCredentialResponse updatePreferredCredential(UpdatePreferredCredentialRequest request)
Description copied from interface:DbManagement
Updates the preferred credential based on the credentialName.- Specified by:
updatePreferredCredential
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
updateTablespace
public UpdateTablespaceResponse updateTablespace(UpdateTablespaceRequest request)
Description copied from interface:DbManagement
Updates the attributes of the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.- Specified by:
updateTablespace
in interfaceDbManagement
- Parameters:
request
- The request object containing the details to send- Returns:
- A response object containing details about the completed operation
-
getWaiters
public DbManagementWaiters getWaiters()
Description copied from interface:DbManagement
Gets the pre-configured waiters available for resources for this service.- Specified by:
getWaiters
in interfaceDbManagement
- Returns:
- The service waiters.
-
getPaginators
public DbManagementPaginators getPaginators()
Description copied from interface:DbManagement
Gets the pre-configured paginators available for list operations in this service which may return multiple pages of data.These paginators provide an
Iterable
interface so that service responses, or resources/records, can be iterated through without having to manually deal with pagination and page tokens.- Specified by:
getPaginators
in interfaceDbManagement
- Returns:
- The service paginators.
-
getDefaultConfigurator
protected ClientConfigurator getDefaultConfigurator()
-
useRealmSpecificEndpointTemplate
public void useRealmSpecificEndpointTemplate(boolean useOfRealmSpecificEndpointTemplateEnabled)
This method should be used to enable or disable the use of realm-specific endpoint template.The default value is null. To enable the use of endpoint template defined for the realm in use, set the flag to true To disable the use of endpoint template defined for the realm in use, set the flag to false
- Parameters:
useOfRealmSpecificEndpointTemplateEnabled
- This flag can be set to true or false to enable or disable the use of realm-specific endpoint template respectively
-
populateServiceParametersInEndpoint
public final void populateServiceParametersInEndpoint(String endpoint, Map<String,Object> requiredParametersMap)
Populate the parameters in the endpoint with its corresponding value and update the base endpoint.The value will be populated iff the parameter in endpoint is a required request path parameter or a required request query parameter. If not, the parameter in the endpoint will be ignored and left blank.
- Parameters:
endpoint
- The endpoint template in userequiredParametersMap
- Map of parameter name as key and value set in request path or query parameter as value
-
updateBaseEndpoint
public final void updateBaseEndpoint(String endpoint)
This method should be used for parameterized endpoint templates only.This does not include {region} and {secondLevelDomain} parameters.
- Parameters:
endpoint
- The updated endpoint to use
-
setEndpoint
public final void setEndpoint(String endpoint)
-
getEndpoint
public final String getEndpoint()
-
refreshClient
public final void refreshClient()
Rebuild the backingHttpClient
.This will call
ClientConfigurator
s again, and can be used to e.g. refresh the SSL certificate.
-
close
public final void close()
- Specified by:
close
in interfaceAutoCloseable
-
getClientCommonLibraryVersion
public String getClientCommonLibraryVersion()
-
-