Database Management

oci.database_management.DbManagementClient Use the Database Management API to perform tasks such as obtaining performance and resource usage metrics for a fleet of Managed Databases or a specific Managed Database, creating Managed Database Groups, and running a SQL job on a Managed Database or Managed Database Group.
oci.database_management.DiagnosabilityClient Use the Database Management API to perform tasks such as obtaining performance and resource usage metrics for a fleet of Managed Databases or a specific Managed Database, creating Managed Database Groups, and running a SQL job on a Managed Database or Managed Database Group.
oci.database_management.SqlTuningClient Use the Database Management API to perform tasks such as obtaining performance and resource usage metrics for a fleet of Managed Databases or a specific Managed Database, creating Managed Database Groups, and running a SQL job on a Managed Database or Managed Database Group.
oci.database_management.DbManagementClientCompositeOperations This class provides a wrapper around DbManagementClient and offers convenience methods for operations that would otherwise need to be chained together.
oci.database_management.DiagnosabilityClientCompositeOperations This class provides a wrapper around DiagnosabilityClient and offers convenience methods for operations that would otherwise need to be chained together.
oci.database_management.SqlTuningClientCompositeOperations This class provides a wrapper around SqlTuningClient and offers convenience methods for operations that would otherwise need to be chained together.

Models

