Skip to Main Content

SQL Developer

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!

v4 Last AWR Report

Amin AdatiaJul 24 2013

Running as SYS

The job runs for a while and then when I cancel because it has been running for more than 3 minutes, an error message pops up

An error was encountered performing the requested operation:

ORA-20019: Database/Instance 1924331302/1 was re-started during specified snapshot interval 3395-3396

ORA-06512: at "SYS.DBMS_SWRF_REPORT_INTERNAL", line 9875

ORA-06512: at "SYS.DBMS_SWRF_REPORT_INTERNAL", line 1226

ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 889

ORA-06512: at line 1

ORA-06512: at line 13

Vendor code 20019

Don't I want to know what happened to cause the re-start? Something does not make sense; why cannot the job just skip the bad stuff? I realize this may have nothing to do with SQL Developer!

Also can we get a message when the user trying to run the ARW/ASH reports does not have the required privileges instead of just some message like

An error was encountered performing the requested operation:

ORA-06550: line 8, column 62:

PL/SQL: ORA-00942: table or view does not exist

ORA-06550: line 8, column 1:

PL/SQL: SQL Statement ignored

ORA-06550: line 10, column 46:

PL/SQL: ORA-00942: table or view does not exist

ORA-06550: line 10, column 1:

PL/SQL: SQL Statement ignored

ORA-06550: line 14, column 10:

PL/SQL: ORA-00904: : invalid identifier

ORA-06550: line 13, column 13:

PL/SQL: SQL Statement ignored

ORA-06550: line 17, column 25:

PLS-00364: loop index variable 'RC' use is invalid

ORA-06550: line 17, column 4:

PL/SQL: Statement ignored

06550. 00000 -  "line %s, column %s:\n%s"

*Cause:    Usually a PL/SQL compilation error.

*Action:

Vendor code 6550

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 21 2013
Added on Jul 24 2013
0 comments
396 views