Results 1 to 5 of 5
  1. #1
    Join Date
    May 2002
    Posts
    20

    Unanswered: Slow Client operations

    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

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Do you have resource plans setup ???

    Gregg

  3. #3
    Join Date
    May 2002
    Posts
    20
    Originally posted by gbrabham
    Do you have resource plans setup ???

    Gregg
    Could you please be more specific?!
    My OS is Windows NT on server and Windows 2000 on client

    thanks for the reply

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Resource plans are setup in Oracle and given to groups of users.
    You can find these in DBA Studio. You can limit CPU priority in
    this manner.

    Gregg

  5. #5
    Join Date
    May 2002
    Posts
    20
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •