From: "Christian Antognini" Newsgroups: comp.databases.oracle.server References: <91721cf.0408080703.1d50b088@posting.google.com> Subject: Re: Extent Management 101 Date: Sun, 8 Aug 2004 19:54:25 +0200 Lines: 23 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 NNTP-Posting-Host: 62.48.119.87 X-Original-NNTP-Posting-Host: 62.48.119.87 Message-ID: <411668d3@post.usenet.com> X-Trace: post.usenet.com 1091987667 62.48.119.87 (8 Aug 2004 12:54:27 -0500) Organization: Usenet.com http://www.usenet.com 100,000+ UNCENSORED Newsgroups. The #1 Usenet Service on the Planet! X-Comments: This message was posted through Usenet.com's, FREE publicly accessible Usenet Server - "post.usenet.com" X-Comments2: IMPORTANT: Usenet.com does not condone, nor support, spam or any illegal or copyrighted postings. X-Comments3: IMPORTANT: Under NO circumstances will postings containing illegal or copyrighted material through this service be tolerated!! X-Report: Please report illegal or inappropriate use to X-Abuse-Info: Please be sure to forward a copy of ALL headers, INCLUDING the body (DO NOT SEND ATTACHMENTS) Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news-out2.nuthinbutnews.com!local!post.usenet.com!not-for-mail Xref: core-easynews comp.databases.oracle.server:227810 X-Received-Date: Sun, 08 Aug 2004 10:53:42 MST (news.easynews.com) **** Post for FREE via your newsreader at post.usenet.com **** Hi Michael > Though I have read about Extents in various books, as a new Oracle DBA > using 8.17 I still do not grasp how I need to manage them. > > 1. Basically, what are common Extent related issues and what are the > actions as a DBA I need to know to address them? > > 2. Any absolute Do's and Dont's on managing Extents? Mhmm... I'm not sure to understand your questions... in fact it's not possible to directly manage extents, i.e. only by setting segments' storage parameters you can have a control on extents. Anyway, I suggest you to read "How to Stop Defragmenting and Start Living". (just search it on Google...) Chris -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=