Re: My woes continue
Date: 1997/07/10
Message-ID: <33C57DC7.1549_at_ATmedicalert.DOTorg>#1/1
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||