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 **