Results 1 to 2 of 2

Thread: segment advisor

  1. #1
    Join Date
    Apr 2011

    Unanswered: segment advisor

    what is the use of runing following procedure inside dbms_space???
    what this procedure is actually doing???


    i found "Automatic Segment Advisor is implemented by the AUTO_SPACE_ADVISOR_JOB job. This job executes the DBMS_SPACE.AUTO_SPACE_ADVISOR_JOB_PROC procedure at predefined points in time."

    but not getting anything...
    anyone can plss explain me

  2. #2
    Join Date
    Jun 2004
    Provided Answers: 1
    Have you examined the view?:

    Oracle DBA_AUTO_SEGADV_SUMMARY view can be used to display the information specific to Automatic Segment Advisor. Each row of this view summarizes one Automatic Segment Advisor run
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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