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

Gopi Krishna P

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

.

Madasamy -Oracle

It mainly depends on the amount of data that's indexed.

Ensure that the data crawl is scheduled properly for your user.

If the issue still occurs,

Do you see the slowness only on the classic -> catalog tab OR is it even slower on the OAC DV as well?

Can you share the OAS version?

Do you have any parameter in the instanceconfig.xml configured related to search ? like bisearch etc..

Do you see any errors/exceptions in the managed server diagnostic log for bisearch module?

SteveF-Oracle

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.

Gopi Krishna P

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.

SteveF-Oracle

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.