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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

Previous Topic: Segment Space Management - Tablespace
Next Topic: Database Reorganisation with "alter table move"
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 06:55:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.