This discussion is archived
9 Replies Latest reply: Jun 21, 2013 5:44 AM by JRH RSS

OBIEE slow login due to S_NQ_ACCT?

JRH Newbie
Currently Being Moderated

Hi all,

 

We have a problem in our 10.1.3.4 Prod environment.  When users login to Analytics it's taking 5+ minutes between entering credentials and actually pulling up a dashboard.  It appears that the below SQL is what's causing the delay (note that if I run it directly against the DB via TOAD it also runs extremely slow):

 

SELECT 'GROUP', R.RESP

  FROM NQ_LOGIN_GROUP R

WHERE R.LOGIN = 'e12345' OR UPPER (R.LOGIN) = 'e12345'

UNION

SELECT 'GROUP',

       CASE 1

          WHEN 0 THEN 'Hierarchy Level (Base)'

          WHEN 1 THEN 'Hierarchy Level 1'

          WHEN 2 THEN 'Hierarchy Level 2'

          WHEN 3 THEN 'Hierarchy Level 3'

          WHEN 4 THEN 'Hierarchy Level 4'

          WHEN 5 THEN 'Hierarchy Level 5'

          WHEN 6 THEN 'Hierarchy Level 6'

          WHEN 7 THEN 'Hierarchy Level 7'

          WHEN 8 THEN 'Hierarchy Level 8'

          WHEN 9 THEN 'Hierarchy Level (Top)'

          ELSE 'NOGROUP'

       END

  FROM S_NQ_ACCT

 

I'm not fully up-to-speed on Usage Tracking, but I understand that's the primary purpose of S_NQ_ACCT.  We have about 470k rows in that table now, which doesn't seem like a lot.  I also verified that the 3 default indexes are in place.

 

Any thoughts or suggestions on how to remedy?

 

Cheers,

Jim

 

SQL was edited by: JRH

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points