Julian/Tim: Help Needed
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Julian/Tim: Help Needed

  1. #1
    Join Date
    Dec 2001
    Posts
    139
    2 statements about plan stability/stored outlines are true?

    1.You can group outlines in categories.
    2.You can only have one stored outline per SQL statement.
    3.Plan stability only wants when SQL statements match textually.
    4.Stored outlines are saved in data dictionary SYS schema
    5. Stored outlines become invalid when you analyze the associated objects.

    I think 1 & 4

    but suspicious about the location of stored outlines where they are stored in SYS schema or OUTLN schema
    Shaan - Virginia - USA
    rshaan@hotmail.com
    ___________________________
    OCP DBA 9i, 8i - DEV 6i, 2.0, 1.0
    SCSA 8.0

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    I think it is 1 and 3 (although 3. is a bit unclearly stated). Stored outlines are stored in a table called OL$ under the OUTLN user. Concerning 3: the text of an SQL must match almost 100% the text in the outline. Almsot because bind variables are not taken into account.


  3. #3
    Join Date
    Dec 2001
    Posts
    139
    Thanks Julian. U R right.
    Regards

    Where are you based?
    Shaan - Virginia - USA
    rshaan@hotmail.com
    ___________________________
    OCP DBA 9i, 8i - DEV 6i, 2.0, 1.0
    SCSA 8.0

  4. #4
    Join Date
    Dec 2001
    Posts
    139
    ONE MORE QS

    2 best ways can you reduce the amount of sorting performed?

    1.By using UNION instead of UNION ALL
    2.By using NOSORT when creating tables
    3.By using NOSORT when creating indexes
    4.By using COMPUTE instead of ESTIMATE when Analyzing objects
    5.By reducing the number of users that have the sort privilege
    6.By creating indexes on tables that are joined often

    I think 3 & 6

    I'm asking these questions I got a break after completing my DBA track. I'll be teaching DBA track for the first time. Wish me luck. That's why I'm asking qs to clear my ambiguities.

    Thanx for the assistance rendered.
    Regards
    Shaan - Virginia - USA
    rshaan@hotmail.com
    ___________________________
    OCP DBA 9i, 8i - DEV 6i, 2.0, 1.0
    SCSA 8.0

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    That was an easy one. You are right, 3 & 6 are the correct answers. Back to your previous question: I am in Helsinki.

    And of course, I wish you the best of luck during your first DBA class!


  6. #6
    Join Date
    Mar 2000
    Location
    Toronto, Ontario, Canada
    Posts
    214
    Shaan, where you teaching? I mean in which institutes?
    FYI:
    I'm also from Toronto
    Regards,
    Vimal Patel
    OCP DBA 7.3, 8, 8i, 9i
    Sun Solaris 8 Sys. Admin.
    A+

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