Home » Other » General » How to manage multiple oracle instances (SUN)
How to manage multiple oracle instances [message #547356] Tue, 13 March 2012 20:31 Go to next message
ozzy80
Messages: 55
Registered: June 2005
Member
Hello,

We have been recently facing resource ( space ) constraints on our DB server and would like your expert option on how this can be managed.

We have multiple Oracle instances on one DB server ( multiple versions of Oracle ). We are about 10 analysts and are in product Support group where we constantly have to drop/import customer DB's for issue replication/triagging.

Though we maintain a table with who is using which SID and what users/schemas, not everyone meticulously drops their schems/ tablespaces when they are done. This, at times, causes the DB sever to run out of disk space and all SIDs to go down. Then the cleaning up of SIDs takes place to make room.

We are planning to be proactive about this.

Can you let me know what strategies are used at other places to address such issues?

We can probably have our Unix team set up some kind of disk space monitoring mechanism to alert us in advance.

Would assigning. Strain number of SIDs to each analyst be a workable solution?

I looking for basic ideas to get a start.

You might have already guessed by now that we do not have a dedicated DBA team.

Any help from you is greatly appreciated.

/Ozzy
Re: How to manage multiple oracle instances [message #547385 is a reply to message #547356] Wed, 14 March 2012 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 67368
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is more an organization problem than a technical one.

You want to be proactive, so send a mail to each space consumers each week showing the space they use, if they do not answer in the next 48h then drop their tablespaces.
You will quickly see everyone will appropriately use their space.

In addition, use QUOTA to limit the used space.

Regards
Michel

[Edit: missing word]

[Updated on: Thu, 15 March 2012 01:57]

Report message to a moderator

Re: How to manage multiple oracle instances [message #547578 is a reply to message #547385] Wed, 14 March 2012 17:44 Go to previous message
ozzy80
Messages: 55
Registered: June 2005
Member
Thanks, Michel.
Previous Topic: Database is not running...
Next Topic: Duties of a DBA
Goto Forum:
  


Current Time: Wed Sep 23 15:12:34 CDT 2020