在使用PL/SQL Developer工具登陆一个新创建的用户进行查询时,报出以下错误(PL/SQL Developer版本:7.1.5 1403):
Dynamic
Performance Tables not accessible,
Automatic
Statistics disabled for this session
You can disable
statistics in the preference menu, or obtain select
priviliges on
the V$session,V$sesstat and V$statname tables
这个报错信息在不同的PL/SQL Developer版本都会出现,从上面详细的报错提示信息中我们可以判断得到,报错原因不在工具本身。
在此,详细记录一下这个小问题的三种处理方法。
1.第一种处理方法(不推荐)
就是在报错的Error对话框中将“Don't show this message again”选项选中,下次就不在提示这个错误了。
这种方法应该可以叫做“鸵鸟方式”的处理方法。没有从根本上解决这个问题。
2.第二种处理方法(可以采纳)
报错信息中描述的非常详细,原因是动态性能表没有权利被访问导致的问题,因此,我们通过把所需访问权限赋予给具体用户的方法来解决这个问题。
这里给出我能想到的三种具体处理方法。大家可以继续补充。
1)如果只是某一具体用户有权限查询这三个动态性能视图,可以如下进行操作
这里注意一下:我们授权的视图是V_$session不是V$session,因为V$session是同名不是具体的视图。否则您会收到下面这个错误。授权方法如下:
SQL> grant
select on V_$session to
user_sec;
SQL> grant
select on V_$sesstat to
user_sec;
SQL> grant
select on V_$statname to user_sec;
2)可以使用下面这个“简单粗暴”的方法处理之。
SQL> grant
SELECT ANY DICTIONARY to user_sec;
3)以上两种方法是针对特定用户的处理方法,如果想让所有用户(不局限在上面的user_sec用户)都能够查询这三个动态性能视图,可以通过将查询权限授权给public方法来实现,操作如下。这样就可以保证所有开发人员都不会再出现上述的报错信息了。
SQL> grant
select on V_$session to
public;
SQL> grant
select on V_$sesstat to
public;
SQL> grant
select on V_$statname to public;
3.第三种方法(推荐)
彻底禁掉PL/SQL Developer的这个功能。
方法如下:
导航到Tools --> Preferences --> Options
找到“Automatic Statistics”选项,将其前面的小对勾去掉,然后点击“Apply”和“OK”保存退出。
http://blog.csdn.net/rudyMatrix/article/details/5339370
分享到:
相关推荐
USER for views, and new conditional compilation directives, Take advantage of extensive code samples, from easy-to-follow examples to reusable packaged utilities, Optimize PL/SQL performance with ...
Oracle SQL Developer, v1.5.0.54.40 Release Notes 完整版下载:http://www.oracle.com/technology/global/cn/software/products/sql/index.html 1. Known Issues 1.1 General - Print prints only one page ...
The Hekaton internals knowledge she provides in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever ...
Sams Teach Yourself SQL in 10 Minutes has established itself as the gold standard for introductory SQL books, offering a fast-paced accessible tutorial to the major themes and techniques involved in ...
Sams Teach Yourself SQL in 10 Minutes has established itself as the gold standard for introductory SQL books, offering a fast-paced accessible tutorial to the major themes and techniques involved in ...
SQL Server 7.0 Performance Tuning Technical Reference, Microsoft Press Windows 2000 Resource Kit companion CD-ROM documentation. Chapter 15: Overview of Performance Monitoring Inside ...
PutlockerAndroid ...The corresponding application is accessible at: https://play.google.com/store/apps/details?id=com.putlocker.upload Set Up Download and set up the android SDK, available at: ...
Sams Teach Yourself SQL in 10 Minutes has established itself as the gold standard for introductory SQL books, offering a fast-paced accessible tutorial to the major themes and techniques involved in ...
Accessible接口读取软件UI元素,可遍历任何软件窗口信息,包括子句柄
Accessible.tlb
In Bluetooth Low Energy, one of the standard's developers has written the first comprehensive, accessible introduction to BLE for every system developer, designer, and engineer. Robin Heydon, a ...
By the end, you’ll understand implicitly what it means to ‘build for performance’- you’ll be a more confident developer, capable of building projects that adapt to a changing world.
易语言基于accessible接口打造获取QQ窗口相关信息。@兔子君。
Vue.js Up & Running Building Accessible and Performant Web Apps pdf 英文高清原版
This is accessible via the Prompt menu : `SQL Prompt > Show List of Code Analysis Issues...`. SP-7033 : Collapsed alignment layout options could cause formatting to fail when dealing with optional ...
Vue.js Up and Running_ Building Accessible and Performant Web Apps (2018, Media)
Sams Teach Yourself SQL in 10 Minutes has established itself as the gold standard for introductory SQL books, offering a fast-paced accessible tutorial to the major themes and techniques involved in ...
MySQL, Sybase, and DB2) using Structured Query Language (SQL). In this chapter, I will introduce all aspects of JDBC, and then you will learn about the more specific ins and outs of JDBC in the ...