Home » RDBMS Server » Server Administration » TRUNCATE COMMAND
TRUNCATE COMMAND [message #207611] Wed, 06 December 2006 03:52 Go to next message
airother
Messages: 27
Registered: February 2006
Junior Member
hello all,
i am work on 10g
After installing new application in it my server is geeting very slow.
After serching, the alter log is of 20GB and it slow for command truncate, it takes so much time
please resloved it

Thanks in advance

Ajit
Re: TRUNCATE COMMAND [message #207619 is a reply to message #207611] Wed, 06 December 2006 04:53 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
A 20GB alert log? Do you have a TON of log switches taking place on your system? Do you see any errors in your alert log ? You should configure STATSPACK and take snapshots every 10-15 minutes.
Re: TRUNCATE COMMAND [message #207635 is a reply to message #207619] Wed, 06 December 2006 06:14 Go to previous message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
ebrian wrote on Wed, 06 December 2006 11:53
A 20GB alert log? Do you have a TON of log switches taking place on your system? Do you see any errors in your alert log ? You should configure STATSPACK and take snapshots every 10-15 minutes.

Laughing and maybe clean up our alert log
Previous Topic: Segment Space Management - Tablespace
Next Topic: Database Reorganisation with "alter table move"
Goto Forum:
  


Current Time: Sat Dec 10 13:13:21 CST 2016

Total time taken to generate the page: 0.07860 seconds