Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 966 invoked from network); 2 Feb 2006 22:00:01 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 2 Feb 2006 22:00:01 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5458C2922F1; Thu, 2 Feb 2006 23:00:01 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12189-05; Thu, 2 Feb 2006 23:00:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CDC7A2922B5; Thu, 2 Feb 2006 23:00:00 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 02 Feb 2006 22:59:45 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B51DC2922E7 for ; Thu, 2 Feb 2006 22:59:45 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12125-01 for ; Thu, 2 Feb 2006 22:59:45 -0500 (EST) Received: from hotmail.com (bay105-f15.bay105.hotmail.com [65.54.224.25]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7C4A6291346 for ; Thu, 2 Feb 2006 22:59:45 -0500 (EST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 2 Feb 2006 19:59:43 -0800 Message-ID: Received: from 65.54.224.200 by by105fd.bay105.hotmail.msn.com with HTTP; Fri, 03 Feb 2006 03:59:43 GMT X-Originating-IP: [70.187.203.93] X-Originating-Email: [chughhk@hotmail.com] X-Sender: chughhk@hotmail.com From: "hitender chugh" To: oracle-l@freelists.org Subject: LOB columns and migrated rows Date: Thu, 02 Feb 2006 22:59:43 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 03 Feb 2006 03:59:43.0729 (UTC) FILETIME=[43E9DE10:01C62876] X-archive-position: 30741 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: chughhk@hotmail.com Precedence: normal Reply-To: chughhk@hotmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net We have tables with LOB columns which are showing chained/migrated rows. I want to know how to reduce the chaining/migration of rows for such tables? Will putting these tables on tablespace with bigger blocksize say 32k will help reducing migration and increase performance? Using multiple block size tablespace feature on 9i , the max blocksize is 32k. If avg row len is more than 100k even placing LOB column tables on 32k blocksize will not help. What are the performance implications of having tables spread out on different blocksize tablespace? I have not used this feature before so I want to know what is the experience/suggestions of other people on this. Thanks in advance -- http://www.freelists.org/webpage/oracle-l