SEO

#1 (**permalink**) 02-25-2008, 05:42 AM

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

#2 (**permalink**) 02-25-2008, 05:42 AM

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

no, a select resulting in ora-600 can crash the database. I remember an
ora-600 on
select * from v$pwfile_users, and the database crashed.
Whether this particular ora-600 can crash the database, I don't know.

--
Sybrand Bakker
Senior Oracle DBA

#3 (**permalink**) 02-25-2008, 05:42 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

can an ORA-600 error cause a DB shutdown