Home » RDBMS Server » Server Administration » fragmentation
fragmentation [message #249620] Thu, 05 July 2007 04:02 Go to next message
jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI
Member
What is fragmentation and How Can i implement in programe pls
help me.

Jai
Re: fragmentation [message #249631 is a reply to message #249620] Thu, 05 July 2007 06:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://en.wikipedia.org/wiki/Fragmentation
PL/SQL User's Guide and Reference

Regards
Michel
Re: fragmentation [message #249666 is a reply to message #249620] Thu, 05 July 2007 08:24 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
You want to implement fragmentation? That's a new one. Get a copy of Oracle 6 or 7 from 15 years ago and it will just happen.
Re: fragmentation [message #249754 is a reply to message #249620] Thu, 05 July 2007 15:00 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
jainarayan5484 wrote on Thu, 05 July 2007 03:02
What is fragmentation and How Can i implement in programe pls
help me.

Jai




create a table with indexes insert 100 millions rows and delete 5 million rows...fragmentation will produce..
Re: fragmentation [message #249761 is a reply to message #249754] Thu, 05 July 2007 15:24 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
DreamzZ wrote on Thu, 05 July 2007 16:00
jainarayan5484 wrote on Thu, 05 July 2007 03:02
What is fragmentation and How Can i implement in programe pls
help me.

Jai




create a table with indexes insert 100 millions rows and delete 5 million rows...fragmentation will produce..


Not in a database with locally managed tablespaces.
Re: fragmentation [message #249765 is a reply to message #249761] Thu, 05 July 2007 15:56 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
joy_division wrote on Thu, 05 July 2007 14:24
DreamzZ wrote on Thu, 05 July 2007 16:00
jainarayan5484 wrote on Thu, 05 July 2007 03:02
What is fragmentation and How Can i implement in programe pls
help me.

Jai




create a table with indexes insert 100 millions rows and delete 5 million rows...fragmentation will produce..


Not in a database with locally managed tablespaces.



BY deletetion fragmentation will not produce in index and table??
Re: fragmentation [message #249900 is a reply to message #249765] Fri, 06 July 2007 08:19 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
I do not understand the response.
Re: fragmentation [message #249941 is a reply to message #249900] Fri, 06 July 2007 10:12 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
its okay.

by deletion fragmentation will produce in table and indexes
that what my mean was.

[Updated on: Fri, 06 July 2007 10:13]

Report message to a moderator

Re: fragmentation [message #249995 is a reply to message #249941] Fri, 06 July 2007 13:11 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Oh, fragmentation in a table as opposed to a tablespace. I get what you are saying. Unfortunately, OP made an ill attempt at explaining what they meant by fragmentation, so it's left to the responders to assume. I made mine...
And for some reason I was thinking you were talking about created tables and indexes and then dropping them. Don't know how I misread that. Maybe because I once again assumed seeing the keyword fragmentation which I associated with DMT.

[Updated on: Fri, 06 July 2007 13:14]

Report message to a moderator

Re: fragmentation [message #249998 is a reply to message #249995] Fri, 06 July 2007 13:29 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And of course there is ALWAYS table fragmentation if you use ASSM with or without delete.
And most of the time deletes on index do not generate index fragmentation (unless you call space in free list fragmentation).

Regards
Michel
Previous Topic: ARCHIVAL Growth = 9Gb a day..
Next Topic: Replication 10g release problem [Multi-Master Replication, Advance Replication]
Goto Forum:
  


Current Time: Sat Dec 03 16:07:22 CST 2016

Total time taken to generate the page: 0.04023 seconds