Re: limiting queries
Date: Wed, 18 Sep 2013 07:04:41 +0300
Message-Id: <03EFBBA8-3527-43E2-87DB-6B8B8EAFA516_at_gmail.com>
Oh, yea. Haven't a playground yet :), but it doesn't change the fact that one has to change the query. Gints
On 2013. gada 18. sept., at 02:12, Justin Mungal <justin_at_n0de.ws> wrote:
> Gints:
>
> The row limiting clause is a new 12c feature.
> http://docs.oracle.com/cd/E16655_01/server.121/e17209/statements_10002.htm#SQLRF55636
>
> -Justin
>
>
> On Tue, Sep 17, 2013 at 2:17 PM, Gints Plivna <gints.plivna_at_gmail.com> wrote:
> 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
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 18 2013 - 06:04:41 CEST