Home » RDBMS Server » Networking and Gateways » Slow Data accessing
Slow Data accessing [message #66028] |
Fri, 12 October 2001 00:54  |
Deepak Bisht
Messages: 13 Registered: October 2001
|
Junior Member |
|
|
i have 1 Winnt4.0 server(P-III,128MB RAM,10/100 mbps N.Card,TCP/IP Protocol) and 3 Winnt4.0 workstation pentium machines.I'm using Oracle8.0(backend) and Dev 2000 Forms 5.0 (Frontend).my problem if users sitting on workstations presses enter at same time, the data accessing speed from Server takes lots of time.
----------------------------------------------------------------------
|
|
|
|
|
Re: Slow Data accessing [message #66041 is a reply to message #66032] |
Fri, 19 October 2001 04:33  |
Suresh Baral
Messages: 11 Registered: October 2001
|
Junior Member |
|
|
Dear,
go through init.ora file. It will be initORCL.ora, where ORCL is the SID name in oracle8.
see the parameter i.e.
shared_pool_size = ?
db_block_buffers = ?
log_buffer = ?
then could you tell me the db_block_size, it is default 2048, but 8192 or higher is appreciable, but can done at the time of database installation, not after that. So don't touch this.
Still if you have problem, you please tell me, I will send some sql to verify the above tuning, then you can change these accordingly.
Good luck.
Suresh
----------------------------------------------------------------------
|
|
|
Goto Forum:
Current Time: Thu May 01 18:53:10 CDT 2025
|