Yes we do have many hidden pages which are placed at the last. We tried to re-order the pages but no luck.

Ours is 12.2.1.2.0. Ya I tried removing and re-adding the roles but that also din't help.

That works.. Thank you.

Thank you. I understand your point. Is there any way to get the actual time taken using Usage Tracking.?

Thanks Berg for the reply. But before I posted I already did initial investigation and that query returns result in less than 2-3 secs after clearing the cache. I wanted to check why for a particular user it took more than 10-12 mins. And what I can do to investigate further.

Hi, No we do not have multiple LTS for the fact. It is database partitioned fact table. Ideally when we put filter on the partitioned column in the report, it internally hits the partition table and we can check that in explain plan. But here we don't have filter on partitioned column but corresponding CURR_FISC_YEARMO…

Thats a different way of implementing. We have partition for each month. So how many LTS we will create.