Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2008
    Posts
    4

    Question Unanswered: 10g Resource Plan Activation Date

    Hi all,

    How can I find activation and deactivation dates of an existing resource plan?

    I know that there is a new view for this purpose in 11g. But we use 10g, do you know a way to find it?

    regards

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    What is the new view in 11g that is used for that?

  3. #3
    Join Date
    Feb 2008
    Posts
    4
    its name is DBA_HIST_RSRC_PLAN in 11g

  4. #4
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    As it says, it is only a "snapshot" of V$RSRC_PLAN_HISTORY. You will have to take your own snapshot periodically pre- 11g I believe.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •