Re: rollback segment reached maximum extent

For your rollback segments -> Use the "optimal" option.

For your export. If you tell exp to do so, it will compress all the data of a table into
one big initial extent when you import the data. So yes, an exp/imp can help you.

Gert

kgsudhi_at_my-dejanews.com wrote in article <7hm3u4$f32$1_at_nnrp1.deja.com>...
> Hello
> I am using Oracle 7.3.3.5 on OpenVMS7.1 (Alpha Server . RAID-5).
> When I was monitoring the disk space utilization, extent information
> etc for tablespaces and rollback segments, I found that one of the four
> rollback segment reached the maximum (121) extents. I would like to
> know what is the effect of this in my system and how can I re-organize
> it. Will it affect the execution time of sqls? Many of other tables are
> also reached more than 50 extents. Will an export and import will do
> the job for me ?
>
> Please help me to solve this issue.
>
> Thanks in Advance
>
> Sudhi
>
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
>
Received on Sun May 16 1999 - 14:38:13 CDT