If A Tablespace Has A Default Pct Increase Of Zero What Will This Cause (in Relationship To The Smon Process)?

If You See Statistics That Deal With “undo” What Are They Really Talking About?

If You See Contention For Library Caches How Can You Fix It?

When Looking At The Estate Events Report You See That You Are Getting Busy Buffer Waits. Is This Bad? How Can You Find What Is Causing It?

Discuss Row Chaining, How Does It Happen? How Can You Reduce It? How Do You Correct It?

Describe Hit Ratio As It Pertains To The Database Buffers. What Is The Difference Between Instantaneous And Cumulative Hit Ratio; Which Should Be Used For Tuning?

Where Can You Get A List Of All Initialization Parameters For Your Instance? How About An Indication If They Are Default Settings Or Have Been Changed?

When Should You Increase Copy Latches? What Parameters Control Copy Latches?

When Looking At V$sysstat You See That Sorts (disk) Is High. Is This Bad Or Good? If Bad, How Do You Correct It?

Explain The Use Of Tkprof? What Initialization Parameter Should Be Turned On To Get Full Tkprof Output?