|
|
|
|
| Re: fragmentation [message #249666 is a reply to message #249620] |
Thu, 05 July 2007 08:24   |
joy_division
Messages: 4963
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 |
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 |
joy_division
Messages: 4963
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 |
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 #249995 is a reply to message #249941] |
Fri, 06 July 2007 13:11 |
joy_division
Messages: 4963
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 |
 |
Michel Cadot
Messages: 68686
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
