| truncate too slow [message #64013] |
Mon, 06 December 2004 10:02  |
Martha Delgado
Messages: 1
Registered: December 2004
|
Junior Member |
|
|
Hi,
I have an oracle database 9.2.0.5 in a box with solaris 5.8 64 bits.
When I try to truncate a table , generally it takes a long time (more than two minutes) when it takes seconds to insert 200000 rows.
The wait event is rdbms ipc reply.
There was a bug in 9.2.04 (#3282805.8) but it is supossed to be corrected in 9.2.0.5.
I work with locally managed tablespace, and the table is nomonitoring and nologging.
If I shutdown the database, and startup, then it takes seconds to execute the truncate.
Any help will be appreciated.
Thanks in advance,
Martha Delgado
|
|
|
|
|
|
| Re: truncate too slow [message #64026 is a reply to message #64013] |
Tue, 07 December 2004 04:10  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
truncate depends on Number of Extents and NOT on number of records.
Your situation might be expected if you have a DICTIONARY MANAGED TABLESPACE.
Did you try with reuse storage option?
sql > truncate table Mytable reuse storage;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
