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
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
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