是否可以在没有DBA角色或特权的情况下访问Oracle 11g R2中的数据库性能视图(CPU,RAM,I / O利用率,运行最慢的查询等)?
作为一名数据库开发人员,我希望能够访问DBA拥有的一些信息。
谢谢,斯坦
Is it possible to have access to the database performance views in Oracle 11g R2 (CPU, RAM, I/O utilization, slowest queries ran, etc.) without having DBA role or privileges ?
As a database developer, I would like to have access to some of this information that the DBAs have.
Thanks, Stan
最满意答案
DBA可以授予您对V $性能视图的SELECT权限。 它适用于实例调优,但不如SQL Trace或ADVISOR查询调优权限那么有效。
https://docs.oracle.com/cd/B28359_01/server.111/b28274/instance_tune.htm
ADVISOR特权(功能不如DBA)是完美的 - 你可以运行AWR,ADDM,ASH。
如果您的DBA愿意为您提供访问Oracle Enterprise Manager以及ADVISOR的权限,那么您还可以进行实时SQL监控。
The DBA can grant you SELECT privileges to the V$ performance views. It's good for instance tuning, but not as effective as SQL Trace or ADVISOR privilege for query tuning.
https://docs.oracle.com/cd/B28359_01/server.111/b28274/instance_tune.htm
ADVISOR privilege (less powerful than DBA) would be perfect - with that you can run AWR, ADDM, ASH.
If your DBA is willing to give you access to Oracle Enterprise Manager along with ADVISOR, that would also allow you to do real-time SQL Monitoring.
更多推荐
发布评论