Re: Re: select catalog role
[QUOTE]Originally posted by jmodic
[B]
Quote:
Originally posted by padma
Extensive use (or abuse) of some dictionary views can have serious impact on the database performance.
That's an overstatement. What do you mean: that nobody should use PATROL, who all the time makes those V$ queries? Come on!
I have tested running long selects with PATROL on and off (which runs quries over the DB). There is no significant difference. And I've done the test against an Oracle Parallel Serevr having hashed locks on SYSTEM! (PATROL having 2 session per instance).
Re: Re: Re: select catalog role
Quote:
Originally posted by julian
Quote:
Originally posted by jmodic
Extensive use (or abuse) of some dictionary views can have serious impact on the database performance.
That's an overstatement.[/B]
Might be in your eyes, not im mine. There are four words in mine statement that should be emphasized to put the things into right perspective: *extensive*, *abuse*, *some* and *can*.
Quote:
What do you mean: that nobody should use PATROL, who all the time makes those V$ queries?
No, I mean that any *inexperienced* (not to speak about experienced ones! ;)) DBA/developer is capable of *writing* a query based on some dictionary views and tables that can have a *huge* impact on your production database performance. Don't you belive me? Well, give me access to your database and I'll show it to you.
By no means I was refering to PATROL or some other monitoring/tuning/DBA tool. Such tools are packaged, so everything you do with them is perfectly controled and within the intended limits! I don't consider people who wrote PATROL to be *inexperienced* DBAs/developers! They new what they can stick in there and how to write that, and they also know what should not be there (although it is available in fixed views/tables) because of the impact it could have on the running database users. By "Extensive use (or abuse)" I ment self written (poorly written) queries.
And a remark to one of your previous posts:
Quote:
That is not a correct work to do the job! Your Senior DBA has a lot to learn. I have full confidence in everyone working with me and I would never reject such a thing.
I don't belive you are responsible for a mission critical production database with huge user base that has to run 24x7 with acceptable (read excelent) response times. If you are, then I can't understand how are you able to survive with such a liberal attitude. If you have full confidence in anyone working with you, are you saying you assign DBA role to all of them? After all, this would be the most obvious expression of your confidence in them ;).
I consider myself as a very open and liberal DBA when it comes to *development environment*. In fact, the majority of our developers have DBA role granted and I never experienced any so often mentioned DBAs : developers tensions or silent wars in my team. But when it comes to the production system, all the liberalism is forgoten - everyone has to have exatly those privileges granted to them that are needed to perform their tasks. No more and no less!! This is my DBA rule no.1 in production environment! That doesn't mean I'm the only one that have prety powerfull privileges (DBA role, for example) on the production database, but the ones that have such privileges have prooved themselves in the past that they know what they are doing. This is what I was talking about in my reply to the original question....
[Edited by jmodic on 08-30-2001 at 01:42 PM]
Re: Re: Re: Re: select catalog role
Quote:
I don't belive you are responsible for a mission critical production database with huge user base that has to run 24x7 with acceptable (read excelent) response times.
:-) Yes I run such a database (OPS). And not just one. And standby too. And how should I put this mildly: you sound very touchy..