oci.database_management.models.ActivityTimeSeriesMetrics The response object representing activityMetric details for a specific Managed Database at a particular time.
oci.database_management.models.AddDataFilesDetails The details required to add data files or temp files to the tablespace.
oci.database_management.models.AddManagedDatabaseToManagedDatabaseGroupDetails The Managed Database details required to add it to a Managed Database Group.
oci.database_management.models.AddmTaskSummary The object containing the ADDM task metadata.
oci.database_management.models.AddmTasksCollection The list of ADDM task metadata.
oci.database_management.models.AdvisorRule The details of the Optimizer Statistics Advisor rule.
oci.database_management.models.AlertLogCollection The list of alert logs.
oci.database_management.models.AlertLogCountSummary The details for one alert log count entry.
oci.database_management.models.AlertLogCountsCollection The collection of the counts of different level or type of alert logs.
oci.database_management.models.AlertLogSummary The detail for one alert log entry.
oci.database_management.models.AllowedParameterValue A valid value for a database parameter.
oci.database_management.models.AsmProperty The details of ASM properties.
oci.database_management.models.AsmPropertyCollection A collection of ASM properties for a specific Managed Database.
oci.database_management.models.AsmPropertySummary The summary of ASM properties.
oci.database_management.models.AssociatedDatabaseCollection A collection of databases using a Database Management private endpoint.
oci.database_management.models.AssociatedDatabaseSummary The summary of a database currently using a Database Management private endpoint.
oci.database_management.models.AttentionLogCollection The list of attention logs.
oci.database_management.models.AttentionLogCountSummary The details for one attention log count entry.
oci.database_management.models.AttentionLogCountsCollection The collection of the counts of different urgency or type of attention logs.
oci.database_management.models.AttentionLogSummary The details for one attention log entry.
oci.database_management.models.AwrDbCollection The result of AWR query.
oci.database_management.models.AwrDbCpuUsageCollection The AWR CPU usage data.
oci.database_management.models.AwrDbCpuUsageSummary A summary of the AWR CPU resource limits and metrics.
oci.database_management.models.AwrDbMetricCollection The AWR metrics time series summary data.
oci.database_management.models.AwrDbMetricSummary The summary of the AWR metric data for a particular metric at a specific time.
oci.database_management.models.AwrDbParameterChangeCollection The AWR database parameter change history.
oci.database_management.models.AwrDbParameterChangeSummary A summary of the changes made to a single AWR database parameter.
oci.database_management.models.AwrDbParameterCollection The AWR database parameter data.
oci.database_management.models.AwrDbParameterSummary The summary of the AWR change history data for a single database parameter.
oci.database_management.models.AwrDbReport The result of the AWR report.
oci.database_management.models.AwrDbSnapshotCollection The list of AWR snapshots for one database.
oci.database_management.models.AwrDbSnapshotRangeCollection The AWR snapshot range list.
oci.database_management.models.AwrDbSnapshotRangeSummary The summary data for a range of AWR snapshots.
oci.database_management.models.AwrDbSnapshotSummary The AWR snapshot summary of one snapshot.
oci.database_management.models.AwrDbSqlReport The result of the AWR SQL report.
oci.database_management.models.AwrDbSummary The AWR summary for a database.
oci.database_management.models.AwrDbSysstatCollection The AWR SYSSTAT time series summary data.
oci.database_management.models.AwrDbSysstatSummary The summary of the AWR SYSSTAT data.
oci.database_management.models.AwrDbTopWaitEventCollection The AWR top wait event data.
oci.database_management.models.AwrDbTopWaitEventSummary A summary of the AWR top wait event data for one event.
oci.database_management.models.AwrDbWaitEventBucketCollection The percentage distribution of waits in the AWR wait event buckets.
oci.database_management.models.AwrDbWaitEventBucketSummary A summary of the AWR wait event bucket and waits percentage.
oci.database_management.models.AwrDbWaitEventCollection The AWR wait event data.
oci.database_management.models.AwrDbWaitEventSummary The summary of the AWR wait event time series data for one event.
oci.database_management.models.AwrQueryResult The AWR query result.
oci.database_management.models.ChangeDatabaseParameterDetails The value of a database parameter to change.
oci.database_management.models.ChangeDatabaseParametersDetails The details required to change database parameter values.
oci.database_management.models.ChangeDbManagementPrivateEndpointCompartmentDetails The details used to move the Database Management private endpoint to another compartment.
oci.database_management.models.ChangeJobCompartmentDetails The details required to change the compartment of a job.
oci.database_management.models.ChangeManagedDatabaseGroupCompartmentDetails The details required to change the compartment of a Managed Database Group.
oci.database_management.models.ChildDatabase The child Managed Database of a Managed Database Group.
oci.database_management.models.CloneSqlTuningTaskDetails The request to clone and run a SQL tuning task.
oci.database_management.models.ClusterCacheMetric The response containing the cluster cache metrics for the Oracle Real Application Clusters (Oracle RAC) database.
oci.database_management.models.ConsumerGroupPrivilegeCollection A collection of consumer group privileges granted to the current user.
oci.database_management.models.ConsumerGroupPrivilegeSummary A summary of consumer group privileges.
oci.database_management.models.CpuUtilizationAggregateMetrics The CPU utilization metrics for Autonomous Databases.
oci.database_management.models.CreateDbManagementPrivateEndpointDetails The details used to create a new Database Management private endpoint.
oci.database_management.models.CreateJobDetails The details required to create a job.
oci.database_management.models.CreateManagedDatabaseGroupDetails The details required to create a Managed Database Group.
oci.database_management.models.CreateSqlJobDetails The details specific to the SQL job request.
oci.database_management.models.CreateTablespaceDetails The details required to create a tablespace.
oci.database_management.models.DataAccessContainerCollection A collection of specific containers for the current user.
oci.database_management.models.DataAccessContainerSummary A summary of the ContainerDataAccess user.
oci.database_management.models.DatabaseCredentials The database credentials used to perform management activity.
oci.database_management.models.DatabaseFleetHealthMetrics The details of the fleet health metrics.
oci.database_management.models.DatabaseHomeMetricDefinition The response containing the CPU, Storage, Wait, DB Time, and Memory metrics for a specific Managed Database.
oci.database_management.models.DatabaseHomeMetrics The response containing the metric collection for a specific Managed Database.
oci.database_management.models.DatabaseIOAggregateMetrics The database Input/Output metric details.
oci.database_management.models.DatabaseInstanceHomeMetricsDefinition The response containing the CPU, Wait, DB Time, and Memory metrics for a specific Oracle Real Application Clusters (Oracle RAC) database instance.
oci.database_management.models.DatabaseParameterSummary A summary of the database parameter.
oci.database_management.models.DatabaseParameterUpdateStatus The result of database parameter update.
oci.database_management.models.DatabaseParametersCollection A collection of database parameters.
oci.database_management.models.DatabaseStorageAggregateMetrics The database storage metric values.
oci.database_management.models.DatabaseTimeAggregateMetrics The database time metric details.
oci.database_management.models.DatabaseUsageMetrics The list of aggregated metrics for Managed Databases in the fleet.
oci.database_management.models.Datafile The details of a data file.
oci.database_management.models.DbManagementPrivateEndpoint A Database Management private endpoint allows Database Management to connect to databases in a Virtual Cloud Network (VCN).
oci.database_management.models.DbManagementPrivateEndpointCollection A collection of Database Management private endpoint objects.
oci.database_management.models.DbManagementPrivateEndpointSummary The summary of a Database Management private endpoint.
oci.database_management.models.DropSqlTuningTaskDetails The request to drop a SQL tuning task.
oci.database_management.models.DropTablespaceDetails The details required to drop a tablespace.
oci.database_management.models.ExecutionPlanStatsComparision The comparison report of the SQL execution plan statistics in the original and modified plan.
oci.database_management.models.FailedConnectionsAggregateMetrics The failed connection metrics for Autonomous Databases on Shared Exadata Infrastructure.
oci.database_management.models.FindingSchemaOrOperation The findings of the Optimizer Statistics Advisor.
oci.database_management.models.FleetMetricDefinition The database metric details.
oci.database_management.models.FleetMetricSummaryDefinition A summary of the fleet metrics, which provides the metric aggregated value of the databases in the fleet.
oci.database_management.models.FleetStatusByCategory The number of databases in the fleet, grouped by database type and sub type.
oci.database_management.models.FleetSummary A summary of the inventory count grouped by database type and subtype, and the metrics that describe the aggregated usage of CPU, storage, and so on of all the databases in the fleet.
oci.database_management.models.HistoricAddmResult The details of the historic ADDM task.
oci.database_management.models.ImplementOptimizerStatisticsAdvisorRecommendationsDetails The request details object to implement the Optimizer Statistics Advisor task recommendations.
oci.database_management.models.ImplementOptimizerStatisticsAdvisorRecommendationsJob The job request details to implement the Optimizer Statistics Advisor task recommendations.
oci.database_management.models.InstanceDetails The details of the Oracle Real Application Clusters (Oracle RAC) database instance.
oci.database_management.models.Job The details of the job.
oci.database_management.models.JobCollection A collection of job objects.
oci.database_management.models.JobDatabase The Managed Database on which the job is executed.
oci.database_management.models.JobExecution The details of a job execution.
oci.database_management.models.JobExecutionCollection A collection of job execution objects.
oci.database_management.models.JobExecutionResultDetails The job execution result details.
oci.database_management.models.JobExecutionResultLocation The location of the job execution result.
oci.database_management.models.JobExecutionSummary A summary of a job execution on a Managed Database.
oci.database_management.models.JobExecutionsStatusSummary A summary of the status of the job executions.
oci.database_management.models.JobExecutionsStatusSummaryCollection A collection of job execution status summary objects.
oci.database_management.models.JobRun The details of a specific job run.
oci.database_management.models.JobRunCollection A collection of job run objects.
oci.database_management.models.JobRunSummary A summary of a specific job run.
oci.database_management.models.JobScheduleDetails The details of the job schedule.
oci.database_management.models.JobSummary A summary of the job.
oci.database_management.models.ManagedDatabase The details of a Managed Database.
oci.database_management.models.ManagedDatabaseCollection A collection of Managed Database objects.
oci.database_management.models.ManagedDatabaseCredential The credential used to connect to the Managed Database and obtain the details of the optimizer statistics tasks.
oci.database_management.models.ManagedDatabaseGroup The details of a Managed Database Group.
oci.database_management.models.ManagedDatabaseGroupCollection A collection of Managed Database Group resources.
oci.database_management.models.ManagedDatabaseGroupSummary A group of Managed Databases that will be managed together.
oci.database_management.models.ManagedDatabasePasswordCredential User provides a password to be used to connect to the database.
oci.database_management.models.ManagedDatabaseSecretCredential User provides a secret OCID, which will be used to retrieve the password to connect to the database.
oci.database_management.models.ManagedDatabaseSummary A summary of the Managed Database.
oci.database_management.models.MemoryAggregateMetrics The memory aggregate metric details.
oci.database_management.models.MetricDataPoint The metric values with dimension details.
oci.database_management.models.MetricDimensionDefinition The metric dimension details.
oci.database_management.models.MetricStatisticsDefinition The metric statistics values with dimension details.
oci.database_management.models.ObjectPrivilegeCollection A collection of object privileges granted to the current user.
oci.database_management.models.ObjectPrivilegeSummary A summary of object privileges.
oci.database_management.models.ObjectStorageJobExecutionResultDetails The details of the job execution result stored in Object Storage.
oci.database_management.models.ObjectStorageJobExecutionResultLocation The details about Object Storage job execution result location type.
oci.database_management.models.OptimizerDatabase The subset information of the Managed Database resource, which is used by Optimizer Statistics.
oci.database_management.models.OptimizerStatisticsAdvisorExecution The summary of the Optimizer Statistics Advisor execution, which includes information about the Managed Database and a comprehensive execution report.
oci.database_management.models.OptimizerStatisticsAdvisorExecutionReport A report that includes the rules, findings, recommendations, and actions discovered during the execution of the Optimizer Statistics Advisor.
oci.database_management.models.OptimizerStatisticsAdvisorExecutionScript The Oracle system-generated script for the Optimizer Statistics Advisor execution.
oci.database_management.models.OptimizerStatisticsAdvisorExecutionSummary The summary of the Optimizer Statistics Advisor execution.
oci.database_management.models.OptimizerStatisticsAdvisorExecutionsCollection The details of each Optimizer Statistics Advisor execution.
oci.database_management.models.OptimizerStatisticsCollectionAggregationSummary The summary of the Optimizer Statistics Collection, which includes the aggregated number of tasks grouped by status.
oci.database_management.models.OptimizerStatisticsCollectionAggregationsCollection The number of times optimizer statistics are collected each hour, grouped by task status.
oci.database_management.models.OptimizerStatisticsCollectionOperation The summary of the Optimizer Statistics Collection tasks, which includes details of the Managed Database and the execution.
oci.database_management.models.OptimizerStatisticsCollectionOperationSummary The summary of the Optimizer Statistics Collection operation.
oci.database_management.models.OptimizerStatisticsCollectionOperationsCollection The details of each statistics collection operation.
oci.database_management.models.OptimizerStatisticsOperationTask The details of the Optimizer Statistics Collection task.
oci.database_management.models.ParentGroup The parent Managed Database Group of a Managed Database.
oci.database_management.models.PdbMetrics The summary of Pluggable Databases (PDBs) and their resource usage metrics, within a specific Container Database (CDB).
oci.database_management.models.PdbStatusDetails The number and status of PDBs in a Container Database.
oci.database_management.models.ProxiedForUserCollection A collection of users on whose behalf the current user acts as proxy.
oci.database_management.models.ProxiedForUserSummary A summary of users on whose behalf the current user acts as proxy.
oci.database_management.models.ProxyUserCollection A collection of proxy users for the current user.
oci.database_management.models.ProxyUserSummary A summary of the proxy user.
oci.database_management.models.Recommendation The details of the Optimizer Statistics Advisor findings and recommendations.
oci.database_management.models.RecommendationExample An example of the recommendation.
oci.database_management.models.RecommendationExampleLine An example line of the recommendation
oci.database_management.models.RecommendationRationale The details of the rationale for the recommendation.
oci.database_management.models.RemoveDataFileDetails The details required to remove a data file or temp file from the tablespace.
oci.database_management.models.RemoveManagedDatabaseFromManagedDatabaseGroupDetails The Managed Database details required to remove it from a Managed Database Group.
oci.database_management.models.ResetDatabaseParametersDetails The details required to reset database parameter values.
oci.database_management.models.ResizeDataFileDetails The details required to resize a data file or temp file within the tablespace.
oci.database_management.models.RoleCollection A collection of roles granted to the current User.
oci.database_management.models.RoleSummary A summary of each role.
oci.database_management.models.RuleFinding The summary of the Optimizer Statistics Advisor findings and recommendations.
oci.database_management.models.RunHistoricAddmDetails The details of the ADDM task, which include the beginning and ending AWR snapshot IDs.
oci.database_management.models.SchemaDefinition The schema object details.
oci.database_management.models.SnapshotDetails The details of the newly generated AWR snapshot.
oci.database_management.models.SqlJob The details of the SQL job.
oci.database_management.models.SqlTuningAdvisorTaskCollection The SQL Tuning Advisor task list.
oci.database_management.models.SqlTuningAdvisorTaskFindingCollection The list of findings for a SQL Tuning Advisor task.
oci.database_management.models.SqlTuningAdvisorTaskFindingSummary A summary of the findings of the objects in a tuning task that match a given filter.
oci.database_management.models.SqlTuningAdvisorTaskRecommendationCollection The SQL Tuning Advisor recommendations for a given SQL statement.
oci.database_management.models.SqlTuningAdvisorTaskRecommendationSummary A recommendation for a given object in a SQL Tuning Task.
oci.database_management.models.SqlTuningAdvisorTaskSqlExecutionPlan A SQL execution plan.
oci.database_management.models.SqlTuningAdvisorTaskSummary The summary of a SQL Tuning Advisor task.
oci.database_management.models.SqlTuningAdvisorTaskSummaryFindingBenefits The benefits of the findings in the SQL Tuning Advisor summary report.
oci.database_management.models.SqlTuningAdvisorTaskSummaryFindingCounts The number of findings in the SQL Tuning Advisor summary report.
oci.database_management.models.SqlTuningAdvisorTaskSummaryReport The content of the SQL Tuning Advisor summary report.
oci.database_management.models.SqlTuningAdvisorTaskSummaryReportIndexFindingSummary A summary for all the index findings in a SQL Tuning Advisor task.
oci.database_management.models.SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary A summary for all the statistic findings of an object in a SQL Tuning Advisor task.
oci.database_management.models.SqlTuningAdvisorTaskSummaryReportStatementCounts The number of statements in the SQL Tuning Advisor summary report.
oci.database_management.models.SqlTuningAdvisorTaskSummaryReportStatistics The statistics of the statements and findings in the SQL Tuning Advisor summary report.
oci.database_management.models.SqlTuningAdvisorTaskSummaryReportTaskInfo The general information regarding the SQL Tuning Advisor task.
oci.database_management.models.SqlTuningSetCollection The details in the SQL tuning set summary.
oci.database_management.models.SqlTuningSetInput The SQL tuning set for a SQL tuning task.
oci.database_management.models.SqlTuningSetSummary The summary information of a SQL tuning set.
oci.database_management.models.SqlTuningTaskCredentialDetails The credential used to connect to the database.
oci.database_management.models.SqlTuningTaskPasswordCredentialDetails The password provided by the user to connect to the database.
oci.database_management.models.SqlTuningTaskPlanStats The statistics of a SQL execution plan.
oci.database_management.models.SqlTuningTaskReturn The returned object for starting or cloning a SQL tuning advisor task.
oci.database_management.models.SqlTuningTaskSecretCredentialDetails The OCID of the Secret provided by the user to retrieve the password to connect to the database.
oci.database_management.models.SqlTuningTaskSqlDetail The details of the SQL statements on which SQL tuning is performed.
oci.database_management.models.SqlTuningTaskSqlExecutionPlanStep A step in the SQL execution plan.
oci.database_management.models.StartSqlTuningTaskDetails The request to start a SQL tuning task.
oci.database_management.models.StatementsAggregateMetrics The queued and running statement metrics for Autonomous Databases.
oci.database_management.models.SystemPrivilegeCollection A collection of system privileges granted to the current user.
oci.database_management.models.SystemPrivilegeSummary A Summary of system privileges.
oci.database_management.models.TableStatisticSummary The summary of table statistics statuses, which includes status categories such as Stale, Not Stale, and No Stats, the number of table statistics grouped by status category, and the percentage of objects with a particular status.
oci.database_management.models.TableStatisticsCollection A collection of table statistics, which are grouped by status.
oci.database_management.models.Tablespace The details of a tablespace.
oci.database_management.models.TablespaceAdminCredentialDetails The credential to connect to the database to perform tablespace administration tasks.
oci.database_management.models.TablespaceAdminPasswordCredentialDetails User provides a password to be used to connect to the database.
oci.database_management.models.TablespaceAdminSecretCredentialDetails User provides a secret OCID, which will be used to retrieve the password to connect to the database.
oci.database_management.models.TablespaceAdminStatus The status of a tablespace admin action.
oci.database_management.models.TablespaceCollection A collection of tablespaces for a specific Managed Database.
oci.database_management.models.TablespaceStorageSize Storage size.
oci.database_management.models.TablespaceSummary The summary of a tablespace.
oci.database_management.models.TimeSeriesMetricDataPoint The metric values with dimension details.
oci.database_management.models.TimeSeriesMetricDefinition The response object representing time series metric details for a specific Managed Database at a particular time.
oci.database_management.models.UpdateDatabaseParametersResult The results of database parameter update.
oci.database_management.models.UpdateDbManagementPrivateEndpointDetails The details used to update a Database Management private endpoint.
oci.database_management.models.UpdateJobDetails The details required to update a job.
oci.database_management.models.UpdateManagedDatabaseGroupDetails The details required to update a Managed Database Group.
oci.database_management.models.UpdateSqlJobDetails The details specific to the SQL job request.
oci.database_management.models.UpdateTablespaceDetails The details required to update a tablespace.
oci.database_management.models.User The summary of a specific user resource.
oci.database_management.models.UserCollection A collection of users for a specific Managed Database.
oci.database_management.models.UserSummary The summary of a specific User.
oci.database_management.models.WorkRequest A description of the work request status.
oci.database_management.models.WorkRequestCollection Lists all work requests in a specific compartment.
oci.database_management.models.WorkRequestError An error encountered while executing a work request.
oci.database_management.models.WorkRequestErrorCollection The results of a work request error search.
oci.database_management.models.WorkRequestLogEntry A log message from the execution of a work request.
oci.database_management.models.WorkRequestLogEntryCollection The results of a work request log search.
oci.database_management.models.WorkRequestResource The resource that is created or operated on by a work request.
oci.database_management.models.WorkRequestSummary A Summary of the work request.