Julian/Tim: Help Needed

[shaan]

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

[julian]

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.

[shaan]

Thanks Julian. U R right.
Regards

Where are you based?

[shaan]

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

[julian]

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!

[vimalp]

Shaan, where you teaching? I mean in which institutes?
FYI:
I'm also from Toronto