Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

create statspack report using sql*developer

John-MKSep 30 2013 — edited Oct 2 2013

Hello,

While connecting with PERFSTAT user I can not create statspack report using SQL*Developer:

@?/rdbms/admin/awrrpt

Error starting at line 1 in command:

@?/rdbms/admin/awrrpt

Error report:

Unable to open file: "?/rdbms/admin/awrrpt.sql"

Actually, my problem or question is that how can PERFSTAT user can generate statspack reports from a Client side. What is the other way a non-dba can see the snapshots histroy and generate report (by using perfstat user ) while joing tables or using views?

Thanks a lot.

Best Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 30 2013

Added on Sep 30 2013

#general-database-discussions

12 comments

3,202 views