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.

• TRW -- ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | Tim Witort || He is not silent. He is not | | trwATmedicalertDOTorg || whispering. We are not quiet | | || we are not listening. | | Pin: TZ, only one :^( || - Out of the Grey | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||