Re: Slow client operations

Hi,

I would like to thank you first again for the replies. Actually to clear some things out, I have an application called Moody's Financial Analyst
which sits on Oracle (the server mentioned previously). This applications of course needs the oracle client to communicate with the server. When I connect to the machine (the client) with administrative priviledges the applications runs fine. When I connect on the machine as a power user, I have the degretation in performance mentioned previously. I took a snapshot of what is being done (sqls etc) when the application connects. I took those queries and connected directly to the oracle and they run ok with either user.
So it comes down to the applications.
I suppose I need to contact the provider of the applications to see what is going on.

Thanks again for the reply! :)

TurkBear <john.greco_at_dot.state.mn.us> wrote in message news:<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 25 2003 - 09:41:49 CEST