select catalog role
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: select catalog role

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    28

    Unhappy

    Hi,

    Is there any bad implication of assigning a select_catalog_role to a development dba to a production database. Basically, my production dba is not willing to assign this role to me as it involves v$ views. As a development dba, I am supposed to monitor the users and the performance of the sql statements etc, (not all the time. But if there was a problem.)

    Please let me know if any of you know about any problem assigning this role to someone who does not have dba privilege on the database.

    Any suggestions / solutions would be appreciated.

    Thanks
    Share on Google+

  2. #2
    Join Date
    Sep 2000
    Posts
    384
    The Senior DBA should have full confidence on you.But once you are appointed as DBA whether it is production database or development database I don't see a reason why are not give a DBA role (system userid).you should be asking the userid which has the DBA role .If not i will not logon to that production database itself as a normal user itself.
    Radhakrishnan.M
    Share on Google+

  3. #3
    Join Date
    Aug 2001
    Posts
    267
    We never had a problem . Some of our developers they do have the access , some are working on query optimization so they need to see some parameters and some v$view's . Basically they can't alter or recreate the system views or insert any rows into the system views ..Ask your Prod DBA for atleast one reason .. Being a supporting person you should get it ...


    Raghu
    Share on Google+

  4. #4
    Join Date
    Jan 2001
    Posts
    28

    Unhappy select catalog role

    My production dba says assigning me 'select_catalog_role' could have potential performance issues on the database. Has anyone ever heard of such issues???
    Share on Google+

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Hmmm, Interesting!!!

    Did you make the How/Why/What question to him? Most of them uses the internal views.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!

    Share on Google+

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by padma
    Basically, my production dba is not willing to assign this role to me as it involves v$ views
    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.

    Share on Google+

  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    Re: select catalog role

    Originally posted by padma
    My production dba says assigning me 'select_catalog_role' could have potential performance issues on the database. Has anyone ever heard of such issues???
    Not that I would act the same as your DBA or that I'm on his side, I would say that the reason he is stating is totaly valid! Extensive use (or abuse) of some dictionary views can have serious impact on the database performance.

    If this is a mission-critical production database and if he is not 100% confident in your DBA knowledge, I can totaly undertand his position... However if I were in his boots, I would first make sure you understand the implications of your catalog queries and if I would find out that there are some "white spots" in your DBA knowledge I would make sure you fill up those gaps and then I'd assign you the desired role.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Share on Google+

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Re: select catalog role

    [QUOTE]Originally posted by jmodic
    [B]
    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).





    Share on Google+

  9. #9
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    Re: Re: Re: select catalog role

    Originally posted by julian
    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*.

    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:

    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]
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Share on Google+

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Re: Re: Re: select catalog role


    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..



    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width