Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004
    Posts
    2

    Unanswered: tow database with problems

    we have tow database in our site ,
    lets say ( DBA1 in UNIX ) and ( DBA2 in NT )

    DBA1 slow than DBA2 ,while we execute same SQL query

    we checked oracle parameters and they are identical ,

    but when we execute SQL query on TOAD tool we chech an ( AUTO TRACE )

    which showing us that there is adifference in
    DB_BLOCK_GETS = 54593 in DBA1
    DB_BLOCK_GETS = 0 in DBA2
    and
    PHISICAL_READS = 446 in DBA1
    PHISICAL_READS = 2 in DBA2

    what dose it mean and how we can fix the problem to make DBA1 fast like DBA2 ?

    thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I think that you'd have better luck if you posted this question in the Oracle forum. While some of us use multiple databases, the folks that concentrate on Oracle can still probably give you better answers.

    -PatP

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    There are no miracles here either.

    Can you prove that both environments are identical

    And it's my experience that Oracle on unix, SMOKES Oracle on NT

    Did you restore both databases from the same dump?

    Certainly doesn't look like it.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    How can you restore "both" from the same dump?

    If I recall correctly DB_BLOCK_GETS is equal to read-aheads or block prefetches, and PHYSICAL_READS...well, that's self-explanatory and corresponds to physical reads on SQL...But the bigger question is: Why are you posting here? There are no more "true" Horacle DBA's left? Hey, convert to SQL and then we will talk
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    dont hate the vendor, hate the game.

Posting Permissions

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