Is it possible to view database performance information without DBA privilege in Oracle 11g?

 

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.