Oracle 12c Ocp-1

Source: Internet
Author: User

To implement Automatic Memory Management (AMM), you set the following parameters:

When you try to start the database instance with these parameter settings, you receive the following error message:

SQL > Startup

Ora-00824:cannot set Sga_target or memory_target due to existing internal settings, see Alert Log for more information.


Identify The reason the instance failed to start.

A. The Pga_aggregate_target parameter is set to zero.

B. The Statistics_level parameter is set to BASIC.

C. Both the Sga_target and Memory_target parameters are set.

D. The sga_max_size and Sga_target parameter values is not equal.



Statistics_level Property
Description
parameter type string
syntax statistics_level = {All | Typical | BASIC}
Default value TYPICAL
Modifiable ALTER SESSION,ALTER SYSTEM


statistics_level  specifies The level of collection for database and operating system STATISTICS. The Oracle Database collects these statistics for a variety of purposes, including making self-management decisions.

setting the statistics_level  parameter to basic  disables The collection of many of the important statistics required by Oracle Database features and Fu Nctionality, including:

  • Automatic Workload Repository (AWR) snapshots

  • Automatic Database Diagnostic Monitor (ADDM)

  • All server-generated Alerts

  • Automatic SGA Memory Management

  • Automatic Optimizer Statistics Collection

  • Object Level Statistics

  • end to End Application tracing (v$client_stats )

  • Database Time Distribution statistics ( V$SESS_TIME_MODEL and V$SYS_TIME_MODEL )

  • Service Level Statistics

  • Buffer Cache Advisory

  • MTTR Advisory

  • Shared Pool Sizing Advisory

  • Segment Level Statistics

  • PGA Target Advisory

  • Timed Statistics

  • Monitoring of statistics

When theSTATISTICS_LEVELparameter is modified byALTER SYSTEM, all advisories or statistics is dynamically turned on or off, depending on the new value ofSTATISTICS_LEVEL. When modified byALTER SESSION, the following advisories or statistics is turned on or off in the local session only. Their system-wide state was not changed:

    • timed statistics

    • timed OS Statistics

    • plan Execution Statistics


Oracle 12c Ocp-1

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.