Database Utilities (MOSC)

MOSC Banner

When run awrsqrpt.sql, it cannot show full output

edited Feb 6, 2015 2:26PM in Database Utilities (MOSC) 4 commentsAnswered

When the SQL becomes really long and complex, the SQL plan becomes long, I cannot see the full output with timing information by running awrsqrpt.sql or select * from table (dbms_workload_repository.awr_sql_report_text (3568266827, 1, 69471, 69473, 'bkrnsndh9sx5a'));

Execution Plan

------------------------------------------------------------------------------------------------------------------------

| Id  | Operation                                       | Name                           | Rows  | Bytes |TempSpc| Cost

------------------------------------------------------------------------------------------------------------------------

|   0 | SELECT STATEMENT                                |                                |       |       |       |   422

|   1 |  REMOTE                                         | KRO_BILL_SCHEDULES             |     1 |   135 |       |     3

|   2 |  SORT ORDER BY                                  |                                |   100 |   278K|   408K|   422

|   3 |   FILTER                                        |                                |       |       |       |

|   4 |    NESTED LOOPS OUTER                           |                                |   100 |   278K|       |   366

|   5 |     VIEW                                        |                                |   100 |   275K|       |   265

|   6 |      NESTED LOOPS OUTER                         |                                |   100 |   276K|       |   265

|   7 |       VIEW                                      |                                |   100 |   273K|       |   265

|   8 |        HASH JOIN RIGHT OUTER                    |                                |   138 |   357K|       |   265

|   9 |         VIEW                                    |                                |    89 | 51086 |       |     2

It should be like

Execution Plan                                                                           

-----------------------------------------------------------------------------------------

| Id  | Operation                        | Name | Rows  | Bytes | Cost (%CPU)| Time     |

-----------------------------------------------------------------------------------------

|   0 | SELECT STATEMENT                 |      |       |       |    61 (100)|          |

|   1 |  SORT AGGREGATE                  |      |     1 |     5 |            |          |

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center