database-management ======================= Description ----------- Use the Database Management CLI 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. Available Commands ------------------ * :doc:`associated-database-summary ` * :doc:`list-associated-databases ` * :doc:`cluster-cache-metric ` * :doc:`get ` * :doc:`diagnosability ` * :doc:`managed-database ` * :doc:`list-alert-logs ` * :doc:`list-attention-logs ` * :doc:`summarize-alert-log-counts ` * :doc:`summarize-attention-log-counts ` * :doc:`external-asm ` * :doc:`get ` * :doc:`get-external-asm-configuration ` * :doc:`list ` * :doc:`list-external-asm-disk-groups ` * :doc:`list-external-asm-users ` * :doc:`summarize-external-asm-metrics ` * :doc:`update ` * :doc:`external-asm-instance ` * :doc:`get ` * :doc:`list ` * :doc:`update ` * :doc:`external-cluster ` * :doc:`get ` * :doc:`list ` * :doc:`summarize-external-cluster-metrics ` * :doc:`update ` * :doc:`external-cluster-instance ` * :doc:`get ` * :doc:`list ` * :doc:`update ` * :doc:`external-database-collection ` * :doc:`list-external-databases ` * :doc:`external-db-home ` * :doc:`get ` * :doc:`list ` * :doc:`update ` * :doc:`external-db-node ` * :doc:`get ` * :doc:`list ` * :doc:`summarize-external-db-node-metrics ` * :doc:`update ` * :doc:`external-db-system ` * :doc:`change-compartment ` * :doc:`create ` * :doc:`delete ` * :doc:`disable-external-db-system-database-management ` * :doc:`disable-external-db-system-stack-monitoring ` * :doc:`enable-external-db-system-database-management ` * :doc:`enable-external-db-system-stack-monitoring ` * :doc:`get ` * :doc:`list ` * :doc:`summarize-external-db-system-availability-metrics ` * :doc:`update ` * :doc:`external-db-system-connector ` * :doc:`check-connection-status ` * :doc:`create-macs-connector ` * :doc:`delete ` * :doc:`get ` * :doc:`list ` * :doc:`update-macs-connector ` * :doc:`external-db-system-discovery ` * :doc:`create ` * :doc:`delete ` * :doc:`get ` * :doc:`list ` * :doc:`patch ` * :doc:`update ` * :doc:`external-exadata-infrastructure ` * :doc:`change-compartment ` * :doc:`create ` * :doc:`delete ` * :doc:`disable-external-exadata-infrastructure-management ` * :doc:`discover ` * :doc:`enable-external-exadata-infrastructure-management ` * :doc:`get ` * :doc:`list ` * :doc:`update ` * :doc:`external-exadata-storage-connector ` * :doc:`check ` * :doc:`create ` * :doc:`delete ` * :doc:`get ` * :doc:`list ` * :doc:`update ` * :doc:`external-exadata-storage-grid ` * :doc:`get ` * :doc:`update ` * :doc:`external-exadata-storage-server ` * :doc:`get ` * :doc:`get-iorm-plan ` * :doc:`get-open-alert-history ` * :doc:`get-top-sql-cpu-activity ` * :doc:`list ` * :doc:`update ` * :doc:`external-listener ` * :doc:`get ` * :doc:`list ` * :doc:`list-external-listener-services ` * :doc:`summarize-external-listener-metrics ` * :doc:`update ` * :doc:`fleet-health-metrics ` * :doc:`get ` * :doc:`job ` * :doc:`change-compartment ` * :doc:`create-sql-job ` * :doc:`delete ` * :doc:`get ` * :doc:`list ` * :doc:`update ` * :doc:`update-result-location ` * :doc:`update-sql-job-details ` * :doc:`job-execution ` * :doc:`get ` * :doc:`list ` * :doc:`job-executions-status ` * :doc:`summarize ` * :doc:`job-run ` * :doc:`get ` * :doc:`list ` * :doc:`managed-database ` * :doc:`cfg-auto-capture-filters ` * :doc:`cfg-auto-capture-filters-with-password ` * :doc:`cfg-auto-capture-filters-with-secret ` * :doc:`cfg-auto-spm-evolve-task ` * :doc:`cfg-auto-spm-evolve-task-with-password ` * :doc:`cfg-auto-spm-evolve-task-with-secret ` * :doc:`change-database-parameters ` * :doc:`change-database-parameters-database-named-credential-details ` * :doc:`change-database-parameters-database-password-credential-details ` * :doc:`change-database-parameters-database-secret-credential-details ` * :doc:`change-plan-retention ` * :doc:`change-plan-retention-database-named-credential-details ` * :doc:`change-plan-retention-database-password-credential-details ` * :doc:`change-plan-retention-database-secret-credential-details ` * :doc:`change-plan-retention-with-password ` * :doc:`change-plan-retention-with-secret ` * :doc:`change-space-budget ` * :doc:`change-space-budget-database-named-credential-details ` * :doc:`change-space-budget-database-password-credential-details ` * :doc:`change-space-budget-database-secret-credential-details ` * :doc:`change-space-budget-with-password ` * :doc:`change-space-budget-with-secret ` * :doc:`change-spb-attr ` * :doc:`change-spb-attr-with-password ` * :doc:`change-spb-attr-with-secret ` * :doc:`change-sql-plan-baselines-attributes-database-named-credential-details ` * :doc:`change-sql-plan-baselines-attributes-database-password-credential-details ` * :doc:`change-sql-plan-baselines-attributes-database-secret-credential-details ` * :doc:`configure-automatic-capture-filters-database-named-credential-details ` * :doc:`configure-automatic-capture-filters-database-password-credential-details ` * :doc:`configure-automatic-capture-filters-database-secret-credential-details ` * :doc:`configure-automatic-spm-evolve-advisor-task-database-named-credential-details ` * :doc:`configure-automatic-spm-evolve-advisor-task-database-password-credential-details ` * :doc:`configure-automatic-spm-evolve-advisor-task-database-secret-credential-details ` * :doc:`disable-auto-plan-capture ` * :doc:`disable-auto-plan-capture-with-password ` * :doc:`disable-auto-plan-capture-with-secret ` * :doc:`disable-auto-spm-evolve-task ` * :doc:`disable-auto-spm-evolve-task-with-password ` * :doc:`disable-auto-spm-evolve-task-with-secret ` * :doc:`disable-automatic-initial-plan-capture-database-named-credential-details ` * :doc:`disable-automatic-initial-plan-capture-database-password-credential-details ` * :doc:`disable-automatic-initial-plan-capture-database-secret-credential-details ` * :doc:`disable-automatic-spm-evolve-advisor-task-database-named-credential-details ` * :doc:`disable-automatic-spm-evolve-advisor-task-database-password-credential-details ` * :doc:`disable-automatic-spm-evolve-advisor-task-database-secret-credential-details ` * :doc:`disable-hf-auto-spm-evolve-task ` * :doc:`disable-hf-auto-spm-evolve-task-with-password ` * :doc:`disable-hf-auto-spm-evolve-task-with-secret ` * :doc:`disable-high-frequency-automatic-spm-evolve-advisor-task-database-named-credential-details ` * :doc:`disable-high-frequency-automatic-spm-evolve-advisor-task-database-password-credential-details ` * :doc:`disable-high-frequency-automatic-spm-evolve-advisor-task-database-secret-credential-details ` * :doc:`disable-spb-usage ` * :doc:`disable-spb-usage-with-password ` * :doc:`disable-spb-usage-with-secret ` * :doc:`disable-sql-plan-baselines-usage-database-named-credential-details ` * :doc:`disable-sql-plan-baselines-usage-database-password-credential-details ` * :doc:`disable-sql-plan-baselines-usage-database-secret-credential-details ` * :doc:`drop-sql-plan-baselines ` * :doc:`drop-sql-plan-baselines-database-named-credential-details ` * :doc:`drop-sql-plan-baselines-database-password-credential-details ` * :doc:`drop-sql-plan-baselines-database-secret-credential-details ` * :doc:`drop-sql-plan-baselines-with-password ` * :doc:`drop-sql-plan-baselines-with-secret ` * :doc:`enable-auto-plan-capture ` * :doc:`enable-auto-plan-capture-with-password ` * :doc:`enable-auto-plan-capture-with-secret ` * :doc:`enable-auto-spm-evolve-task ` * :doc:`enable-auto-spm-evolve-task-with-password ` * :doc:`enable-auto-spm-evolve-task-with-secret ` * :doc:`enable-automatic-initial-plan-capture-database-named-credential-details ` * :doc:`enable-automatic-initial-plan-capture-database-password-credential-details ` * :doc:`enable-automatic-initial-plan-capture-database-secret-credential-details ` * :doc:`enable-automatic-spm-evolve-advisor-task-database-named-credential-details ` * :doc:`enable-automatic-spm-evolve-advisor-task-database-password-credential-details ` * :doc:`enable-automatic-spm-evolve-advisor-task-database-secret-credential-details ` * :doc:`enable-hf-auto-spm-evolve-task ` * :doc:`enable-hf-auto-spm-evolve-task-with-password ` * :doc:`enable-hf-auto-spm-evolve-task-with-secret ` * :doc:`enable-high-frequency-automatic-spm-evolve-advisor-task-database-named-credential-details ` * :doc:`enable-high-frequency-automatic-spm-evolve-advisor-task-database-password-credential-details ` * :doc:`enable-high-frequency-automatic-spm-evolve-advisor-task-database-secret-credential-details ` * :doc:`enable-spb-usage ` * :doc:`enable-spb-usage-with-password ` * :doc:`enable-spb-usage-with-secret ` * :doc:`enable-sql-plan-baselines-usage-database-named-credential-details ` * :doc:`enable-sql-plan-baselines-usage-database-password-credential-details ` * :doc:`enable-sql-plan-baselines-usage-database-secret-credential-details ` * :doc:`get ` * :doc:`get-awr-db-report ` * :doc:`get-awr-db-sql-report ` * :doc:`get-optimizer-statistics-advisor-execution ` * :doc:`get-optimizer-statistics-advisor-execution-script ` * :doc:`get-optimizer-statistics-collection-operation ` * :doc:`get-spb-configuration ` * :doc:`get-sql-plan-baseline ` * :doc:`get-user ` * :doc:`implement-optimizer-statistics-advisor-recommendations ` * :doc:`list ` * :doc:`list-asm-properties ` * :doc:`list-awr-db-snapshots ` * :doc:`list-awr-dbs ` * :doc:`list-consumer-group-privileges ` * :doc:`list-cursor-cache-statements ` * :doc:`list-data-access-containers ` * :doc:`list-database-parameters ` * :doc:`list-object-privileges ` * :doc:`list-optimizer-statistics-advisor-executions ` * :doc:`list-optimizer-statistics-collection-aggregations ` * :doc:`list-optimizer-statistics-collection-operations ` * :doc:`list-proxied-for-users ` * :doc:`list-proxy-users ` * :doc:`list-roles ` * :doc:`list-spb-jobs ` * :doc:`list-sql-plan-baselines ` * :doc:`list-system-privileges ` * :doc:`list-table-statistics ` * :doc:`list-users ` * :doc:`load-spb-from-awr ` * :doc:`load-spb-from-awr-with-password ` * :doc:`load-spb-from-awr-with-secret ` * :doc:`load-spb-from-cc ` * :doc:`load-spb-from-cc-with-password ` * :doc:`load-spb-from-cc-with-secret ` * :doc:`load-sql-plan-baselines-from-awr-database-named-credential-details ` * :doc:`load-sql-plan-baselines-from-awr-database-password-credential-details ` * :doc:`load-sql-plan-baselines-from-awr-database-secret-credential-details ` * :doc:`load-sql-plan-baselines-from-cursor-cache-database-named-credential-details ` * :doc:`load-sql-plan-baselines-from-cursor-cache-database-password-credential-details ` * :doc:`load-sql-plan-baselines-from-cursor-cache-database-secret-credential-details ` * :doc:`reset-database-parameters ` * :doc:`reset-database-parameters-database-named-credential-details ` * :doc:`reset-database-parameters-database-password-credential-details ` * :doc:`reset-database-parameters-database-secret-credential-details ` * :doc:`summarize-awr-db-cpu-usages ` * :doc:`summarize-awr-db-metrics ` * :doc:`summarize-awr-db-parameter-changes ` * :doc:`summarize-awr-db-parameters ` * :doc:`summarize-awr-db-snapshot-ranges ` * :doc:`summarize-awr-db-sysstats ` * :doc:`summarize-awr-db-top-wait-events ` * :doc:`summarize-awr-db-wait-event-buckets ` * :doc:`summarize-awr-db-wait-events ` * :doc:`summarize-managed-database-availability-metrics ` * :doc:`summarize-sql-plan-baselines ` * :doc:`summarize-sql-plan-baselines-by-last-execution ` * :doc:`update ` * :doc:`managed-database-group ` * :doc:`add ` * :doc:`change-compartment ` * :doc:`create ` * :doc:`delete ` * :doc:`get ` * :doc:`list ` * :doc:`remove ` * :doc:`update ` * :doc:`managed-my-sql-databases ` * :doc:`heat-wave-fleet-metrics ` * :doc:`get ` * :doc:`managed-my-sql-database ` * :doc:`get ` * :doc:`list-managed-my-sql-database-configuration-data ` * :doc:`list-managed-my-sql-database-sql-data ` * :doc:`summarize-managed-my-sql-database-availability-metrics ` * :doc:`managed-my-sql-database-collection ` * :doc:`list-managed-my-sql-databases ` * :doc:`my-sql-fleet-metrics ` * :doc:`get ` * :doc:`named-credential ` * :doc:`change-compartment ` * :doc:`create ` * :doc:`create-named-credential-basic-named-credential-content ` * :doc:`delete ` * :doc:`get ` * :doc:`list ` * :doc:`test ` * :doc:`update ` * :doc:`update-named-credential-basic-named-credential-content ` * :doc:`pdb-metrics ` * :doc:`get ` * :doc:`perfhub ` * :doc:`managed-database ` * :doc:`modify-snapshot-settings ` * :doc:`preferred-credential ` * :doc:`delete ` * :doc:`get ` * :doc:`list ` * :doc:`test ` * :doc:`test-basic-preferred-credential-details ` * :doc:`test-preferred-credential-test-named-preferred-credential-details ` * :doc:`update ` * :doc:`update-basic-preferred-credential-details ` * :doc:`update-preferred-credential-update-named-preferred-credential-details ` * :doc:`private-endpoint ` * :doc:`change-compartment ` * :doc:`create ` * :doc:`delete ` * :doc:`get ` * :doc:`list ` * :doc:`update ` * :doc:`sql-tuning-task ` * :doc:`clone ` * :doc:`clone-with-pwd ` * :doc:`clone-with-secret ` * :doc:`drop ` * :doc:`drop-with-pwd ` * :doc:`drop-with-secret ` * :doc:`get-exec-plan-stats-compare ` * :doc:`get-sql-exec-plan ` * :doc:`get-summary-report ` * :doc:`list-findings ` * :doc:`list-recommendations ` * :doc:`list-tasks ` * :doc:`start ` * :doc:`start-with-pwd ` * :doc:`start-with-secret ` * :doc:`summary-metrics ` * :doc:`get ` * :doc:`tablespace ` * :doc:`add ` * :doc:`create ` * :doc:`drop ` * :doc:`drop-tablespace-database-named-credential-details ` * :doc:`drop-tablespace-database-password-credential-details ` * :doc:`drop-tablespace-database-secret-credential-details ` * :doc:`drop-with-pwd ` * :doc:`drop-with-secret ` * :doc:`get ` * :doc:`list ` * :doc:`remove ` * :doc:`remove-data-file-database-named-credential-details ` * :doc:`remove-data-file-database-password-credential-details ` * :doc:`remove-data-file-database-secret-credential-details ` * :doc:`remove-datafile-with-pwd ` * :doc:`remove-datafile-with-secret ` * :doc:`resize-data-file ` * :doc:`update ` * :doc:`work-request ` * :doc:`get ` * :doc:`list ` * :doc:`work-request-error ` * :doc:`list ` * :doc:`work-request-log-entry ` * :doc:`list-work-request-logs ` .. toctree:: :hidden: /cmdref/database-management/associated-database-summary /cmdref/database-management/cluster-cache-metric /cmdref/database-management/diagnosability /cmdref/database-management/external-asm /cmdref/database-management/external-asm-instance /cmdref/database-management/external-cluster /cmdref/database-management/external-cluster-instance /cmdref/database-management/external-database-collection /cmdref/database-management/external-db-home /cmdref/database-management/external-db-node /cmdref/database-management/external-db-system /cmdref/database-management/external-db-system-connector /cmdref/database-management/external-db-system-discovery /cmdref/database-management/external-exadata-infrastructure /cmdref/database-management/external-exadata-storage-connector /cmdref/database-management/external-exadata-storage-grid /cmdref/database-management/external-exadata-storage-server /cmdref/database-management/external-listener /cmdref/database-management/fleet-health-metrics /cmdref/database-management/job /cmdref/database-management/job-execution /cmdref/database-management/job-executions-status /cmdref/database-management/job-run /cmdref/database-management/managed-database /cmdref/database-management/managed-database-group /cmdref/database-management/managed-my-sql-databases /cmdref/database-management/named-credential /cmdref/database-management/pdb-metrics /cmdref/database-management/perfhub /cmdref/database-management/preferred-credential /cmdref/database-management/private-endpoint /cmdref/database-management/sql-tuning-task /cmdref/database-management/summary-metrics /cmdref/database-management/tablespace /cmdref/database-management/work-request /cmdref/database-management/work-request-error /cmdref/database-management/work-request-log-entry