Re: [Q] Server Logon Performance

From: Charles Crow <ccrow_at_erols.com>
Date: 1997/09/09
Message-ID: <01bcbcd0$a771be00$02020202@jt.crow>#1/1

Try the following:

Check with your DBA to see if you are running an Oracle muti threaded server sessions or
dedicated sessions.
Your DBA may have to change the MTS parameters in the init.ora. ( Make sure that your batch jobs
are running in a dedicated session not a muti threaded session. This will slow down logons.
You can setup both MTS and dedicated under tnsnames --- see your ref. manuals for more info.)

256 mb is not much memory. check your memory use and system performance. Check for paging.
vmstat 5 5 --- to check resource use.
ps gu --- what or who is eating your CPU

If you are running client/server applications make sure your users have at least 586 100 MHz PCs
with 16 MB of ram. (The more ram the better. I recommend 32 mb.) Client/server and WEB based apps. are tough so it may take some playing around with different configurations.

Also, look at Oracle support web site for info. Received on Tue Sep 09 1997 - 00:00:00 CDT