| How to manage multiple oracle instances [message #547356] |
Tue, 13 March 2012 20:31  |
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  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
