How do you troubleshooting and tune oracle without oracle diagnosics pack and tuning pack?
Asked
Active
Viewed 561 times
-2
-
See "statspack survival guide – ibre5041 Apr 03 '15 at 10:24
1 Answers
0
- See "statspack survival guide"
- plus you can still generate AWR reports (uder some circumstances). Use google
- you can also watch v$ views using own sql scripts.
ibre5041
- 4,903
- 1
- 20
- 35
-
thanks for your response. We need to investigate the DB activities in the past (3/16/2015) and (3/23/2015), we cannot do statspack snapshot for the past. I tried awr report, it generates empty report because the customer's DB has no diag pack license. V$ view is only works for current, not work for the past (a week or 2 weeks) ago. DBA_HIST_xxxx views are not available for non Diag pack /Tune pack licensed DB. – betty Apr 03 '15 at 13:59