Re: Slow client operations

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Wed, 18 Jun 2003 15:36:56 -0500
Message-ID: <i6j1fvodouvhgs3nd6cqqsg4f936dljcs8_at_4ax.com>


Are you using OS level authentication or does the user log into the Oracle database - if logging in to the database is the non-admin user using the same username as the admin one ? Normally the client side settings have little impact on database performance..

DMina_at_laiki.com (Demetris) wrote:

>My OS is Windows NT on the server and Windows 2000 on the client.
>The issue here is not that the client cannot do the operations. The
>issues is that the client does the operations but it takes too much
>time.
>
>Thanks for the reply
>
>TurkBear <john.greco_at_dot.state.mn.us> wrote in message news:<jbr0fv89vvuncq2dp404hp6ipm5ai2tj5e_at_4ax.com>...
>> Start with the obvious..permissions..Be sure that all Oracle users have the same rights/privs on all directories that oracle
>> uses ( datafiles, redo logs, temporary areas, tablespace, logs, etc)...
>>
>> You did not mention your OS, so the methods of doing this will vary...
>>
>>
>> DMina_at_laiki.com (Demetris) wrote:
>>
>> >Hello there,
>> >
>> >I have an Oracle Server (8.1.6) and an Oracle client (same version).
>> >When the client connects on his machine with administrative
>> >priviledges then the operations that are performed (queries on the
>> >database) are ok.
>> >
>> >When the client connects/logins on his machine with restricted
>> >priviledges then we have a huge performance degredation on the same
>> >operations.
>> >
>> >Could anyone specify what is going on? Does it have anything to do
>> >with authentication? Where can I look to resolve the issue?
>> >
>> >Thanks a lot
>> >Demetris
>>
>>
>>
>> ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
>> http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
>> ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Wed Jun 18 2003 - 22:36:56 CEST

Original text of this message