Re: guidance

Tanel , good you drew that smiley .
I am so worried about this exam that for a minute there I was noting down what you wrote.
Thanks for cheering me up though.
Here is a question for you

Which two statements about row migration are true? (Choose two)

1. Row migration is caused by a PCTREE value set too low.
2. Row migration can be resolved using the ANALYZE command.
3. Row migration can be reduced by choosing a larger block size.
4. Row migration means that row pieces are stored in different blocks.
5. Queries that use an index to select migrated rows perform additional I/O.

Answer: A, B

Shouldn't it be a and e ?
What does answer b mean when it says : "row migration can be RESOLVED" Whatever the meaning , analyze .. or analyze.. list chained rows would not be able to differentiate between chained or migrated rows, right ? And upon migration , the index will not be updated and will retain the old rowid right? so then e is correct .

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, September 25, 2003 03:24

> Forget the modern tuning skills and when you're asked what shows the best
> that your database works optimally;
>
> 1) Buffer cache hit ratio is 99%
> 2) Buffer cache hit ratio is 99,999%
> 3) Buffer cache hit ratio is 999999%
> 4) Users aren't complaining
>
> Then answer 3 for sure ;)
>
>
> Tanel.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, September 25, 2003 12:04 AM
>
>
> > List , I am planning to give my 9i performance tuning exam on the first
Received on Thu Sep 25 2003 - 15:09:44 CDT