Home » Other » General » How to format the AWR & ADDM report? (11g, 11.2.0.3, solaris 10)
How to format the AWR & ADDM report? [message #602641] Fri, 06 December 2013 04:14
ishika_20
Messages: 334
Registered: December 2006
Location: delhi
Senior Member
Dear All,

While running AWR / ADDM report at solaris database through putty, report format for the sql statements are appearing as vertically. For example -

SQL statements consuming significant database time were found. These
statements offer a good opportunity for performance improvement.

   Recommendation 1: SQL Tuning
   Estimated benefit is .11 active sessions, 21.14% of total activity.
   -------------------------------------------------------------------
   Action
      Run SQL Tuning Advisor on the SELECT statement with SQL_ID
      "973ss4gp31avd".
      Related Object
         SQL statement with SQL_ID 973ss4gp31avd.
         s
         e
         l
         e
         c
         t
         T
         X
         T
         _
         C
         U
         S
         T
         O
         M
         E
         R
         _
         N
         A
         M
         E
         f
         r
         o
         m
         G
         E
         N
         M
         S
         T
         _
         C
         U
         S
         T
         O
         M
         E
         R
         w
         h
         e
         r
         e
         t
         o
         _
         c
         h
         a
         r
         (
         T
         X
         T
         _
         C
         U
         S
         T
         O
         M
         E
         R
         _
         C
         D
         )
         =
         :
         "
         S
         Y
         S
         _
         B
         _
         0
         "
   Rationale
      The SQL spent 100% of its database time on CPU, I/O and Cluster waits.
      This part of database time may be improved by the SQL Tuning Advisor.
   Rationale



Please guide me to make it to readable format.

Regards,
Ishika
Previous Topic: Developer License
Next Topic: Why SNMP agent requried in network
Goto Forum:
  


Current Time: Thu Jul 24 18:43:55 CDT 2014

Total time taken to generate the page: 0.12761 seconds