In OAS search option is giving the results very slow when compare with OBIEE12c search option

Question

In OAS when we were trying to the search the reports using search option that time it was displaying the results very slow like more than 2 mins.

where as in OBIEE 12c displaying the results with in 60 seconds.

can some one please advise/suggest do we need to do any changes for this to work like OBIEE12c search or it is expected behavior only.

your help is greatly appreciated in advance

.

Steve F-2 · Answer

I think I cross-posted at a similar time as Madasamy.

You want your scheduled crawl set to to weekly or longer, mainly because new catalog content now gets added to the index immediately.

I see your search type is 'ALL' for all users folders and sub-folders. This is an expensive search (ALL), and ideally, you would want of filter at a lower level,  but the results should be similar or better results than OBI 12c.

Is this an unpatched OAS 2023?  Meaning, you have not applied the latest CPU/bundle patches (opatch lspatches)? Have you left the loglevels at their defaults (specifically obips)? Do you see any CPU constraints/high utilization while performing this search?

Other comments welcomed.

Gopi Krishna P · Answer

Hi @Madasamy -Oracle

data crawl is scheduled properly for your user -WebLogic.

slowness in classic -> catalog only. OAS version 2023.

In instance config file bisearch enabled was set to "False".

There was no errors in the logs for search.

Steve F-2 · Answer

Hi @User_DCJG6,

Welcome to the Oracle Analytics Online Forum!

We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.

Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

Can you elaborate on your OAS version?  Are you using OAS 2022, or OAS 2023?

As a start, can you confirm your search indexing is enabled for the catalog?

Manage How Content Is Indexed and Searched

You can check the monitor tab to see if any indexing has failed or is successful.