Home » RDBMS Server » Networking and Gateways » Slow Data accessing
Slow Data accessing [message #66028] Fri, 12 October 2001 00:54 Go to next message
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 #66032 is a reply to message #66028] Fri, 12 October 2001 23:50 Go to previous messageGo to next message
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member
sir,

increase the system global area(i.e tune your database)

k.sreenivasan

----------------------------------------------------------------------
Slow Data accessing [message #66035 is a reply to message #66032] Mon, 15 October 2001 08:10 Go to previous messageGo to next message
Deepak Bisht
Messages: 13
Registered: October 2001
Junior Member
Dear Sir,
Thanx for reply.
would u tell me from where i can increase SGA and wat are the parameters i have to set.

----------------------------------------------------------------------
Re: Slow Data accessing [message #66041 is a reply to message #66032] Fri, 19 October 2001 04:33 Go to previous message
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

----------------------------------------------------------------------
Previous Topic: Re: ORA-03121
Next Topic: Re: Can't Install 8i Client on Pentium 4 , NT 4 machine??
Goto Forum:
  


Current Time: Tue Feb 20 20:14:57 CST 2024