Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 232 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 86 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Tuning parameter to limit OBIEE SQL text
Organization Name
Sage Intacct
Description
We are currently using OBIEE 12.2.1.4 and planning to upgrade to OAS soon.
We allow users to have ability to create their own reports, however sometimes, users makes silly mistakes, and may accidentally generate a huge OBIEE SQL.
The request is to have a tuning parameter to limit OBIEE SQL Text, such that if the generated OBIEE SQL text is huge ( say more than 2MB ), it should be prevented for further OBIEE processing and be prevented to run against the Datasource .
Use Case and Business Need
We recently had an issue wherein an end-user came up with a report that generated a massive OBIEE SQL ( 20 pages long), this caused
the underlying host to hang and become non-responsive, causing so many users to be unable to use the system.
To mitigate the issue, we were forced to kill the sawserver process.
We logged oracle support ticket for this, but there were not able to help us.
SR 3-26592523951 : Very large OBIEE SQL causing server issues
Original Idea Number: b5774281c0