Amazines Free Article Archive
www.amazines.com - Sunday, October 13, 2019
Read about the most recent changes and happenings at Amazines.com
Log into your account or register as a new author. Start submitting your articles right now!
Search our database for articles.
Subscribe to receive articles emailed straight to your email account. You may choose multiple categories.
View our newest articles submitted by our authors.
View our most top rated articles rated by our visitors.
* Please note that this is NOT the ARTICLE manager
Add a new EZINE, or manage your EZINE submission.
Add fresh, free web content to your site such as newest articles, web tools, and quotes with a single piece of code!
Home What's New? Submit/Manage Articles Latest Posts Top Rated Article Search
Google
Subscriptions Manage Ezines
CATEGORIES
 Article Archive
 Advertising (133313)
 Advice (160841)
 Affiliate Programs (34734)
 Art and Culture (73685)
 Automotive (145676)
 Blogs (75042)
 Boating (9840)
 Books (17122)
 Buddhism (4124)
 Business (1328447)
 Business News (426309)
 Business Opportunities (366260)
 Camping (10960)
 Career (72723)
 Christianity (15840)
 Collecting (11637)
 Communication (115054)
 Computers (241951)
 Construction (38995)
 Consumer (49679)
 Cooking (17061)
 Copywriting (6567)
 Crafts (18204)
 Cuisine (7538)
 Current Affairs (20384)
 Dating (45774)
 EBooks (19685)
 E-Commerce (48197)
 Education (185226)
 Electronics (83492)
 Email (6392)
 Entertainment (159829)
 Environment (28934)
 Ezine (3039)
 Ezine Publishing (5446)
 Ezine Sites (1550)
 Family & Parenting (110899)
 Fashion & Cosmetics (196387)
 Female Entrepreneurs (11842)
 Feng Shui (130)
 Finance & Investment (310266)
 Fitness (106046)
 Food & Beverages (62863)
 Free Web Resources (7937)
 Gambling (30224)
 Gardening (25102)
 Government (10512)
 Health (629446)
 Hinduism (2205)
 Hobbies (44033)
 Home Business (91552)
 Home Improvement (251337)
 Home Repair (46124)
 Humor (4819)
 Import - Export (5453)
 Insurance (45130)
 Interior Design (29545)
 International Property (3484)
 Internet (190981)
 Internet Marketing (146326)
 Investment (22824)
 Islam (1167)
 Judaism (1356)
 Law (80475)
 Link Popularity (4591)
 Manufacturing (20842)
 Marketing (98765)
 MLM (14136)
 Motivation (18212)
 Music (27000)
 New to the Internet (9479)
 Non-Profit Organizations (4048)
 Online Shopping (129614)
 Organizing (7803)
 Party Ideas (11855)
 Pets (38081)
 Poetry (2234)
 Press Release (12672)
 Public Speaking (5618)
 Publishing (7523)
 Quotes (2407)
 Real Estate (126613)
 Recreation & Leisure (95262)
 Relationships (87453)
 Research (16158)
 Sales (80317)
 Science & Technology (110203)
 Search Engines (23451)
 Self Improvement (153096)
 Seniors (6231)
 Sexuality (35942)
 Small Business (49283)
 Software (82994)
 Spiritual (23464)
 Sports (116077)
 Tax (7658)
 Telecommuting (34066)
 Travel & Tourism (307297)
 UK Property Investment (3118)
 Video Games (13427)
 Web Traffic (11727)
 Website Design (56812)
 Website Promotion (36563)
 World News (1000+)
 Writing (35764)
Author Spotlight
CACEY TAYLOR

Im just a man who likes to be happy and see others happy. Im into home business, sports, family, and...more
SHWETA SINGH

This article has been written by a verified author, Shweta Singh. She has been in the business of wr...more
RAJESH THAPALIYA

I am in Nepalest tourism industery working since 2000 as a trekking porter to the senior tour leader...more
SHOVON JOARDER

Shovon Joarder has been working as Freelance Marketing Project Manager for over four years. He also ...more
HANVEY HUANG

I'm a Chief Operated Officer from KIMKOO Mattress machinery.The pen is mightier than the sword.so I ...more


Fragmentation in Dictionary Managed Tablespace in Oracle Database by Gitesh Trivedi





Fragmentation in Dictionary Managed Tablespace in Oracle Database by
Article Posted: 02/29/2012
Article Views: 657
Articles Written: 83
Word Count: 519
Article Votes: 38
AddThis Social Bookmark Button

