That's why you can set up different logins with different priorities so a runaway statement has zero effect on anybody else. This is DBA 101 stuff here. I've never used Oracle in my life and it took me a grand total of about 5 minutes of naive searching to find out how you do it in Oracle. [1] So "no" here doesn't mean it's not possible, and if they're as good as you say they are, it doesn't mean "we don't know how to". By my reckoning, that just leaves "we don't feel like it"...
Now, it would be perfectly reasonable (and best practices) for them to want to see the queries you want to run to help you optimize them or see if they should be made into a stored procedure or something, though. Or to not want to put in a trigger due to performance issues. Or heck, to only allow you to run queries from 2 AM to 4 AM or promise to break your fingers if you do more than 1,000 queries a minute or something.
[1] http://www.google.com/search?q=oracle+%22resource+plan%22
>>> [log in to unmask] 1/17/2007 4:29 PM >>>
On Jan 17, 2007, at 6:16 PM, Casey Durfee wrote:
> So it sounds to me like they're stonewalling you because they flat out
> don't know what they're doing and don't care to find out. In which
> cases, condolences.
Nope, I really think it's for fear of someone writing a huge runaway
SQL statement that hurts production performance, or something. Our DB
admins are quite competent, if perhaps overly cautious.
And might be reading this list ;-)
"Production" systems at Madison's libraries are famously (and sadly)
*very* limited-access -- hence the, uh, "solutions" that don't
require the Powers That Be to sign off on stuff ;-)
-n
|