授权某用户，查看动态性能视图的权限（如 v$latch,v$lock,v$sqlarea,v$sql,v$sysstat ）

解决方法： grant select any dictionary to doudou;

doudou@TEST> desc sys.v$latch

ERROR:

ORA-04043: object sys.v$latch does not exist

doudou@TEST> desc v$sqlarea

ERROR:

ORA-04043: object "SYS"."V_$SQLAREA" does not exist

doudou@TEST> desc v$sql

ERROR:

ORA-04043: object "SYS"."V_$SQL" does not exist

doudou@TEST> desc v$sysstat

ERROR:

ORA-04043: object "SYS"."V_$SYSSTAT" does not exist

doudou@TEST> desc v$lock

ERROR:

ORA-04043: object "SYS"."V_$LOCK" does not exist

doudou@TEST> desc v$sqltext

ERROR:

ORA-04043: object "SYS"."V_$SQLTEXT" does not exist

doudou@TEST> desc v$process

ERROR:

ORA-04043: object "SYS"."V_$PROCESS" does not exist

sys@TEST> grant select any dictionary to doudou;

Grant succeeded.

doudou@TEST>desc v$latch [ OK 问题解决 ]

ITPub博客

Oracle 查看动态性能视图的权限（如v$latch,v$lock,v$sqlarea,v$sql,v$sysstat）