Question on IO consideration

From: Lok P <loknath.73_at_gmail.com>
Date: Wed, 22 Sep 2021 00:18:33 +0530
Message-ID: <CAKna9VaPUaB6SqaJwrvzkd9anaP0wPnTYzrN-sXacwPPGFX6YA_at_mail.gmail.com>

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

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

Received on Tue Sep 21 2021 - 20:48:33 CEST