Home » RDBMS Server » Server Administration » Truncate slow
Truncate slow [message #232731] Mon, 23 April 2007 02:24 Go to next message
girishta
Messages: 30
Registered: December 2006
Member
Hi,
When i give the TRUNCATE statement, Its taking very much time to complete. My database is Oracle 9.2.0.6 on HP-UX.
SGA size --- 10G
DB-CACHE --- 4.5G
SHARED POOL -- 3.5G

How to make it to perform better?

Re: Truncate slow [message #232739 is a reply to message #232731] Mon, 23 April 2007 02:43 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

THIS
THIS(search for truncate)
might be some help to you

[Updated on: Mon, 23 April 2007 02:49]

Report message to a moderator

Previous Topic: DBID
Next Topic: Communicaton between oracle7 and oracle 9!?
Goto Forum:
  


Current Time: Fri Dec 02 16:45:14 CST 2016

Total time taken to generate the page: 0.15331 seconds