dbTalk Databases Forums  

Re: Slow client operations

comp.databases.oracle comp.databases.oracle


Discuss Re: Slow client operations in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Demetris
 
Posts: n/a

Default Re: Slow client operations - 06-25-2003 , 02:41 AM






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 (DOT) state.mn.us> wrote

Quote:
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 (DOT) 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 (DOT) state.mn.us> wrote

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 (DOT) 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 =---

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.