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.