AUM Common Analysis/Diagnostic Scripts (문서 ID 877613.1) -> 한글버전 :  AUM에서 사용되는 분석/진단 스크립트 (문서 ID 1532541.1)

스크립트도 있네요. ( 첨부파일 )

Script - Check Current Undo Configuration and Advise Recommended Setup (문서 ID 1579035.1)

스크립트도 있네요.(첨부 파일)

How To Rollback Alter System Set "_smu_debug_mode" = 33554432; Without restarting the database? (문서 ID 805698.1)

-------

In this Document

Goal

Solution

References

APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later

Oracle Database Exadata Cloud Machine - Version N/A and later

Oracle Cloud Infrastructure - Database Service - Version N/A and later

Oracle Database Cloud Exadata Service - Version N/A and later

Oracle Database Cloud Schema Service - Version N/A and later

Information in this document applies to any platform.

***Checked for relevance on 21-Jul-2017***

GOAL

Would like to know how to rollback/disable the _smu_debug_mode parameter: 

    SQL> alter system set "_smu_debug_mode" = 33554432;

dynamically without having to restart the database database.

What is the default value for "smu_debug_mode" ?

SOLUTION

Use the following command to set to unset the parameter:

    SQL>alter system set "_smu_debug_mode" = 0;

The default value of _smu_debug_mode is 0.

The V$UNDOSTAT view has still got updated in every 10 minutes from 12c (문서 ID 2314796.1)

--------

In this Document

Purpose

Questions and Answers

References

APPLIES TO:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]

Oracle Database Cloud Schema Service - Version N/A and later

Oracle Database Exadata Cloud Machine - Version N/A and later

Oracle Cloud Infrastructure - Database Service - Version N/A and later

Oracle Database Cloud Exadata Service - Version N/A and later

Information in this document applies to any platform.

PURPOSE

 This article is intended to instruct the new action in 12c about V$UNDOSTAT view's updating.

QUESTIONS AND ANSWERS

Version from 10.2.0.1 to 11.2.0.4, when the parameter "_undo_autotune" has been set to FALSE, automatic undo tuning has been disabled, 

and the V$UNDOSTAT view is not getting updated every 10 minutes.

But from 12c, though the parameter "_undo_autotune" has been set to FALSE, the V$UNDOSTAT view can still get updated, 

of course the action that automatic undo tuning has been disabled remain the same with before.

The V$UNDOSTAT view is not getting updated in every 10 minutes. (문서 ID 1206365.1)

--------

In this Document

Symptoms

Cause

Solution

References

APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]

Oracle Database Cloud Schema Service - Version N/A and later

Oracle Database Exadata Cloud Machine - Version N/A and later

Oracle Cloud Infrastructure - Database Service - Version N/A and later

Oracle Database Backup Service - Version N/A and later

Information in this document applies to any platform.

SYMPTOMS

The V$UNDOSTAT view is not getting updated every 10 minutes.

SQL> select BEGIN_TIME,END_TIME, UNDOBLKS from v$undostat;

BEGIN_TIME END_TIME UNDOBLKS

-------------------- -------------------- ----------

21-aug-2010 03:48:44 07-sep-2010 11:02:14 75016989

Only a single record is seen as above.

CAUSE

The parameter "_undo_autotune" has been set to FALSE.

This has disabled automatic undo tuning.

SOLUTION

Set "_undo_autotune" parameter to TRUE:

SQL> alter system set "_undo_autotune"=true;

This disables the standard tracking of UNDO statistics in V$UNDOSTAT.  You can see only the one row of data as noted in this case.

REFERENCES

NOTE:420525.1 - Automatic Tuning of Undo_retention Causes Space Problems

NOTE:877613.1 - AUM Common Analysis/Diagnostic Scripts

NOTE:2314796.1 - The V$UNDOSTAT view has still got updated in every 10 minutes from 12c