Re: 2 Quick Question: Datafiles/Performance and Deleting a Database

Hi!

To question 1):
You got to shut down the instance and then remove all the datafiles, redo logs, archive logs and control files.

Anne-Marie Ternes

Chuck wrote:

> 1)
>
> This may be a dumb question, but what is the proper procedure to
> delete a database? (I have three databases all using their own
> instance nad need to delete one of them)
>
> 2)
> Will their be a significant performance difference between the
> following two configurations?
>
> Config. 1
>
> 5 1gig datafiles on the same physcail disk (not contiguous on the
> disk)
>
> Config 2
>
> 1 5gig datafile on the same physical disk
>
> Thanks,
> Chuck
Received on Tue Nov 16 1999 - 09:27:27 CST