RE: V$ access for production support

From: Richard J. Goulet <rgoulet_at_kanbay.com>
Date: Mon, 18 Sep 2006 10:37:22 -0400
Message-ID: <C3EE2ADD31ACF64DAB1B236044A1968D294AE8@miaexc01.kanbay.com>

I'll add my name to the list of grantee's, but I did do some serious controlling of what could be seen & what queries could be run by displaying the data via PHP on a web site. Worked extremely well.

Dick Goulet, Senior Oracle DBA
45 Bartlett St Marlborough, Ma 01752, USA Tel.: 508.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795 RGoulet_at_kanbay.com
: POWERING TRANSFORMATION
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jay.Miller_at_tdameritrade.com
Sent: Thursday, September 14, 2006 5:14 PM To: oracle-l_at_freelists.org
Subject: 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 Mon Sep 18 2006 - 09:37:22 CDT