Home » RDBMS Server » Server Administration » Problem about extents
icon5.gif  Problem about extents [message #213690] Thu, 11 January 2007 22:04 Go to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Dear all,

I used database health check from toad and got message as following:

[Segments with > 100 extents] Exec Time 0 seconds
! TABLE user01.ttable: 250 Extents

After then i create new tablespace and export this table,drop table and import to new tablespace.then i ran health check again and got message:

[Segments with > 100 extents] Exec Time 0 seconds
! TABLE user01.ttable: 410 Extents

oracle version 9.2.0.7
tablespace extent management : local
segment space management : auto

What happend? How i will fix this problem?

Thanks for advance
Chara
Re: Problem about extents [message #213699 is a reply to message #213690] Thu, 11 January 2007 23:32 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
>How i will fix this problem?
Problem? What problem?
Why is Segments with > 100 extents a problem?
Ready, Fire, Aim!
Re: Problem about extents [message #213829 is a reply to message #213690] Fri, 12 January 2007 08:06 Go to previous message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
What kind of inferior product is TOAD that it claims 100 extents is bad? Is this version 1.0 from 1980?
This was the whole purpose of locally managed tablespaces, so people wouldn't have to waste their time caring about extents.
I don't use TOAD, but I see many people do so I assumed it was a pretty good product, but now I'd view with skepticism any other message from it's so called health check.
Previous Topic: IDLE_TIME
Next Topic: Archive/nonarchive mode
Goto Forum:
  


Current Time: Wed Dec 07 07:00:11 CST 2016

Total time taken to generate the page: 0.06492 seconds