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) A. Row migration is caused by a PCTREE value set too low. B. Row migration can be resolved using the ANALYZE command. C. Row migration can be reduced by choosing a larger block size. D. Row migration means that row pieces are stored in different blocks. E. 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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > Sent: Thursday, September 25, 2003 12:04 AM > > > > List , I am planning to give my 9i performance tuning exam on the first
