dave_23
11th March 2003, 17:23
Is anyone experiencing the problem where the first session
executed takes a really long time to start? (say >1 minute)
For Baan on Win2K or NT?
(For Some people removing anti-virus software from their Baan system resolves the problem, other people it hasn't. )
I'd like to know if you are or aren't having the problem, and what type / speed disks you have.
Thanks!
Dave
lbencic
11th March 2003, 17:35
Try this link to another thread:
http://www.baanboard.com/baanboard/showthread.php?s=&threadid=1053&highlight=slow+first+session
dave_23
11th March 2003, 17:55
Hi lbencic,
That's a good conversation. But this isn't an Oracle issue.
If you run a TT_SQL_TRACE=02200, an ORAPROF=1 or a
SQL_TRACE=true and tkprof you'll see that the query is
as good as it can get, the parse and fetch times are fine.
But the session still takes a horrible amount of time to start.
I've found using a utility called "filemon" that the ntbshell
reads a lot of DDs from disk at first session startup (opens and closes but doesn't read the contents)
This is what is causing the problem.
I'd like to get an idea of the number of customers who are experiencing this problem.
Thanks.
Dave
EdHubbard
11th March 2003, 19:45
I tested this on our live system:
Open BW = 3 seconds
Open first session (tiitm0101m000) = 3 seconds.
Bw client version = 068
I do vaguely recall some time ago when we hadn't updated our standard program for quite some time that it took ages to open sessions. Could be worth installing a newer one?
What about shared memory - our live package combination is in shared memory + all tools objects (+ as from today a few heavily used applications as well - but not tiitm0101m000 !).
dave_23
11th March 2003, 20:24
Thanks, Also could you let me know what porting set you're on?
Baan is reading the DDs from shared memory (for example if you do a -dbgsrdduse it will show them all coming from SHM.)
I haven't checked the tools standards, it could be!
Thanks.
Dave
EdHubbard
11th March 2003, 20:26
6.1c.06.06 is our current porting set but it behaved, performance wise, the same with 6.1c.06.05, 6.1c.06.04 as well.
Good luck!