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.
No comments:
Post a Comment