O'Reilly logo

Oracle Business Intelligence 11g R1 Cookbook by Cuneyt Yilmaz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuring query limits

Configuring limits are very useful when it comes to performance tuning. End-users might execute queries and the returning result set might contain hundred thousands of rows. Eventually, this will negatively impact the performance. We'll have to configure query limits to avoid such a situation.

How to do it...

  1. Query limits can be configured at the user or the application role level. Applying query limits at the application role level will be easier. Open the Identity Manager and double-click on Application Role.
    How to do it...
  2. Click on the Permissions button. You'll see User/Application Role Permissions window. There are three tabs in this ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required