Outlines not used
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Outlines not used

Hybrid View

  1. #1
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448

    Outlines not used

    Oracle 8.1.7.3.50 EE, MVS, OS3/90 Z/OS

    Hi
    In Production after rebuild of partitioned indexes we have some bad execution-plans. Now i want to take the good working Executuin-plans from another instance.

    Steps

    Instance 'good' :
    * give application-user create any outline -Sys-priv
    * create the outlines from the SQL in V$sql of the 'bad' instance

    export the outln-tables

    Instance 'bad'
    * give application-user create any outline -Sys-privs
    * alter the system : use_stored_outlines = TRUE
    * import the outln-tables from good db
    * flush the shared_pool


    But on 'bad' instance :
    select * from user_outlines show still 'UNUSED'
    in v$sql the columns OUTLINE_CATEGORY is still NULL

    What i have do wrong?
    both instances are the same Version
    the *enabled-init.ora is the same

    Orca

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Hope you have set the parameter 'CREATE_STORED_OUTLINES' to true or the name of category in the 'bad' instance.

    Also, your SQL must match text for text in the 2 instances in order to use stored outlines.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi
    * 'CREATE_STORED_OUTLINES' has nothing to do if your outline is used?
    it's used for automatic creation of outlines but not for using them
    * The SQL fits perfectly,i pasted the whole V$sga.sql_text in an excel-sheet and found exact the sql_text in the stored-outline -view

    So i tried it with a 9iR2 -Instance on winNT
    and ... it WORKED!

    This must be an os-specific problem

    Thanks for reply!!!
    Orca

    Last edited by Orca777; 12-10-2002 at 05:36 PM.

Posting Permissions

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


Click Here to Expand Forum to Full Width