Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to get drop awr snap shot id

user11153253Mar 5 2015 — edited Mar 8 2015

Hi folks,

Morning i have taken awr report from one of node of RAC from 08:30 am to 10:30 am using @$ORACLE_HOME/rdbms/admin/awrrpt.sql

it shows me today awr snapshot ids but when i run the same (@$ORACLE_HOME/rdbms/admin/awrrpt.sql ) on second node it showing latest one is 90868 on 06 Feb 2015 08:00 then again i run it on first node, it will show latest one is 91276 on 14 Feb 2015 20:00 .

My Question is how do i get the latest one that 5th March 2015 .

Please assist me to get the right one .

Regards.

Younus

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 5 2015

Added on Mar 5 2015

#general-database-discussions

19 comments

7,104 views