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));
==================================================================================================
分享到:
相关推荐
只想弄几个积分去下sp4,现在的人贼坑,一个镜像包都卖,有问题问,弄到了sp4,我会在挂的 SLE-12-SP2-Server-DVD-x86_64-GM-DVD1.iso;SLE-12-SP2-Server-DVD-x86_64-GM-DVD1.iso
SLE-15-SP2-Full-x86_64-GM-Media1.iso
SLE-15-SP2-Full-x86_64-GM-Media2.iso
openEuler-20.03-LTS-SP2-x86_64-dvd支持鲲鹏及其它多种处理器,文件分割成 5个 压缩包,必须集齐5个 文件后才能一起解压一起使用: openEuler-20.03-LTS-SP2-x86_64-dvd.part5.rar ... openEuler-20.03-LTS-SP2-x86_...
openEuler-20.03-LTS-SP2-x86_64-dvd支持鲲鹏及其它多种处理器,文件分割成 5个 压缩包,必须集齐5个 文件后才能一起解压一起使用: openEuler-20.03-LTS-SP2-x86_64-dvd.part5.rar ... openEuler-20.03-LTS-SP2-x86_...
openEuler-20.03-LTS-SP2-x86_64-dvd支持鲲鹏及其它多种处理器,文件分割成 5个 压缩包,必须集齐5个 文件后才能一起解压一起使用: openEuler-20.03-LTS-SP2-x86_64-dvd.part5.rar ... openEuler-20.03-LTS-SP2-x86_...
openEuler-20.03-LTS-SP2-x86_64-dvd支持鲲鹏及其它多种处理器,文件分割成 5个 压缩包,必须集齐5个 文件后才能一起解压一起使用: openEuler-20.03-LTS-SP2-x86_64-dvd.part5.rar ... openEuler-20.03-LTS-SP2-x86_...
openEuler-20.03-LTS-SP2-x86_64-dvd支持鲲鹏及其它多种处理器,文件分割成 5个 压缩包,必须集齐5个 文件后才能一起解压一起使用: openEuler-20.03-LTS-SP2-x86_64-dvd.part5.rar ... openEuler-20.03-LTS-SP2-x86_...
SLES-11-DVD-x86_64-GM-DVD1.iso sles11官方iso文件的百度网盘链接。 官网和其它源已很难找到该ISO。
SLE-12-SP4-SAP-DVD-x86_64-GM-DVD1.iso SUSE12 for SAP 百度下载地址:SLE-12-SP4-SAP-DVD-x86_64-GM-DVD1.iso.txt
SLE-12-SP4-Server-DVD-x86_64-GM-DVD1.iso
SLE-11-SP4-SAP-DVD-x86_64-GM-DVD1.iso SUSE 11 SP4 for SAP 百度下载地址:SLE-11-SP4-SAP-DVD-x86_64-GM-DVD1.iso.txt
openEuler-22.03-LTS-SP2-netinst-x86_64-dvd.iso 适用于x86_64平台服务器
SLE-12-SP4-SAP-DVD-x86_64-GM-DVD1.iso SUSE12 for SAP 百度下载地址:SLE-12-SP4-SAP-DVD-x86_64-GM-DVD1.iso.txt
SuSE Linux Enterprise Server 12 SP2-x86_64下载地址,安全可靠。
SLE-15-SP2-FULL-X86_64-GM-Media1
Kylin-Desktop-V10-SP1-General-Release-2203-ARM64.iso.torrent Kylin-Desktop-V10-SP1-General-Release-2203-LoongArch64.iso.torrent ...Kylin-Server-10-SP2-Release-Build09-20210524-arm64.iso.torrent
系统:Kylin-4.0.2-desktop-sp2_lenovo-20180409-arm64 QT:编译版本是QT5.6.3 测试编译QT5.6.3,亲测可用 其他设备、系统、自行测试 ---------------------------------------------------------------------------...