Shulou(Shulou.com)06/01 Report--

After Oracle has been running for a period of time, the system automatically gives some tuning suggestions, which are placed in the dba_advisor_actions view. The main fields of the view are as follows:

Task_name-name of the optimization task

Execution_name-execution name

Object_id-object ID

Command-commands used

Attr1-specific commands: for example, alter table xxx shrink space

Attr2-specific commands: for example, alter table xxx shrink space compact

Attr3-specific commands: for example, alter table xxx enable row movement

Attr4

Attr5-Index recommendation. When attr4 = BTREE, attr5 gives the name of the column to be indexed, and attr3 is the table name

Attr6

Message-A description of optimization in Chinese

-- View system automatic optimization recommendations (from the day before the report), 'SYS_AUTO_SQL_TUNING_TASK' is system customized

Select dbms_sqltune.report_tuning_task ('SYS_AUTO_SQL_TUNING_TASK') from dual

-- View a range of reports, with begin_exec and end_exec taken from the value of the execution_name field

Select dbms_sqltune.report_auto_tuning_task (begin_exec = > 'EXEC_5815',end_exec = >' EXEC_6166') from dual

-- View the tuning report of execution_name

Select dbms_sqltune.report_tuning_task (task_name = > 'SYS_AUTO_SQL_TUNING_TASK', execution_name = >' EXEC_6166') from dual

-- View the tuning report of an object and take the value of object_id

Select dbms_sqltune.report_auto_tuning_task (object_id = > '33075') from dual

Through the above tuning recommendations, you can refer to the implementation of the optimization (the above can be implemented under an account with DBA permission).

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.