Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: My woes continue
Joost Ouwerkerk wrote:
>
> To all DBA's:
> Should any of
> the following statements be true:
>
> 1) A complex query can 'crash' the database and cause corruption of
> data.
It depends on what "crash" means. You could bring the server to its knees performance-wise with a really ugly multi-table, join with full table scans on unindexed columns returning millions or billions of rows. But, the database should not "crash" in the sense that you get ORA-600s or the database needs to be shutdown and restarted.
> > 2) Running Personal Oracle on a client (user) machine can 'crash' the
> database and cause corruption of data
As long as there is no connection to the production instance via a DBLINK or some other network activity there is NO WAY a stand-alone instance could do this.
> 3) Running Developer/2000 on a client machine can 'crash' the database
> and cause corruption of data.
Is Dev2000 accessing the production database? If so, then see the response to (1) above. Otherwise, see response to (2) above.
![]() |
![]() |