Weird Sqlplus performance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Weird Sqlplus performance

  1. #1
    Join Date
    Mar 2001
    Posts
    149

    Weird Sqlplus performance

    Hi all, I've a script run on 2 seperate PCs (select statement)using SQLPLUS (same version). One took about 5 min and other one took almost 38 minutes. I'm not sure what causes this problem. Please advise. THank you

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    Too many variables here to answer.

    2 seperate pc's? Are they using 2 seperate databases?
    Could it be a network thang?
    The SQL plus cversion would be the last thing I looked at.

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Mar 2001
    Posts
    149
    Hi, it's the same database. Thx

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    So its the same database loaded on two machines. What type of hardware, i.e. CPU/RAM/Disk space, and what OS does each machine have? What version of Oracle does each machine have, including patches? How is each SGA sized? What is the optimizer mode for each? Do you generate stats for either or both and how do you generate stats? I thnk those are the variablles that our Christmas poo is talking about.

Posting Permissions

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



Click Here to Expand Forum to Full Width