Welcome! Sign in to access your account. New user?

AWR For Oracle

Just trying to determine how prevalent AWR use is, and how useful DBA's have found it to be. AWR includes ASH, Active Session History.

Do you use AWR?

67% (89) Yes
32% (42) No

131 voters have answered this question.

If you do not use AWR, why not?

27% (36) Too Expensive
5% (7) Not Needed
15% (20) Statspack is sufficient
9% (13) Other
59% (78) Not Applicable

131 voters have answered this question.

Has AWR met your expectations?

61% (80) Yes
11% (15) No
27% (36) Not Applicable

131 voters have answered this question.

Do you use Statspack on 10g+ ?

49% (65) Yes
50% (66) No

131 voters have answered this question.

Have you extended Statspack?

16% (22) Yes
83% (109) No

131 voters have answered this question.

Has your troubleshooting time been reduced by using AWR?

53% (70) Yes
17% (23) No
29% (38) Not Applicable

131 voters have answered this question.

Has AWR enabled you to solve performance problems that you were previously unable to solve?

33% (44) Yes
36% (48) No
29% (39) Not Applicable

131 voters have answered this question.

Did you find it difficult to justify the extra licensing expense for AWR?

48% (63) Yes
34% (45) No
17% (23) Not Applicable

131 voters have answered this question.

What method do you use to access and analyze AWR data?

40% (52) OEM
53% (69) SQL Scripts
11% (15) Other
29% (38) Not Applicable

130 voters have answered this question.

Do you use any of the following?

48% (64) Automatic Database Diagnostic Monitor
40% (53) SQL Tuning Advisor
21% (28) Undo Advisor
22% (30) Segment Advisor
41% (55) Not Applicable

131 voters have answered this question.

This poll was created on 2008-08-13 21:45:08 by Polls Are Us
Next Poll
Back to Category