Re: How to determine if a database is in use?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 13 Apr 2016 13:51:58 -0400
Message-ID: <570E873E.4030708_at_gmail.com>
On 04/12/2016 08:33 PM, Oracle DBA wrote:
>
> Question – How to determine if a database is in use.
>
>
Date: Wed, 13 Apr 2016 13:51:58 -0400
Message-ID: <570E873E.4030708_at_gmail.com>
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:
- Ask around.
- Take a full offline backup. If someone objects, the database is in use.
- 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.
- If nobody complains, the database is not used.
- If somebody does complain, you have a full offline backup and can bring it back.
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 13 2016 - 19:51:58 CEST