Mistton wrote:
> plan on using an IOT with compressed PK however said this bug
>
> Bug 2718937 OERI:6033 from SELECT on IOT with COMPRESSED PRIMARY KEY
> Queries on an IOT table with a compressed primary key
> may fail with ORA-600 [6033].
>
> can an ORA-600 cause the DB to shutdown? or just the select to fail

In general: yes, ORA-600's can cause an instance shutdown.
For this specific one: read Metalink Note:45795.1

--
Jeroen