Re: Question on IO consideration

Thank You Anton. Will see this MOS note.

On Wed, Sep 22, 2021 at 1:20 AM Anton Spitsyn <antonio.spitsyn_at_gmail.com> wrote:

> Hi Lok,
>
> MOS Note 1965343.1 Oracle Database In-Memory Advisor contains the attached
> scripts and will install the Advisor in your database to evaluate the
> benefits and get recommendations for its usage.
>
> --
> Anton Spitsyn
> Database Administrator
> http://aspitsyn.wordpress.com
>
>
> On Tue, Sep 21, 2021 at 10:13 PM Pap <oracle.developer35_at_gmail.com> wrote:
>
>> I heard there exists a table hash clustering kind of concept in oracle
>> but never used it for IO reduction or performance improvement even in
>> 100TB+ size oracle databases i worked on. But I see something matching that
>> thought below. Not sure , to what extent it's used/proved useful in real
>> life scenarios. Others may comment.
>>
>> http://www.dba-oracle.com/oracle_tip_hash_index_cluster_table.htm
>>
>> On Wed, Sep 22, 2021 at 12:19 AM Lok P <loknath.73_at_gmail.com> wrote:
>>
>>> Hello Listers, We have oracle exadata databases which are performing
>>> mostly warehousing or batch type data processing. And few are hybrid i.e
>>> combination of both oltp+warehousing/analytics types processing. ETL jobs
>>> run on a few of these which move/read/write billions rows daily.
>>> The databases are 50TB to ~150TB in size currently. Few architecture
>>> team members suggested evaluating if we can use columnar database type of
>>> offering for IO reduction and thus better performance considering the
>>> future growth. As per my understanding , Oracle stores data in row format
>>> only, so is there any other offering from Oracle for columnar datastore
>>> format or columnar databases and we should evaluate that? Or is there any
>>> clustering kind of technique which can be evaluated which will help reduce
>>> IO? Want to understand experts' views here on this.
>>>
>>> Regards
>>> Lok
>>>
>>
>
> --
>
> Anton Spitsyn
>
> Database Administrator
>
> http://aspitsyn.wordpress.com
>
>

--
http://www.freelists.org/webpage/oracle-l