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