Oracle 11g 调优方面做的一些改进-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

Oracle 11g 调优方面做的一些改进

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 05:08 PM

Oracle 11g 在调优方面做了一些改进。Oracle 将以下方面的调优自动化了：

Redo Logfile Sizing Advisor —— 此特性推荐重做日志文件的最佳大小，从而避免因频繁出现的检查点而导致过多的磁盘 I/O。

Automatic Checkpoint Tuning —— Oracle 数据库现在可以自调优检查点，从而取得良好的恢复速度，同时降低对正常吞吐量的影响。不再需要设置任何与检查点相关的参数。

Automatic Shared Memory Tuning —— Automatic Shared Memory Tuning 通过自调优算法自动地配置与 System Global Area (SGA) 内存相关的参数（缓冲区缓存、共享池）。它简化了数据库的配置，确保最高效地利用可用内存并提高性能。

Transaction Rollback and Recovery Monitoring —— 此特性让您能够估计回滚一个事务要花多少时间。还可以监视被恢复的事务的进度，，并估计事务恢复的平均速度。

SQL Tuning —— SQL Tuning Advisor 自动地调优高成本的 SQL 语句。

Automatic Storage Manager —— Automatic Storage Manager (ASM) 简化对与 Oracle 相关的文件的管理。

Oracle 还提供一些 Advisor，比如 Segment Advisor 和 Undo Advisor。Segment Advisor 根据对象内的空间碎片化程度，给出是否应该对对象执行新的在线收缩操作的建议。另外，这个 Advisor 还提供关于段的历史增长趋势的报告，特别是能为容量规划提供有效的信息。

另一方面，Undo Advisor 帮助管理员在 flashback 和非 flashback 特性中调整撤消表空间大小时做出正确的判断。它为管理员适当地设置 UNDO_RETENTION 提供建议，以避免快照过于陈旧的问题。

linux

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Reduce the use of MySQL memory in DockerMar 04, 2025 pm 03:52 PM

This article explores optimizing MySQL memory usage in Docker. It discusses monitoring techniques (Docker stats, Performance Schema, external tools) and configuration strategies. These include Docker memory limits, swapping, and cgroups, alongside

How to solve the problem of mysql cannot open shared libraryMar 04, 2025 pm 04:01 PM

This article addresses MySQL's "unable to open shared library" error. The issue stems from MySQL's inability to locate necessary shared libraries (.so/.dll files). Solutions involve verifying library installation via the system's package m

How do you alter a table in MySQL using the ALTER TABLE statement?Mar 19, 2025 pm 03:51 PM

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

Run MySQl in Linux (with/without podman container with phpmyadmin)Mar 04, 2025 pm 03:54 PM

This article compares installing MySQL on Linux directly versus using Podman containers, with/without phpMyAdmin. It details installation steps for each method, emphasizing Podman's advantages in isolation, portability, and reproducibility, but also

What is SQLite? Comprehensive overviewMar 04, 2025 pm 03:55 PM

This article provides a comprehensive overview of SQLite, a self-contained, serverless relational database. It details SQLite's advantages (simplicity, portability, ease of use) and disadvantages (concurrency limitations, scalability challenges). C

How do I configure SSL/TLS encryption for MySQL connections?Mar 18, 2025 pm 12:01 PM

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

Running multiple MySQL versions on MacOS: A step-by-step guideMar 04, 2025 pm 03:49 PM

This guide demonstrates installing and managing multiple MySQL versions on macOS using Homebrew. It emphasizes using Homebrew to isolate installations, preventing conflicts. The article details installation, starting/stopping services, and best pra

What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)?Mar 21, 2025 pm 06:28 PM

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]

See all articles