Truncate table takes time

[darshilm]

Hi friends

I am using Oracle 10g. I have a table with 7 columns. No index on anyone of them. It contains approx 25,000,000 rows. I am using the following command to truncate the table.

TRUNCATE TBALE table name.

It take ages to truncate this table. What could be the reason?

Please help.

Thanks...

[hrishy]

Hi

How many extents does the table have ?

[PAVB]

please show the actual command...

Does your "actual" truncate table command included "drop storage" option?

If that's the case I'm with hrishy; most probably affected table has a zillion extents.

[darshilm]

PAVB, I am not using drop storage option.

Unfortunately, I do not have access to DBA_EXTENTS view. But I could get the following stats from ALL_TABLES

Initial Extent = 65536
Next Extent = NULL
Min Extent = 1
Max Extent = 2147483645
Blocks Used = 314176
Empty Blocks = 8

[malay_biswal]

PAVB, I am not using drop storage option.

Unfortunately, I do not have access to DBA_EXTENTS view. But I could get the following stats from ALL_TABLES

Initial Extent = 65536
Next Extent = NULL
Min Extent = 1
Max Extent = 2147483645
Blocks Used = 314176
Empty Blocks = 8

get the values from all_extents then.