I have already tried that. That does not work amit John Kanagaraj wrote:
Amit,There is a hidden parameter "_awr_restrict_mode" which defaults to to FALSE... Changing it to TRUE may be done at your own risk ! >Is it documented anywhere that AWR snapshot cannot be taken when the>database is in restricted mode ? -- John Kanagaraj <>< DB Soft Inc Phone: 408-970-7002 (W)Disappointment is always inevitable; Discouragement is invariably optional** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **
-- //www.freelists.org/webpage/oracle-l