| 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 #66032 is a reply to message #66028] |
Fri, 12 October 2001 23:50  |
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 |
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 |
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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
