RE: Urgent Reply requested. Truncate command
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'smishra_97@xxxxxxxxx'" <smishra_97@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 18 Feb 2005 08:36:27 -0500
A few details such as the tablespace management mode in use and the number
of extents that the table and its indexes are in would be helpful. More
that likely if dictionary management is in use Oracle is having to perform a
ton of work cleaning up the sys.fet$ and uet$ base tables where free space
and extent management information is kept.
There is an article on this topic at the cooperative FAQ hosted at
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Sanjay Mishra
Sent: Thursday, February 17, 2005 9:13 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: *****SPAM***** Urgent Reply requested. Truncate command
Dear friend
I am running a truncate on 15G table with 10G indexes
and it is running from last 3 hours.
Am I missed anything. Is there any way I can check if
it running
TIA
Sanjay
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
