RE: V$ access for production support

Add me to the group that grants access to query the views but puts a strict resource limit on through the profile.

As others have said, the developers know the application best. We went through about a 6 month period where developers (per senior management edict) were not allowed any access to the production servers. So when a batch job malfunctioned they'd come up to my desk and they'd tell me what to type to check what data had been processed so far, etc. I'm very happy that this edict was eventually revoked.

On the other hand, many years ago I had a production database *crash* because someone was running a huge query that was doing full table scans and sort-merge joins on about 6 different 100 million row tables. That was when we instituted the resource limits...

Thanks,
Jay Miller
Sr. Oracle DBA
x68355  

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael McMullen Sent: Tuesday, September 05, 2006 10:31 AM To: Dave.Herring_at_acxiom.com; oracle-l
Subject: Re: V$ access for production support

How about v$session_longops? It's not a restricted view and it's supposed to
be used to monitor progress of long running queries/transactions?

Mike

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 14 2006 - 16:13:52 CDT