Home » RDBMS Server » Server Administration » Fragmentation
Fragmentation [message #56765] Wed, 23 April 2003 02:12 Go to next message
Praveen Kumar
Messages: 21
Registered: December 2001
Junior Member
How u manually defragment a fragmented tablespace if u set the pctincrease as 0(so smon will not automatically coalase free space)

Report message to a moderator

Re: Fragmentation [message #56767 is a reply to message #56765] Wed, 23 April 2003 04:25 Go to previous message
StS
Messages: 3
Registered: September 2002
Junior Member
alter tablespace ... coalesce

Report message to a moderator

Previous Topic: v$transaction: The noundo column
Next Topic: ORA-00600: [17074], [0x1218143C], [0x1124B1E4], [6], [], [], [], []
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:43:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.