Re: What is Your Idea for optimizing Table Performance?
From: Surachart Opun <surachart_at_gmail.com>
Date: Fri, 18 Mar 2011 21:00:40 +0700
Message-ID: <AANLkTinnpNRU6dFhTmr7YAMMAohmxz1BfuqB=TBe75Ye_at_mail.gmail.com>
What is your idea?
Create Tablespace by using ASSM
Using IOT
Check ROW Chaining
Reclaim space/readjust HWM
Date: Fri, 18 Mar 2011 21:00:40 +0700
Message-ID: <AANLkTinnpNRU6dFhTmr7YAMMAohmxz1BfuqB=TBe75Ye_at_mail.gmail.com>
What is your idea?
Create Tablespace by using ASSM
Using IOT
Check ROW Chaining
Reclaim space/readjust HWM
... ... ...
Surachart Opun
http://surachartopun.com
skye: surachart_op
On Fri, Mar 18, 2011 at 6:29 PM, Paul Drake <bdbafh_at_gmail.com> wrote:
>
> http://download.oracle.com/docs/cd/E11882_01/server.112/e16508/toc.htm
>
>
>
> On Fri, Mar 18, 2011 at 7:13 AM, Surachart Opun <surachart_at_gmail.com>wrote:
>
>> When we work with Oracle Database as DBA or Developer. We have to maintain
>> about table segments. We have to know about Tablepsace/Database file.
>> When we create table, Do you think about it before? Or Do something after
>> created table?
>>
>> What is Your Idea for optimizing Table Performance?
>>
>> Surachart Opun
>> http://surachartopun.com
>> skye: surachart_op
>>
>>
>>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 18 2011 - 09:00:40 CDT