RE: cdump, bdump, udump

2001-04-24 Thread Venkat_Kalepalli
Title: RE: cdump, bdump, udump Hello folks! I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS on the Oracle server. Next we are running with Rule based optimizer and we want to change to costbased optimizer. I want to know what are the advantages we get on this and

MTSCost based Optimzer

2001-04-24 Thread Venkat_Kalepalli
Title: MTSCost based Optimzer Hello folks! I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS on the Oracle server. Next we are running with Rule based optimizer and we want to change to costbased optimizer. I want to know what are the advantages we get on this and

Defragmentation on tablespace

2001-04-22 Thread Venkat_Kalepalli
Title: Defragmentation on tablespace hi friends, I have tablespace of 15GB out of that 2 GB freespace is available but I have 188MB contiguous space only. Is there any way to defragment the tablespace(more than 500MB contiguous space) except the following. 1. Export/Import 2. tablespace