Ganesh,
We run a third part app, a crappy third party app that has had serious
performance problems. One of their specifications for their app is to
defrag (export and import) whenever there are more than two extents. So
back to my original question, is the amount oftime it took for that
table normal considering the size and long data type?
>>> Ganesh Raja <[Email Address Removed] 09/30/02 12:23AM >>>
You don't need to do that.
2 Extents is Normal. 100 Extents Is Normal ... 500 Extents is Normal.
1000
Extents --- Manageability goes down so start putting partitions.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
============================================
Live to learn... forget... and learn again.
============================================
-----Original Message-----
From: Joe Zitnik [mailto:[Email Address Removed]
Sent: Monday, September 30, 2002 2:06 AM
To: LazyDBA.com Discussion
Subject: Defrag
Gurus,
I just did a defrag of all tables with more than 2 extents belonging to
a
certain schema. One of the tables took 8 hours to do the re-import of
the
table. It has 1.5 million records and one of the data types is long.
Does
this sound feasible?
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
----------------------------------------------------------------------------
-------------------
Any opinions, expressed or implied,presented are solely those of the
author
and do not necessarily represent those of GTFS.
----------------------------------------------------------------------------
-------------------
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page