Re: populate_group slow

In article <ae330f95.0110130611.49315f69_at_posting.google.com>, ehabsalem_at_yahoo.com says...
>
>I am having 2 servers running SCO Unix 5.0.5 and oracle 7.3.4. Clients
>use D2K forms runtime. My problem is that the logon to the application
>on one machine takes a lot of time while on the other one it enters
>instantly. The two servers have exactly the same configuration. I
>traced this problem and found that
>the command POPULATE_GROUP that gets the list of the menu options is
>the reason for this slow logon.
>Please note that the logon to the database itself is fast, the problem
>is in the logon to the application.

something is different between the two machines.

populate group just runs the query and fetches the rows. The query must run fast on one machine and not the other.

step 1: enable sql_trace, timed_statistics and use tkprof to analyze the results. See what is different about the queries on the two systems. Different plans, different numbers of rows -- something is different. See

http://asktom.oracle.com/~tkyte/tkprof.html for info on tkprof and such.

step 2: correct what you discover above. Find out what is different and why and correct that. Until you do something along the lines of step 1 though, you'll just be guessing.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp