Re: limiting queries

From: Justin Mungal <justin_at_n0de.ws>
Date: Tue, 17 Sep 2013 18:12:57 -0500
Message-ID: <CAO9=aUxEA8jaRXaeQtbx-m5D35WyJHBvDqgY-DkL9ocuYqiv1Q_at_mail.gmail.com>



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-l
Received on Wed Sep 18 2013 - 01:12:57 CEST

Original text of this message