DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 29

Thread: How to limit users to run heavy queries?

  1. #1
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233

    How to limit users to run heavy queries?

    Hi Falks,

    What is the best way to limit users to run long and heavy queries?
    I want ,for example ,that a session which runs a heavy CPU query will be terminated automatically after 2 minutes maximum.
    database version : 10.1.0.2
    OS : Sun Solaris

    Thanks in advance,
    Nir

  2. #2
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    create a profile, setting values for cpu_per_session\logical_reads_per_session (depending on what you want to limit your users on) and then assign the profile to the user you require.

  3. #3
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233
    Thanks!
    I'll check it.

  4. #4
    Join Date
    Jan 2001
    Posts
    3,134
    USERS!!

    Don't make me say it!
    I remember when this place was cool.

  5. #5
    Join Date
    Jan 2004
    Posts
    162
    Presumably your answer involves threats of (or actual) grievous bodily harm towards the users in question?

  6. #6
    Join Date
    Jan 2001
    Posts
    3,134
    Originally posted by padders
    Presumably your answer involves threats of (or actual) grievous bodily harm towards the users in question?
    Sharp like a bowling ball you are.
    I remember when this place was cool.

  7. #7
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166

    Re: How to limit users to run heavy queries?

    Originally posted by nir_s
    Hi Falks,

    What is the best way to limit users to run long and heavy queries?
    I want ,for example ,that a session which runs a heavy CPU query will be terminated automatically after 2 minutes maximum.
    database version : 10.1.0.2
    OS : Sun Solaris

    Thanks in advance,
    Nir
    You could also help them to rewrite their queries.
    Either that or you could give them a close up view
    of MH's bowling ball.

  8. #8
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Hi Falks,


    Does this make us "Falkers" .. get the bowling ball
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  9. #9
    Join Date
    Jan 2001
    Posts
    3,134
    Lock and Load!!
    We're goin in.
    I remember when this place was cool.

  10. #10
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Originally posted by Mr.Hanky
    Lock and Load!!
    We're goin in.
    It's spit balls at 10 paces!

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