Fragmentation in Dictionary Managed Tablespace in Oracle Database


 
Business,Software,Computers
The fragmentation of tables is fairly common in most databases, and to some extent, it is almost inevitable, unless specific measures are taken to prevent that from the time of the initial database setup and creation of segment. Let's look at the fragmentation of table space to understand the issues raised and some preventive and palliative needed to overcome it.

Table fragmentation can be demonstrated either as a chunk of contiguous space (referred to as fizz or bubble) or as a series of pieces which are adjacent to each other (known as a combination of fizz or honeycomb). Thus, a bubble comprises one or more blocks to be joined, while a honeycomb comprises multiple bubbles. A honeycomb can be joined to form a large bubble key. Bubbles between subsequent extensions assigned to the segments stored in that tablespace. A small bubble, which comprises one or a few blocks, can result in waste of space if it is unable to adapt to the new extensions of the segments within the tablespace. In case of diapers, they comprise a large number of bubbles or even a small number of large bubbles, and then it is likely wasted space is minimal, since the honeycomb will be able to accommodate new allocations measure. However, small panels consisting of two or three blocks bubbles, which are quite common, are more likely to produce space-wasteful, unless the sizes of extension of the segments that need to expand are small enough to fit within them.

Both bubbles and combs are the remnants of far-allocations within tables. When a table is dropped or truncated, the extents, if previously occupied are released. Other reasons for the extension to be released include the use of SQL command to release. Furthermore, in the case of rollback segments or undo segments, extensions can be released when the segment shrinks. If the extensions are released and adjacent each other form a honeycomb. Otherwise, f that are scattered throughout the table space, each remains effective as a bubble. Also, if some of these extensions of-allocated next to the pre-existing bubbles, then that together form a honeycomb, with the larger bubbles. Note that it is in the case of honeycomb, by default, the edge around each bubble remains intact, separating them from each other. However, it is possible to pick them up to bring the edges down and form a big bubble next. Also, if there are other neighbors in the free space chunks, which can be part of this great party. Whenever a new extension should be assigned to a segment and the size of the new extension is less than or equal to the largest available free space bubble, the measure can be assigned to that bubble. If the pieces released to drop the table are not adjacent to each other and there is no neighboring pieces of free space, each point remains an independent spirit and a new extension can use the bubble only if the new extensions specific size of the bubble.

Author is having 15+ years experience and providing Database Support and Online Oracle DBA Courses.

Related Articles - Tablespace fragmentation, dictionary managed tablespace, oracle tablespace, segment management, oracle space management, databases,

Email this Article to a Friend!

Receive Articles like this one direct to your email box!
Subscribe for free today!

 Rate This Article  
Completely useless, should be removed from directory.
Minimal useful information.
Decent and informative.
Great article, very informative and helpful.
A 'Must Read'.

 

Do you Agree or Disagree? Have a Comment? POST IT!

 Reader Opinions 
Submit your comments and they will be posted here.
Make this comment or to the Author only:
Name:
Email:
*Your email will NOT be posted. This is for administrative purposes only.
Comments: *Your Comments WILL be posted to the AUTHOR ONLY if you select PRIVATE and to this PUBLIC PAGE if you select PUBLIC, so write accordingly.
 
Please enter the code in the image:



 Author Login 
LOGIN
Register for Author Account

 

Advertiser Login

 

ADVERTISE HERE NOW!
   Limited Time $60 Offer!
   90  Days-1.5 Million Views  

 

Great Paranormal Romance


STEPHEN BYE

Steve Bye is currently a fiction writer, who published his first novel, ‘Looking Forward Through The...more
GENE MYERS

Author of four books and two screenplays; frequent magazine contributor. I have four other books "in...more
STEVERT MCKENZIE

Stevert Mckenzie, Travel Enthusiast. ...more
LAURA JEEVES

At LeadGenerators, we specialise in content-led Online Marketing Strategies for our clients in the t...more
SUSAN FRIESEN

Susan Friesen, founder of the award-winning web development and digital marketing firm eVision Media...more
TIM FAY

I am not a writer nor am I trying to become a writer. I am an average person with average intelligen...more
JOANNA MORGAN

Joanna Morgan has a huge passion for making money online from home and enjoys traveling around the w...more
JAMES OLEANDER

James Oleander is a professional writer on business and financial topics. He has published many arti...more
JASON NG

Jason Ng has a huge passion for the health and fitness industry as he strongly believes that having ...more
LANCE CHAPMAN

An experienced, resourceful and highly motivated IT professional, with a proven record of success in...more

HomeLinksAbout UsContact UsTerms of UsePrivacy PolicyFAQResources
Copyright © 2019, All rights reserved.
Some pages may contain portions of text relating to certain topics obtained from wikipedia.org under the GNU FDL license