SP2-0613: 无法验证 PLAN_TABLE 格式或实体

最新推荐文章于 2024-11-01 12:20:35 发布

yanguz

最新推荐文章于 2024-11-01 12:20:35 发布

阅读量91

点赞数

分类专栏： Database 文章标签：数据库

本文链接：https://blog.csdn.net/yanguz/article/details/84224659

版权

Database 专栏收录该内容

27 篇文章 0 订阅

订阅专栏

SQL> conn sys/sys as sysdba
已连接。

SQL> @ %oracle_home%/rdbms/admin/utlxplan.sql

表已创建。
---这个脚本只是创建一张plan_table表

SQL> create role plustrace;

角色已创建

SQL> grant select on v_$sesstat to plustrace;

授权成功。

SQL> grant select on v_$statname to plustrace;

授权成功。

SQL> grant select on v_$session to plustrace;

授权成功。

SQL> grant plustrace to dba with admin option;

授权成功。

SQL> set autotrace on;

SQL> grant all on plan_table to public;

授权成功。

SQL> grant plustrace to scott;

授权成功。

utlxplan.sql内容：
==========================================================================================
rem
rem $Header: utlxplan.sql 29-oct-2001.20:28:58 mzait Exp $ xplainpl.sql
rem
Rem Copyright (c) 1988, 2001, Oracle Corporation. All rights reserved.
Rem NAME
REM    UTLXPLAN.SQL
Rem FUNCTION
Rem NOTES
Rem MODIFIED
Rem     mzait      10/26/01 - add keys and filter predicates to the plan table
Rem     ddas       05/05/00 - increase length of options column
Rem     ddas       04/17/00 - add CPU, I/O cost, temp_space columns
Rem     mzait      02/19/98 - add distribution method column
Rem     ddas       05/17/96 - change search_columns to number
Rem     achaudhr   07/23/95 - PTI: Add columns partition_{start, stop, id}
Rem     glumpkin   08/25/94 - new optimizer fields
Rem     jcohen     11/05/93 - merge changes from branch 1.1.710.1 - 9/24
Rem     jcohen     09/24/93 - #163783 add optimizer column
Rem     glumpkin   10/25/92 - Renamed from XPLAINPL.SQL
Rem     jcohen     05/22/92 - #79645 - set node width to 128 (M_XDBI in gendef)
Rem     rlim       04/29/91 -         change char to varchar2
Rem   Peeler     10/19/88 - Creation
Rem
Rem This is the format for the table that is used by the EXPLAIN PLAN
Rem statement. The explain statement requires the presence of this
Rem table in order to store the descriptions of the row sources.

create table PLAN_TABLE (
statement_id varchar2(30),
timestamp    date,
remarks      varchar2(80),
operation    varchar2(30),
options       varchar2(255),
object_node varchar2(128),
object_owner varchar2(30),
object_name varchar2(30),
object_instance numeric,
object_type     varchar2(30),
optimizer       varchar2(255),
search_columns number,
id  numeric,
parent_id numeric,
position numeric,
cost  numeric,
cardinality numeric,
bytes  numeric,
other_tag       varchar2(255),
partition_start varchar2(255),
        partition_stop varchar2(255),
        partition_id    numeric,
other  long,
distribution    varchar2(30),
cpu_cost numeric,
io_cost  numeric,
temp_space numeric,
        access_predicates varchar2(4000),
        filter_predicates varchar2(4000));