Re: Question on IO consideration

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