Re: limiting queries

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Tue, 17 Sep 2013 22:17:45 +0300
Message-ID: <CAN2wOq0LhzHoo1JQFLuQM9yVaz7q2koHa5Tt=kN8tgT4J534TQ_at_mail.gmail.com>

Do you want to limit resources (for example CPU used by user) because too many users are using too much resources? Or you want to limit record count per query because application screens are showing too many rows?
So for the first one you can look for profiles or resource manager. For the second one you have to code the info in application. AFAIK oracle haven't identic for set rowcount in sql server. You have to use where rownum <= N.

Gints Plivna
http://www.gplivna.eu

2013/9/17 Zelli, Brian <Brian.Zelli_at_roswellpark.org>

> Is there a way I can control users to limit the queries they run? Either
> by # of rows or time? Googling only seems to show how to do it IN a query.
>
> Brian
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Tue Sep 17 2013 - 21:17:45 CEST