994566 wrote:what stops you from having your own sandbox Oracle DB inside of a VirtualBox system?
Increasing some places I work at have a very strict and restrictive set up around Oracle development and test databases and servers.
They seem to think that so long as people have TOAD/SQL*Developer, that is it.
The dev/test databases tend to be neglected as teh DBA teams are "too busy" with production systems.
Developers who need to implement some new feature, or investigate prerformance issues are often left up the proverbial without a paddle. Obtaininb the tkprof trace file is a pain (raise request), then if you want to reformat the tkprof with some different options you have to raise anothe rrequest, by which time teh DBA is now fed at having to do his job.
Then we have the old deployment scripts for implementing project releases - how can you build-in things like checking all users have been kicked off, checking there are no locks/open cursors on object you are going to change. Builds and deployments need to tested regularly, but if you have to secure a DBA resource to do it then that restricts this activity.
Thankfully most places I have worked either trusttheir developers up to a point on the development and some test rigs, then apply more rigour as the the project progresses up the chain. This is reasonable.
The other approach that works well is to have 1 or 2 Development DBAs embedded in the team.
But, not allowing DBA access at all, and not having ready access to a DBA who understands the project goals/requirements and whatthe develoipers are tryingto achive is a new one on me.
I would welcome comments on whether I am wrong to think like this, or whether this really is a stupid policy implemented by people who never actually get to see their policies in action.