Re: How to determine if a database is in use?
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 13 Apr 2016 13:51:58 -0400
On 04/12/2016 08:33 PM, Oracle DBA wrote:
Question – How to determine if a database is in use.
Well, here is a simple way:
1. Ask around.
2. Take a full offline backup. If someone objects, the database is in use.
3. If nobody complains by time the backup is finished, start it up
using the following command: "startup mount restrict" and when the
database comes up, execute "drop database" command. That will
provide immediate savings in space and machine resources.
4. If nobody complains, the database is not used.
5. If somebody does complain, you have a full offline backup and can
bring it back.
--
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com
Other related posts: