Dynamic Performance Tables not accessible,Automatic Statistics...

最新推荐文章于 2020-02-12 12:09:05 发布

igogo007

最新推荐文章于 2020-02-12 12:09:05 发布

阅读量238

点赞数

分类专栏： oracle 文章标签： performance Oracle SQL

oracle 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

使用的PLSQL Developer 工具在对oracle 10g插入数据或查询数据的时候都会报以下错误：


Dynamic Performance Tables not accessible,   
Automatic Statistics Disabled for this session   
You can disable statistics in the preference menu,or obtanin   select priviliges  on the v$session,v$sesstat and v$statname tables

开始以为是用户的权限不够,网上找了下

原来是打开了PLSQL Developer 的自动统计功能。

解决方法如下：

[color=red] 在Tools->Preferences->Options里把Automatic Statistics前的那个勾子去掉，保存就可以了[/color]

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

igogo007

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

Hadoop_3.X.x 注意事项

底层码农

03-31

1万+

hadoop3 hdfs web端口改为9870 <property> <name>dfs.namenode.http-address</name> <value>0.0.0.0:9870</value> <description> The address and the base port where...

Oracle 053 595-667译文

Jesse的黑洞

09-18

5825

QUESTION NO:595 Examine the followingscenario: - Database is running inARCHIVELOG mode. - Complete consistentbackup is taken every Sunday. - On Tuesday theinstance terminates abnormally because th

参与评论您还未登录，请先登录后发表或查看评论

plsql dev中Dynamic Performance Tables not accessible分析解决

热门推荐

heqiyu34的专栏

12-07

1万+

PL/SQL Developer 报错Dynamic Performance Tables not accessible, Automatic Statistics disabled for this...

weixin_34406796的博客

06-20

304

可以从以下几个方面考虑： 1）单独给用户授动态性能视图的权限： SQL> grant select on V_sessiontouser;SQL>grantselectonV_sessiontouser_sec;SQL>grantselectonV_sesstat to user;SQL> grant select on V_$stat...

Dynamic Performance Tables not accessible,Automatic Statistics disabled for this session

z540134865的专栏

02-12

2773

今天用PL/SQL时，出现了一下报错：解决办法：第一种：把V$session，V$sesstat和V$statname这三个视图的SELECT权限授予给出现这个错误的用户；第二种：在PL/SQL中更改设置，Tools ->Preferences -> Oracle -> Options -> Automatic statistics，将此项取消选中；...

Dynamic Performance Tables not accessible Automatic Statistics Disabled for this session

weixin_33736649的博客

05-03

122

Dynamic Performance Tables not accessible, Automatic Statistics Disabled for this session You can disable statistics in the preference menu,or obtanin select priviliges on the v$session,v$sesstat an...

Dynamic Performance Tables not accessible, Automatic Statistics disabled for this session You can disable statistics in the preference menu, or obtain select privileges on the v$session, v$sesstat and v$statname tables

最新发布

05-25

这错误信息通常表示你当前的...在菜单栏中选择 "Tools" -> "Preferences" -> "Database" -> "Advanced"，然后将 "Enable Automatic Statistics Collection" 设置为 "No"。希望这些解决方案可以帮助你解决这个问题。

Oracle数据库表查询或者新建时报错处理

charmerhu的博客

09-09

637

在添加表时，或者右键进行数据查询时出现以下错误： Dynamic Performance Tables not accessible, Automatic Statistics Disabled for this session You can disable statistics in the preference menu,or obtanin select priviliges on th...

个人网页、博客、课程--不断更新

qq_27009517的博客

12-18

2685

Dynamic Performance Tables not accessible 问题解决

好记忆也需烂博客

10-25

1万+

刚新建立的用户，在添加表时，出现以下错误： Dynamic Performance Tables not accessible, Automatic Statistics Disabled for this session You can disable statistics in the preference menu,or obtanin select priviliges on the v$session,

Dynamic Performance Tables not accessible, Automatic Statistics

squall140

05-14

140

Dynamic Performance Tables not accessible, Automatic Statistics Disabled for this session You can disable statistics in the preference menu,or obtanin select priviliges on the v$...

Dynamic Performance Tables not accessible, Automatic Statistics Disabled for this session【ZZ】

weixin_34191734的博客

11-15

143

原文：http://hi.baidu.com/wowodo/blog/item/b7f12834674bab3e5ab5f5d5.html Dynamic Performance Tables not accessible, Automatic Statistics Disabled for this session You can disable ...

Dynamic Performance Tables not accessible 问题

helloaq

07-24

224

摘自：http://hi.baidu.com/wowodo/blog/item/b7f12834674bab3e5ab5f5d5.html Dynamic Performance Tables not accessible, Automatic Statistics Disabled for this session You can disable statistics in the pref...